Support » Plugin: Order Export & Order Import for WooCommerce » Error Conflict with Import

  • Resolved monpinoliad

    (@monpinoliad)


    Hello Team,

    When I’m trying to import WooCommerce Orders from my Production to Staging site, it is giving me error always from Row 1 to 34.

    Please see here the screenshot: https://prnt.sc/118mt6l

    Can someone help me check this?

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author webtoffee

    (@webtoffee)

    Hi @monpinoliad,

    If the importing order IDs are already used on the importing site for other posts then the orders will be skipped from importing due to ID conflict. You may please either delete the ID column or change the IDs in the file in order to overcome the ID conflict and import the orders.
    Please note that the orders will be imported with a new ID if the ID column is deleted.

    Hi @webtoffee

    Even I am facing a similar issue.

    But then deleted the order id column shouldn’t be the solution as the order ids would change on the new website.

    What happens to the customers who get in touch with us later for an invoice or something referring the old order id?

    Do you have any other solution and I don’t think that its a conflict between post ids as order ids and post id might match in 5-10 cases and not in 300+ order id cases (like mine).

    Thanks
    Shashikant

    Plugin Author webtoffee

    (@webtoffee)

    Hi @shashikant91,

    The issue you are facing is because the order IDs in the CSV file are already used on your site. WordPress considers everything as posts. Eg: a product is a post, the image is another post Like that and it does not support importing multiple posts with the same ID. Due to this reason, the orders have to be imported with a new available ID.

    We can suggest you a method to retain the order numbers from the CSV file by installing our Sequential order number plugin so that even if the orders ate imported with a new ID their order number will remain the same. Please just install this plugin and import the orders with the order ID removed and the order number will be retained from the file.

    Hi @webtoffee

    We haven’t waited for your revert as we were to go live asap on the new server as the old one was getting expired in couple of days.

    Facing one more issue now. We have added a last digit ‘9’ to the order ID and uploaded the csv with order number as is. After this upload we could find 2 issues.

    1) few users (customers) are complaining that order duplication is happening in my account section of the website

    2) new orders which get generated are adding one extra digit at the end. Example: order ID should be 47855 but the ID generated is 478551, 478552 etc etc 1,2,3 are getting added.

    Pls help to fix this and let us know a way to remove the last digit (6th) in order ids which are getting generated now. Rest we can manage

    Thanks
    Shashikant

    Hi @webtoffee
    I am currently testing the free version to see if the import/export suite will work for my client.

    Current procedure:
    Live Page – Export Orders (Type: Order)
    Quick Export to CSV

    Staging Site with WP_STAGING_PRO
    Import CSV use Advanced Way with update if exists

    Sequential Order Numbers for WooCommerce plugin is installed on both sites.

    Here only half are imported without errors.

    Second try:
    Now I deleted all content of the orders under order_id (except the column header) also this fails.

    I have also moved existing orders to the recycle bin and deleted them from there as well.

    Is there a solution for this? If it already does not work with the free version, my customer will probably not buy the PRO version.

    Thanks,
    Kevin

    • This reply was modified 1 month, 1 week ago by pfaelzersoul.
    Plugin Author webtoffee

    (@webtoffee)

    Hi @pfaelzersoul,

    If the order ID data is deleted then the orders will be imported with a new ID which will be generated by Woocommerce. If you are still receiving ID conflict error after deleting the order ID data then please share your import file so that we can check it. You may please share it with us via support.

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