How can I move ALL products from one shop to another?

[Lao]

Can anyone tell me if that's possible? I want to move all my products (including reviews) to another shop. Is that possible?

[bill110]

Can anyone tell me if that's possible? I want to move all my products (including reviews) to another shop. Is that possible?

make a backup of your database, copy it , place the copy in the backup folder of your new shop, renameit to match the existing backups, then do a restore from backup. all product images from the old shop will also need to be copied over to the corosponding location in new shop.

[Lao]

Thanks. Can I backup only the products?

 

The reason that I ask this question is that I made too much modifications to the present database and now I want to make a new shop from zero and import only the products from the first database.

[ComicWisdom]

Thanks. Can I backup only the products?

 

The reason that I ask this question is that I made too much modifications to the present database and now I want to make a new shop from zero and import only the products from the first database.

 

 

Create the new database for your new shop. Then export and import only the products tables. You will have to delete those tables from your new shop database before you try to import them if you are using myPHPadmin.

[Lao]

And that's all I have to do?! I guess that goes for the customer table as well, right?

[Lao]

And that's all I have to do?! I guess that goes for the customer table as well, right?

 

 

Well, now I'm afraid to do what you said.

 

I tried to copy customer table to the new shop so I copied "customers" and "customers_info". One example is:

 

INSERT INTO `customers` VALUES (80, 'm', 'Zsolt Laszlo', 'Wegroszta', '0000-00-00 00:00:00', '[email protected]', 83, '0723354422', '', '6b14005181c824cc45a301e45fa8fa7a:34', '');

 

I ran this over the new DB, customers show up in the Admin list, but when I edit a customer it's all blank, all fields are blank, except the one customer I created for testing. That one is working good.

 

Anyone?

[♥Vger]

When accessing the old database in phpMyAdmin, click on the Export tab, highlight only the 'customers' table, make sure that you have selected both table structure and data, and Drop Table, and then click 'Save As File'.

 

This will download only the customers table structure and what is in the customers table.

 

On the new site in phpMyAdmin click on the SQL or import tab, Browse to the backup you took of the customers table and click the Go button. Because you saved this table with a 'Drop table if exists' command in it then it will drop the existing table, recreate it and put the data in it.

 

Vger

[Lao]

Thanks for replying Vger, but that didn't work. It gave me this error and all empty fields in the Admin Customers area.

Let me add that on my new shop I run oscommerce-2.2ms2-060817.

 

 

Warning: reset() [function.reset]: Passed variable is not an array or object in /usr/local/psa/home/vhosts/maycon.ro/subdomains/sh/httpdocs/admin/includes/classes/object_info.php on line 17

Warning: Variable passed to each() is not an array or object in /usr/local/psa/home/vhosts/maycon.ro/subdomains/sh/httpdocs/admin/includes/classes/object_info.php on line 18

 

 

I put some contribs in the old shop that don't allow me to use Extra Customer Fields contrib, so I'm making a new shop in witch I want to import ALL the customers and ALL products from the old shop.

[boxtel]

Thanks for replying Vger, but that didn't work. It gave me this error and all empty fields in the Admin Customers area.

Let me add that on my new shop I run oscommerce-2.2ms2-060817.

Warning: reset() [function.reset]: Passed variable is not an array or object in /usr/local/psa/home/vhosts/maycon.ro/subdomains/sh/httpdocs/admin/includes/classes/object_info.php on line 17

Warning: Variable passed to each() is not an array or object in /usr/local/psa/home/vhosts/maycon.ro/subdomains/sh/httpdocs/admin/includes/classes/object_info.php on line 18

I put some contribs in the old shop that don't allow me to use Extra Customer Fields contrib, so I'm making a new shop in witch I want to import ALL the customers and ALL products from the old shop.

 

as there are several tables involved and some require extra attention as to id values, it is NEVER a good idea to simply export and import tables like that.

 

The only controlled way of doing a migration like that is writing a migration program which extracts data from the old system and inserts the data in the new system.

 

It always amazes me when certain people actually believe you can just copy and past table contents from one system to another and expect it to function correctly.

[Lao]

So, is it possible or not? Vger tells me it can be done and you that it can't. :(

 

I'm more interested in the importing the products than the customers.