How should a tint shop track window film inventory so it never runs out mid-week?
Track film at the roll level — including footage left on partial rolls — deduct usage as each job closes, and set a reorder point for every film SKU based on your weekly usage and your supplier's lead time. Then check remaining stock against the coming week's booked jobs so shortfalls surface while there's still time to order at normal shipping speed.
A mid-week film stockout is expensive in ways the invoice never shows: booked jobs get rescheduled, rush shipping eats the margin on the roll, and a customer who asked for one film gets talked into another. Most stockouts trace back to the same root cause — the shop counts rolls on the shelf instead of footage remaining, so a nearly empty roll looks like stock. Reliable window film inventory management comes down to three habits: live counts tied to jobs, a reorder point per SKU, and a weekly look at what the booked schedule is about to consume.
Why the answer is what it is
Track footage per SKU, not rolls on a shelf
A SKU in a tint shop is the combination of film line, VLT, and roll width — a 40-inch roll is a different SKU than a 60-inch roll of the same 35% ceramic. Record the linear feet remaining on every roll, including partials. A shelf showing three rolls can hide the fact that two of them are down to their last car.
Deduct film when the job closes, not at month-end
Make usage logging part of closing out every job: the installer records what came off the roll, including miscuts and remakes. Live deduction keeps the count honest all week. Month-end reconstruction guarantees you discover a shortage only when the shelf is already empty.
Set a reorder point for every film you stock
For each SKU, estimate how much you use during your supplier's lead time and add a buffer for a heavy week or a remake. When stock crosses that line, order — don't wait for the roll to run out. A reorder point turns restocking from an emergency into a routine.
Check the booked schedule against stock weekly
Your calendar already tells you what next week will consume: a run of full-car ceramic bookings can drain a VLT that looked fine on Monday. Once a week, walk the coming jobs against footage on hand and order against the shortfall while standard shipping still gets it there.
Verify with physical counts — and let software carry the routine
Spot-count fast movers weekly and do a full count monthly; the gap between counted and recorded footage is your waste and miscut rate, and it sharpens your reorder points. SalesThumb is built with film and supply inventory alongside the job record, and its Inventory Reorder tool flags low stock before you run out and assembles a suggested reorder list — while you still place the actual order.
What to look for
- List every film SKU — line, VLT, and roll width
- Record footage remaining on all partial rolls today
- Deduct film used, including miscuts, when each job closes
- Set a per-SKU reorder point: lead-time usage plus a buffer
- Compare next week's booked jobs against stock every Friday
- Spot-count fast movers weekly; full count monthly
- Give one person ordering duty on a fixed day
Related questions
How much backup window film should a tint shop keep on hand?
Enough to cover what you would use during your supplier's lead time on each fast-moving SKU, plus a remake or two. Size the buffer from your own usage log rather than a rule of thumb, and revisit it whenever your booking volume shifts.
Is a spreadsheet good enough for window film inventory management?
It works if one person updates it after every single job — the system fails the first week that discipline slips. Shop software keeps the count in the same system as the job itself instead of a separate file. SalesThumb, for example, is built with film and supply inventory alongside the job record, and its Inventory Reorder tool flags low stock and drafts a suggested reorder list for you to place.
What causes most mid-week film stockouts?
Partial rolls counted as full, miscuts and remakes that never get logged, and nobody checking the booked schedule against footage on hand. Ordering only when a shelf goes empty — instead of at a reorder point — turns every busy week into a gamble.
How Roffik addresses this
The operating system for auto service shops — booking, CRM, AI photo-to-quote, payments, warranty certs, and a technician mobile app, all in one place. Learn more about SalesThumb.