I am sorry for support request but i don't know where else to ask. i am working on upgrading my existing Ubercart (D6) website to D7, and it would take many months for me to launch the new site. So far all of order details are updated in D7 test website, however, as i work on upgrading with test server, there will be few orders in my live D6 website.

Is there a way to export (don't know the exact term) few orders from D6 website and import to new D7 website or is there a module? i checked feeds, migrate module, but i am not sure if that module is right choice for my case. How would you move few orders from D6 to D7? Thank you.

CommentFileSizeAuthor
#3 users.png25.65 KBbellagio
#3 uc_orders_table.png51.7 KBbellagio
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

bellagio created an issue. See original summary.

TR’s picture

Personally, if it's only a few orders, I would do it manually. On your new site, set the initial order number to be equal to the current order number on the old site PLUS a large enough offset that you won't have to worry about duplicate order numbers (see the FAQ for how to set the initial order number), then when the new site is ready to deploy, you only have to manually copy those few orders over. Any orders placed on the new site will have order numbers > the old site, so there will be no overlap (but there will be a gap of unused order numbers).

You can just manually dump the table rows that refer to the few orders - part of your development on the new site will be to create an appropriate query to dump all the rows that contain order information for those few rows, so when you're ready to switch over you just have to put the old site in maintenance mode, then dump from the old site and load to the new site - shouldn't take more than a few minutes, and your new site will be online the whole time so you won't miss any orders.

bellagio’s picture

FileSize
51.7 KB
25.65 KB

Thank you very much for your answer. Yes, i will do as your suggestion, but i don't know which rows contain order information. Do i choose all table name with uc_order, and user table to link new user to the order? Selecting few rows to see if they contain order information is something i can play around?
What makes me worry is that i may break the data structure and end up with incorrect data structure which cause lots of errors in the future.

TR’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.