Invoice numbers are not sequential

Hello Hans,
Are you using the latest 2.0.4 version? Are you sure you’re looking at the invoice numbers and not the order numbers?
Sequential numbers is one of the main and most important characteristics of the invoice numbering system, so I don’t know why you are missing the even numbers…
Check this bit in the documentation too: Invoice numbers explained

Let me know what you find!
Ewout

Hi Ewout,

I am using the latest version of all plugins and now even 2.0.6 of yours.
Also did i download WooCommerce Sequential Order Numbers wich makes my ordernr sequential.
However are my invoices stil not seq and that is killing.
I tried another plugin: WooCommerce PDF Facturen, and this is making it right: 1041, 1042, 1043 etc.
When i do them both, woocmmerce pdf facturen leafs a blank also, so i think that your plugin adds another invoice number after the one that he is crating.

can you please advise?

you can also send a mail directly to me: [email protected]

Kind regards,

Hans

Hello Hans,
First of all: order Numbers are not connected to invoice numbers (so the sequential order numbers plugin shouldn’t make any difference) and invoice numbers from different invoice plugins are not interchangable. I have had no other reports from customers with non-sequential invoice numbers so I’m not sure what’s different in your setup.

I have sent you an email!
Ewout

This turned out to be database related & should be fixed in 2.0.7

Some background:
Invoice numbers are normally generated by the plugin using an AUTO_INCREMENT table in the database. This is the most reliable way to avoid duplicate invoice numbers, especially for stores with a high sales volume. Some servers have an alternative configuration for AUTO_INCREMENT that takes steps bigger than 1 (a MySQL setting called ‘auto_increment_increment’), which means that the invoice sequence then automatically takes the same steps, leaving gaps in the sequence.
I have a added a backup method that calculates each next invoice number by taking the last invoice number and adding +1. The downside of this method is that there is a higher risk of duplicate invoice numbers for shops with high peaks in sales volume (i.e. multiple orders per second), or when external applications trigger the generation of invoices simultaneously for multiple orders. Most shops will not have any issues with this method.

This option can be found under PDF Invoices > Status > Calculate document numbers (slow). As a failsafe mechanism, this setting is overriden to be automatically enabled in setups with an auto_increment_increment value higher than 1.

Ewout

And this works perfect!

I am a happy user of this plugin now, manny thanks Ewoud!!

Kind Regards

Hans