Can I send email directly to support@wpovernight.com, (I found that on a previous post that someone else was having similar issue) ?
Thanks
Kristin
Plugin Contributor
Ewout
(@pomegranate)
If you’re using the free version it’s preferable to keep the conversation here. Can you provide a link to the post you found? It may help us resolve the issue quicker.
Yes free version.
The website is not yet live. So I can’t provide a link to share unless I can email private somewhere and create a login for you.
Thanks
Kristin
Sorry I can’t find that other post again, I found it accicentally, it was similar issue. But wasn’t resolved.
I hope you can help as I haven’t had that issue before.
Thanks
@kristinubute,
We would love to help but need a way to try to reproduce your error or more information to help detect conflicts.
Could you share your system status report here? WooCommerce > Status > get status report.
Plugin Contributor
kluver
(@kluver)
In addition to sending us the system report you can also download a small plugin we’ve created, called Number Tools, to troubleshoot invoice number issues. You can download the latest release here.
After installing and activating the Number Tools plugin you will have an additional tab in the PDF Invoices settings (WooCommerce > PDF Invoices > Number Tools). You can select ‘Invoice’ in the ‘Choose a number store’ option to retrieve a list of all invoice numbers since the last reset.
It will show when they were created and to which order number they are connected. Hopefully this will shed some light on the situation. You can share a screenshot of the list with us via a service like Imgur or ImgBB.
Also could you tell us if the ‘Calculate document numbers’ option is enabled? You can check this option via: WooCommerce > PDF Invoices > Status > Calculate document numbers
-
This reply was modified 4 years ago by
kluver.
From what I can see also that it created an Invoice Number even when order is “ON HOLD”.
So maybe I need to change the setting ?
FYI
I have checked my settings, and it is set to attach Invoice ONLY on “NEW Order” to Admin, Completed Order and Customer Invoice (Manual Email).
Order On Hold is NOT ticked.
In the “NEXT INVOICE NUMBER (without Prefix./suffix etc), I had typed in 3224, that is the Invoice number that keeps repeating. It is NOT adding 1 to each Invoice number for some reason. FYI
I’ve gone to Status as you suggested also. I have now ticked the setting for “Calculate Document Numbers …
And will test again now …
And that seemed to have fixed the issue. I will test it again tomorrow and let you know.
Regards
Kristin
Just a quick question, if I haven’t ticked for it to create an Invoice for “ON HOLD” why is it doing it ?
Please advise. I assume it is just internal Invoice number as it is ONLY ON HOLD … then will send Invoice to customer once status has changed ..
Thanks
Kristin
Plugin Contributor
Ewout
(@pomegranate)
I’ve gone to Status as you suggested also. I have now ticked the setting for “Calculate Document Numbers …
And will test again now …
And that seemed to have fixed the issue. I will test it again tomorrow and let you know.
This indicates there’s an issue with your database – apparently it cannot handle autoincrement properly. This “Calculate document numbers” option is somewhat of a last resort because under circumstances where a lot of invoices are generated at the same time (orders being placed within microseconds from each other, for example when you have a lot of checkout orders being placed in a short timespan, or when order status changes are triggered in parallel by an external API request), this can result in duplicate numbers. I would recommend reaching out to your host to ask why autoincrement doesn’t work. Did the Number Tools show you anything interesting?
if I haven’t ticked for it to create an Invoice for “ON HOLD” why is it doing it ?
This is because you have also attached the invoice to the “New Order” admin email, which is sent when the order moves to Processing, Completed OR On Hold!
