ds97

Hi Ewout
Thanks for your answer.
Would I be able to resolve this by upgrading?
Anything at all I could do? ??

Thanks

Hi alexmigf,
Thanks for your reply.
So the problem is, that the old site is no longer is use, and the back up I have does not include the invoices. I separately downloaded the invoices as PDFs thinking all was in order, but now all the pdf invoices don’t have the invoice number, just the order number on them, so now I need to redownload them with the invoice number for my accountant, from my new website, where the product is missing. So my issue is retrospective.

I will keep the pro version in mind for the future, but is there any way to add this product back or something so that I don’t have to manually add the product to each invoice or manually assing each invoice number to the old invoices?

I’m desperately trying finding a way not to spend my evenings sifting through a years worth of invoices trying to fix my mistake ??

Thanks for your help

Good day Ewout,
the list above comes from the Woocomerce orders dashboard.

I had a good look at the list generated from the code snippet. In this list, there are situations where the order number is the same for two orders and the time created is the same, but the invoice number is different.

(Here the first two orders have the same order number and a different invoice number, but were created at the exact same time, the same with the second and third last order)

536 51827 2020/12/15 20:19
537 51827 2020/12/15 20:19
538 51878 2020/12/15 21:26
539 51986 2020/12/16 00:11
540 51986 2020/12/16 00:11
541 52104 2020/12/16 10:01

When I search for the two invoice numbers in the system only one appears. This is where those gaps were created, as when I print the invoices, they then print in an order similar to this: 536,538,539,541) – Which obviously made our accountant question our invoices.
From what I can see, this is only ever the case with PayPal payments.
Like in this post: https://www.ads-software.com/support/topic/order-number-generates-2-different-invoice-numbers/

I have disabled PDT to see if this makes a difference.

As for the random orders in the middle of the other orders, this seems to be the case when an order failed or was returned from the shopper, where money was refunded. Not entirely sure what makes it jump to a different date, but I could at least explain this to the accountant, and find the place it would have fit in, in terms of the invoice numbering.
So the orders are sequential, except for when PayPal is used, just with some random invoices where they shouldn’t be.

Thanks for your help again!

Hi Ewout,
so sorry for the confusion, both the invoice numbers and the order numbers have gaps. I have read many articles about the order number gap problem, but that doesn’t concern me too much (I just couldn’t download a list of my invoice numbers).

These are some of the invoice numbers in sequence, and then after the line, another sequence.

120575BY Dec 22, 2020
GAP
120573BY Dec 21, 2020
120572BY Dec 21, 2020
——————————
120568BY Dec 20, 2020
120567BY Dec 20, 2020
120574BY Dec 20, 2020 (Strange to have this one here)
120566BY Dec 19, 2020
120565BY Dec 19, 2020
120564BY Dec 19, 2020
120563BY Dec 18, 2020
GAP
120557BY Dec 18, 2020
120556BY Dec 18, 2020
120555BY Dec 18, 2020

So basically sometimes there are just gaps (as if a few numbers were skipped) and sometimes there’s a completely random invoice number in between the others. This problem repeats itself over the last four months or so, and wasn’t an issue when I first created the site in March, so not sure what I changed. Hmmm. I don’t know at what point I added paypal and stripe, not sure if that could be the culprit.
Thanks again!

Hi Ewout, sorry, I am talking about the second column. If you read from the top, the first few numbers end in 35,36,39,41… and then there are more gaps as you go down.

I used the code you suggested in this post: https://www.ads-software.com/support/topic/number-of-invoices-skipped/

Thanks for the help, I am more interested in the invoice numbering than the order numbering. Is there maybe a way I can attach a screenshot here of the problem?

Thanks again.

* Additional info to the above question:
We offer customers the option to pay with Paypal, Stripe (credit cards) and Sofort (EFT).

I’m so sorry, I just reread this and completely miss read this post. Thanks for the help nonetheless.

Hi Ewout
on this same note,
I am a EU Taxpayer and would like to show the Tax rate on the invoices generated with your plugin. Is this possible? Many thanks!

Thanks so much for your help! It worked.

Thanks so much! That worked. Brilliant!

Thanks so much Long,
I have tried adding it and it did not change anything. Do I need to fill in the page number maybe?

Hi Sneak123 thanks so much for pointing me in the right direction! I will check those out. Sorry, I am a total novice, so I lack a lot of the terminology to describe these kinds of things.