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.

Now that I have the variant values and the option names listed within the csv file as columns I can change the name of those options names to the attribute names I created in Magento. Theoretically this should work from what info I have gleaned from the forums and little dabbling with csv files I exported from Magento. My next step is to test this and see how successfully it is.

1) I will have to create a custom import profile and map all the Xcart field names to the magento one.
2) Cross my fingers and hope the import goes ok.

I am a complete novice when it comes to Magento Code, but I have much experience with X-cart 4.0.x code and would love to move to Magento.

I think the first place to start is to narrow down which version to begin the import. Since 4.1.x just got released and I don’t currently use it I am going to work with 4.0.x. I know there are differences between database structure from 4.0.x to 4.1.x but I don’t know how the exported product csv file differers.

Next is “what is going to be imported?”.

I think products is the most important feature.

What product elements need to be imported and how complex 1-5 from my point of view?
1. Variants - 5
2. Price - 5 - can be complex depending on membership pricing and variants
3. Descriptions - 1
4. SKU - 1
5. Weight - 1
6. Category - 5
7.List Price - 1
8. Availble - 1
9.Tax - 3
10. Dimensions - 3 - can be simple depending on attributes set up in Magento or if auto setup
11. Images - not sure, Magento’s looks a bit complex
12. Extra Fields - 3 - complex depends on if attribute is set in Magento
13. Manufactures - 3 - see Dimensions
14. Shipping - not sure - see Dimensions
15. For Sale - 1
16. Free Shipping, Tax Free, Discount would have to be imported without and set up conditions in magento separately.

Any other comments or ideas are much appreciated.