Duplicate Invoice numbers

Just this week I got one other report, but overall this seems to be very rare. The only thing I can think of is that in WordPress 4.4 something may have changed to database caching/handling. I haven’t been able to replicate the issue and it is definitely not common.
Do you actually have 50 doubles or is that number referring to something else? That’s a lot!

I will look into ways to avoid/circumvent db caching issues.
You can edit the invoice numbers in the order backend, under the ‘PDF Invoice Data’ header, don’t forget to adjust the ‘Next invoice number’ setting to match.

Hope that helps and I’m sorry for the inconvenience!

Hi!
I have just released an update (1.5.28) that uses some logic to prevent duplicate invoice numbers (well, on top of the mechanisms already in place…):
The ‘next invoice number’ is now stored separately from the other settings in the WordPress Settings table (wp_options) and also retrieved in a way that bypasses caching as much as possible. It should be both faster and less prone to caching now, preventing duplicates.

Hope that helps (only time will tell I’m afraid)!

Ewout

Hello Ewout.

Thanks for the updateI will install and seeif Iget any problems however one week ago I reset the invoice number sequence andso far no duplicates (108 invoices processed).

Thanks for your time i will give some feed back in two weeks unless I need to contact you before.

Chris

Ola,

I’m facing similar issue for v1.5.36. Different order, same invoice number. It happen twice so far. It was explained to me that it had happened when completing order using the bulk-action.

I could not replicate the issue in local dev.

Here’s the production server info:

php 5.4.45
mysql 5.5.47

All plugin requirement met, except for:
GMagick or IMagick
opcache.

Cheers.

Hi! As stated above, I have never been able to replicate this issue either, so it’s a bit hard to debug. Since 1.5.28 the plugin queries the DB directly so I don’t know what’s up with this. Is the site using any caching plugins like W3TC?

Ewout

Ola,

There was no caching plugins. Well then, if ever i could replicate the issue, will let you know. Happy coding. ??

Cheers.