Thanks for the response. I knew the Zen cart was a fork initiated several years ago but I was/am worried that there were sufficient changes to where it wouldn’t work.
With that said, I did try to do the import using the oscommerce tool and it worked for our 2000+ customers (within the known limitations) and also 200+ products (as best i can tell so far) it did not seem to import any of the orders, which is not a huge problem but would be nice to have for historical data.
did someone succeed importing data from Zen Cart in magento using the OsCommerce migration tool or using an sql script or a php import script ?
Thanks for your feedback.
Has there been any headway on this? I have my programmer working on a driver for zencart and a payment processor. I would like to tell him to stop what he is doing. I have absolutely had it with trying to style third party crap.
I am digging Magento so far. A few more hours under the hood and I will be able to get around it a bit better. I am however pretty much done with the zencart gig. If I could simply port my data I think I could sort the rest of it pretty quickly. I only have a few products with attributes and such.
Could anyone who has successfully imported data from a zencart (or OSC) store into Magento using the OSCommerce import mod please post how they got it to work properly?
We’re waiting for this mod to be fixed before moving to Magento - no updates seem to have been made to it for a few weeks now.
We had a successful (?) import of our ZenCart database in to Magento, using the osCommerce import tool.
We finally got it to work by following the guide in the Wiki (http://www.magentocommerce.com/wiki/creating_an_oscommerce_import_profile) and renaming the database tables. That was the problem for us—database table names. We made a copy of our existing Zen Cart db, then renamed all of the tables (in the copy). The reason to rename the tables was to remove the prefix (zencart_tablename renamed to tablename). After we did that, the import tool did what it was suppose to . . . . . kind of!
Here’s what the import tool did not do (I don’t think it is designed to do so, either): It did not import references to additional photos, so every product was imported with only its default image. No attributes were imported. Some odd characters showed up in the product descriptions, but that could be to do with character sets, not sure. The product descriptions were dumped in to both the description field and the short description field. Product and category META did not import. Product and category sort settings were dropped.
So, for us, even after using the import tool—we will basically have to go back to every imported product and re-do. Customers and orders did import just fine, though.
We really like a lot of the features of Magento, and we had been seriously considering migrating. However, we’re not sure if it is worth the effort—yet. Zen Cart works flawlessly and it feels a lot more stable. Zen Cart is, at least in our experience, much faster than Magento. So, right now, I think we’ll keep our Zen Cart up and running and keep our eyes on Magento.
Hope that helps!
Pixx - 06 July 2008 05:34 AM
Could anyone who has successfully imported data from a zencart (or OSC) store into Magento using the OSCommerce import mod please post how they got it to work properly?
We’re waiting for this mod to be fixed before moving to Magento - no updates seem to have been made to it for a few weeks now.
I used SOAP. It worked for me. I guess this post is meant for a programmer or someone who can read code.
You will need to create a mapping_table with fields id, new_id. And a customer_mapping_table with the same fields. You would use this table to map old customer ids to new customer ids if you want to import orders, which I did not.
Sales: Call 800.374.8146 (N America)|757.278.0920 (International)
