phpmyadmin transfer of shop products...

HI,
I currently have a zencart within a zencart in which I am copying accross all products from one to the others so that it is quicker to make adjustments in the sec0ond cart rather than re adding each product.

I used phpmyadmin to export all the zen_products and zen_catagories related items. When I then import them into my second site, they do not appear on the user end. If I look in the folders in phpmyadmin (such as zen_categories), the items are all there but they do not appear in the actual admin for my zencart or on the user end.

Is there something I may have missed?

Thank you
Amy

rainbow_pixie_star:

HI,
I currently have a zencart within a zencart in which I am copying accross all products from one to the others so that it is quicker to make adjustments in the sec0ond cart rather than re adding each product.

I used phpmyadmin to export all the zen_products and zen_catagories related items. When I then import them into my second site, they do not appear on the user end. If I look in the folders in phpmyadmin (such as zen_categories), the items are all there but they do not appear in the actual admin for my zencart or on the user end.

Is there something I may have missed?

Thank you
Amy

table prefixes the same between the old and new database locations?

Copied all applicable tables such as products_descriptions, etc...?

Wiki information that relates: http://www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema

why dont you install apsona shopadmin in both ur shops and use that to transfer the products/cats ?

seems to be much easier then bughunting through phpmyadmin

Hi,
I have compared my config sections and both now say the same under // define our database connection
Is this what you meant by table prefixes the same between the old and new database locations?

I have triple checked that I have Copied all applicable tables for products_descriptions at the link you gave under the section for Table List Ordered by Data/ Product Info.

Still not showing my catagories or products on the page.

I would have tried an easier method but everywhere I looked everyone said to use the databases in phpmyadmin :( grrrrr!

Thank you
Amy

rainbow_pixie_star:

Hi,
I have compared my config sections and both now say the same under // define our database connection
Is this what you meant by table prefixes the same between the old and new database locations?

I have triple checked that I have Copied all applicable tables for products_descriptions at the link you gave under the section for Table List Ordered by Data/ Product Info.

Still not showing my catagories or products on the page.

I would have tried an easier method but everywhere I looked everyone said to use the databases in phpmyadmin :( grrrrr!

Thank you
Amy

Did you check the language id's of the old site en new one?

Where do I go to check the language id?

Thanks
A

rainbow_pixie_star:

Where do I go to check the language id?

Thanks
A

compare the language id(s) in the language table and the product/ categorie tables in your database

HI,
I checked the language id(s) in the language table and they are the same.
As for the product/ categorie tables in your database , still not sure what to look under for this. Looked under product_to_categories and there was nothing there to do with languages

Thanks
Amy

Might have t ohave a look into apsona shopadmin as this is getting messy and I dont want to start changing things and accidentally mess something up. Is apsona shopadmin easy to install?

Thank you
Amy

Hi,
I had a try with apsona shopadmin, exported the categories then imported into the other site and it still isnt working.

Thank you
Amy

When looking at your old database configuration settings in include/configure.php for DB_PREFIX is that the same for your new site in the same file? (Also look at admin/include/configure.php as compared to all other files.)