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
10
votes
4answers
35k views

Adding images with CSV import

I have been running into problem after problem with the CSV export/import functions. My currently problem is that I cannot seem to assign 'image', 'small_image', and 'thumbnail' attributes to any ...
15
votes
5answers
23k views

Import & Export all categories using csv file (without extension)

I want to import all the categories in magento using CSV file, I tried to do using extension http://www.magentoworks.net/importexport-magento-category-extension/ it works but i want to do it using ...
17
votes
3answers
16k views

Importing orders from a CSV into Magento programmatically

We're switching from an old, outdated point-of-sale system to using Magento 1.7 as our POS exclusively. Not unexpectedly, one of the challenges we're facing is how to get almost 20 years of records ...
5
votes
2answers
24k views

Import products with multiple categories

Hi I am importing products in my 1.7.0.2 new setup, I already added the categories. when i import the csv product file, all go well. But the problem is the product is added to only subcategory, it is ...
0
votes
5answers
15k views

Magento 2: Product Import Error - Product Type is invalid or not supported. Duplicates found in column names [SOLVED]

I'm using Magento 2 CE Version 2.1.2 I have exported Sample CSV File from Magento Admin & importing the same file again. Then also it's not working for more than 1 record. If you have only 1 ...
1
vote
1answer
134 views

Magento 2: Import categories images external url via csv

I have import categories via CSV and I would like to import category image from external URL. I have used Magento ver. 2.3.1 I have tried to save images to the category but can't able to get success. ...
2
votes
1answer
4k views

Base Image, Small Image, Thumbnail Image are not selected after product images csv import

I have successfully imported product images using csv file but Base Image, Small Image and Thumbnail Image columns in Images tab, are not selected. No Image is selected by default. So products images ...
2
votes
1answer
4k views

Import of product via CSV (need to update, not replace, not append)

I'm having this situation where I need to import around 300 products with different attributes and 4-8 pictures for every products. I have created a valid csv file, within my ERP program (accounting ...
1
vote
1answer
1k views

Product Importing issue for store

Hello I am try to import csv for my german store product name other some information. so i export one product for getting csv. i tried with with singal record i just set my information inplace of ...
1
vote
0answers
231 views

Magento 2: How to import export Categories in csv via backend using Entity Type catalog_category

I have to need import export categories in csv same as product, in Magento 2 provided same thing for product. I have tried below code but facing issue in Model file path Vendor/CategoryImportExport/...
0
votes
2answers
3k views

Magento 2 csv import : How to escape commas in additional_info?

I am importing products via .csv import. I have an additional_attribute field that contains commas. Commas are the delimiter within additional_attributes, and when i try to import my products, all ...
7
votes
6answers
20k views

Is there a way to export all categories into a csv?

Is there a way to export all categories into a csv? Im moving data from a non-magento store into a fresh build.
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
1answer
3k views

Is there a list of default magento attributes?

I am scrubbing a product spreadsheet csv. I would like to know if these are custom, configured, or default. By configured I mean if something like customer groups were created and price tiers were ...
2
votes
4answers
3k views

How to get product price after a discount was applied

I tried to get the product price after a catalog price rules was applied and i can't. The code that i use to do this: //load product by id $product = Mage::getModel('catalog/product')->load($...
1
vote
3answers
4k views

Exporting a CSV File

I need to export a CSV file with all the product weights on it, i tried to do it in the back end but i get this error Request Timeout This request takes too long to process, it is timed out by the ...
1
vote
2answers
790 views

Programatically put meta description in Magento cms Pages

I have more than 500 cms pages in my Magento store, and i want to change all meta descriptions based on a CSV file. There are two columns in my csv file: Cms Page identifier Meta description
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 ...
4
votes
1answer
2k views

Magento 2.1.2 - Importing multiselect attribute values from CSV

Is it possible to create values for a multiselect attribute via CSV upload? For example we want to populate a multiselect attribute for Car Year. We added a few sample entries and the ...
4
votes
1answer
1k views

Admin Grid - Remove columns from export

I am in a situation, where I need to display an email_address1 in grid, and during export have to use other one (email_address2). For this I have added two columns in grid, with email_address1 is ...
3
votes
3answers
3k views

Are there any csv import logs kept?

We've been trying to import a csv of products on to our Magento store, Magento doesn't show any errors when it checks the file, and it reports the import as successful once it has "finished". The ...
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 ...
2
votes
1answer
1k views

Importing “Ø” (special character) in Magento

I had a lot of problems with the Export and Import of Products through a CSV file. My main issue is that in Germany MS Excel generally uses ";" as a delimiter instead of ",". I tried a few work ...
1
vote
2answers
2k views

magento can't upload large csv file

this is my file upload code when i try to upload file which has size more than 75mb i can't upload file i did't get any error i also change php.ini file still its not working $uploader = new ...
1
vote
1answer
1k views

How to add Upload Button for importing a csv file in the Custom Admin Grid Container?

I'm creating a custom module where i have a requirement to add a upload button to the Grid container for uplaoding a csv file and execute it to update a attribute value in the database. how do i ...
1
vote
1answer
908 views

unable to update Status of product from csv

When I change the status field of product from enable to disable or vice versa via updating through csv using data flow profile, it is not updating value of status, simply leaves status of a product ...
1
vote
2answers
459 views

Importing product videos

We have thousands of products with videos to move from the old shop system and we need a way to import videos to Magento. Is there some nice product video extension that would allow to import via csv? ...
1
vote
0answers
307 views

Import products and customer data programatically

I needed to programatically export and import customer data, product data and order details. I've successfully created my exports. I'm having problems with my import. I need to do this using an ...
0
votes
2answers
836 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
5answers
15k views

How do I import configurable products? csv?

I have created a .csv file and then created a profile to import simple products which works absolutely fine. However when I create a configurable product, it does not associate the simple products to ...
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'); /...