Invoice numbering issue

I’m not sure, but I think you may be confusing invoice numbers with order numbers here.

You wrote “Before i installed this plugin, the invoice-numbers got created randomly”, but WooCommerce doesn’t have invoice numbers out of the box, only order numbers. These are not random, but shared across all entities in WordPress. From our documentation “Why is the PDF invoice number different from the woocommerce order number?“:

By default, WooCommerce orders are numbered in the main WordPress post numbering system. This includes everything in WordPress: posts, pages, images, orders, coupons, products, etc. So if you create a new product between when two orders are placed, and upload an image for that product too, the order number is not sequential (if the first order was #100, the product would be #101, the image #102 and the next order #103).

Since you mention your DB autoincrements with more than 1, that would look even more random since this increment would apply to all other entities in WordPress/WooCommerce too.

Legacy mode should only be enabled if you are using a pre-2017 invoice template on your site. if you just installed this plugin, that’s highly unlikely. To my knowledge, the legacy mode doesn’t affect the invoice numbering. But if you’re looking at the order number rather than the invoice number, that would explain the difference.

If these are in fact the invoice numbers and not the order numbers, do let us know and we can look further into this!

Thank you. It is probably order numbers – I am working on a transelated wordpress so I got lost in translation probably. The order numbers are the ones appearing random. I have unchecked “Legacy mode” and “Calculate document numbers” and still it gives me random order numbers (and it still skippes a digit,) Now it is 11450 and 11452

Edit:
I downloaded a plugin dedicated to get the order numbers fixed on top of this plugin, and now it worked. I thought it could be done with this plugin as well, but i love the pdfs created so now I keep them both ??

Martin

• This reply was modified 5 years, 8 months ago by fyrileiv.
• This reply was modified 5 years, 8 months ago by fyrileiv.
• This reply was modified 5 years, 8 months ago by fyrileiv.

Hello Martin,
That makes sense. Indeed there’s a pretty good plugin for sequential order numbers: WooCommerce Sequential Order Numbers, probably what you are using too now?

To view the invoice numbers you can enable the option “Show invoice number” under PDF Invoices > Documents > Invoice (this will normally only apply to invoice created after changing this setting), and/or enable the Invoice number column in that same settings tab.

Glad to hear the issue is resolved and that you like the plugin ??

Yes. Thank you for all help. I will continue to use the plugin, since the PDFs created are really awesome!

Martin

Hello, I will use this thread.
Before I installed Pro version of the plugin I accidently changed invoice numbering from sequential to order number. Meanwhile I got some paid orders. Now I get numberring like 1941 and the next one is 3501 (number of order). Is there a chance to rewrite the new 3… invoice numbers and get back sequential numbering? I looked at mysql, but there is no table with invoice numbers…
Thank you for any help.

That depends, can you tell me what you mean by this?

I accidently changed invoice numbering from sequential to order number

Did you use code for that? If not, is it possible you’re simply looking at the order number rather than the invoice number? You can enable the invoice number display in the PDF Invoice settings under Documents > Invoice > Display invoice number.
If you want this to apply to existing invoices too, you can enable the option “always use most current settings” on that same page.

Well, I changed it in admin from sequential to order number. Meanwhile new orders came. Then I changed to sequential, but the new numbering remained.
This is the screenshot:
https://img.techpowerup.org/190718/invoice-number.jpg

This plugin doesn’t have a setting to change ‘from sequential to order number’ and the column with the invoice numbers from your screenshot doesn’t appear to be coming from our plugin. Are you using any third party plugins for invoice numbers? Can you show me the setting you were referring to (‘from sequential to order number’)?