Numbers went wonky this morning

OK. I have this too. Number jumped from 1499 to 6249!

How do I get order 6249 renumbered to 1500 as it should be without messing anything else up?

I posted this on the main “not working” thread that was marked as resolved:

Unfortunately I have to say its not resolved. I tested the latest update on the staging site and it was ok. Updated the live page with the latest plugin version. After an hour I get an order coming in. The email order number is 4407 where the order itself should be and is 4006 in the wordpress back end. SO the customer gets a wrong Order ID and any support with emails goes bonkers. Is there quick fix other than disabling the plugin?

Just to note… Thanks a lot for the quick fix and the free plugin and support even if the issue is not resolved yet. This is something that gets forgotten quite fast when something doesn*t work. Its a free plugin. So thanks for the support!

• This reply was modified 3 years, 4 months ago by mike8040.

Hi @mike8040, @doggieboat, @buddylove72,

We are extremely sorry for the inconvenience caused.

After debugging the issue with the previous update, we have identified that for users who haven’t saved the settings at least once after installing or set some prefix for sequential numbers, the last code optimization caused a negative impact. We have fixed it in our latest release.

For the orders that came in between the 2 updates, the order numbers will be set the same as the order_id which is causing this confusion. While the update fixed the sequence, the order number already generated should be manually updated to fix the issue. Please make use of this code snippet to update the order number for the orders that are missing in the sequence.

Let us know if any concerns or queries regarding the snippet.

Thanks for being on top of this. By manually updated you mean through the DB?

Hi @buddylove72,

You can either do it through DB or you can use the code snippet shared.

Well, thanks for clarifying. But somewhat in my case your solution won’t work or I don’t get it. I already got the latest update and did re-save the plugin settings. The order confirmation emails sent to me and customers gets the post ID sent. There is no way to change the email already sent. So now there are several discrepancies with the order tab and customer invoices. The order IDs are correct in the order tab but the emails sent to customers are sending the post ID. How to fix that?

Hi @mike8040,

Since you have created a new topic, let’s continue this discussion there.

I’m new to this code snippet thing. I’ve got the Snippets plugin installed and have pasted the snippet there and specified that it can be used anywhere but beyond that I don’t know where the functionality manifests itself.

If I open an affected order to the edit screen I can see that the various custom fields, including the “wf_invoice_number”, have two buttons: “Delete” and “Update”. Selecting “Update” has no effect.

How do iI actually use the snippet?

Hi @rodac,

Please share the order numbers that was incorrectly added in your site and the sequence numbers they should be updated to.

This is the sequence of order# containing the dodgy ones:

1256. 1257, 22703, 22708, 22713, 1263, 22722, 1264, 1265, 1266

There are just four dodgy numbers

Hi @rodac,

You can use below code to modify the first 3 orders. Please add below code snippet to your active theme’s functions.php and run it. Once done you can remove the code.

add_filter('wt_alter_sequence_number','wt_change_seq_number',10,2);
function wt_change_seq_number ($sequence_number,$order_id)
{
	if($order_id=='22703') //enter your post_id which should be changed
	{
		$sequence_number = '1258'; //enter the sequence number to which it should be changed
		update_post_meta($order_id, '_order_number', $sequence_number);
	}
	elseif($order_id=='22708') 
	{
		$sequence_number = '1259';
		update_post_meta($order_id, '_order_number', $sequence_number);
	}
	elseif($order_id=='22713') 
	{
		$sequence_number = '1260';
		update_post_meta($order_id, '_order_number', $sequence_number);
	}
	return $sequence_number;
}

For the rest of the orders, we can see some inconsistencies. Did you happen to delete any orders in between them?

Thanks. That cured all but 22722 which if course is probably the anomalous Order that you are talking about.

We are using SUMO Pre-Orders. This plug-in, unlike the wooCommerce version, can handle an order with a mixture of available and unavailable items. In this particular case a customer ordered just such a mix. What happened next was that the plugin accepted her credit payment for the available item, set the price of the unavailable items to $0 then created a new order with just the the unavailable items at the proper selling price and debited the inventory.

It did not however get a proper sequence number but used the post_id instead.

I hope you’re not going to tell me that SUMO has to fix this.

Sounds like the same combination I got trouble with too. I use a Pre-order plugin with YITh PayPal and customers get the post ID as invoice. Organization nightmare.. Strange is that bac and cash on delivery orders are fine with the Preorder function. Hope for a fix too

Hi @rodac.

As much as we wish not to say this, the function calling the order number must be modified by the plugin authors to sort out this issue. We have already been in touch with them and they are yet to respond.

@mike8040, Please mention which plugin do you for pre order.

@webtoffee,
We have also encountered an issue with xero, wherein the wf_invoice_number, which doesn’t get updated by your script, seems to be used by xero as its order identifier. Was it intentional on your part to leave the wf_invoice_number untouched, perhaps to provide some traceability?

• This reply was modified 3 years, 4 months ago by rodac.
• This reply was modified 3 years, 4 months ago by rodac.