Transfering Products From One Zen Cart To Another

[hudda]

Hi,

Sorry to bother you all.

I was just wondering if i could have a simple, step by step guide on how to transfer products from one zen cart to another, with them staying in their categories.

I am new so if you could make it patronising as possible, that would be great!

Ive had a quick look at some posts but they are are part problems that want solving.

Any help would be greatly appreciated.

Thanks,

N.Hudda

[Ajeh]

Databases should be able to be backed up and loaded to a new, empty database without any problem ...

If it is the same version of Zen Cart on the new server, then just customizing the settings would be needed ...

If it is a newer version of Zen Cart on the new site, then you would need to run the upgrade via the /zc_install

If you are trying to merge products and categories from one Zen Cart database to another ... that is a whole different story ...

[hudda]

If you are trying to merge products and categories from one Zen Cart database to another ... that is a whole different story ...

Its that one, is there a simple easy to folllow guide to do this.

Thanks

[Ajeh]

There isn't a simple method ...

One that I have used in the past is to update all the products_id and categories_id by a higher value than what is used in one database vs the others ...

Then when you import the data there would be no conflict ...

However, you have to ensure that you update all of the fields in all of the tables correctly ...

products
products_description
categories
categories_description
specials
featured
meta_tags_products_description
meta_tags_categories_description
reviews
salemaker_sales

Then if using Attributes ... you need to also update similar issues for products_id as well as the options_id, options_values_id, etc. in all of the attribute related tables ...

It is not a lot of fun to do ... but it can be done if you are careful ...