Magento

This has been talked about elsewhere but usually mixed in with other topics.

I see that you have released the oscommerce migration tool.

Is here an estimate on when can we expect one for Zen Cart? Days, weeks months?

Thanks in advance

Zen Cart is just a fork of osCommerce, I’m sure the data can’t be too different.  Why not try the osCommerce import tool?

I’m sure you could massage the data in a spreadsheet if something needs changing.

Ross,

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.

Thanks,

Mike

Hi there,

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.

daYmo

Hi folks, at first glance I am fairly impressed. 

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.

Nice work folks!

Nigel Lew

We have recently migrated a 1500+ product zencart store into Magento.

Feel free to contact us if you need help.

V.F

Ok thanks. I sent you a mail.

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.

Thanks

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.

Thanks

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.

Max

importCategories.php  (File Size: 4KB - Downloads: 58)

importCustomers.php  (File Size: 3KB - Downloads: 44)

importProducts.php  (File Size: 5KB - Downloads: 50)

Run importCategory.php, importProduct.php and importCustomer.php

Make sure you change the zencart table prefixes.

importCustomer doesn’t import customer address information. But at least customers will be able to login using their old information.

max_w

Hi max_w,
Your link posts back to this thread - could you please update the link?

Also, a little bit of info re: which files to run 1st, sequence etc would be helpful.
Thanks,
Eddie

msport7 - 09 July 2008 10:01 AM

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.

Thanks

Hi, I have zen car but the tables are not looking like zencart_tablename, but more of a wcTblename… Do you know if I just remove the wc?

also if I rename the table do I lose it? I also tried to install the plugin, but keep getting pear error messages…

Hi,

I’m interested in converting a few sites from Zen to Magento.... and I do know they have a utility that will convert an oscommerce site to Zen, So my plan was to see if I could reverse the data flow in that utility to put the zen data in a oscommerce database and then use Magento’s utility to finish the job.

Is this a good plan of attack, or just flawed logic??

Any updates??