MAgento CSV example for MagMI

magento magmi
Lucas Scholten picture Lucas Scholten · Nov 11, 2011 · Viewed 13k times · Source

Hi I'm trying to make a CSV file to run a product import with Magmi.

Previous answers suggest that I export a CSV from magento to get an example. However it I'm running Magento 1.6, I think the CSV format in v1.6 has changed quite a bit and is no longer recognised by MagMI. For instance, magento now export categories as full names rather than a simple category id.

Could someone share a CSV with me that would work?

Answer

Michael picture Michael · Feb 20, 2014

There are 2 different CSV formats used in Magento: the dataflow format and the new (not so robust) format you're referring to. Magmi will only work with the dataflow format.

The easiest way to figure out how the format looks like is by exporting a CSV in the dataflow format. To do this do the following in the Magento backend: System -> Import/Export -> Dataflow profiles -> Export all products -> Run profile. You can then download the csv file via FTP, you'll find it in var/export.

Related questions

Which magento table contains product image names?

The problem I'm having is that I import products with Magmi (magento product import open source solution), but I don't see the product image on the front end. I need to know which table in magento database contains image names …

Read More
Change Magento product's attribute set.

I want to change the attribute set of Magento. I searched through, and everyone suggested to delete the product and re-import it with new attribute set. I did the same however after importing the data I could not see product …

Read More
Magmi csv format?

I can 't seem to find an example of the format Magmi wants for the csv data. Could someone please provide a one-line example of a successful product import? Edit: Magmi Wiki: http://sourceforge.net/apps/mediawiki/magmi/index.php?…

Read More