Too little jewellery stock loses sales and makes a successful campaign feel like a problem. Too much stock turns cash into trays, boxes and components that may sit untouched for months. The right answer is not one universal quantity. It is a stock system that protects proven demand, limits speculative buying and gives every product a clear reason for the cash it uses.
Stock is not potential profit sitting on a shelf. It is cash that has accepted a job, and that job should be visible.
There is no magic jewellery stock number
A business selling repeatable chains from a reliable UK supplier needs a different stock position from one buying one-off stones, producing personalised pieces or importing finished jewellery on a twelve-week lead time. Order frequency, supplier reliability, production capacity, product value, seasonality and the cost of a stockout all change the answer.
Start with the decision each product requires. Some pieces need enough finished stock to dispatch immediately. Some need only shared components. Some can be made after the order. Limited and one-of-a-kind pieces are the stock by definition. Treating every SKU in the same way creates either unnecessary risk or unnecessary cash pressure.
Use a rolling plan rather than one annual stock guess. The aim is to know what is available, what is committed, what is on order, how quickly it sells and when a decision must be made.
- Finished stock ready to sell
- Work in progress already committed to production
- Components that can serve several products
- Supplier orders placed but not yet received
- Customer orders already allocated against stock
- Packaging and consumables needed to fulfil the pieces
Measure the cash in stock, not the dream retail value
A tray with a potential retail value of £20,000 does not mean the business has created £20,000 of useful inventory. Record stock at its cost to the business and separately record the sales value. Cost shows how much cash is tied up. Retail value shows what the stock might generate if it sells at the planned price.
Include the costs required to bring an item into saleable condition. Depending on the business, that can include bought-in product, metal, stones, findings, direct production cost, hallmarking, duties and inbound freight. Keep the method consistent and confirm the accounting treatment with the business's accountant.
HMRC's Business Income Manual states that the modern rule for trading stock is the lower of cost and net realisable value. That becomes relevant when damaged, outdated or slow stock can no longer reasonably be expected to achieve its original value. Stock records should reflect commercial reality, not preserve a number because it feels more encouraging.
Give every jewellery product an inventory role
Stock decisions become clearer when the range is divided by commercial role. A proven bestseller deserves stronger availability than an untested colourway. A hero piece may justify a small display quantity because it attracts customers even if it sells less often. A component shared across ten products can deserve more protection than a finished piece that serves only one page.
Review roles at product and variant level. A necklace may be a bestseller overall while one metal colour or chain length barely moves. Ordering the product total without inspecting the variants hides the cash problem.
| Role | Purpose | Stock approach |
|---|---|---|
| Core bestseller | Dependable revenue and demand | Protect availability and reorder early |
| Hero product | Express the brand and attract attention | Hold enough to show and fulfil realistic demand |
| Entry product | Create an accessible first purchase | Keep margin and replenishment under close review |
| Extension | Increase basket value or repeat purchase | Stock in proportion to the core piece it supports |
| Seasonal or occasion-led | Serve a defined demand window | Buy in phases with a clear final reorder date |
| Experimental | Test a new idea | Cap the first quantity and set a review date |
| One of a kind | Sell the exact available piece | Track individually and remove immediately after sale |
| Long tail | Add breadth for limited demand | Use made to order, low depth or retirement rules |
Choose the right stock model for each product family
Ready-to-ship stock supports fast dispatch and can improve conversion when timing matters, but it commits cash before demand is known. Made-to-order reduces finished-stock exposure, but it moves risk into components, labour capacity and lead-time promises. A hybrid model often gives a small jewellery business the best balance.
For a hybrid range, keep proven core pieces or standard components ready, then complete less predictable options after purchase. Shared chains, fittings, packaging and repeatable bases can support several products without committing the business to every finished variation.
Make the model clear on the product page. A customer should know whether the piece is ready to dispatch, made after ordering, personalised or one of a kind. Do not display one generic delivery estimate across products with different production paths.
| Model | Main advantage | Main risk | Best suited to |
|---|---|---|---|
| Ready to ship | Fast fulfilment and certainty | Cash committed before sale | Proven, repeatable demand |
| Made to order | Low finished-stock exposure | Capacity and lead-time pressure | Variable or lower-frequency pieces |
| Component led | Shared stock supports several products | Component records can become complex | Modular ranges and personalisation |
| Pre-order | Demand is visible before full production | Customer trust depends on clear timing | Defined launches and genuine production windows |
| One of a kind | No variant forecasting | Every listing needs exact stock control | Unique stones and singular pieces |
Create one reliable jewellery inventory record
Inventory cannot be managed if one piece has different names in the supplier invoice, bench notes, website and accounting system. Give every stock item and component a stable SKU or reference. Variants need their own identity when their cost, stock or reorder decision differs.
Use one source of truth for the current quantity and make every stock movement traceable. Record purchases, production, sales, returns, repairs, samples, damage, personal use and stock transferred to events or stockists. Unexplained adjustments are a warning that the process is no longer reliable.
A spreadsheet can work at modest volume if it has a clear owner and disciplined updates. Software becomes useful when the business needs live stock across several channels, locations, components or team members. The deciding factor is control, not the appearance of sophistication.
- SKU and plain-language item name
- Finished product, component, packaging or work-in-progress type
- Supplier and current lead time
- Unit cost and minimum order quantity
- Quantity on hand, allocated and available
- Quantity already on purchase order
- Reorder point and normal reorder quantity
- Last count, last sale and next review date
Use sell-through to see whether stock is doing its job
Sell-through rate shows how much of the available quantity sold during a period. A simple version is units sold divided by units sold plus ending stock. Use the same time window when comparing products and remember that a newly launched piece has had less opportunity to sell than an established one.
Shopify's inventory reporting uses that calculation for its product sell-through report and also shows starting quantity, ending quantity, quantity sold and inventory cost value. Shopify notes that its most recent sell-through period can have roughly a two-day processing delay, so use the dates displayed in the report rather than assuming it includes today.
A low sell-through rate is a question, not an automatic markdown. The product may have weak demand, poor visibility, the wrong price, incomplete photography, a hidden stock variant or a launch that never reached the right audience. Diagnose the cause before reducing the price.
| Measure | Example | Meaning |
|---|---|---|
| Units sold in 90 days | 8 | Customer demand during the period |
| Units left at period end | 12 | Stock still carrying cash and storage cost |
| Sell-through | 8 ÷ (8 + 12) = 40% | Two fifths of the available quantity sold |
| Next question | Compare margin, age and lead time | Rate alone does not decide the action |
Calculate how many days or weeks of jewellery stock remain
Stock cover translates quantity into time. Divide available units by the average units sold per day or week. Ten necklaces in stock may be far too many if one sells each quarter, or dangerously few if four sell every week.
Shopify defines days of inventory remaining as ending inventory units divided by inventory units sold per day. It is a forecast based on the recent sales rate, not a promise. A campaign, press mention, seasonal peak or stockout in the comparison period can make the result misleading.
Use a period long enough to represent the product, then overlay known events. For seasonal jewellery, compare with the same period last year where the product and marketing were similar. For a new product, use a cautious test quantity and learn rather than disguising a guess as a forecast.
Set a jewellery reorder point that includes uncertainty
A reorder point is the stock level that triggers the next purchase or production run. At minimum, it must cover expected demand during the supplier or production lead time. Add safety stock only where a stockout would matter and demand or delivery is genuinely uncertain.
A practical formula is: average demand during lead time plus safety stock. If a bracelet sells two units a week, replenishment takes four weeks and the business wants two weeks of protection, the reorder point is twelve units: eight for normal lead-time demand plus four as safety stock.
Do not add the same safety-stock percentage to everything. Give more protection to profitable proven products with unreliable supply or important gifting deadlines. Keep less protection for expensive experiments, easily substituted pieces or products that can be made quickly.
| Input | Example | Calculation |
|---|---|---|
| Average weekly sales | 2 bracelets | Use a representative period |
| Lead time | 4 weeks | Confirm the real door-to-door time |
| Lead-time demand | 8 bracelets | 2 × 4 |
| Safety stock | 4 bracelets | Two extra weeks of normal demand |
| Reorder point | 12 bracelets | 8 + 4 |
Measure the real lead time, not the supplier's best estimate
Lead time begins when the business can place the order and ends when the stock is checked and available to sell. Include internal approval, supplier processing, production, hallmarking where relevant, freight, customs, receiving and quality control. A quoted four-week production time may become a seven-week replenishment cycle.
Record promised and actual arrival dates for each order. The difference reveals which suppliers, materials or periods need more safety stock. It also prevents the business from repeatedly planning around a best case that rarely occurs.
Minimum order quantities and price breaks should not overrule demand. A cheaper unit is not cheaper if most of the extra quantity remains unsold. Compare the cash saved per unit with the cash committed, storage required and risk of the style changing.
Plan shared jewellery components separately from finished products
Component-led ranges need two views: what customers can buy and what the workshop needs to complete it. One chain, clasp, stone size or base casting may support several SKUs. That flexibility reduces finished-stock risk, but a missing shared component can stop many products at once.
Create a simple bill of materials for repeatable products. State the quantity of every controlled component used, expected wastage and any acceptable substitution. When a product sells, the system or production process should reduce the correct component quantities as well as the finished piece.
Prioritise components by the number and value of products they enable. A low-cost finding that stops ten bestsellers may deserve a higher safety level than an expensive decorative component used by one slow piece.
Build Christmas and gifting stock in decision stages
Seasonal demand creates pressure to commit early, but one large speculative order transfers every risk to the business. Divide the plan into opening stock, scheduled replenishment and a final buy date. Place the first commitment against evidence, then release later quantities when sales, traffic and campaign response justify them.
Work backwards from the last useful selling date. Add supplier lead time, receiving, quality checks, photography or listing work and the delivery promise to customers. Stock arriving after the main gifting window is not late Christmas stock. It is January stock with a Christmas forecast attached to it.
Protect the narrowest constraints as well as the products. Packaging, popular chain lengths, personalisation capacity and dispatch labour may limit sales before the jewellery itself runs out.
Give slow and dead jewellery stock a decision date
Stock becomes dangerous when the business stops looking at it. Define ageing bands that suit the range, such as no sale in 90 days, 180 days or 365 days. Review cost value, last sale, product role, page traffic, margin and whether the components can be reused.
The first response does not need to be a sale. Improve the listing if demand exists but the presentation is weak. Rephotograph it, clarify scale, link it from the right collection, style it with a bestseller or use it for an appropriate gifting edit. If customers see the piece and repeatedly choose something else, accept the evidence.
Choose an exit deliberately: return to supplier where permitted, rework components, sell through a suitable event or channel, bundle without hiding the economics, use as an approved sample, donate where appropriate or markdown with a firm end point. Record the loss honestly and change the buying rule that created it.
- No sale or meaningful enquiry within the review window
- Low product-page views caused by weak visibility
- Healthy views but poor add-to-basket or conversion
- Returns or service issues that make selling it risky
- Materials or components that can be recovered
- A repeat buying habit that needs a new approval rule
Use ABC analysis without abandoning the brand
ABC analysis ranks products by their contribution to revenue. Shopify describes A-grade products as the products responsible for the largest share, with C-grade products contributing much less. This helps identify where a stockout may lose meaningful sales and where overbuying adds unnecessary carrying cost.
Revenue is not the only measure a jewellery business needs. Add contribution margin, production time, return rate, strategic role and component risk. A hero piece may deserve to remain visible even if it is not an A-grade seller. A high-revenue product with poor margin or frequent repairs may be less valuable than the ranking suggests.
Use the analysis to change attention, not to automate every decision. Protect proven profitable winners, investigate the middle and place a cap or exit rule around weak stock. Keep creative experiments, but fund them intentionally.
Run a jewellery stocktake that finds the process problem
A stocktake is not only an accounting exercise. It tests whether the recorded business and the physical business match. Count by SKU and location, separate customer-owned items and repairs, identify damaged stock, and reconcile differences before changing the system quantity.
Use cycle counts between full stocktakes. Count high-value, fast-moving and error-prone items more often. If the same item is repeatedly wrong, look for the source: unrecorded samples, incorrect units, returns placed back without inspection, event stock, production wastage or duplicate variants.
Keep valuable items secure during the count and use a second check for material differences. The objective is not to force the physical number to match the spreadsheet. It is to understand why it did not.
- Freeze or carefully record movements while counting
- Count physical stock before looking at the expected number
- Separate saleable, damaged, repair and customer-owned items
- Reconcile material differences with a reason code
- Update costs, suppliers and lead times while the data is open
- Assign the process change revealed by each recurring variance
Use a small jewellery inventory dashboard
A useful dashboard should lead to a buying, production, merchandising or exit decision. Review the same measures on a regular date and compare them with cash commitments already placed. An inventory report viewed without purchase orders can make stock appear safer than it is.
Keep the view small enough to use. The business needs exceptions and actions, not a wall of numbers. Review by product family and variant so a successful total does not hide slow colours, sizes or finishes.
| Measure | Question | Action signal |
|---|---|---|
| Inventory cost value | How much cash is tied up? | Value rising faster than profitable sales |
| Sell-through | What proportion is selling? | Weak rate after a fair selling period |
| Weeks of cover | How long will stock last? | Below lead time or far above expected demand |
| Stockout days | Where could demand not convert? | Repeated gaps in proven profitable products |
| Aged stock value | What has stopped moving? | Items crossing the agreed review date |
| Open purchase orders | What cash and quantity are already committed? | Future stock exceeds the revised forecast |
| Inventory variance | Can the records be trusted? | Repeated unexplained count differences |
A 90-day jewellery inventory plan
Do not try to forecast every SKU perfectly. Make the cash visible, protect the products that already earn their place and put boundaries around the uncertain ones. The first 90 days should create better decisions, not more administration.
| Phase | Focus | Outputs |
|---|---|---|
| Days 1 to 30 | Count and classify | Reliable quantities, unit costs, product roles, supplier lead times and aged-stock list |
| Days 31 to 60 | Set rules | Reorder points, safety stock, test-buy caps, component priorities and seasonal final-buy dates |
| Days 61 to 90 | Act and review | Purchase plan, slow-stock decisions, cycle-count rhythm and monthly inventory dashboard |
Jewellery business consultant · Devon, UK · Clients worldwide