Orders Will Not Import Between Sites

  • Resolved toad78

    (@toad78)


    1 week, 5 days ago

    I have a live site and a staging site and am attempting to export orders from the live site to the staging to keep the staging updated prior to pushing live. However, quite a few orders are not importing and am receiving these errors:

    Importing Order(ID) conflicts with an existing post. ID: 16565 (this post does not exist on staging!)
    Untitled Importing Order(ID) conflicts with an existing post. ID: 16558 (this post does not exist on staging!)
    Untitled Importing Order(ID) conflicts with an existing post. ID: 16557 (this post does not exist on staging!)
    Untitled Importing Order(ID) conflicts with an existing post. ID: 16548 (this post does not exist on staging!)

    Why are there errors claiming conflicts with an existing post when the above posts DO NOT EXIST! I need to get the above orders migrated, as this step is holding up progress to push our staging live.

    Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support WebToffee Support

    (@webtoffeesupport)

    1 week, 4 days ago

    Hi @toad78,

    Thank you for reaching out.

    In WordPress, most content types share a single ID pool this includes orders, products, pages, images, and more. So even if order ID 16565 does not exist as an order on your staging site, that same ID may already be assigned to another post type, which causes this conflict.

    To resolve this, you can create a new import file containing only the orders that failed to import, remove the Order ID column from the file, and then re-import. WordPress will automatically assign new IDs to those orders.

    Please note that the imported orders will receive new order numbers on your staging site, but all order data will remain intact.

    Thread Starter toad78

    (@toad78)

    1 week, 4 days ago

    Thank you, @webtoffeesupport .

    That does make sense, so I did do as you recommended and that did fix the problem.

    Thank you for the prompt reply and solution!

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

You must be logged in to reply to this topic.