Hi there,
Thank you for sharing more details and for the system status report.
I’ve discussed this with our team, and based on what we’re seeing, this looks like an incomplete or stuck batch process. In some cases, the scheduler can get blocked and stop progressing as expected.
To reset this process, the following WooCommerce options would need to be cleared:
woocommerce_admin_scheduler_last_processed_order_modified_datewoocommerce_admin_scheduler_last_processed_order_id
This will force the batch process to restart from the beginning.
Just to clarify, we’re not suggesting that you run the PHP snippets directly. You can clear these values in whichever way you’re most comfortable with—for example:
- via the database (removing those specific option keys), or
- by opening
options.php and clearing their values there.
Please note that if there is a corrupted order in the sequence, the import may restart and potentially get stuck again, which would indicate that a specific order needs further investigation.
Let us know how it goes.
Hi shahzeen and thanks for your follow-up.
I cannot find these options to any options.php file. Can you tell me which file it is, precisely?
Thansk a lot
Hi @bvedgie,
Thanks for checking back and for taking the time to verify this on your test site. I can see how this would be confusing, and I want to make sure the distinction here is clear so you know exactly what to look for.
Those entries are not database tables or physical files. They are option values that may be created by the WooCommerce admin import process only when that batch runs and stores its progress. Because of that, they are not guaranteed to exist on every site, and it is completely expected that you might not see them listed if the process has not stored its state or if it has already cleared it.
To clarify the options.php part, this is not a file you open on the server. It is an admin screen in WordPress. While logged in as an administrator, you can access it directly by visiting:
https://your-site-url/wp-admin/options.php
Once on that page, you can use your browser search to look for the following option names:
woocommerce_admin_scheduler_last_processed_order_modified_date
woocommerce_admin_scheduler_last_processed_order_id
If they exist, clearing their values or removing those option rows from the wp_options table will reset the import batch state. If they do not appear in options.php or in the database, then there is nothing to reset, which usually means the repeated imports are being triggered by something else interacting with those same historical orders.
In that case, the next helpful step is to review whether any plugins, custom code, or external services are touching or syncing orders, as that can cause older orders to be picked up repeatedly. Sharing your WooCommerce system status report will also help us review the environment more closely and spot anything that stands out. You can generate that report by following this guide:
https://woocommerce.com/document/understanding-the-woocommerce-system-status-report/
Once we have that information, we can better pinpoint why those 2022 and 2023 orders keep being reprocessed and guide you on the best next step.
I’m going to mark this as resolved, as we haven’t heard back from you in a while. Please open a new thread if you need further assistance.
We’d love your feedback – please leave us a review: https://ww.wp.xz.cn/support/plugin/woocommerce/reviews/
Hello,
The mentioned options don’t appear in my options list.
Hi there!
Could you please try resetting the WooCommerce Admin batch process using the following code:
delete_option( 'woocommerce_admin_scheduler_last_processed_order_modified_date' );
delete_option( 'woocommerce_admin_scheduler_last_processed_order_id' );
The safest way to do this is by adding it temporarily using a Code Snippets plugin after that Load any page on your site once this will delete the options and reset the batch process.
After that Deactivate or remove the snippet immediately. Let us know if you still face the same issue.
