GuideCoffee

One Coffee in Several Shopify Products: Shared Stock

Count the coffee once, however many products sell it. Keep the roasted weight as one amount and link every variant that ships that coffee to it: the 12 oz retail bag, the 12 oz in your subscription product, the 5 lb wholesale bag. A 5 lb wholesale order then takes 2,268 g, and the retail and subscription bags drop with it.

Updated November 8, 20264 min readBy Carboy

A roaster rarely lists a coffee once. Ethiopia Guji has its own product page, it is one of the choices in the Coffee Subscription product, and wholesale customers order it from a separate 5 lb listing. That is three products and three sets of stock numbers in Shopify, and every one of them ships beans from the same roast.

Shopify keeps each variant's count on its own. A sale on the wholesale listing doesn't touch the retail bag or the subscription, so each listing believes it has the whole roast.

Where it goes wrong

Take a 10 lb roast, 4,536 g, with 100 g held back for cupping. That leaves 4,436 g to sell. Linked to one amount, the listings look like this before and after a single 5 lb wholesale order:

ListingVariantBagFrom 4,436 gAfter one 5 lb order (2,168 g)
Ethiopia Guji12 oz / Whole Bean340.2 g136
Ethiopia Guji2 lb / Whole Bean907.2 g42
Coffee SubscriptionEthiopia Guji / 12 oz340.2 g136
Wholesale Ethiopia Guji5 lb2,268 g10

Without the link, the retail page and the subscription each keep showing 13 bags of 12 oz after the wholesale order. Sold through, that is 26 bags, 8,845 g of coffee from a roast that has 2,168 g left.

Each number is sellable = (roasted weight left − reserve) ÷ bag weight, rounded down. The 12 oz bag on the retail page and the 12 oz in the subscription can both show 13: either one could fill 13 bags. What matters is that a sale on one lowers the other straight away.

One pool per coffee, not per product

Group by what is in the bag. Every variant that ships Ethiopia Guji, on any product, takes from the Ethiopia Guji amount. A Coffee Subscription product with two coffees and two sizes has four variants: the two Ethiopia Guji variants go with the Ethiopia Guji roast, the two Colombia Huila variants with the Colombia Huila roast.

Some listings need no linking at all. If subscriptions are sold as a purchase option on the retail product, the way Shopify's own Subscriptions app does it, the subscriber buys the same variant as everyone else. Shopify's B2B catalogs set wholesale prices on the same products, so a wholesale buyer orders the same variant too. Only a separate product needs its variants linked.

Roaster's choice and rotating coffees

A Roaster's Choice variant ships whatever is on rotation this month, so it can't belong to one coffee for good. When the rotation changes, move it: take it out of last month's coffee and add it to this month's. Orders already placed stay counted where they were.

Tasting boxes that mix coffees

A box of three 4 oz bags from three coffees takes from three roasts, and a variant can only draw from one. Pack boxes in batches and take each coffee's share out of its own amount when you pack them, or keep boxes in a bundle app, the job those apps are built for. Carboy vs bundle, BOM and shared inventory apps goes through where each fits.

Setting it up in Carboy

  1. Make a pool for the coffee from its retail product. Set up many does this for every coffee at once when the bag sizes are in the variant names.
  2. Enter the roasted weight on hand and a reserve for cupping, 100 to 200 g is a reasonable start.
  3. Open the pool and choose Add sizes from another product. Pick the Coffee Subscription product and tick only the variants that ship this coffee. Do the same for the wholesale listing.
  4. Check each size. Carboy reads 12 oz or 5 lb from the variant name. A variant called Ethiopia Guji with no size in it needs the bag weight typed once, 12 oz or 340.2 g.

A variant belongs to one pool at a time, and Carboy marks variants that are already in a pool when you pick a product. Ounces and pounds are converted inside the pool, so a 12 oz retail bag and a 5 lb wholesale bag take the right grams from the same roast.

What to check after setup

  • Every listing moves. Sell a 12 oz on the retail page and check that the subscription's 12 oz and the wholesale 5 lb drop too.
  • Wholesale weight. An order for one 5 lb bag should take 2,268 g.
  • Renewals. Subscription renewals arrive in Shopify as orders. Let a renewal come in and check that it took from the right coffee.
  • Rotation day. After moving the Roaster's Choice variant, sell one and check which coffee it took from.

For bag sizes and grinds within one product, read Coffee inventory on Shopify: bag sizes and grinds. See Carboy for coffee roasters for the whole setup.

Put one coffee and every listing that ships it in one pool. Your first three pools are free, with every feature.