How To Transfer Product Catalog from one site to another

[webfective]

Ok, this may have been answered somewhere here, but I wasnt able to find it.

 

I have an OSCommerce store that has about 100 products and product images in it now. I purchased a new design, and have decided to use that. The first store was installed in my main public_html directory, the 2nd store is installed in a subdirectory (public_html/store/)

 

At first I was going to have all new products in the new store, but have decided I want to also use all the products from my first store. Instead of manually adding one product at a time, isnt there a way I can just export the SQL file for my products and categories, and just add the file to my new store?

 

Im not very good with phpmyadmin or mySQL.

 

I just was wondering if it were possible, and what needed to be exported from my old store's database.

 

Thanks

Bill

[compuskill]

Ok, this may have been answered somewhere here, but I wasnt able to find it.

 

I have an OSCommerce store that has about 100 products and product images in it now. I purchased a new design, and have decided to use that. The first store was installed in my main public_html directory, the 2nd store is installed in a subdirectory (public_html/store/)

 

At first I was going to have all new products in the new store, but have decided I want to also use all the products from my first store. Instead of manually adding one product at a time, isnt there a way I can just export the SQL file for my products and categories, and just add the file to my new store?

 

Im not very good with phpmyadmin or mySQL.

 

I just was wondering if it were possible, and what needed to be exported from my old store's database.

 

Thanks

Bill

 

Hi,

so, you simply want to transfer the databases, right?

 

1) go to www.your-domain.com/admin/backup.php

2) create a database backup

3) download the created file either by clicking on it or by using a ftp program (admin/backups/....sql)

4) upload the file to the admin/backups/ folder of your new store

5) go to www.your-domain.com/store/admin/backup.php and restore the uploaded database

 

Ready.

[♥geoffreywalton]

Would be very careful doing that.

 

What version are both your shops? Are they the same?

 

If you restore the db all your other tables will be overwritten.

 

You could install Easy Populate on both shops, export from one and import to the other.

[amr.khusheim]

i had the same issue

 

i did what he did but the only left for me is to make the images appear ..

 

i did copy the images file from the old website to the new one .. is that enough ?

or do i need to modify a file path by editing a php file ??

 

thanks a lot

[♥geoffreywalton]

No, if both your configuration files point to where the images are, normally /images you should be OK.

 

Set up a product throughthe admin panel.

 

See where the image is placed, check your images are in the same directory and have the same permissions.

 

Should get you started.

 

G