Reviewing a 200-Line Supplier Invoice in Shopify Without Losing Your Place

A forty-line invoice is a quick read. A 200-line one from a liquor distributor, a grocery wholesaler or an auto-parts jobber is a different job. Somewhere around line 90 you lose track of which rows you have checked, which ones the software was unsure about, and whether that case of vodka was matched to the 750 ml or the 1.75 L.

Start Free Trial — 14-day free trial on Starter plan, no credit card required.

Why Long Invoices Go Wrong

Parsing is rarely the problem on a long invoice. The trouble is human: scrolling past a row that needed a decision, correcting one line and forgetting you were mid-way through another, or posting everything because a couple of rows are still unsettled and you are out of patience. A good review routine does three things: it shows you only the lines that need you, it lets you check them against the paper, and it lets you post what is settled without waiting on what is not.

Step One: Let the Matcher Do the Easy 80 Percent

When you upload a PDF, Excel file or CSV, each line is read and matched against your catalog, barcode first, then SKU, then title, with an exact check before a SKU or barcode match is accepted. On a store with clean identifiers most rows are matched before you look at them. For how that ranking works and why it avoids guessing, see matching supplier invoice lines to Shopify SKUs . Your job in review is the remainder.

Lines matched to existing Shopify products, and what is left for you to review.

Step Two: Work From the Toolbar, Not From the Scrollbar

The invoice lines list has a toolbar that stays visible as you scroll. Instead of reading top to bottom, use its buttons to walk straight to the rows that need a decision:

The buttons only show when they have something to do, so a clean invoice has a clean toolbar. The point is that the number on each button is a to-do list: when it reaches zero, that category is done.

Step Three: Search for the Line You Mean

For everything else there is a search box at the top of the lines list. Type part of a product name, a SKU or a barcode and the list narrows to the matching lines. Some details that matter on a real invoice:

The search is a view, not a filter on what gets posted. Your selection and every count at the top still cover the whole invoice, so typing a product name cannot quietly remove other lines from the upload.

Step Four: Check the Paper When Something Looks Off

If a quantity or a price looks wrong, the answer is on the original document, and leaving the page to find it is the most common way to lose your place. The toolbar has a View invoice button that opens the stored original without leaving the screen. It only appears when the original file was kept, so older invoices may not show it.

A useful habit for liquor and grocery invoices, where one SKU can appear in several pack sizes: search the line, open the original, and confirm the pack size and the unit count against the paper before trusting the cost. Case-pack arithmetic is covered in the liquor distributor guide .

Step Five: Select, Post What Is Settled, Come Back for the Rest

At the top of the list a single tick box sits beside a count such as "180 selected of 192 matched". Tick it to select every matched line, untick it to clear. If you picked some lines by hand it shows a dash, and one click completes the set rather than wiping your choices, so a stray click does not undo ten minutes of work.

Because you can post a selection, a long invoice does not have to be all-or-nothing. Post the 180 lines you are sure of, and the invoice stays open as partially posted while you chase the twelve that are not resolved. Each posting goes to one Shopify location, which also means you can send different batches to different locations; the limits of that are spelled out in receiving one invoice into multiple locations . Posting updates quantities and cost, and if you catch a mistake afterwards you can undo a posted invoice .

A Ten-Minute Routine for a 200-Line Invoice

Newly created products from unmatched lines are built as drafts for you to review, so they do not go on sale by themselves. Check them in Shopify before you publish.

What This Will Not Do

The search finds lines on one invoice; it is not a catalog search. The toolbar tells you where the attention is needed but it does not decide for you, and it will not post anything without your click. Apparel invoices with size runs lean on variant groups more than search; see the apparel and footwear guide . The goal is simply to make a long invoice feel like a short one.

Review your next long invoice in ten minutes

Run a real supplier invoice through the 14-day free trial and see which lines need you. Inventory and cost only change when you post.

Review long invoices faster

A long invoice should not take a long afternoon

Turn supplier invoices into accurate Shopify stock and cost, with a review step before anything posts.