Skip to main content

Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
11 votes
4 answers
38k 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 ...
Julien's user avatar
  • 211
16 votes
5 answers
26k 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 ...
Swetha's user avatar
  • 707
6 votes
3 answers
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 ...
Mujtaba Haider's user avatar
2 votes
2 answers
1k 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 ...
Nagaraju Kasa's user avatar
17 votes
3 answers
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 ...
Kale's user avatar
  • 271
2 votes
1 answer
2k 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/...
Kirti Nariya's user avatar
  • 3,471
2 votes
1 answer
2k 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=...
Nitesh Kumar  Singh's user avatar
1 vote
1 answer
1k 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. ...
Kirti Nariya's user avatar
  • 3,471
1 vote
5 answers
24k 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 ...
Jackson's user avatar
  • 9,919
3 votes
2 answers
3k 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 ...
Richard's user avatar
  • 193
2 votes
2 answers
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 ...
Goutam's user avatar
  • 101
2 votes
1 answer
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 ...
user15151's user avatar
  • 581
1 vote
2 answers
5k 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 ...
Bullseye's user avatar
1 vote
1 answer
2k views

Product Importing issue for store

I am trying to import CSV for my german store product name other some information. so I export one product for getting CSV. I tried with the single record I just set my information in place of others ...
Yogesh's user avatar
  • 1,503
10 votes
6 answers
21k 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 ...
Dhaval Solanki's user avatar
8 votes
4 answers
28k 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> &...
simple guy's user avatar
  • 2,484
8 votes
8 answers
26k 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.
Matthew McLennan's user avatar
4 votes
1 answer
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 ...
Abdul Ghaffar's user avatar
4 votes
2 answers
5k views

Data showing in Grid but not in export file Magento2

I have created a custom report, Used below code in my ui_component listing file. <column name="custom_tax_code" class="Vendor\Module\Ui\Component\Listing\Column\Quantity"> <argument name="...
Jafar Pinjar's user avatar
  • 1,929
4 votes
1 answer
3k 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 ...
bennychaos's user avatar
3 votes
3 answers
6k views

Magento 2 Import CSV File to Custom Module Table

As per my requirement, I want to import CSV into my custom table, for that i have reviewed the following URL http://www.blogtreat.com/how-to-import-csv-file-to-custom-module-table-in-magento-2/ In ...
senthil's user avatar
  • 1,729
3 votes
3 answers
5k 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 ...
homespace direct's user avatar
2 votes
2 answers
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 ...
mit patel's user avatar
2 votes
3 answers
2k 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 ...
SharmaV's user avatar
  • 129
2 votes
1 answer
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 ...
MrKainig's user avatar
  • 121
2 votes
1 answer
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 ...
Matthew McLennan's user avatar
2 votes
4 answers
5k 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($...
Alin Lupoiu's user avatar
  • 2,662
1 vote
0 answers
935 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 ...
Joey's user avatar
  • 571
1 vote
2 answers
778 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? ...
Webninja's user avatar
  • 1,593
1 vote
3 answers
6k 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 ...
Adam Allen's user avatar
  • 2,205
1 vote
1 answer
2k 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 ...
Kumar's user avatar
  • 333
1 vote
1 answer
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 ...
user00247's user avatar
  • 638
1 vote
1 answer
2k views

Magento & fputcsv strange empty row at beginning of file

I'm writing some info to a .csv file in Magento: public function batch_update_attributeAction(){ $attribute_id = $_GET['attribute_id']; $table_name = $_GET['table_name']; $input = $_GET['...
Moose's user avatar
  • 7,495
1 vote
0 answers
1k 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 ...
Shekhar Suman's user avatar
1 vote
2 answers
923 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
user28311's user avatar
0 votes
2 answers
1k 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 ...
Mohammad's user avatar
0 votes
0 answers
669 views

Send csv file on email in Magento 2.4.0

I am generating order report in csv and saving that file in Var folder. Now i want to send that file on email without using any email template. How to i can send that file on email ? Kindly check ...
Wajahat Bashir's user avatar
0 votes
6 answers
16k 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 ...
luke brown's user avatar
0 votes
1 answer
1k views

magento 2 How to add new column in order csv export

magento 2 How to add new column qty ordered in order csv export. and coumn should not be visible in the grid
user12992122's user avatar
0 votes
2 answers
1k 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/...
robgt's user avatar
  • 439
0 votes
1 answer
612 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'); /...
Magento2 Devloper's user avatar
0 votes
3 answers
686 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?
Devidas's user avatar
  • 3,358