0

I am starting over on a busy Magento store. New fresh installation with no additions installed so only the bits that are required are installed, keeping everything lean and clean.

Once this site is developed and ready for launch, how do I go about importing all of the existing data that we need to keep - i.e. Products, Customers, Orders, etc.

Keeping the existing database (and upgrading it) isn't an option because there is too much stuff in there that is not needed, and it is easier to start with a fresh database. Also, the new site stores lots of settings and contents in the database, and I don't want to go losing all that development work by dumping the new database and replacing it with an upgraded old database.

Any help and pointers greatly appreciated!

1 Answer 1

1

Whilst it makes a lot of sense to make a "fresh start" when you want to upgrade or migrate your Magento store to a new version and theme you may well be underestimating the work involved to rebuild your catalog exactly as it was in the old store.

Unless you go to a company that specialises in Magento data migration you will need to consider carefully how you will migrate all your products data (and images), categories and CMS pages.

There are various tools available to help you export your product and category data including the inbuilt Magento export tools.

For product data I would export using Magento and then either try a reimport to the new version, or import into Excel where you can make any changes you require and use something like MAGMI to do the import. This will depend a lot on the product types you have. Even after a basic import you may still need to do a lot of manual editing of each product.

The same applies with categories, my experience has shown that even if you can reimport the category data you will need to still do a lot of manual editing to restore the structure that you had before.

With CMS its a bit easier as it is fairly easy to simply dump the CMS tables from your database and then import them back into SQL, this has worked well for me in the past.

If your shop is large and an upgrade is out of the question (and if you have the budget) get a quote from one of the companies that specialises in Magento data migration.

If that is not an option, have a look at what you can achieve with the import export tools that are around.

I would also recommend experimenting with the upgrade, it will save you a lot of work!

1
  • I guess I am underestimating how straightforward this really should be? I imagine that I should be able to develop the new site from scratch on a develop domain. Create a third separate domain solely for use in upgrading the Magento database from the live website, then migrate the data I want to keep out of that third database into the new development site. If that's not a possibility, then I will have to have a rethink? Thanks for the time spent on your answer - much appreciated, and food for thought from someone who seems to have been there already!
    – robgt
    Commented Aug 7, 2015 at 15:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.