Updating webstore to new OsCommerce 2.2 RC2

[gameuniverse]

Does anyone know how to import catalogues and products from old store to new store?

 

This would save months of work

[♥geoffreywalton]

Install Easypopulate contribution on old store.

 

Export file.

 

Install EP on new store

 

Import file

 

Or

 

Use phpmyadmin, export all prod files, all manu files and all category files.

 

Try to imort using phpmyadmin. Edit import file to new file layout if required.

 

or read upgrade instruction that come with each release and follow db upgrade instructions

[GemRock]

it depends on your shop. but these tables are 'must-have':

 

1. products;

2. products_description;

3. categories;

4. categories_description;

5. products_to_categories.

 

if you have manufacturers, then the two tables with manufacturers in the table names. if you use product attributes, then all the tables whose names contain products and attributes, or products and options.

you use phpMyAdmin to do it.

 

Ken

[gameuniverse]

it depends on your shop. but these tables are 'must-have':

 

1. products;

2. products_description;

3. categories;

4. categories_description;

5. products_to_categories.

 

if you have manufacturers, then the two tables with manufacturers in the table names. if you use product attributes, then all the tables whose names contain products and attributes, or products and options.

you use phpMyAdmin to do it.

 

Ken

 

 

thanks for your helpful replies

 

i knaffed it i think as the new store was created on the same database name as the old store and I can't find the old product files in there anymore so assuming they have been erased to make room for new? I am quite new at this but learning quickly as I go. Before yesterday I never knew those DB existed!

 

I do have backups still from the old store, is it possible to extract those products from there somehow?

 

Brent

[gameuniverse]

thanks for your helpful replies

 

i knaffed it i think as the new store was created on the same database name as the old store and I can't find the old product files in there anymore so assuming they have been erased to make room for new? I am quite new at this but learning quickly as I go. Before yesterday I never knew those DB existed!

 

I do have backups still from the old store, is it possible to extract those products from there somehow?

 

Brent

 

 

done followed your instructions Ken and worked blurdy beautiful. Im learning a lot here. Very satisfying and I also have your Header Tags for Novices contribution installed and it is excellent.

 

Thanks for all your help :)