Support » Plugin: WooCommerce » Import/Export orders/customers from one wordpress to it’s clone?

  • Resolved SamValiant

    (@samvaliant)


    Here’s my issue, I had a fully working site, then I had the fateful “Are you sure you want to do that” thing, by that point I had 26 orders since last backup. I decided it was best to put the site into maintenance mode (Maintenance Free), having tried every method to diagnose I decided it was best if I exported the dbase and rolled back my site to the previous backup which was 6 hours earlier meaning that I’d loose those 26 orders. I was hoping that I would be able to import the customers and orders via CSV once the new database was repaired on the testing server. (I cleared all the transients etc to make sure people weren’t logged in upon their return etc). I got the database and wordpress working and can export the orders/customers via CSV.

    Unfortunately, in the meantime people have somehow managed to get around the maintenance mode and make purchases on the live site.

    So now it becomes trickier. Thankfully due to woocommerce not using sequential order numbers most will slot in, but there is 3 order number conflicts, incidentally, all of which have failed. I thinking Paypal may have realised something was up and cancelled the order? So I’m guessing I can just delete these failed orders and import the good ones and all will be ok?

    Anyways, what is the best way to export orders/customers from one wordpress and import them into a clone one? Do I do customers first or orders?

Viewing 2 replies - 1 through 2 (of 2 total)
  • MakeOnlineShops

    (@makeonlineshops)

    Also interested to know. Thanks.

    SamValiant

    (@samvaliant)

    Here’s what I did:

    1. Check for any order number conflicts
    2. If any do match, and they’ve failed, delete that order
    3. Purchase and download Customer/Order CSV Export by SkyVerge and their Customer/Order/Coupon CSV import suite.
    4. Export the CSV, best to start with just one first
    5. Import into your current site, and follow instructions. Though I would highly recommend that you do not merge etc.
    6. Do a dry run first
    7. If it works import
    8. Compare orders on both sites to double check.

    Read all the documentation first. Woocommerce may change the order numbers.

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.