Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Convert zencart db to oscommerce db


carpenoctem

Recommended Posts

I am aware that table names between ZenCart and osCommerce are different, but I do not know if I can easily convert a ZenCart site to an osCommerce site?

 

Can somebody please help???

 

I cannot stand zen..... and do not want to learn how to use it for my customer... but at the same time, i do not want to be stuck copying and pasting over and over again.

 

Please help me ASAP

 

Thanks

 

Mark

Link to comment
Share on other sites

You *might* be able to get away with a phpMyAdmin backup, with DROP TABLE, then restoring that on top of an osC 2.2 MS2 shop. The downside would be that you would probably end up with some configuration options that didn't actually do anything, since the supporting code would be missing from the PHP files.

 

If you want to do a table structure comparsion, look for mysqldiff - - http://www.adamspiers.org/computing/mysqldiff/ .

 

Alternately, you could do it table-by-table, using the following as a rough guide:

 

tables for customers info:

- address_book

- customers

- customers_basket* (if you want what's currently in their shopping cart)

- customers_info

 

tables for orders:

- orders

- orders_products

- orders_products_attributes (if you use them)

- orders_products_downloads (if you use them)

- orders_status_history

- orders_status (if you've changed from the default)

- orders_total

 

table for product info

- products

- products_description

- products_to_categories

- categories

- categories_description

- products_options* (if you use them)

 

I think I got all the ones that you'd probably care about.

 

-jared

Link to comment
Share on other sites

Do you know what the chances of me getting this to work correctly are??? I am scared of mySQL.... and paranoid about it (as i do not have a lot of experience with it).

 

Thank you for your help.

 

Mark

 

You *might* be able to get away with a phpMyAdmin backup, with DROP TABLE, then restoring that on top of an osC 2.2 MS2 shop. The downside would be that you would probably end up with some configuration options that didn't actually do anything, since the supporting code would be missing from the PHP files.

 

If you want to do a table structure comparsion, look for mysqldiff - - http://www.adamspiers.org/computing/mysqldiff/ .

 

Alternately, you could do it table-by-table, using the following as a rough guide:

 

tables for customers info:

- address_book

- customers

- customers_basket* (if you want what's currently in their shopping cart)

- customers_info

 

tables for orders:

- orders

- orders_products

- orders_products_attributes (if you use them)

- orders_products_downloads (if you use them)

- orders_status_history

- orders_status (if you've changed from the default)

- orders_total

 

table for product info

- products

- products_description

- products_to_categories

- categories

- categories_description

- products_options* (if you use them)

 

I think I got all the ones that you'd probably care about.

 

-jared

Link to comment
Share on other sites

  • 2 weeks later...

Your chances are very good, assuming you follow some simple steps:

1) backup, backup, backup

2) make a tiny change, and then restore the database backup to make sure you know how to do it, and that it works

3) go slow, ask questions, take notes of what you've done, and be patient.

 

That's how most of the folks on here (myself included) came to have even the slightest clue about PHP and MySQL.

 

-jared

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...