A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
448 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.
3
votes
4answers
2k views

Magento 2: how can I remove columns in exported csv from order grid?

I want remove columns while exporting order grid data in magento 2. I google it but didn't find solution. Like I want to remove these fields from exported csv. Payment Method Total Refunded Customer ...
3
votes
2answers
4k views

CSV Import: Simple Products not linked to Configurable Product

I'm importing Configurable products using the Import/Export tool but can't get the simple products to be associated with the configurable product. The CSV looks like this1. _type, ...
3
votes
1answer
791 views

Export new orders to individual CSV files

Could someone tell me how to export each new order from Magento to individual CSV files and save them on the server?
3
votes
1answer
216 views

static attribute not handled by csv importer

I created a static product attribute with corresponding source model: /* @var $installer Mage_Catalog_Model_Resource_Setup */ $installer = $this; $installer->startSetup(); $installer->getConnection()-...
3
votes
1answer
362 views

Adding the same product image path to multiple products through csv import issue

I am trying to add products by duplicating them in a CSV file. It seems to work fine but when I update the product image path with the same path to multiple products it doesn't seem to update. When ...
3
votes
0answers
113 views

Run native csv import product magento 2, no way to set csv file in custom module

I followed steps in this topic Magento 2 run native product csv import programtically, but it didn't work. When I try to import product through a CSV file in back-office, the check data is correct and ...
3
votes
1answer
884 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 ...
3
votes
0answers
37 views

Adding new products to a store with a template, without changing other products in the store

I have recently taken over a store at work that I did not build, nor do I have enough experience with Magento to be truly confident yet. I have a .csv product template, to add 195 new products to a ...
3
votes
0answers
2k views

How to export/import orders in Magento?

I am moving companies website from old installation 1.7.1 to fresh installation of Magento 1.9.3. I have moved now all the Product and Customer data easily - how do I export/import orders? I have ...
3
votes
0answers
267 views

Problem importing images from a CSV file - Magento ver. 1.9.2.2

Magento ver. 1.9.2.2 I've been working on this issue for several days and have read numerous articles. I have uncovered a few clues but can't tell where the hang up is. Here is a link to a test CSV ...
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
2answers
3k views

Magento 2: Create downloadable CSV

I want to export table content in downloadable csv format. In magento 1.x it can be achieve by _prepareDownloadResponse() how can we achieve same in magento 2. Looks like this function is missing in ...
2
votes
3answers
9k views

How to read CSV with multi columns and reside in magento root dir?

If a csv file with id, name, price columns reside in magento root dir How I can read this file and retrieve data using Varien_File_Csv() from custom model?
2
votes
4answers
4k views

Bulk item delete via csv

i am a newbie in magento so dont know much about coding and scrippts, my problem is i have list of SKU's which are end of line now and has been replaced with new products. i want to delete them so i ...
2
votes
2answers
76 views

How to send a file using FTP?

I have a sample CSV file and want to send it to another server using FTP. I have successfully connected FTP but couldn't able to send the file. In the FTP where I want to send, there are 2 folders ...
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 ...
2
votes
1answer
13k views

“Product Type is invalid or not supported in rows” importing csv file

I’m new in using Magento. I’m using Magento 1.9. My web site have to sell Paper books and Ebooks, so I set two kind of products in my catalogue: “simple” and “downloadable”. Now my need is to import ...
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($...
2
votes
2answers
2k views

Magento 2 Import - General system exception

I try to import customer data into Magento2 which got exported from a Magento2 store, but something wont work... Since its a 1:1 Magento export, the import should be perfectly fine or am I wrong ...
2
votes
1answer
1k views

Mass password reset after Importing customers via CSV

I'm performing a large import of an existing customer base from a different platform. I've exported their DB and written a script to make a CSV to import into Magento 1.9. Unfortunately, we do not ...
2
votes
2answers
1k views

Export CSV error “You cannot define a correlation name more than once” cause by SQL JOIN?

So I have narrowed it down to the fact that Magento does not like the JOIN when I am adding it to the collection. Is there anyway to make it so it doesnt duplicate the correlation name or whatever it ...
2
votes
1answer
235 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=...
2
votes
1answer
36 views

Magento 2 Localization Adding Links in CSV

How to add text with link in csv file of a module. For example, "An error occurred" I want to add text with link like below for this message. "An error occurred.Please contact our customer service&...
2
votes
2answers
262 views

While Exporting CSV from Sales > Order Grid, I am getting error - “You cannot define a correlation name 'order' more than once”

When I try to export csv in Sales > Order Grid, I am getting You cannot define a correlation name 'order' more than once Trace: #0 /www/Myproject/htdocs/lib/Varien/Db/Select.php(281)...
2
votes
1answer
488 views

import multiple image from two column

i want import this in my magento, this csv have two columns of image, now how import this on my store: this is a csv example: http://www.filedropper.com/importproduct i read some guide but this ...
2
votes
3answers
6k views

Using Varien_File_Csv and _prepareDownloadResponse to return csv

I am creating csv exporter for some custom tables where multiple tables are combined in a way that is not like any model or grid in the back end. In the controller I have a action function that ...
2
votes
3answers
2k views

bulk apply (or csv import) fixed product tax

I have a csv file with more than 400 items to import. All the attributes are imported fine except for the fixed product tax (that is the same for all products). I tried to manually create one on a ...
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
718 views

Magento Product CSV Import error

I'm having kinda serious issue with CSV product import. When I'm trying to import only one product from CSV (for testing reasons) I get following error: SQLSTATE[23000]: Integrity constraint ...
2
votes
1answer
1k views

Cron Advanced CSV Product Import Mapping

I'm wondering how I could map a product CSV import including product attributes etc. I need the CSV import to run daily via cron, as the CSV file is updated daily with product data. I also need any ...
2
votes
1answer
321 views

Multi Site Magento store won't reimport a CSV of products that I just exported

I have two different sites for my magento store. Each site is originated in a different country. I am trying to create a configurable product with attributes such as colour and size. These attributes ...
2
votes
1answer
4k views

csv import shows category does not exist for already existing categories

Am using Magento version 1.8.1. Created categories in admin and prepared the CSV file filling out all the categories for the products. when importing am getting error "category does not exist in row ....
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
978 views

Magento 1.9 CSV import using categoy id

In the category column of the CSV ("_category"), how do I use the ID number of the category instead of the full path? I did google this but I think the results were for 1.7 as the field name was "...
2
votes
1answer
2k views

CSV - Imported product image is not visible in admin section but shown in front end

I have imported products from CSV into my magento store using Product import section.The product images are visible in front store, but not visible in admin section. When I try to edit a product, ...
2
votes
2answers
2k views

Magmi image import sets majority of product images, but not all [closed]

I've been using Magmi to do a mass import of both product data and then going over the product data to reference product images via SKU. I've been able to get Magmi to import product data without ...
2
votes
1answer
396 views

Cannot export customer list in Magento 2

I was trying to export a customer list to a CSV file in Magento 2 (2.2.7). But every time I try it comes up with a 500 error regardless of how many customers are included in the export. Exporting ...
2
votes
1answer
264 views

Magento1.9 CSV generate but not download on save action

Here is my controller code :: public function saveAction() { $post_data=$this->getRequest()->getPost(); if ($post_data) { try { ...
2
votes
3answers
2k views

magento 2 images on category page not visible

If I import products with csv the image is not visibly at the category page. If I go to the product page the image is showing. How is that possible. base, thumbnail, small image and swatch are fine. ...
2
votes
1answer
2k views

Append Complex Data (duplicate images) [duplicate]

Way the Append Complex Data keeps adding (duplicate) the pictures every time I do the import. Can this been change? All other data (attributes) are not duplicated, just the images.
2
votes
1answer
9k views

Product has image but it show placeholder image as default image

I got a strange problem I imported products by csv. There're some products showing placeholder magento image, even it has image. I try to re save, reindex, clear cache. not working it still showing. ...
2
votes
2answers
4k views

Having a small issue with Magento CSV import

ive managed to use the profiler for CSV import on magento - when i run and execute the file i get this http://imgur.com/UlyPREu So the data processes 100% (i dont think images are crucial for ...
2
votes
1answer
726 views

Magento sets zero quantity importing csv with only _links_* column

I'm trying to update products adding related, cross sell and upsell products by importing a CSV from System->Import/Export->Import functionality. After the import process all the modified ...
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 ...
2
votes
2answers
2k views

Parsing a CSV file for custom options script

First off I'm new to Magento, so please forgive me for my ignorance. I would like to read from a CSV file that has item_id, sku, and the custom options data so I can use it in a foreach loop. I'm ...
2
votes
1answer
2k views

magento import not working for products set with visibility of 1 (not visible individually)

I have a spreadsheet which I use to import my simple products. Originally, I only had products on there which had their visibility set to 1 (not visible individually) - as they were meant to be ...
2
votes
0answers
37 views

Add Attribute Bulk Value Using CSV File in Magento 2.3.3?

I have Magento 2.3.3 Store And I have too many Product Dropdown Attribute And One Attribute have a something 500 1000 value. So How can I add multiple values using CSV file or other options so, ...
2
votes
0answers
150 views

Magento 2 - Import product quantity is empty after product csv import

In Magento 2.3.1, When I Go to admin panel System -> Import -> Products and Upload product CSV. Product imported with all information but miss qty, it shows empty. Any help, experience and ...
2
votes
0answers
75 views

Magento 2.2.5 - Delete all products and products images

I have a site with Magento 2.2.5, with thousands of products imported via Magmi v0.7.23-git with csv. I tried to delete all these products with the Magmi utility 'Clear Catalog v1.0.4', and then ...