Back to original order nr after update

Me too I have this problem from today, after the update in two e-shop

Hi @webwingslaura @pdasiras,

Thanks for reaching out to us.

We are sorry for the inconvenience caused. There is a chance that the WordPress timezone mismatch can cause this issue. Kindly make sure that your WordPress timezone is correct. You can check it by going to Settings > General as shown in the below screenshot. Check it in that way and let us know if anything.

Hi,

The time zone is correct, what else could I do?

Thank you.

• This reply was modified 2 years, 4 months ago by pdasiras.

I fixed it, I am from Greece and I had timezone Athens, I changed to UTC+3 and it fixed
Thank you.

Hi @webwingslaura, @pdasiras,

There is a chance that if you are using the timezone city instead of UTC time offset in WordPress can cause the issue. We will address it within the plugin in an immediate release. Thanks for understanding.

@webwingslaura Can you also change the timezone city to your corresponding UTC offset and check? If the issue persists, as a temporary workaround, kindly copy the below-mentioned code snippet to your active theme’s functions.php and check.

add_filter('wt_sequential_is_old_order','__return_false');

Hi,
I see about 10 hours ago en new order came in and the order number was right. I did change the timezone to UTC+2 just now aswell.
I hope this is fixed now (I will check when a new order arrives). For now, what is the best way to change te order numbers correctly? Administration wise we now have a gap of about ten orders that don’t have the proper order nr.

I hope this is easily fixable ??

• This reply was modified 2 years, 4 months ago by webwingslaura.

In terms of fixing the order numbers, I had to go into the database, open the wp_postmeta table and insert a new record.

The meta_id should autoincrement
post_id is the current order number
meta_key is _order_number
meta_value is the actual order number desired

I dunno if this is okay or whether there will be unintended consequences. Thoughts developers?

I’m dealing with the same issue right now. Time zone was correct so that wasn’t the solution for me. I put the snippet in for now hoping for the best.
Snippet: add_filter('wt_sequential_is_old_order','__return_false');

Hi @webwingslaura @andrewews,

Thanks for getting back in touch.

We have created a sample code snippet to manually alter the order numbers to handle this situation. You can modify the code by using the post id of the missing sequence numbers and adding the required sequence number. Then copy it to your active theme’s functions.php and check.

Hi @timdendikken,

Thanks for reaching out.

We have identified and fixed the issue in the latest version (v1.4.8) of our plugin. Kindly follow the below-mentioned instructions to fix the issue on your site.

Instructions:

1. Copy this code snippet to your active theme’s functions.php
2. Deactivate and delete the existing Sequential Order Numbers for WooCommerce plugin.
3. Remove the previously added code in step 1 from the functions.php. (Important)
4. Install and activate the latest version of the plugin (v1.4.8).

Try this out and let us know how it works.

I have done the indicated steps. But for example if I then put start the sequence from a specific number in the options and create an order from the backend, the sequence number does not correspond to the start number that I put in the options

I have to repeat the steps every time I create a test order. The first time I create a test order (in the options, for example, I put start with 1000) and it gives me 1001 (good), I delete the order and delete it from the trash. I create a new order and it no longer starts from 1000 but starts from 1002.

Hi @sermalefico,

Greetings from WebToffee!

Our plugin generates order numbers at the time of order creation. Regarding the issue you are facing with the order number counter, the sequential counter generates the next order number based on the previously created order number (even if the order is deleted). To reset the counter, you will need to save the settings again with your desired start number on your plugin settings page (WooCommerce > Settings > Sequential Order Number). Check it in that way and let us know if anything.

Yes, but saving settings again dont do anything (no restart the sequential numbers)

regards!

Hi @sermalefico,

Thanks for getting back in touch and sharing the information.

We were not able to replicate the issue when we tested it on our end. However, as you reported, could you please share the screen-recording of the scenario via this link for a better understanding? It will help us to replicate it on our end.