Magento

The Magento Data Flow

Finally, after some hours of testing and trial and error, and forum searching I have some test products that I have successfully imported into Magento sort of.

My success and not so success:

1) Magento Import Profile - This whole section could be greatly improved upon. When you map Magento db fields with the file fields the files fields/columns must be in the exact order mapped.

For example: store, sku, price if mapped in that order must be in that order in the file or it will give the “Skip import row”.

In the file remove the header/field names information or it will give “Skip import row”.

There are some other hang ups that I didn’t have but if you need direction see this thread or look in the forum “Magento Data Flow” topic.

2) Simple products - seemed to import with out much of a problem. All the attributes imported fine but you have to create those fields in the csv to get them to populate. To get the attributes out of Magento simply created a product in Magento and export it to get all the attributes and Magento fields.

3) Configurable products are another story. See this thread for the issues that will arise for v1.0. Because they all happened with my import.

Sad to say the process was not as slick as I would have liked and would probably advise not going this route as of version 1.0.

PiotrN is probably on the right track with a programistic approach to getting product, categories, users and more from Xcart into Magento.

See this wiki post regarding some preliminary api code..

The api code could all change when version 1.1 comes out with “Web Service” capabilities, but at the moment it is something to play with.