GuideCoffee
Coffee Inventory on Shopify: Bag Sizes, Grinds, One Roast
Track each roast as one amount in grams and work out every bag from it: (roasted weight left − reserve) ÷ bag weight, rounded down. 10 lb of roast with 100 g held back is 13 × 12 oz, 4 × 2 lb or 1 × 5 lb. Every grind of a size shares that number, because grinding happens after the order.
A typical roaster's product page has two options: bag size and grind. Three sizes, 12 oz, 2 lb and 5 lb, and four grinds, whole bean, drip, espresso and French press, make 12 variants. Shopify gives each of the 12 its own stock number. All 12 come out of the same roast, and nothing in Shopify knows that.
So the numbers drift. A 5 lb wholesale order empties half the roast, and the 12 oz whole bean still shows the 20 bags you typed in on Monday. Or you split the roast between variants to be safe, and the espresso grind shows sold out while there are kilos in the bin.
One number per roast
The fix is to stop counting bags and count the roast. Keep one amount per coffee, the roasted weight on hand, and work out every variant from it: sellable = (roasted weight left − reserve) ÷ bag weight, rounded down.
| Bag | Weight | From 4,436 g to sell | After two 2 lb bags sell (2,621 g) |
|---|---|---|---|
| 12 oz | 340.2 g | 13 | 7 |
| 2 lb | 907.2 g | 4 | 2 |
| 5 lb | 2,268 g | 1 | 1 |
The numbers above are a 10 lb roast (4,536 g) with 100 g held back. Two 2 lb bags take 1,814 g, and every size changes at once, not only the one that sold.
Grinds share the size's number
Grinding happens after the order, at the bench, so a grind is not stock of its own. The 12 oz whole bean, drip, espresso and French press all draw from the same roast, and each of them can show 13. That is right: any one of them can fill 13 bags. What matters is that a sale of one grind lowers all four, straight away, before the next order comes in.
If you pre-grind and bag ahead of a busy weekend, those bags are finished stock, not roast. Take their weight out of the roast when you bag them, and count the bags themselves until they sell.
Count roasted weight, not green
Coffee loses weight in the roaster, mostly water, and darker roasts lose more. A loss of around 15 to 20 percent is common, so 12 lb of green coffee comes out at roughly 10 lb. Start the count from what you weigh after cooling, never from the green weight on the invoice, or the store sells bags you can't fill.
Weigh each batch as it comes out and add that weight to the coffee's amount. If you roast the same coffee twice a week, each batch is one addition to the same number.
A reserve for cupping and dialing in
Some of every roast never ships: the cupping table, dialing in the grinder after a burr change, sample bags for a café you're pitching. Hold back a fixed amount per coffee so the store doesn't sell the last bag's worth that you'll drink at the bench. 100 to 200 g per batch is a reasonable start. Adjust it from your counts: if every batch of the house blend ends 150 g short, that is its reserve.
Subscriptions and wholesale
Subscription renewals arrive in Shopify as orders, so they take from the roast like any other sale. Plan the roast around them: renewals that land the morning after a roast day are easy, renewals that land before it can push a coffee to zero. Wholesale orders entered as draft orders count once they are completed. A wholesale order agreed outside Shopify doesn't, so take its weight off by hand when you pack it.
Ways to keep the 12 numbers in step
- By hand. After each batch of orders, work out the three sizes from the bin and type them into all 12 variants. Fine for a few coffees and a few orders a day; the store is wrong between updates.
- A spreadsheet. One row per coffee, a column per size,
=INT((B2 - C2) / 340.2)for the 12 oz. Better, but someone copies numbers into Shopify and orders back into the sheet, every day. - Bundles of a hidden unit. A hidden 10 g item with each bag set up as a bundle of it. A 12 oz bag is 340.2 g, which needs a 0.1 g unit, and 12 variants per coffee means 12 bundles to build and keep.
- A pool-based app. The app keeps the roast as one amount and sets all 12 variants after every order, refund and cancellation.
The comparison of all four goes through when each one is fine and where it breaks.
What to test before you trust it
- Every grind moves. Sell a 12 oz drip and check that the 12 oz whole bean and the 2 lb espresso drop too.
- Size × quantity. An order for three 12 oz bags should take 1,020.6 g.
- Refunds. Refund a sealed bag with restock and check that its weight goes back to the roast. Refund an opened bag without restock and check that nothing changes.
- Ounces and pounds. A 2 lb bag should take 907.2 g, not 2 g or 2 oz.
- Overnight orders. Let subscription renewals and late orders come in, and check the counts in the morning.
Where Carboy fits
Carboy keeps each coffee as one pool and sets all its variants in Shopify from it. It reads the bag size from the variant name, so 12 oz / Whole Bean, 2 lb / Espresso and Drip / 12oz all work, and the grind part is ignored. Ounces and pounds are converted inside the pool. One scan of your catalog sets up every coffee at once, and Counted the shelf? sets the roast's amount after you weigh the bin.
Each order, refund and cancellation recounts every variant of that coffee, and a reserve keeps the cupping allowance off the shelf. See Carboy for coffee roasters, and price each bag with the price per gram calculator.
Put your best-selling coffee in one pool. Your first three pools are free, with every feature.