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.

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.

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.

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

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)

Thank you for your reply.
I’m sorry for the late reply.

I understand it well in your explanation.
I ask a new question from support.
I will consider purchasing the premium version.

Thank you very much for the wonderful plugin.