ClearStock is live on the Shopify App Store.Install free →

← All blogs

Guides9 min read

Cutting from twelve suppliers to five: the consolidation checklist

A quarter-long supplier consolidation checklist: map spend, score the keep-set, run the transition sequence, and exit the rest, with worked PO math.

InventoryX is in development and not available today. ClearStock is the live Shopify app.

The checklist in this article takes a twelve-supplier stack down to five in one quarter, without leaving any SKU without a home. The reason to want it is arithmetic: every supplier you keep charges you a standing fee measured in POs, minimums, freight moves, deposits, and memory. Twelve suppliers for a few hundred SKUs is a sprawl tax most small merchants pay without ever seeing an invoice for it — and consolidating is one of the few inventory projects that saves time and money simultaneously, in both cases by deleting work rather than adding it.

Before touching anything, know what you're consolidating into: scoring the suppliers you already have — delivery reliability, quality history, financial signals — is its own discipline, covered in the supplier risk assessment guide. This article owns the two parts that sit next to it: the consolidation decision itself, and the transition sequence that moves your spend without breaking replenishment.

What twelve suppliers actually cost you

Worked example, illustrative throughout — set the benchmark from your own PO history. A stationery store, 12 suppliers, 340 SKUs across notebooks, pens, sticker sheets, and seed-packet kits:

  • PO administration. Roughly 34 POs a quarter, an average of 2.8 per supplier. At a conservative 35 minutes each (illustrative) — create, send, confirm, chase, receive, reconcile — that's 34 × 35 ≈ 1,190 minutes, about 20 hours a quarter of pure order plumbing.
  • Fragmented freight. Nine small inbound shipments a month, each paying its own minimum freight, instead of three consolidated lanes. Estimated saving from consolidation: $180/month (illustrative) at this scale.
  • Small-order fees and missed minimums. Six orders a quarter below the supplier's free-freight threshold, eating an estimated $25 each (illustrative): $150 a quarter for buying in the wrong-sized slices.
  • Deposit and terms sprawl. Five suppliers wanting deposits means five prepayments to track, five sets of payment dates, five reconciliations — the mechanics multiply exactly as shown in the deposit and prepayment guide.
  • Context switching. Twelve sets of lead times, contact people, spec quirks, and invoice formats. The cost here is errors, and every merchant who has received 200 of the wrong notebook size knows it.

Rough total at this illustrative scale: about 20 hours a quarter, an estimated $600–$700 in freight and fees per quarter, and a steady drip of mistakes. Consolidating to five suppliers cuts the PO count to roughly 18 — around 9 hours of plumbing a quarter saved — while the freight lanes and minimums consolidate in your favor. That's the case for the project; the checklist below is how you run it without breaking anything.

The consolidation checklist

Four phases, one quarter. Print it, work it, date it:

Phase 0 — Map the spend (weeks 1–2)

  • Pull 12 months of POs by supplier and category; total spend per supplier.
  • Note each supplier's capabilities: categories they could serve beyond what you currently buy.
  • Record reliability notes per supplier: late deliveries, quality incidents, deposit disputes.
  • Flag one-way dependencies: proprietary specs, exclusive colors, tooling you'd strand.

Phase 1 — Choose the keep-set (weeks 3–4)

  • Score every supplier using the risk-assessment method — spend share, reliability, price position, terms, capability overlap.
  • Run the coverage test: every SKU in the catalog must have at least one home in the keep-set.
  • Apply the second-source rule: any A-list SKU gets two possible homes before its current supplier can be exited.
  • Name the exits and their final-order dates.

Phase 2 — Move the spend (weeks 5–12)

  • Re-quote the keep-set for the categories they're taking over, using the quote evaluation worksheet — consolidation is a negotiating event, and bigger baskets earn better terms.
  • Dual-run the top category for one full cycle before switching it entirely.
  • Consolidate freight lanes: same Incoterm, same forwarder pattern, fewer larger shipments (Incoterms 2020, International Chamber of Commerce, accessed November 2026).
  • Update lead-time records for every moved SKU — per-supplier lead-time measurement starts at zero for a newly consolidated lane — and build the identifier crosswalk for every moved SKU before their first invoice arrives: the supplier SKU mapping guide is the table.

Phase 3 — Exit cleanly (weeks 9–16, overlapping)

  • Place final orders with exiting suppliers, sized to cover the transition gap.
  • Settle every open deposit and invoice to a zero balance, in writing.
  • Archive the supplier records but keep the files — a clean exit is a re-openable door.
  • Send the exit note: professional, specific, no bridge-burning.

Choosing the keep-set

The keep-set decision is a table, not a feeling. Sort every supplier into one of three verdicts:

Verdict Criteria Action
Keep (target: ~5) 60–80% of combined spend, or unique capability; reliable delivery record Consolidate categories onto them; renegotiate terms on the bigger basket
Watch (1–2) Reliable but small spend, or single specialized SKU Keep for one quarter; re-score after the transition settles
Exit (5–6) Overlapping capability, weak reliability record, or spend too small to matter Final order, settle balances, archive

Two traps live in this table. The first is keeping a supplier because the relationship is pleasant — consolidation is a portfolio decision, and niceness is not a capability. The second is the opposite error: exiting the specialist who makes one SKU nobody else can make. Unique capability beats spend share; a supplier holding your only source of a bestseller belongs in the keep-set regardless of size, or the second-source rule fails its first test.

The transition sequence, quarter by quarter

Consolidation fails when it's executed as a big-bang switchover, because the first order to a consolidated supplier almost always has a wrinkle — a spec question, a packaging change, a lead time nobody believes yet. Sequence the risk so the wrinkles hit small orders first:

Weeks Move Why this order
1–2 Spend map and capability notes Everything downstream depends on this picture
3–4 Score, coverage test, name the keep-set Decision before movement
5–8 Move the top category; dual-run one cycle Biggest saving first; wrinkles surface on a watched order
9–12 Move remaining categories; re-quote; update lead times Momentum with practice behind it
13–16 Final orders with exits; settle deposits; archive No supplier left dangling with open balances

The dual-run is the phase merchants skip and regret: one overlapping cycle where the old and new supplier both carry the category costs an estimated few hundred dollars in extra pipeline stock (illustrative) and buys you a clean fallback if the consolidated supplier's first big order misses. Consider it insurance priced per SKU.

What consolidation should not touch

Three things survive the project untouched, and writing them down before you start is what prevents over-consolidation:

  • The second source on A-list SKUs. Cutting from twelve suppliers to five doesn't mean five single points of failure. If one supplier can halt a category, the keep-set isn't done.
  • Sample and trade-show suppliers. Someone you buy three samples a year from to scout new products isn't a replenishment supplier and doesn't count in the twelve. Consolidating them saves nothing and costs optionality.
  • The exit doors themselves. Exits should be clean, not scorched. The supplier you leave today is the quote you want next year when your keep-set slips a delivery.

After the cut: fewer POs, cleaner books

The payoff shows up in the plumbing. Fewer suppliers means fewer POs to create, confirm, chase, and receive — and PO discipline gets easier to keep when each one matters more. This is also where native tooling carries its weight: Shopify's purchase orders record order, confirmation, and receiving per supplier (Shopify Help Center, accessed November 2026), and the Fall '26 release added PO data to analytics, so per-supplier spend and fill behavior are inspectable without a spreadsheet assembly line (Shopify Fall '26 Editions release notes, accessed November 2026). Run that view one quarter after consolidation: spend per supplier, on-time performance, deposit balances. If the keep-set isn't outperforming the twelve it replaced, the checklist above has a re-scoring step waiting.

Common questions

How many suppliers is the right number? Whatever covers your catalog with no single points of failure — commonly five or fewer for stores in the low hundreds of SKUs, grouped by category. The test isn't the count; it's coverage: every SKU has a home, every A-list SKU has two, and no keep-set supplier can halt a category alone by failing.

When should a small store consolidate suppliers? When PO administration, fragmented freight, and missed minimums visibly cost time or money — the sprawl arithmetic above is the trigger test — or when supplier count has grown past roughly one supplier per 30 SKUs. Consolidate in stable trading periods, never mid-season and never while a big order is in production with a supplier you're about to exit.

Do I lose negotiating leverage by consolidating? Usually the opposite, provided the keep-set is genuine competition for categories. Bigger consolidated baskets earn better prices, better payment terms, and free-freight thresholds you previously missed. The leverage you do lose is the threat to walk — which is why the second-source rule and clean exits matter: optionality, not supplier count, is what keeps terms competitive.

How do I exit a supplier without burning the bridge? Place a final order, settle every balance to zero in writing, settle any deposits explicitly, and send a short professional note stating the reason and the door being left open. No debrief of grievances, no negotiation relitigation. Suppliers remember how exits were conducted, and today's exit is next year's emergency quote.

What's the first move in a consolidation project? The 12-month spend map: every PO by supplier and category, totaled, with reliability notes beside it. It takes an afternoon in a spreadsheet and it decides everything downstream — who carries enough spend to deserve consolidation, which suppliers overlap, and where the coverage test will fail. Skipping it is how stores consolidate onto the wrong five.

Next step

Run the Phase 0 spend map today: pull twelve months of POs into a sheet, group by supplier, and total them — an afternoon, and it either reveals the sprawl tax or proves your stack is already lean. When you're ready to score the survivors, the supplier risk assessment method is the scoring frame the checklist above plugs into.