Crystal Shop Inventory: Records, Receiving and Reorder Points

Crystal shop inventory is cash sitting on a shelf, in a heavier and dustier form than the money in your bank account. Lose track of the count, the cost or the condition and you start losing money without seeing it. The rule holds at forty pieces and at forty thousand: if you cannot track it, you cannot sell it profitably.

We have written before about the number one inventory mistake crystal shops make. This guide takes a different angle: the records, the receiving routine, the reorder points and the one number most sellers never calculate. It follows the inventory chapter of Arthur Narin's book How to Start a Crystal Business, and it is part of our guide to starting a crystal business.

What a crystal shop inventory record needs

A consistent spreadsheet beats expensive software nobody keeps up to date, as long as every movement changes the record. At minimum, each line holds:

• SKU: an internal code you can read and type without mistakes.
• Description: mineral, format, size and grade.
• Supplier or batch, so you can trace cost and quality back to a shipment.
• Landed cost, price, quantity and location.
• Status.

Status is the column beginners leave out, and it is the one that stops you selling stock you do not have. Useful statuses are available, reserved, damaged, returned and waiting for inspection, and in transit. Only "available" is ready to sell.

Repeatable products get one SKU per meaningful difference: mineral, format, size, grade or design. A one-of-a-kind specimen needs its own reference. A price sticker cannot tell you which piece, at which cost, left the table.

Receiving: where accuracy starts

Most inventory errors are born at the receiving table. A five-step routine taped above wherever you open boxes prevents most of them.

1. Check the shipment against the purchase order and the invoice.
2. Count it, and inspect for damage and for differences from what you agreed.
3. Photograph problems before you unpack further, outer box and packing included.
4. Record unsellable pieces as damaged before anything goes in as available.
5. Enter the landed cost and the location, then put the stock away in a labelled place.

Step five depends on knowing your real cost per stone, freight and duty included. Our guide to crystal landed cost per stone shows how to work it out. If a shipment is not received properly, every number after it is wrong.

One picture across every location

Stock at home, at a market, in a shop or on consignment belongs in one inventory picture. Three movements change it, and each should change the record:

• A transfer changes location. Moving thirty pieces from the house to the market table is not a sale.
• A sale changes ownership and quantity.
• Damage changes availability and value.

If you consign stock to a partner, reconcile against their statements regularly. Ten pieces in and three sold means your record accounts for seven pieces, any returns, and the payment due.

Five stages, and when to climb

Stage one: just starting. A single shelf, weekend markets, a little online. A simple sheet with item, quantity, landed cost and price is enough. Coloured dots for price brackets let you price a tray in minutes. The highest-value habit is nearly free: count before and after every market. Eighty-five tumbles out, forty-seven back, compared with what you rang up, tells you what sold and what walked off the table.

Stage two: growing. Two or three locations. One workbook with a tab or column per location, every restock recorded as a transfer, and a monthly count of each location. Check counts the morning after a busy market, not at eleven at night.

Stage three: early storefront. A point of sale with inventory. Give each price tier of each tumbled stone one item code, because you cannot give every tumble its own record. Count your top twenty sellers weekly and the whole store each quarter. Keep a damage log and a seconds box, which make invisible losses visible.

Stage four: online and in store together. Now you can sell the same unique piece twice. Either test that your platform and point of sale really share one inventory across every channel, or allocate one-of-a-kind pieces to one channel, with a labelled "online orders" bin.

Stage five: full control. Several staff, a wholesale channel, barcodes on arrival, written procedures, and counts tiered by value and speed.

Climb when the current system is outgrown, not because a dashboard looks impressive. Good triggers: you pass roughly two hundred active units, a second person starts handling stock, you oversell once, or your counts stop matching and you cannot explain why. When a count differs from the record, investigate before you adjust. Write the cause beside every adjustment, or the same gap returns next month.

Reorder points for crystal shop inventory

For repeatable products, set a reorder point: the stock level at which you place the next order.

Reorder point = average weekly demand × lead time in weeks + safety stock.

Say you sell four of a particular amethyst point a week, your supplier takes three weeks, and you want four extra for a strong week or a late delivery. Four times three, plus four, is sixteen. When stock drops to sixteen, you order. For something faster, like amethyst tumbles selling fifteen a week with a two-week lead time and ten in reserve, the reorder point is forty. Give imported goods their full lead time, customs clearance included.

Fast, repeatable lines are where reorder points earn their keep. That usually means bulk tumbled stones and steady sellers like wholesale amethyst, not one-off specimens.

Review ageing stock before you reorder anything. A high margin on a product that rarely sells is worth less than a moderate margin on one that sells every week. Before buying more of a slow line, try better placement, clearer information, a bundle or a genuine markdown.

When cash is tight, which in an inventory business is often, reorder the top fifth of your sellers first and let slow stones run down. A long wall of bracelets looks wonderful, but a small share of the stones usually does most of the selling. Breadth makes a display inviting. It just should not get first call on the money.

The one number most sellers never calculate

Inventory turn = annual cost of goods sold ÷ average inventory at cost.

If the stock you sold over a year cost you three times what you held on the shelves on average, you turned your inventory three times. That number says more about a crystal business than revenue does. A shop with high sales and a turn of one is sitting on a stockroom full of money it cannot use. Rocks are patient. Your landlord is not.

A good turn depends on your mix. Tumbles and kits can turn many times a year. Large specimens and one-of-a-kind pieces may turn once or less, which can be fine if their margin pays for the wait. As an example target, a small shop selling mostly repeatable stock might aim for four or better. Set yours from your own margins and cash needs, and measure by category, because a healthy average can hide a slow corner.

When turn drops, the usual cause is breadth bought where depth was needed. A narrow, deep first order, like the one in our guide to the crystal shop opening order, is the easiest way to start with a healthy turn.

Start this week with three small jobs. Add a status column to your stock list. Write reorder points for your top three repeatable products. Then calculate your turn, overall and for your slowest category. If you cannot calculate it yet, that is the first thing to fix.

Frequently asked questions

How often should a crystal shop count its inventory?

At the start, count before and after every market. As you grow, count each location monthly, your top sellers weekly and the whole store each quarter. Do a full count when your accountant needs one for year end.

Should every tumbled stone have its own SKU?

No. Give each stone and price tier one item code, because tumbles are interchangeable. One-of-a-kind specimens are different: each needs its own reference so you know exactly which piece, at which cost, sold.

What is a good inventory turn for a crystal shop?

It depends on your mix. Tumbles and kits can turn many times a year, while large specimens may turn once or less. A small shop selling mostly repeatable stock might aim for four or better, but set your own target from your margins and cash needs.

How do I stop selling the same crystal twice online and in store?

Either test that your shop platform and point of sale share one live inventory across every channel, or allocate each one-of-a-kind piece to a single channel and keep a labelled bin for online orders.

Stock it for your shop

Stonebridge has no minimum order and ships from Kitchener, Ontario. Open a wholesale account or plan your opening order.