SoftwarePublished

Inventory tracking that is worth the effort

Most decorators hold stock and count none of it. Where tracking pays, where it does not, and how to start without a warehouse system.

  • 12 min read
  • 1,007 words
Inventory tracking that is worth the effort — warehouse at a print shop
Software12 min readA1printsoft EditorialPhoto: Rack Manufacturing Expert / Unsplash
On this page7 sections

The short answer

  • Most shops hold more stock than they think and count none of it
  • The critical distinction is allocated versus free stock
  • Track blanks held for stores and repeat programmes; not every consumable
  • Count on a rolling schedule rather than once a year
  • Stock visible where orders are taken prevents the expensive mistakes

Ask a decorator what stock they hold and the answer is usually vague. There are boxes from a store that closed, leftovers from an over-ordered run, a colour bought in bulk when it was cheap, and a shelf of garments nobody can account for.

All of it is money, and the pieces allocated to jobs are worse than money — they are the difference between an order shipping on time and a scramble.

What you are actually holding

CategoryTrack it?
Blanks allocated to open ordersAlways
Stock held for a running storeAlways
Decorated stock awaiting collectionAlways
Speculative blanks bought on priceYes
Common inks and threadLoosely — reorder points
Screens, film, chemicalsReorder points only
Tape, boxes, bagsNo

The point of the table is that tracking is not all-or-nothing. Attempting to count every consumable produces a system nobody maintains, and the value sits almost entirely in the first four rows.

Track what would ruin a delivery if it were missing. Everything else needs a reorder point, not a count.

Why it goes wrong

The common failures

  • Allocated stock borrowed for another job and never replaced
  • Overruns absorbed into general stock without a record
  • Spoilage taken from the shelf silently
  • Store stock and job stock stored together
  • Nobody responsible for the count
  • Counts done annually, so errors run for months

Borrowing is the single largest cause. A printer short two mediums takes them from another job's pile with every intention of replacing them, the replacement never happens, and the shortage surfaces days later on a different order with a nearer deadline.

Physical separation fixes more of this than any software does — allocated stock on a job shelf, free stock elsewhere, as covered in receiving and storing blanks.

What to track

For anything worth tracking, five fields are enough.

Per line

  • Style, colour and size — the exact combination
  • Quantity on hand
  • Quantity allocated, and to which job
  • Location, specific enough to find it
  • Cost, so the value is known

Size is not optional. "Forty navy tees" is not a stock record when the order needs twelve larges, and a system that tracks style but not size will report availability that does not exist.

Allocated versus free

This distinction does more work than everything else combined. Stock on the shelf is not stock you can sell.

TermMeans
On handPhysically present
AllocatedCommitted to a specific job
FreeOn hand minus allocated — what you can promise
On orderComing, with a date
AvailableFree plus on order within the deadline

Quoting from "on hand" is how a shop sells the same garments twice. Quote from free stock, and treat on-order quantities as available only when the delivery date beats the deadline — which requires knowing your real lead times.

Counting

An annual stocktake tells you how wrong you were, twelve months late. Rolling counts tell you in time to act.

A workable rhythm

  • Count a small section weekly rather than everything annually
  • Count fast-moving lines more often than slow ones
  • Count store stock before every store opens
  • Investigate discrepancies rather than adjusting silently
  • Record who counted and when

Investigating is the part that improves things. An adjustment made without explanation hides the process fault that caused it, and the same fault will produce the same discrepancy next month.

Where software helps

A spreadsheet can hold stock levels. What it cannot do is update them when an order is taken, which is where the real value sits.

What connected stock gives you

  • Allocation happening automatically when an order is confirmed
  • Free stock visible at the point of quoting
  • Shortages flagged while there is still time to order
  • Store products limited to what exists
  • Stock value reported without a manual exercise
  • One record, whoever is looking

Quoting against live free stock is the feature that prevents the expensive errors. Where stock sits inside the same system as the orders, the shortage is discovered by the person taking the order rather than by the printer on the morning of the run.

Supplier availability belongs beside it. Your own shelves are only part of the picture, and current supplier stock data is what turns "we have six" into "we can have thirty by Thursday".

Starting small

The first month

  • Count what you have, once, properly
  • Separate allocated stock physically from free stock
  • Record the four fields for anything worth money
  • Set reorder points on consumables you cannot run without
  • Name one person responsible
  • Count one section a week from then on

The first count is usually the moment the exercise justifies itself, because most shops discover both dead stock they had forgotten and shortages they were about to be caught by. Neither is visible without counting.

Set a rule for overruns while you are at it, because they are the main way untracked stock accumulates. Either return them to free stock with a record, send them to the customer as spares, or scrap them deliberately — what must not happen is a pile that exists physically and nowhere else.

Decorated leftovers deserve a decision too. A dozen shirts carrying a customer's logo are worth nothing to anybody else, so either the customer takes them or they become rags, and holding them for a year in the hope of a reorder is simply storing a loss.

Then decide what to do with what you found. Dead stock is money that can be recovered by selling it cheaply, using it for samples, or writing it off deliberately — all of which are better than storing it for another year and counting it again. The rest of the software archive assumes stock is a number somebody can look up.

Filed underSoftware
Share
Written byA1printsoft Editorial
175 articles

The print production desk at A1Printsoft. Writes the practical side of running a decorating shop: what things cost, how long they take and what to charge, checked against published trade figures.

Keep reading

More on software

All Software articles

Set up in an afternoon. From what you already do.

Free for 14 days · no card · pick what you make and we preload the methods, products and price tables.