How do I update an order with Order Import?

  • Resolved inductan

    (@inductan)


    5 months, 2 weeks ago

    <font _mstmutation=”1″></font>I use “Order / Coupon / Subscription Export Import Plugin for WooCommerce (BASIC) 2.5.3”,
    I imported Order data, but most of the data fails to update.
    For the order data, we created only the columns that needed to be updated, and deleted the parts that did not need to be updated.
    The update is successful in about 1 in 100 cases. I don’t know what the different conditions are for update failure and success.

    I have selected “Update” for “If order exists in the store” in the link below, but it is not updated correctly.
    https://woocommerce.com/document/import-and-export-of-woocommerce-orders/
    If order exists in the store: One can either Skip or Update the entry.

    Although it is possible to exclude and import the “order_id” column,
    There are also disadvantages such as new order data being created separately from existing data and the order number being different.
    This method is inconvenient for me.

    I would like to update only the columns that require updating of existing data.
    thanks in advance.

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

    (@webtoffeesupport)

    Hi @inductan,

    Thank you for reaching out to us.

    When updating orders, it’s crucial to include the “order_id” column in the import CSV file because orders are matched based on their IDs. If the “order_id” column is not present, the order will be imported as new orders instead of updating them.

    If you are experiencing problems with updating data, even after including the “order_id” column, please provide us with your import logs so that we can investigate. You can share the import log by uploading it to Google Drive, WeTransfer, or a similar service and then sharing the link with us.

    Thread Starter inductan

    (@inductan)

    Hi @webtoffeesupport,

    Thank you for your reply.

    The log file is as follows. At this time,
    I ran the plug-in up to Row :240 and was able to update only two rows (Row :92, Row :198).
    The other lines have failed, so they will be omitted.

    No matter how many times I try,
    these two rows are updated successfully and the other rows fail.

    I carefully compared the differences between these two rows (Row:92, Row:198) and the other rows,
    but could not find any differences. Of course, the username, phone number, order_notes, etc.
    are different, but I don’t think that’s the essential difference.

    I hope you can find the cause of the problem and resolve it. Thanks in advance.

    06-15-2024 @ 10:10:21 - ---[ New import started at 2024-06-15 01:10:21 ] PHP Memory: 40 GB, WP Memory: 40 MB
    06-15-2024 @ 10:10:21 - Preparing for import.
    06-15-2024 @ 10:10:21 - Row :1 - Parsing item.
    06-15-2024 @ 10:10:21 - Row :1 - Parsing failed. Reason: Skipped. Order already exists.
    06-15-2024 @ 10:10:21 - Row :2 - Parsing item.
    06-15-2024 @ 10:10:21 - Row :2 - Parsing failed. Reason: Skipped. Order already exists.
    06-15-2024 @ 10:10:21 - Row :3 - Parsing item.
    06-15-2024 @ 10:10:21 - Row :3 - Parsing failed. Reason: Skipped. Order already exists.
    (omitted)
    06-15-2024 @ 10:10:37 - Preparing for import.
    06-15-2024 @ 10:10:37 - Row :91 - Parsing item.
    06-15-2024 @ 10:10:37 - Row :91 - Parsing failed. Reason: Skipped. Order already exists.
    06-15-2024 @ 10:10:37 - Row :92 - Parsing item.
    06-15-2024 @ 10:10:38 - Row :92 - Processing item.
    06-15-2024 @ 10:10:38 - Found order object. ID:1236
    06-15-2024 @ 10:10:38 - Row :92 - Order updated successfully.
    06-15-2024 @ 10:10:38 - Row :93 - Parsing item.
    06-15-2024 @ 10:10:38 - Row :93 - Parsing failed. Reason: Skipped. Order already exists.
    (omitted)
    06-15-2024 @ 10:10:58 - Row :198 - Parsing item.
    06-15-2024 @ 10:10:58 - Row :198 - Processing item.
    06-15-2024 @ 10:10:58 - Found order object. ID:1342
    06-15-2024 @ 10:10:58 - Row :198 - Order updated successfully.
    06-15-2024 @ 10:10:58 - Row :199 - Parsing item.
    06-15-2024 @ 10:10:58 - Row :199 - Parsing failed. Reason: Skipped. Order already exists.
    (omitted)
    Thread Starter inductan

    (@inductan)

    I have uploaded the 4 data that I actually uploaded and the error log to the URL below.
    Personal information has been removed from the data, and names and phone numbers have been suppressed.
    The top two items are data that failed to update, and the bottom two items are data that was successfully updated.
    This data will be automatically deleted in 3 days, so please download it as soon as possible.
    It didn’t seem to me that there was any essential difference between the data that failed and the data that succeeded.
    If you need more data, please give us your email address. It is impossible to upload it to a public place.
    I hope you can analyze the cause and find a solution. Thanks in advance.

    ttps://74.gigafile.nu/0626-c8791635ee2d88171ffe0b1f2729284c9

    Thread Starter inductan

    (@inductan)

    Hi, @webtoffeesupport

    I forgot to mention above, but of course the “order_id” column is included in the data.

    I discovered that whether this bug occurs or not depends on the version of the plugin.
    Specifically, normal operation is possible before version 2.0.8, and normal operation is not possible after version 2.0.9. This means that the order data cannot be overwritten and updated.
    This issue does not seem to depend on WordPress, WooCommerce, PHP, or theme versions.
    I tested in the two environments below. In either case, versions 2.0.9 and later cannot function properly.

    WordPress 6.4.4
    Astra 4.7.0
    WooCommerce 8.9.3
    PHP 8.1.22

    WordPress 5.7.11
    Astra 4.6.13
    WooCommerce 5.4.4
    PHP 7.4.33

    Since 2.0.9, an import function for “delivery_phone” has been added, so I suspected a problem with this and tried turning it off, but I was unable to import it.
    I think that the overwrite update function may no longer work properly due to changes in the plug-in specifications.
    What do you think is the cause of the problem? How long will this bug fix take? Please tell me the answer.

    We wish you continued improvement and your company’s growth.
    Thanks in advance.

    Thread Starter inductan

    (@inductan)

    Hi, @webtoffeesupport

    There was another problem.

    When I use this plugin, emails are automatically sent to my customers. I unintentionally became a spam sender.
    Recently, I received a lot of calls from customers complaining about my work. That was a very bad result.

    The problem is that it is not specified that the email will be sent, and it does not arrive in my mailbox, so I do not know, and I cannot choose whether to send it or not.
    Previously, when I used other versions of this plugin, I think I was able to choose whether or not to send an email. Shouldn’t that feature be reinstated and not sent by default?

    This is an important issue. We’d love to hear your thoughts.

    Please do not take this as an unreasonable complaint. I take the development of your product seriously, so I spend a lot of time experimenting and reporting the results.
    Thanks in advance.

    Plugin Support WebToffee Support

    (@webtoffeesupport)

    Hi @inductan,

    Thank you for your response, and we apologize for the delay.

    We’re sorry to hear about the issue you’re facing. Typically, the “Parsing failed. Reason: Skipped. Order already exists” message appears when “Skip” is selected in the “If order exists in the store” option. However, we can observe that two orders have indeed been updated on your site. This discrepancy could be specific to your environment.

    Our plugin’s basic version does not automatically send emails to customers during order imports. This functionality is part of our pro version. The issue you’re experiencing may be due to conflicts with other plugins on your site.

    To further diagnose the issue you’re facing, could you please provide us with a system status report? Additionally, we encountered difficulty accessing the file you shared. Could you kindly share the import CSV file with us again? You can share the system status report and the import CSV file privately via this link if you prefer not to share it publicly. This will help us investigate the issue more effectively.

    Thread Starter inductan

    (@inductan)

    Hi, @webtoffeesupport

    Sorry. I have been busy with work for a long time and have not been able to reply to this issue.

    Thank you for your reply. After following your advice and minimizing other plugins as much as possible, I tried your latest Order Import plugin.
    However, I got the same result as before. Most of the data failed to be imported, and only a small amount of data was successfully imported. The data that is successfully imported is the same as before.
    The current plugins are listed below.

    WordPress Environment

    WordPress address (URL): https://xie.xsrv.jp/wc
    Site address (URL): https://xie.xsrv.jp/wc
    WC Version: 9.0.2
    Legacy REST API Package Version: This site does not have any legacy REST API plugins installed.
    Action Scheduler Version: ? 3.7.4
    Log Directory Writable: ?
    WP Version: ? 6.4.5 - A new version of WordPress is available (6.5.5)
    WP Multisite: –
    WP Memory Limit: 40GB
    WP Debug Mode: –
    WP Cron: ?
    Language: en
    External object cache: – Server Environment

    Server Info: Apache
    PHP Version: 8.1.22
    PHP Post Max Size: 20 GB
    PHP Time Limit: 3600
    PHP Max Input Vars: 1000
    cURL Version: 7.29.0
    NSS/3.90

    SUHOSIN Installed: –
    MySQL Version: 10.5.24-MariaDB-log
    Max Upload Size: 10GB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? Active Plugins (30)

    FiboSearch - AJAX Search for WooCommerce: Posted by: FiboSearch Team – 1.28.1
    Akismet Anti-spam: Spam Protection: Posted by: Automattic - Anti-spam Team – 5.3.2
    Activity Log: Posted by: Activity Log Team – 2.10.1
    Custom Order Status Manager for WooCommerce: Posted by: Bright Plugins – 1.1.3.2
    Conditional Shipping for WooCommerce: Posted by: Lauri Karisola / WP Trio – 3.2.0

    Contact Form 7: Posted by: Takayuki Miyoshi – 5.9.6
    Flamingo: Posted by: Takayuki Miyoshi – 2.5
    Flexible Shipping: Posted by: Octolize – 4.25.2
    GTranslate: Posted by: Translate AI multilingual solutions – 3.0.6
    Kadence WooCommerce Email Designer: Posted by: Kadence WP – 1.5.12

    Media Library Assistant: Posted by: David Lingren – 3.18
    Order Export & Order Import for WooCommerce: Posted by: WebToffee – 2.5.4
    Custom Order Status for WooCommerce: Posted by WPFactory – 1.4.6
    Perfect Brands WooCommerce: Posted by: QuadLayers – 3.4.0
    Product CSV Import Export (BASIC): Posted by: WebToffee – 1.9.3

    Really Simple SSL: Posted by: Really Simple Plugin – 8.1.5
    Redirection: Posted by: John Godley – 5.4.2
    Regenerate Thumbnails: Posted by: Alex Mills (Viper007Bond) – 3.1.6
    SiteGuard WP Plugin: Posted by: JP Secure – 1.7.7
    Theme My Login: Posted by: Theme My Login – 7.1.7

    UpdraftPlus - Backup/Restore: Posted by: UpdraftPlus.Com DavidAnderson – 1.24.4
    Import Export WordPress Users and WooCommerce Customers: Posted by: WebToffee – 2.5.5
    Checkout Field Editor for WooCommerce: Posted by: ThemeHigh – 2.0.2
    Print Invoice & Delivery Notes for WooCommerce: Posted by: Tyche Softwares – 5.1.0
    Japanized for WooCommerce: Posted by: Craftsman Studio – 2.6.14

    WooCommerce: Posted by: Automattic – 9.0.2
    WP Mail SMTP: Posted by: WP Mail SMTP – 4.0.1
    WP Multibyte Patch: Posted by: Masanori Kuraishi – 2.9
    WP-Optimize - Clean, Compress, Cache: Posted by David Anderson Ruhani Rabin Team Updraft – 3.4.2
    Sequential Order Numbers for WooCommerce: Posted by: WebToffee – 1.6.3

    The current number of plugins is 30 in total. I have not yet been able to find the plugin that has the problem.
    Please help me find the problematic plugin. Can you guess which plugin has the problem?

    We will send your link a detailed system report and the offending file.

    Please help me.
    Thanks in advance.

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

Tags