Transfer Products Database

[kelly34]

Hi,

 

Can anyone tell me how to transfer products from one oscommerce cart to another through myphpadmin?

[241]

are the products to be added to a set of existing products in the other cart or to a blank database

[kelly34]

I need to add them to a new blank cart

[241]

ok in phpMyAdmin select the database from the left hand window that has the products, then in the right hand window select the export tab and allow this new window to open.

 

in the part for export have the radio button SQL checked then select the catagories, categories_description, and all the tables beginning products

 

in the part SQL options select structure and any other you wish check all if unsure.

 

you can now either save as a file or just hit go, if you choose to just hit go then the new window will contain all that is required, select all from this window and copy and paste to notepad, then comment out the very first line by placing a # before it.

 

Now save this file naming it what ever you want with the extention .sql this now gives you a sql file to use on your blank database.

 

select your blank database in the left window and then select the SQL tab in the right hand window, where it says query you can browse to your saved sql file and hit go

[kelly34]

Thanks for that! :D