We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [csv]

Denotes questions related to CSV file management on Magento (import,export,creation,modification)

Filter by
Sorted by
Tagged with
0
votes
1answer
222 views

Grid csv/excel export not working

I currently can't export anything in the grids for products, clients and newsletters in my computer (and from another computer in another state). It downloads properly from my phone. When I click ...
0
votes
1answer
120 views

Bulk Products import are not showing on front end

I have uploaded bulk products through using a CSV file. The products get uploaded successfully and can be found on the back end, but they are not showing on front end. When I edit a product and save ...
1
vote
1answer
742 views

Magento 2. Custom grid. Can not exprot to csv

I've created custom grid block using UI component but I can not export it to csv file. I'm getting the error: Undefined index: attributes in vendor\magento\framework\View\Element\UiComponentFactory....
0
votes
1answer
291 views

import parent and sub category with csv magento 1.9

I am uploading a CSV in Magento 1.9, and what i need is to import both categories and sub-categories, but now it is currently importing only sub-categories. Here is an example of how I the categories ...
1
vote
0answers
33 views

Base table or view not found: 1146 - While importing products from one DB to another DB

I have a site in magento 1.9.2, I installed a new magento 1.9.2 on my localhost which is blank. I export all products by going into system->dataflow->exports and download file as a csv. Now I am ...
4
votes
3answers
3k views

Magento 2: Import multiple select attribute values using CSV

How can we import multiple select attribute values using CSV ? For example SKU "test" has two values for attribute "xyz" - "val1" and "val2". When I use both value as val1<space><comma>&...
2
votes
0answers
78 views

Magento 2 : Any Script or Extension to Attach Product Images to SKU

I am looking a script or extension to do this: I upload products via CSV, then run script or extension and attach product images (multiple) to the SKU, easy and fast and don't have to write in csv ...
1
vote
0answers
58 views

How to understand magento 2 profiler output?

I've just enabled profiler on my M2 site (csvfile output). But I can't understand its content. Is there any software that could make the output data more understandable?
1
vote
0answers
99 views

Manipulate customer grid column data in csv(export)

I added a custom column in customer grid i.e subscriber_status which is showing correctly. In DB the actual value saved as either 1(subscribed) or 3(unsubscribed). Currently I am able to manipulate ...
1
vote
2answers
755 views

Custom CSV export for last 1000 orders

I would like to export the last 1000 orders with following fields: order id, customer email, first name, last name. Is there an easy way to export a CSV like this? I do have access to PHPMyAdmin.
1
vote
0answers
457 views

general system exception happened additional data: class name and class type already exists

while importing in magento 2 getting this error general system exception happened additional data: class name and class type already exists. when i check in var/import_history/filename_error.csv ...
1
vote
0answers
206 views

Magento product with many custom options, need to update the prices with unique values for each product

I have simple products with 1,815 custom options which are tartans, and I need to update the price with unique values for each product. Would I be able to achieve this using a CSV import or do I need ...
0
votes
1answer
112 views

Magento 1.9.2.1 Product Upload Via .csv file does not generate url rewrites

I uploaded products via .csv file but the URLs does not get created/generated. I wonder if anyone can tell whether this is the expected behavior or there is a bug? Updated Question I have uploaded a ...
3
votes
1answer
409 views

Fatal error : Call to a member function getBackendModel() on null in app/code/core/Mage/ImportExport/Model/Import/Entity/Customer.php on line 425 M-1

I got error while importing the customer using CSV in the admin.
5
votes
1answer
625 views

Where to put downloadable csv file in custom module and generate download link in phtml?

I have a csv file, i want to put it inside my custom module folder app/code/Vendor/Module but i don't know where to put the csv file inside my custom extension folder, and how to generate link to ...
4
votes
1answer
2k views

How to delete product images using magento csv import in magento 2?

Magento Version: 2.1.0 We have added the wrong image for some of the products when importing through Magento CSV import. we want to remove the images from those products and add new images or replace ...
1
vote
0answers
70 views

Multiple CSV Automation - Distributors product feeds for ecommerce importing

I am looking for a way to merge / automate 3 CSV files which each have different headings, i need to import these files automatically into Magento but they need to be mapped to attributes that Magento ...
3
votes
3answers
376 views

How can i remove Multiple Assigned Categories of products remove from selected Category

I need to remove Multiple Assigned Categories of products remove from selected Category. Eg. Product1 assigned to cat1, cat2, cat3. I need my product remove from the category cat3. How can I do it by ...
6
votes
3answers
9k views

Read input csv file and convert it to array

I have an input file form in phtml to import data from csv file type like this: <div class="import-shipping"> <div class="header"> <h4>CSV File:</h4> </div> &...
2
votes
2answers
1k views

Magento 2 csv product import : How to escape commas in category name

I would like to import a product csv into Magento 2 through the standard admin UI. The category name contains commas Default Category/Grocery/Snacks/Fruit, Nuts, Seeds. The (abbreviated) csv looks ...
1
vote
0answers
38 views

Magento, photo import ( csv ) from url, no direct link

How do I import CSV a photo from a url? It is not a direct link though. There is a link to the product page with description and a photo gallery. here is how the link ends /product.php/pid-...
0
votes
1answer
640 views

images not imported through csv in magento 1.9

I tried to import products through import/export, everything gets imported but not image. What I did was: Flushed cache and re-index Media folder provided permissions to 777 Place all images in var/...
0
votes
1answer
331 views

Magento 2 import product VAT rate from csv

I have a product csv file which I would like import into Magento 2. It contains all the required product data including the VAT rate for each product. This is represented as a percentage which can ...
0
votes
1answer
46 views

Product Images - Different Websites/Store Views

I've got two websites in my Magento project which got single inventory catalog. I would like to upload different images to different Websites. I managed to use store_view_code for each image. Up to ...
6
votes
5answers
8k views

Product custom attribute import with CSV Magento 2.2

I am trying to import product with CSV in Magento2. In first case all attributes are default attributes so import works fine. Now In second case I have added some custom attribute in my Magento 2.2 ...
0
votes
1answer
608 views

Products import success but products not imported

I am trying to import products using the system>import in Magento 2. The system say: CSV file has no errors. Import works fine. But still no products are created from the given data. Also ...
0
votes
1answer
344 views

Import default value in import product price

I have multistore in magento 1.9 site. Like au,us and ca I use following csv to import prices. No | store | sku | price au => MYSKU 20 us => MYSKU 30 ca => MYSJU 31 But this will set stores ...
0
votes
1answer
420 views

Uploading product csv error in magento 2

When I was uploading csv I got these two errors . Any one have any idea about it ? my csv is https://sheet.zoho.com/sheet/editor.do?doc=...
1
vote
0answers
301 views

Automatic import csv

Is there a way to automatic import product wholesale csv to magento2 I know some extensions has column mapper but my csv doesnt have the requered headers like productype etc, so the import fails. ...
4
votes
0answers
595 views

export group price and tier price in magento

How can we export group price and tier price in magento 1.9? Currently I am using profiler to export product price but I didn't get group price in exported csv file. Group price column shows blank ...
0
votes
0answers
160 views

Magento 1.9 Import Product with CSV but with Dynamic Product names

I need to Import Product Using CSV But CSV does not have Product name column so Need to create product names dynamic from products different attribute combination like type, color, fabric, etc. if ...
1
vote
0answers
198 views

not getting associated product's sku in export CSV Magento 1.9.2

I am trying to get associated product's Sku of configurable products in exported CSV file but not getting. Here is my Action XML in "Dataflow-Advanced profiles" - <action type="catalog/...
0
votes
0answers
74 views

Add CSV to order emails

How can I programmatically add a CSV containing all order information to order emails. By default only a PDF is attached to those emails. I know I have to write a plugin. But I don't know which class ...
1
vote
2answers
2k views

Category has not been created. URL key for specified store already exists

I am trying to upload my stock through the Magento 2 admin panel via CSV. I am getting the following error: Category "Default Category/Aftermarket and Parts/Spare Parts/ Fasteners/Screws and Bolts/...
0
votes
1answer
1k views

Product import : SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row

I am trying to import a CSV file for products. When clicked on "check data" button, it says "File is valid! To start import process press 'Import' button " but when I click on the import button, I ...
1
vote
1answer
471 views

Import Module to allow for multiple CSV imports in a batch setting

<?php /** * Copyright © 2013-2017 Magento, Inc. All rights reserved. * See COPYING.txt for license details. */ /** * Import model * * @author Magento Core Team <core@magentocommerce....
3
votes
1answer
842 views

Is there any tool to Convert magento 1 Product import csv file to magento 2

I have Magento 1 Product Import CSV file, I need to convert Magento 2 Product Import CSV Format. Is there any tool out there?. If not there means, Suggest me How to Convert it. Because ...
1
vote
1answer
335 views

Fail to import large file on Magento 2 from admin

I succeeded importing a csv file size 319KB with 357 products. But failed to import a csv file size 571KB with only 349 products. Please help me to fix the problem.
2
votes
0answers
548 views

Custom csv import using data flow profile not working in magento-1.9.3.1

I want to custom import csv in a model using data flow profile. For that i have followed below steps : 1) Created a customimport.csv under var/import 2) Under admin > system >Import/Export >...
1
vote
1answer
45 views

Magmi Special charactars not allowing to upload

I am facing an issue when uploading Products with Magmi only when excel sheet contains special charactars so, I followed link & tried saving with `Libre Office Calc with UTF-8', but that didn't ...
1
vote
0answers
563 views

import products csv file fails with 'Specified URL key already exists in row(s)' error

I have the following error "Specified URL key already exists in row(s): 99, 124, 179, 190, 194, 222, 271, 297, 326, 328, 329, 332". When I tried to import some 338 simple products with created ...
5
votes
2answers
2k views

magento 2 / can't set addImageToMediaGallery path

i created php file in root folder and trying to create simple product programatically in magento 2. testimg folder locating in root. I always thow the error: The image does not exist. Here is code: $...
1
vote
3answers
1k views

Importing prices csv is taking a long time

In Magento 2, there are roughly 115,000 products in the store. There are 7 customer groups. When importing prices via csv, the batch upload slowly imports the price but eventually crawls to a stop. ...
0
votes
1answer
321 views

EAN Barcode image

if I have in my CSV the EAN value as number in a column called EAN and I'm importing it as a Magento attribute called EAN that at the moment I have set it to display on the frontend near to the SKU ...
0
votes
1answer
319 views

Programitically Import products using CSV in video url not set magento2?

I have created a script for import CSV products everything's working perfect but one issue is product video url not set. <?php use \Magento\Framework\App\Bootstrap; include('app/bootstrap.php'); /...
0
votes
2answers
190 views

Permission to access customer export

What do I need to do in order to be able to export a CSV of my customers? Getting the following Forbidden Error. You don't have permission to access /index.php/brandits_admin/customer/exportCsv/...
0
votes
2answers
2k views

Magento 2 : Cannot set product stock status to “Out of stock” using csv

I tried to import a product using CSV with is_in_stock value to '0' and after the import, the stock status still shows "In stock" CSV looks like this : sku,is_in_stock DC3508BR,0 What am I ...
0
votes
2answers
835 views

Magento 2.1 Image Import Documentation Wrong

I have followed the documented instructions to create the image import CSV, and produced an exact replica of the CSV shown, but with my own product details, obviously. http://docs.magento.com/m2/ce/...
0
votes
1answer
296 views

Update Inventory and prices in Magento using a CSV

We would like to update inventory quantities and prices in our Magento store from our ERP system. We can generate CSV file in our ERP to be imported into Magento. We need CSV file format layout. ...
1
vote
0answers
89 views

How to skip some column to write csv data

I would like to skip some column to write data in CSV when it generate. Here is my code to generate CSV in magento. it would be start writing from column no 20 for first row only then continue with ...