Hi @finalwebsites,
This is because the invoice number you have set exceeds the maximum value signed by SQL for int (2147483647). See Integer Types. That is, this is not something our plugin controlled, but the database itself.
However, you can overcome this limitation by using the first 4 digits, that seems to be the year, as prefix using the [invoice_year] placeholder, under WooCommerce > PDF Invoices > Documents > Invoice > Number format > Prefix. Then, you can set your next invoice number to 1975210 instead of 20211975210.
Hi Yordan,
thank you, that makes sense.
you can overcome this limitation by using the first 4 digits, that seems to be the year, as prefix using the [invoice_year] placeholder,
I have used the prefix before and it looks like that I need to use the English version to notify this options in the first place 🙂
It’s solved now, thanks
I’m glad to know that it worked for you!
By the way, when you say you need to use English to notice these options, does the description with additional information not appear in your language? If so, what language do you refer to?
By the way, when you say you need to use English to notice these options, does the description with additional information not appear in your language?
Yes it’s translated into Dutch, but it’s easier for me to recognize instructions in English language. It might be a bit strange because I talk Dutch the whole day, but my development work documented in English language.
Oh, that’s interesting: thanks for your feedback! 🙂
By the way, if you don’t mind and have the time, do you think you could leave us a review?
Thanks in advance and all the best with your store!
By the way, if you don’t mind and have the time, do you think you could leave us a review?
Thanks for the reminder 🙂
