Entering supplier invoice products without losing your evening
A delivery arrives, the supplier invoice runs three pages, and you need to create forty product listings with the right sizes, the right colors, the right prices and the right photos. This is the moment when most independent shops fall behind, sell slower, and end up rushing the catalog. Here's how to take back control of this step.
What a delivery really costs you
- A 40-line invoice takes 4 to 8 hours of manual entry on average.
- Every day of delay means items sitting in the stockroom that can't be sold online.
- Entry mistakes (size, color, price) get paid for later: returns, disputes, cancellations.
- A sloppy catalog then hurts visibility, both on Google and in AI assistants.
Creating product listings is often seen as an administrative chore. In reality, it's the bottleneck for most independent shops: until a reference is entered, it doesn't exist on the website, at the register, or on marketplaces. And because this task always lands at the worst moment — delivery day, the eve of a weekend, the start of a season — it gets postponed, then rushed.
What a supplier invoice actually contains
Before talking about tools, it's worth looking at the raw material. An invoice or delivery note already contains the essentials of a product listing:
- The supplier reference: the key that lets you find the product with the brand, and later manage restocking.
- The EAN or barcode, when the supplier includes it: the most reliable identifier for finding photos and specifications.
- The product label, often abbreviated, sometimes in all caps, rarely sellable as-is.
- The variants: sizes, colors, capacities. They're there, but scattered across several lines.
- The quantities, which give the initial stock for each variant.
- The cost price, and sometimes a recommended selling price.
The classic trap
The price on the invoice is a cost price, not a selling price. If it goes straight into the listing as-is, the shop sells at a loss without even noticing. A recommended selling price, on the other hand, is only indicative: the margin is yours to decide.
The four possible methods
| Method | Time for 40 references | Main limitation |
|---|---|---|
| Manual entry in the back office | 4 to 8 h | Fatigue, variant mistakes, missing photos |
| Supplier's CSV file | 1 to 3 h | Few suppliers provide one, columns always differ |
| Outsourced data entry service | 24 to 72 h turnaround | Recurring cost, back-and-forth corrections |
| Automated invoice reading | A few minutes + review | Still needs validation before publishing |
None of these methods removes the need for review. The real difference lies elsewhere: with the first three, you produce the data; with the fourth, you check it. Correcting two listings out of forty takes a few minutes. Entering all forty takes an evening.
The five-step method
1. Start from the invoice, not a blank page
Photograph or upload the invoice PDF. The goal is one line per reference with its quantity, cost price and variants, without retyping anything. A simple rule: what isn't written on the invoice shouldn't be invented. An empty field is a field to fill in later, not a field to guess.
2. Match each line to a real product
A supplier reference or an EAN lets you find the product as it already exists: full commercial name, brand, material, dimensions, official photos. This is the step that turns "CK08090 BLACK 38" into a listing a customer can understand and buy. If you don't have an EAN, the supplier reference combined with the brand name is usually enough.
3. Group variants under the right listing
This is the most common and most costly mistake: creating four separate products instead of one product with four sizes. A single model available in several sizes and colors should stay one listing, with one variant per combination, each with its own stock and barcode. Above all, check that the photo matches the color: a black photo on an "ivory" variant generates immediate returns.
4. Set the selling price, not the cost price
Apply your markup once across the whole delivery, then review the exceptions. Keep the cost price stored somewhere: it's what lets you track your real margin, item by item, and spot the references not worth reordering.
5. Review, publish, sync
One last check on five points: readable title, correct photo, complete variants, stock matching the delivered quantity, selling price applied. Only then send it to your online store and your register, so stock stays the same on both sides.
Why a sloppy listing costs you for a long time
A listing with no description, no brand and no specifications sells poorly, but above all it can't be found. Search engines and AI assistants rely on structured data: brand, material, dimensions, barcode, category. A shop with a clean catalog becomes citable; a shop whose listings read "V-NECK SWEATER BLACK" stays invisible, even when paying for ads.
In other words, the time invested in creating product listings isn't judged on delivery day. It's judged three months later, when the product does — or doesn't — resurface in a search.
The takeaway
The supplier invoice already contains 80% of the product listing. Your real value-added work is pricing, review and variant consistency — not retyping. Refect reads the invoice, finds the matching products, and prepares the listings with photos, variants and stock, so all you have to do is approve before sending to Shopify or Square.
Create my listings from an invoiceFAQ
How long does it take to enter the products from a supplier invoice?
By hand, count 5 to 10 minutes per reference once photos and descriptions are found, so 4 to 8 hours for a 40-line invoice. Starting from an automated invoice reading, most of the time goes into review and price adjustments.
What if the invoice has no EAN code?
The supplier reference combined with the brand name usually lets you find the product on the manufacturer's website. Failing that, the full label and category are enough to build a correct listing, and you can fill in the specifications later. Our guide to finding an EAN code covers reliable sources.
Should I create one product per size, or one product with variants?
One product with variants, in almost every case. This avoids splitting your sales history, simplifies restocking, and gives the customer a single page to pick a size from. Each variant keeps its own stock and its own barcode.
Can the price printed on the invoice be used as the selling price?
No. In the vast majority of cases it's a cost price before tax. Apply your markup and treat any recommended selling price as a mere suggestion, never as a value to publish automatically.
Does this work with Shopify and a physical register?
Yes, as long as listings are created once and then synced to both systems. The point to watch is stock: it must be decremented in one single place, otherwise discrepancies show up within the first week.