🔧

Upholstery Supply Inventory Tracker

Keeps a running list of your tacks, staples, springs, webbing, thread, and other shop supplies.

UpholsteryRepair and Everyday Services✓ Checkedv1.0

Before and after

BEFORE · what the owner typed

ok updating stock. used 2 boxes of the 3/8 tacks on the wingback job and one box of 1/2 staples on the dining chairs. got a delivery today, 4 rolls of 3.5in jute webbing and 6 spools of black bonded nylon #69. counted springs this morning, 40 of the 8 gauge 7in coil and 12 of the 9 gauge 5in. i think i have about 15 sinuous clips left. had 6 boxes of 3/8 tacks and 5 boxes of 1/2 staples before. webbing 2 rolls before delivery, thread black 2 spools before delivery and tan 1 spool. minimums: tacks 3 boxes, staples 2, webbing 3 rolls, black thread 3, tan thread 2, 8ga coils 30, 9ga coils 20, clips 25. Cut a bunch of 3/8 tacks into the count by accident? no ignore that. Next week I have a settee needing 18 coils of the 9 gauge 5in. Webbing last paid 22 a roll, tan thread 9 a spool, 9ga coils 1.50 each, clips 0.40 each. Supplier is Dalton Upholstery Supply.

AFTER · what the skill produced

Updated inventory

Tacks and staples

3/8 tacks, box: 6, minus 2 used, equals 4. Status: OK
1/2 staples, box: 5, minus 1 used, equals 4. Status: OK

Springs and clips

8 gauge 7 inch coil springs, each: fresh count 40. Status: OK (minimum 30)
9 gauge 5 inch coil springs, each: fresh count 12. Status: Low (minimum 20)
Sinuous clips, each: about 15 (estimate). Status: Low (minimum 25)

Webbing and straps

3.5 inch jute webbing, roll: 2, plus 4 received, equals 6. Status: OK

Thread and needles

Black bonded nylon #69, spool: 2, plus 6 received, equals 8. Status: OK
Tan thread, spool: 1. Status: Low (minimum 2)

Reorder list (Dalton Upholstery Supply)

9 gauge 5 inch coil springs: have 12, need 18 for the settee next week, so you are short 6 for that job alone and 8 below your minimum of 20. Quantity to order: blank for you to set. Last price 1.50 each.
Sinuous clips: about 15 on hand, minimum 25. Quantity to order: blank for you to set. Last price 0.40 each.
Tan thread: 1 spool, minimum 2. Quantity to order: blank for you to set. Last price 9 per spool.
Estimated total: not calculated because quantities are blank. Once you pick quantities, send them and I will add it up from your last prices.

Questions and notes

Your tack message mentioned cutting tacks into the count, then said to ignore it. I did not change the tack counts for that.
The settee needs 18 of the 9 gauge 5 inch coils and you have 12. Order at least 6 more before next week, and more if you want to get back to your minimum of 20 after the job.
The clip count is an estimate. A quick physical count would make the Low status more reliable.
Tacks, staples, webbing, black thread, and the 8 gauge coils are all above minimum. No order needed.

What it does

Keeps a running list of your tacks, staples, springs, webbing, thread, and other shop supplies. It updates counts when you use or buy items, flags what is running low, and builds a reorder list.

Use it when: Use when an upholstery shop needs to track, count, or reorder tacks, springs, webbing, thread, and other shop supplies, such as "what am I low on," "update my stock," "make a reorder list," or "I used 3 rolls of webbing on that job."