MAgento CSV example for MagMI

Question

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?

Solution 1

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.

Solution 2

Magmi will only work with the dataflow forma so magmi need some structured for import base with column name with required field.

Download csv example Hear.

Configurable Product csv for import