My site ( is running Drupal 6 / Ubercart 2 and I'm looking to move to Drupal 7 / Commerce. I've looked at the Ubercart/Commerce migrate module and I don't think its really for me as I don't need to pull everything over. Over time a lot of junk has crept in to the site and this is an opportunity for me to largely start again.

I'm happy to rebuild the shop from scratch as it doesn't have huge numbers of products and most of the product content is going to be replaced with new text, images and so on. I can easily rebuild the shop taxonomy and set up the URL aliases. Loosing comments will be a pain, but not the end of the world.

I don't need to be able to migrate the existing orders (just under 1000 completed) as my customer base will not worry about losing direct access to past orders. Besides I can always email through order details from a local backup if needed.

What I would like to keep and move to D7/Commerce is:

i) All Users that have a role of Customer or Affiliate (which is less than 1/3 the total due to a flood of spam users). Some profile details for these users, specifically Username, Password, Email, Billing Address, Shipping Address, Phone Numbers.

ii) All blog posts, including comments if possible.

iii) All nodes for a custom content type called Recipes. Its actually pretty basic, but there are quite a few comments that it would be good to be able to keep. If it's not possible, I can manually re-create the nodes losing the comments

Particularly in the case of i) I imagine that this can be done using a query in MySQL on the old site and then another to add to the database of the new site. Can someone give me details of the queries to run?

I've come across the Data export import module ( which looks like it might work for all 3 above. Has anyone used it for D6 to D7 moves?


John_B’s picture

Dubber Dan’s picture

Thanks, looks likes there's lots of options so will have to get stuck in