Invoice number progression

Hi @emanuelemn,

Thanks for providing that screenshot. However, that seems not to be a screenshot of the Number Tools log, but the order list instead. Could you please also send a screenshot of the number invoice log, under WooCommerce?> PDF?Invoices?> Number?Tools?

Let me ask something more: Do you use PayPal as a payment method in your store?

I do not use PayPal as the payment method.

print screen Number Tools:

View post on imgur.com

The WooCommerce-> orders are missing:
0376
0378
0379

In Number Tools numbers that are missing are associated with older commands

I also attach a printscreen with the settings

View post on imgur.com

Hi @emanuelemn,

Judging by your screenshot of the Number Tools plugin there are no skipped invoice numbers. Invoice number 0376, 0377, 0378 and 0379 are assigned to canceled orders.

Perhaps that is causing the confusion?

I noticed because of the canceled invoices
But the invoices are not numbered chronologically.
I think this is the problem

View post on imgur.com

Hi @emanuelemn,

The Date column in the logs from Number Tools is not the document date, but the order date.

Please note that invoice numbers are assigned based on when the document is generated, and this does not always match the sequence in which orders arrive (unless you generate an invoice at order creation, regardless of whether you have received payment or not, e.g. by sending the document to the administrator).

For example:
Let’s say that your next invoice number is I-101 and you only generate an invoice when the order changes to Completed status (that in fact appear to be your case). If you receive three orders in a row, with the order numbers 100, 101 and 102, but the order status changes to Completed in a difference sequence: 102, 100, 101, the invoice numbers would look like this:

Order: 100 = Invoice: I-102 (second to change to Completed)
Order: 101 = Invoice: I-103 (third to change to Completed)
Order: 102 = Invoice: I-101 (first to change to Completed)

The status of the orders is automatically set to Completed, after making payments.
There is only one payment method on the site
Payment is made by bank card.

Thanks for the clarification.

I see that the orders with a date out of the chronological sequence are #Id-0398, #Id-0410, #Id-0414, and #Id-0424 that have some in common: their order status is Cancelled. Maybe do you had previously selected the order email notification from this order status in the Attach to setting? In your 2nd screenshot here, this notification is not selected, but I wonder if it was, that would explain why an invoice was generated at this point.

Hi @emanuelemn,

I have taken a second look at your case, and I realized that I was wrong when I said that the Date column displays the Order date: It displays the local date at the moment of the document number creation, so please ignore my explanation above, since this seems not to apply to your case.

That said, It’s very weird that your dates for those cancelled orders differ from the dates sequence for the before/after orders. The only thing that I can think of is that maybe (very unlikely) you have changed your server date…

I’ll ask with my colleagues if they have any hint about it, but if you found out why this happened first, please let us know!

Hi @emanuelemn,

The ‘Date’ column displays the invoice date and therefore reflects your ‘Display invoice date’ setting (WooCommerce > PDF Invoices > Documents > Invoice). In this case it looks like you’ve chosen to use the order date as your invoice date.

Which means the invoices for the canceled orders were created (probably manually) some time after the orders were placed. And between the creation of these cancelled orders and the creation of their invoices, new orders came in that automatically generated an invoice number.

A quick example below where the order date is set to display as the invoice date and invoices are automatically generated when the order is set to Completed.

Orders:

• Order #1, Order date: 01-07-2022, set to Cancelled
• Order #2, Order date: 10-07-2022, set to Completed
• Order #3, Order date: 20-07-2022, set to Completed

Invoices:

• Invoice #1, Order #2, Invoice date: 10-07-2022 (automatically generated)
• Invoice #2, Order #3, Invoice date: 20-07-2022 (automatically generated)
• Invoice #3, Order #1, Invoice date: 01-07-2022 (manually generated)

• This reply was modified 2 years, 8 months ago by kluver.

Hi @emanuelemn,

Since we haven’t heard back from you in the last two weeks, we’re assuming you solved this issue, so I’ll go ahead and mark this ticket as Resolved.

Feel free to reply to this topic is you still need help with this, or open a new topic if you have any other questions!