transfer the catalog of products from one store to another

Started by andes1, Dec 03 2005, 18:41

You cannot reply to this topic

4 replies to this topic

#1 andes1

Community Member
180 posts

Real Name:andrea pataquiva diaz

@Mention

Posted 03 December 2005, 18:41

Sometimes we want to transfer the catalog of products from one store to another new or modified store, without make modifications on excel and so on.
We only seek a clean transfer of information, well�
Here we have an easy way to achieve this purpose
[img]http://www.latinrebels.net/cosas-varias/images_ayuda_sql_guia/1.gif[/img][img] On PhpMyAdmin choose the tab export; after that you should see something like the picture below First select: categories categories_description products products_attributes products_attributes_download products_description products_notifications products_options products_options_products products_options_values products_options_values_to_products_options products_to_categories Next, chose the fallowing options: sql Structure: Add DROP TABLE Add IF NOT EXISTS Add AUTO_INCREMENT value Enclose table and field names with backquotes export type : insert �from the menu�. Select save as a file; give a name to the table, i.e. fer__DB__products select Compression none. This should looks like: [img]http://www.latinrebels.net/cosas-varias/images_ayuda_sql_guia/2.gif[/img][img] Save on your hard drive. Now the next part is to place the saved data on your new or heavy modified store. 1. Select the new store�s database 2. Then, select the tab SQL. 3. Now, upload the database file that you save in your hard drive, (select auto detect) and click on Go. [img]http://www.latinrebels.net/cosas-varias/images_ayuda_sql_guia/3.gif[/img]
4. Check your store and admin.

That is all�. Easy.
You can do the same with whatever table as you want i.e. Customers.