Migrate products and categories

Question

What would be the easiest way to copy all products (including images) and categories from one installation of Magento to another one (completely empty and vanilla) on the same server? I don't need to keep orders, users, etc. but only the products. I don't mind, however, copying these too. I also don't need them to keep the same keys, as long as the association with the appropriate categories stays the same.

Exporting to CSV and importing seems particularly messy, while just duplicating the database simply won't work...

Answer 1

The easiest way to move a database is to backup and restore, you can choose to remove all your orders on the new install. The total time (Depending on the server) would be less than 10 minutes!

mysqldump -p'PASSWORD' -uuser -hyourhost database1 > mydumpfile.sql
mysql -p'PASSWORD' -uuser -hyourhost database2 < mydumpfile.sql

All you need to do now is change the url for the site: Something like

Here is an easy way to find them

select * from core_config_data where value like 'http%';

Find the config_id's for your secure and unsecure address

then

update core_config_data set value = 'http://my.newdomain.com/' where config_id in (You list of ids');

• List of id's must be something like this (6,7) etc

I can post a delete orders script if you want - The entire process is quick and efficient.

Answer 2

Why don't you try to copy the entire database ? Then you only has to change all the old URL for the new ones. ( for example the old URL www.oldone.com/x to -> www.newone.com/x ).

What I do is to copy the old database, change the urls automatically and then upload to the new database.

Hope this can help you.

Answer 3

I have found the best approach to this is to use the export import profiles.

Create an export profile that gives you the information you are looking to migrate and then import that information into your new Magento.

There are a few required fields, make sure those fields are in your csv when importing, make sure you have table headings.