Shopify invoice numbering: why the order number will not do

Of everything on an invoice, the number is the field with the most law attached to it and the least attention paid to it. It is also the one Shopify merchants most often get wrong, because there is an obvious-looking number already sitting on the order.

The rule

Across the EU, an invoice number must be:

sequential — the series runs in order;
continuous — no gaps. A missing number reads as a destroyed or hidden invoice, and that is exactly what an auditor is looking for;
unique — never reused, ever, including across years;
traceable to a series — you may run several (one per entity, per year, per document type), but each must be internally continuous and identifiable.

Credit notes belong to their own series. So do proformas, which are not invoices at all and must never consume a number from the invoice series.

Why the Shopify order number fails

#1001, #1002, #1003. It looks sequential. It is not a valid invoice number, for four reasons.

It has gaps by design. Cancelled orders, fraud-cancelled orders and test orders all consume numbers. Your invoice series then has holes you cannot explain, because the explanation ("that one was cancelled") is precisely the explanation an auditor will not take at face value.

It counts orders, not invoices. An order that is never paid is not invoiced. A single order that ships in two parts may be invoiced twice. A refund needs a credit note with its own number. The two sequences drift apart on day one and never reconverge.

It is store-scoped, not entity-scoped. Two Shopify stores under the same legal entity both start at 1001. You now have two invoices with the same number issued by the same company, which is the one thing the uniqueness rule exists to prevent.

You do not control the counter. The prefix and suffix are configurable; the counter is not resettable and the numbering is not guaranteed contiguous. It is a store-order identifier, and it is a good one — it is just not a legal document number.

What a proper series looks like

Simple and boring is correct:

INV-2026-00001
INV-2026-00002
INV-2026-00003

A prefix that identifies the series, INV- for invoices and something distinct like CN- for credit notes.
Optionally the year, if you restart annually. If you do, restart consistently — a series that restarts one year and not the next is worse than either choice.
Zero-padded increment, wide enough that you never overflow it.

Two rules that follow from continuity:

Never edit an issued invoice. If it is wrong, issue a credit note that cancels it and then a new invoice. Editing an issued document destroys the audit trail, and in several countries it is straightforwardly not allowed.

Never delete an issued invoice. Same reason. The number stays consumed. If nothing should have been invoiced, cancel it with a credit note, which leaves both numbers in place and the story readable.

Doing this on Shopify

By hand you keep the counter in a spreadsheet. It works and it fails the first time two people issue an invoice on the same afternoon, or the first time you restore an old copy of the file.

With Order Printer you get a template that prints the order number, because that is what the template has access to. Getting a real series out of it means maintaining the counter somewhere else anyway.

With an app the counter belongs to the app: it increments once per issued document, in its own series, independently of order numbers, cancellations and test orders.

That is how InvoicePilot does it. You choose the prefix once and it locks at the first issued document of that series — deliberately, because a prefix change mid-series creates exactly the break the rule forbids. Invoices and credit notes run as two separate continuous series, and a refund produces a credit note referencing the invoice it corrects.

The five-minute check on your own store

Open the last three invoices you sent a business customer.
Are the numbers consecutive? If they came from order numbers, they almost certainly are not.
Is there a document type that shares the series with invoices — a proforma, a quote, a refund note?
If you run more than one store under one company, do their numbers collide?

If any answer is uncomfortable, the fix is to start a clean series today, with a distinct prefix, from number one. A new series starting now is normal and explicable. A broken series stretching back two years is the thing you do not want to be explaining.

Written on 3 August 2026. General EU rules; national law adds detail. For your own situation, ask your accountant.