Manage Jewelry Inventory for Silver Boutique - HOLYCOME
Inventory is where most young jewelry businesses quietly die. Not from bad sales, but from boxes of unsold rings sitting in a spare room while cash runs out. Good inventory management is less about fancy software and more about measuring what sells, reordering winners, and cutting slow stock before it becomes dead stock. This guide covers the practical system a silver boutique needs, from SKU discipline to tarnish prevention to reorder points.
Why Inventory Kills More Stores Than Pricing
A store can price perfectly and still fail if cash is locked in unsold stock. Silver jewelry is not perishable, but it is cash sitting on a shelf. Every dollar in dead stock is a dollar you cannot spend on ads, new pieces or payroll. The goal of inventory management is to keep enough stock to sell, but not so much that cash dies.
The healthy inventory turnover for a boutique is about four to six times a year. That means stock sells through in two to three months. If your inventory sits for a year, you have a problem. If it sells out in a week, you are understocked. The number to watch is not how much you own, but how fast it turns.
SKU Discipline: One Code, One Piece, One Size
The foundation is SKU discipline. Every piece gets one code: material, category, style, size and color. A ring is not "silver ring"; it is "SR-RNG-SIGNET-07." When you sell a unit, you know exactly what left. Mixing sizes and colors under one code makes reorders guesswork.
Use a simple system: a spreadsheet, a cheap POS, or a low-cost inventory app. At small scale, a spreadsheet works. When you pass 200 SKUs, move to dedicated software. The system must tell you, at a glance, how many of each size you have. For the broader topic, read managing jewelry inventory.
Track the Numbers That Matter
Three numbers run inventory. Sell-through rate: what percentage of a buy sold in 30 days. Turnover: how many times a year stock sells. GMROI: gross margin return on inventory. A high GMROI means each dollar of stock returns strong profit. Track these monthly by SKU.
| Metric | Healthy range | What it tells you |
|---|---|---|
| 30-day sell-through | 40-60% | Is the buy sized right? |
| Annual turnover | 4-6x | Is stock moving fast enough? |
| GMROI | 2.5x+ | Is inventory profitable? |
If sell-through is under 30 percent, you overbought. If it is over 80 percent, you understocked. Adjust the next buy to hit the middle.
The Reorder Point and Safety Stock Formula
Never reorder by gut. Set a reorder point: when stock drops to X units, reorder Y. The reorder point equals average weekly sales times lead time, plus safety stock. If a stud sells ten a week and lead time is four weeks, reorder when you hit 50 units (40 weeks of lead time plus 10 safety). This prevents stockouts on winners.
Safety stock covers unexpected spikes. For a best seller, keep two weeks of sales as buffer. For a slow piece, keep zero. Do not hold safety stock on trend pieces; if they sell out, let them go.
Tarnish Prevention and Storage Conditions
Silver tarnishes when exposed to air, moisture and sulfur. Store stock in low humidity, away from direct sunlight, in anti-tarnish bags or strips. Do not store in a basement or attic. Keep a silica gel pack in the storage box. Pieces that arrive tarnished in the bag are the supplier's fault; pieces that tarnish in your storage are yours.
Rotate stock. Sell the oldest units first. A ring stored for a year tarnishes even with a strip. For the chemistry, read why silver tarnishes and silver jewelry care guide. Include a care card with every sale so customers store it right too.
Cycle Counting: Count a Little Every Week
Do one full inventory count once a year and you will find discrepancies everywhere. Instead, cycle count: count a small section every week. Monday count rings, Tuesday count earrings, and so on. Over a month, you count everything. This catches shrinkage, lost pieces and data errors while they are small.
Cycle counting takes twenty minutes a week. It beats a stressful year-end count and keeps your numbers trustworthy. If the system says you have ten rings but you find seven, investigate before reordering on bad data.
Mark Down Slow Stock Before It Becomes Dead Stock
Every piece has a clock. If a SKU has not sold in 45 days, mark it down. At 90 days, bundle it or sell it at cost. Dead stock is not an investment; it is a loan you made to a style nobody wants. Marking down early recovers cash that can buy winners.
Use markdowns strategically. Bundle slow pieces with fast ones. Offer them as a free gift with purchase. Sell them to a discount buyer. Do not let them sit and tarnish. For seasonal planning, read seasonal inventory calendar.
Separate Wholesale and Retail Stock
If you sell both DTC and to boutiques, keep the stock separate. Mixing channels causes overselling and confusion. Assign SKU batches: retail stock on the website, wholesale stock for B2B orders. This also protects your wholesale pricing; you do not want to accidentally sell a wholesale-priced piece to a retail customer.
Track which channel moves which SKU. A piece that sells wholesale slowly may sell DTC well, and vice versa. The channel mix informs the next buy. For packaging, read wholesale jewelry packaging.
Software Options at Every Budget
At the start, a spreadsheet tracks 50 SKUs. At 200 SKUs, use a light inventory app that syncs with your store. At 500 SKUs, move to a proper inventory system with purchase orders and barcode scanning. Do not overbuy software early; the discipline matters more than the tool.
Whatever you use, it must do three things: track units per SKU, flag reorder points, and report sell-through. If it cannot do those, it is a catalog, not an inventory system. Review the system quarterly; it grows with you.
Inventory Cleanup Checklist
Once a quarter, run a cleanup. Count stock, verify the system, identify slow SKUs, place reorders on winners, and mark down losers. Refresh anti-tarnish strips. Update size charts based on return data. This two-hour ritual keeps the business healthy. Inventory is not exciting, but it is the difference between a store that lasts and a store that drowns in unsold rings.
Frequently Asked Questions About Inventory Management
How much inventory should a new boutique carry?
Start with 15 to 20 SKUs, enough to cover six to eight weeks of projected sales. Do not tie up all cash in stock. Reorder winners and test trends in small quantities.
What is a good inventory turnover?
Four to six turns a year is healthy for silver jewelry. If stock sits over a year, you are overstocked. If it sells out in days, you are understocked and should reorder more.
How do I prevent silver from tarnishing in storage?
Store in low humidity, away from sunlight, in anti-tarnish bags with silica gel. Rotate oldest stock first. Include care cards so customers store pieces right too.
When should I mark down slow jewelry?
At 45 days with no sales, mark down. At 90 days, bundle or sell at cost. Do not let slow stock sit and tarnish. Recover cash for winners.
Do I need fancy inventory software?
No. A spreadsheet works under 200 SKUs. Move to a light app at 200 SKUs and a full system at 500. The discipline matters more than the tool.
How do I handle ring sizes in inventory?
Track each size as its own SKU. Buy a size spread from day one. Reorder based on which sizes sell fastest. Never track "rings" as one undifferentiated code.
What is safety stock?
A buffer of two weeks of sales on your best sellers to cover spikes and lead time delays. Do not hold safety stock on slow or trend pieces; that just creates dead stock.
How often should I count inventory?
Cycle count a section every week rather than one big count a year. Twenty minutes a week keeps numbers accurate and catches shrinkage early.
How do I handle shrinkage and lost stock?
Cycle count weekly and investigate discrepancies immediately. Most shrinkage comes from miscounts, not theft. If a product page says you have ten but you find seven, fix the system before reordering on bad numbers.
Should I use barcode scanning?
At over 500 SKUs, yes. Under that, a disciplined spreadsheet or POS is fine. Barcodes speed counts and reduce data entry errors. Do not buy a scanner before you need it.
How do I value inventory for accounting?
Value at landed cost, not retail. Inventory is an asset on the balance sheet at what you paid. Retail value is not real until sold. This matters for taxes and cash flow.
What safety stock level should I keep?
Two weeks of average sales on proven best sellers. Zero on trend pieces. Safety stock prevents stockouts on winners without creating dead stock on losers.
How do I handle a supplier backorder?
Communicate to customers immediately with a new date. Offer a cancellation or a discount on the next order. A backorder managed well builds trust; a silent delay loses it.
Should I keep physical or digital stock records?
Digital, synced to your store. Physical backup counts help during cycle counts. The system of record should be digital so your website reflects real availability.
How do I prevent overselling online?
Sync inventory in real time. When a piece hits zero, hide the product page. Overselling creates orders you cannot fulfill and angers customers. Track each size separately.
What is dead stock and how do I clear it?
Dead stock is unsold pieces over 90 days. Clear it with bundles, flash sales, or a discount buyer. Do not donate it hoping it recovers. For seasonal planning, read seasonal inventory calendar.
How do I set up a reorder point?
Multiply average weekly sales by lead time in weeks, then add safety stock. If a stud sells ten a week and lead time is four weeks, reorder at fifty. Review the number quarterly as sales change.
What is GMROI?
Gross margin return on inventory: the gross profit you make for each dollar of stock. A GMROI above 2.5 means inventory is working hard. Below 1.5 means stock is tying up cash. Track it by SKU.
How do I store silver without tarnish?
Low humidity, anti-tarnish strips, sealed bags, and silica gel. Avoid basements and bathrooms. Rotate oldest stock first. A piece stored a year will tarnish even with care.
Should I insure my inventory?
Once inventory value exceeds a few thousand dollars, yes. Business insurance covers theft, loss and damage. It is a small cost that protects the business from a single disaster.
How do I handle a lost shipment?
File a claim with the courier, refund or replace the customer immediately, and track the claim. Do not make the customer wait for the courier. Your reputation matters more than the claim.
What is the 80/20 rule for inventory?
About 20 percent of SKUs drive 80 percent of sales. Identify that 20 percent and keep it well stocked. The other 80 percent should be tight and tested. Do not overstock the long tail.
How do I count jewelry accurately?
Count by SKU and size, slowly, with a system. Use a tally sheet or a scanner. Do not count "rings" as a pile; count each size separately. Small items are easy to miscount.
Should I keep stock on consignment?
Consignment to boutiques can expand reach, but it ties up stock in someone else's store. Start with wholesale, not consignment, because consignment gives you less control and slower cash.
How do I plan for a seasonal spike?
Order three months ahead. Q4 stock arrives by October. Mother's Day stock by March. Do not wait for the spike to order; lead times stretch when everyone orders at once.
What is the easiest inventory win?
Marking down slow stock. Most stores let slow pieces sit out of hope. A 45-day markdown rule frees cash and shelf space for winners. For pricing, read pricing for maximum profit.
How do I forecast demand for a new SKU?
Start small and extrapolate. If a similar style sold ten a month, order fifteen to test. Use the first 30 days to adjust. Forecasts are guesses; the small buy protects you when the guess is wrong.
What is a safety stock formula?
Safety stock equals (max weekly sales minus average weekly sales) times lead time. It covers demand spikes. Keep it only on proven winners. On new or slow pieces, hold zero.
How do I handle seasonal stock?
Buy ahead for peaks, then clear down after. Do not carry holiday stock into February. Mark it down hard. Seasonal stock should turn within the season, not roll over.
Should I use a consignment inventory model?
Consignment lets boutiques sell your stock without buying, but it ties up your inventory in their store. Prefer wholesale for cash flow. Use consignment only to test a new boutique relationship.
How do I value dead stock?
Write it down to what you can recover. Dead stock on the books at cost is an illusion; it is really worth the markdown price. Clear it and redeploy the cash.
What is cycle counting?
Counting a small section of inventory each week instead of one big annual count. It keeps numbers accurate and catches errors early. Twenty minutes a week beats a stressful year-end.
How do I prevent tarnish during shipping?
Include an anti-tarnish strip and seal the piece in a bag. Do not ship in open boxes. Silver that sits in transit for two weeks needs protection. For care, read why silver tarnishes.
What inventory KPIs should I watch?
Sell-through, turnover, GMROI, and stockout rate. Sell-through tells you if buys are sized right. Turnover tells you if stock moves. GMROI tells you if it is profitable. Stockout rate tells you if you underorder.
How do I handle a supplier MOQ that forces overstock?
Negotiate a lower MOQ, bundle SKUs, or split the order with another buyer. Do not buy a year of a style just to hit a MOQ. For MOQ tactics, read low MOQ jewelry wholesale.
What is the most common inventory mistake?
Emotional restocking. Reordering a piece because you love it, not because it sells. Cut the cord. Let data, not affection, drive reorders. Your taste is not the market.
How do I know when to reorder a best seller?
When stock hits the reorder point: average weekly sales times lead time, plus safety stock. Do not wait until it is empty. A stockout on a winner is lost revenue. For formulas, read inventory management.
What is the difference between inventory and stock?
Inventory is all the goods you own. Stock is the units available to sell right now. Inventory includes reserved, damaged and incoming stock. Track both for accuracy.
How do I handle damaged stock?
Set it aside in a damaged bin. Photograph it, file a claim with the supplier, and either return it or mark it at cost. Do not sell damaged pieces as new. Honesty protects reviews.
Should I track inventory by weight or unit?
By unit and size. Weight matters for pricing and freight, but unit counts drive reorders. Track each SKU and size separately. Weight is a financial metric, not a replenishment one.
How do I plan cash flow around inventory?
Keep cash for three months of fixed costs outside inventory. Never tie every dollar in stock. The stores that fail are liquid-strapped, not sales-starved. For cash flow, read pricing for profit.
What is overstock?
More stock than you can sell in a season. It ties up cash and risks tarnish. The cure is small test buys and reordering on data. Overstock is the most common inventory mistake.
How do I organize a stockroom?
Group by category, then by SKU code. Label shelves. Keep best sellers easy to reach. A disorganized stockroom wastes packing time and causes errors. Spend an hour organizing; it pays back weekly.
How do I handle inventory across two sales channels?
Sync stock in real time so a sale on one channel updates the other. Overselling across channels is a fast way to lose trust. Use a tool that syncs your website and marketplace automatically.
What is the cost of carrying too much inventory?
Cash tied up, tarnish risk, and storage. A piece that sits for a year also goes out of style. The real cost is the opportunity: that cash could have bought winners. Buy small, test, reorder.
How do I decide what to reorder?
Reorder pieces with strong sell-through and good reviews. Do not reorder pieces that sell slowly, no matter how much you like them. Let the data pick the reorder list.
Should I count inventory myself or hire help?
Cycle count yourself while small. Once you have staff, train one person to count and another to verify. Segregation prevents errors and theft. At small scale, your own weekly count is enough.
What is the simplest inventory system?
A spreadsheet with columns for SKU, name, size, quantity, reorder point, and last sold date. Update it with every sale. When it outgrows the spreadsheet, move to an app. Do not overbuy software early.
Your Weekly Inventory Ritual
Spend twenty minutes every Monday. Pull last week's sales by SKU. Note any piece below its reorder point and place the order. Count a small section of stock. Check for tarnish on stored pieces. This weekly habit prevents stockouts and surprises. For purchase orders, pair with shipping wholesale jewelry.
- Review weekly sales by SKU.
- Reorder pieces below reorder point.
- Cycle count one section.
- Check stored stock for tarnish.
- Mark down pieces over 45 days slow.
Final Thought on Inventory
Inventory is the quiet engine of a jewelry business. The store that turns stock fast stays liquid and can buy what sells. The store that ties cash in slow pieces cannot reorder winners or run ads. Track sell-through, reorder on data, cut slow stock early, and protect against tarnish. Done weekly, it is not exciting, but it keeps the doors open. For the margin side, read pricing for maximum profit.
- One SKU code per piece per size.
- Track sell-through and turnover monthly.
- Reorder on a formula, not a gut.
- Mark down slow stock at 45 days.
- Cycle count weekly, not annually.
Related Articles
- Social Media Marketing for Silver Jewelry Business - HOLYCOME
- Customer Retention: Turning One-Time Buyers into Loyal Customers
The 92.5% silver composition and properties of sterling silver are described in the Wikipedia entry on sterling silver.
Frequently Asked Questions
How do I prevent tarnish in storage?
Anti-tarnish bags with a sulfur absorber, humidity under 60% and no paper wrap. Rhodium plating adds a further barrier.
Is rhodium plating worth it?
Yes for display and gift lines: it holds colour 12 to 18 months and cuts markdowns.
What purity do you supply?
925 sterling, stamped and hallmarked; fine silver available for beads.
What is the MOQ and lead time?
50 pieces per design, samples 3 to 5 days, bulk 15 to 20 days.
