Copy products from site to site

[mpforum]

Hi all,

I've got a customer that has asked for another site to be built. Their first site was very similar to the new site so I thought it would be easy to just export the product tables from the older site and import them into the new site.

This is where the problem started. The tables imported fine, but there are no products showing in the admin. The Categories showed up fine but none contain any products. I also noticed that when I went into 'admin'catalogue/attributes controller' at the top of the screen there was a yellow bar telling me that there were no option names either.

The tables I copied were:
zen_categories
zen_categories_description
zen_manufacturers
zen_manufacturers_description
zen_products
zen_products_attributes
zen_products_attributes_download
zen_products_description

Both Zen Cart versions were the same version.

Any idea's?

[rlexyd]

Hi all,

I've got a customer that has asked for another site to be built. Their first site was very similar to the new site so I thought it would be easy to just export the product tables from the older site and import them into the new site.

This is where the problem started. The tables imported fine, but there are no products showing in the admin. The Categories showed up fine but none contain any products. I also noticed that when I went into 'admin'catalogue/attributes controller' at the top of the screen there was a yellow bar telling me that there were no option names either.

The tables I copied were:
zen_categories
zen_categories_description
zen_manufacturers
zen_manufacturers_description
zen_products
zen_products_attributes
zen_products_attributes_download
zen_products_description

Both Zen Cart versions were the same version.

Any idea's?

Hi mpforum,

You also need to copy (zen_products_to_categories)

Let me know how you go!

Cheers,
rlexyd

[Ajeh]

If you are using Attributes you will also need the tables:
products_options
products_options_values
products_options_values_to_products_options

Note: in your case add the zen_ prefix ...

[rlexyd]

Hi Ajeh,

I recently copied my products from one site to another:

I didn't care about moving my attributes, I just created them from scratch in the new website:

I only copied over these tables and the site seems to be working fine:

zen_categories
zen_categories_description

zen_products
zen_products_description
zen_products_to_categories

That is all I need to copy to the new site if I just want the products to be moved over right, not the attributes nor the manufacturers??

Also,
When I was adding the zen_products_description to my PHPMyAdmin database, I kept getting an error and it seem to only add 265 products, other products did not add!

This must be a limitation with sql entries or something right??
I ended up adding them in smaller blocks in the Admin Instal SQL section and they worked fine!

Awaiting your further response.

Best Regards,

[Ajeh]

The Install SQL Patches was not designed to be a substitute for phpMyAdmin so there will be limitations to what you can do in there ...

[rlexyd]

I know the admin/install sql has limitation :) But the problem is the limitations were from the PHPMyAdmin databse section as I tried installing the products from there but it seems to be limited to 265 products or something?

Also,
zen_categories
zen_categories_description
zen_products
zen_products_description
zen_products_to_categories

Was that all I needed to copy to the new site if I just want the products to be moved over right, not the attributes nor the manufacturers??

[DrByte]

I know the admin/install sql has limitation :) But the problem is the limitations were from the PHPMyAdmin databse section as I tried installing the products from there but it seems to be limited to 265 products or something?

That's not a normal limit to phpMyAdmin, but maybe yours is incapable of more.

Also,
zen_categories
zen_categories_description
zen_products
zen_products_description
zen_products_to_categories

Was that all I needed to copy to the new site if I just want the products to be moved over right, not the attributes nor the manufacturers??

No. The complete list is here: http://www.zen-cart.com/wiki/index.p...a#Product_Info
For example, you must move Manufacturers too, because every product record has a manufacturer number tied to it. If you don't move the manufacturers too, then later when you *do* start adding manufacturers, all your products will be linked randomly to the new manufacturers, causing confusion. Similarly with all the other related tables.
Similar issues arise with other "selective" extraction of data.
That's why we always advise moving COMPLETE databases, not just a table here and a table there.
IT IS STRONGLY DISCOURAGED TO BE SELECTIVELY MOVING PIECES OF DATA WITHOUT INTIMATE KNOWLEDGE OF DATABASE OPERATIONS AND ZC STRUCTURE.