products from one store to another

[lcarlo1507]

i have a zen cart website and i also have another one. is there a way to copy all the products only to the other zen cart site. I don't want to do each one all over again there are thousands.

any help would be great.

thanks

[nigelt74]

Yep, but you won't do it through zencart

you will need to go to your hosting control panel,
open up PHPmyadmin and export the relevant tables

probably these ones (yours may not have the zen prefix)

zen_categories
zen_categories_description
zen_manufacturers
zen_manufacturers_info
zen_products
zen_products_attributes
zen_products_attributes_download
zen_products_description
zen_products_discount_quantity
zen_products_notifications
zen_products_options
zen_products_options_types
zen_products_options_values
zen_products_options_values_to_products_options
zen_products_to_categories
zen_product_music_extra
zen_product_types
zen_product_types_to_category
zen_product_type_layout

You'll probably not need all of them, but it isn't going to hurt if they are going to a new site

and then import them into your new database

also don't forget to copy the images folder, (seen loads of people copy everything and forget this)

[lcarlo1507]

thank you i will let you know if it works or i messed up. I'm so not good at this stuff.

Luci

[lcarlo1507]

where do i find the php files?

[nigelt74]

Nothing to do with php files, php admin is a databse control panel, it allows you to export the tables from your existing database.