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
37k 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 ...
16
votes
5answers
25k 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 ...
1
vote
1answer
640 views

Magento 2 how to import custom link type products

We have created custom link types like consumable, recommended, etc..like cross-sells, upsells, related. Now we would like to implement the import functionality for these custom types. We have written ...
17
votes
3answers
19k 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
25k 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 ...
1
vote
1answer
1k 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
5answers
20k 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 ...
2
votes
1answer
1k views

How to Create a excel file in custom module?

I want to create an excel format file for download in Magento 2 <item name="buttons" xsi:type="array"> <item name="add" xsi:type="array"> <item name="name" xsi:type=...
1
vote
1answer
633 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
2answers
5k 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
5k 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
2k 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 ...
0
votes
2answers
4k 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 ...
8
votes
8answers
24k 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.
7
votes
4answers
18k 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> &...
9
votes
6answers
15k views

Product custom attribute import with CSV Magento 2

I am trying to import product with CSV in Magento2. In the first case, all attributes are default attributes so import works fine. Now In the second case I have added some custom attributes in my ...
2
votes
1answer
4k 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
3answers
365 views

Import new and update products and their attributes with a CSV file and cron job Magento2

I am using Magento 2.3.3 and wants to import products using cron and csv. I have google Sheet which contains all products data and sheet's data changes continuously. So I have to run a cron every day ...
2
votes
4answers
4k 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
2answers
853 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
1
vote
3answers
5k 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 ...
4
votes
1answer
2k 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 ...
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 ...
3
votes
3answers
4k 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
1answer
2k 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 ...
2
votes
2answers
2k 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
2answers
595 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
1answer
1k 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
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
0answers
630 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 ...
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
0answers
852 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 ...
0
votes
0answers
41 views

Magento 2 : Add new options to Import settings > Entity Type

Is their any way i can add new entity type & just execute basic method without any validation of csv ? Please share your thoughts on this.
0
votes
2answers
411 views

Magento2.3: How to create a CSV and JSON file?

I have successfully got the wishlist collection of customer by referring the below link: https://www.rakeshjesadiya.com/get-wishlist-collection-of-customer-by-customer-id-magento-2/ Now, I have to ...
0
votes
1answer
1k views

How to remove products from the particular store view in magento2

I have created three website view and three store views in magento2(English,French & German). I have uploaded the products through default magento2 CSV import option and mapped to all store views. ...
0
votes
3answers
383 views

How to increase the length of the product meta_description in Magento1.9 (when importing)?

How to increase the limit of meta_description in magento1.9 .When we have import bulk of products during CSV then showing meta_description limit error.Please give me any solution?
0
votes
6answers
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
2answers
989 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
462 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'); /...