How-to

🔢 Variants & inventory basics

Variants and inventory are where messy stores lose money. Set up options cleanly, track stock honestly, and avoid overselling and dead stock.

🎯 Why it matters

Variants (size, color) and inventory tracking seem mundane but quietly cause lost sales: overselling erodes trust, out-of-stocks lose orders, and dead stock ties up cash. Clean setup and simple stock discipline prevent all three. AI structures your variants and a reorder rule from your data; you keep the counts honest.

💬 My take

Variants & inventory basics

Messy variants and sloppy stock counts quietly bleed money. Overselling burns trust, stockouts lose orders, and dead stock traps cash.

Clean setup plus a simple reorder rule prevents all three. AI can structure your variants and compute a reorder point from your sales rate. You keep the physical counts honest, because only real stock data prevents overselling.

Fastest path: one prompt, end to end

🤖 AI prompt — paste into ChatGPT / Claude

You are an inventory-ops advisor for a DTC store on Shopify.
Product: [one line]  Options: [e.g. size S-XL, 3 colors]
Sales rate: [units/week if known]  Supplier lead time: [days]  Current stock: [units]

Do this using MY numbers only (invent no sales or lead-time figures):
1. Recommend a clean variant structure (option names/values, SKU naming convention) for Shopify.
2. Compute a reorder point: (weekly sales x lead-time weeks) + a small safety buffer. Show the math; if I didn't give sales/lead time, tell me to supply them.
3. Give rules to avoid overselling (track inventory, continue-selling settings) and to spot dead stock (a slow-mover flag).
4. Flag the most common variant/inventory mistake for a store like mine.
Output: variant structure + reorder-point math + overselling/dead-stock rules.

Or do it in 4 steps

Structure variants cleanly. Use consistent option names and values (Size: S/M/L, not "small"/"Med"/"lg") and a readable SKU convention (PRODUCT-COLOR-SIZE). Messy variants break filtering, reporting, and feeds downstream.
Track inventory and turn off "continue selling when out of stock" unless you truly can backorder. Overselling and then cancelling is one of the fastest ways to lose a new customer's trust.
Set a reorder point per variant. Reorder point = (weekly sales × lead-time in weeks) + safety buffer. When stock hits it, reorder. This prevents both stockouts and panic-ordering.
Watch for dead stock. Flag variants that haven't sold in 60-90 days, they tie up cash and shelf space. Discount, bundle, or discontinue them rather than reordering blindly.

Worked example (labeled): a variant sells 10/week, supplier lead time is 3 weeks, safety buffer 10 units. Reorder point = (10 × 3) + 10 = 40 units.

When stock drops to 40, reorder, so you don't run out during the 3-week wait. Compute this per variant from your real sales rate.

Review reorder points and dead-stock flags monthly as sales rates shift.

⚖️ Do & Don't

Do

Structure variants with consistent option names and values (Size: S/M/L) and a readable SKU convention (PRODUCT-COLOR-SIZE).
Track inventory and turn off 'continue selling when out of stock' unless you can truly backorder.
Set a reorder point per variant: (weekly sales x lead-time weeks) + a safety buffer.
Flag variants that haven't sold in 60-90 days and clear them rather than reordering blindly.

Avoid

Don't mix inconsistent option values like 'small'/'Med'/'lg'; it breaks filtering, reporting, and feeds.
Don't oversell and then cancel; it's one of the fastest ways to lose a new customer's trust.
Don't panic-order or run out during lead time; the reorder point exists to prevent both.
Don't reorder a slow mover on autopilot; a dead variant ties up cash and shelf space.

💡 Quick tips

Give the AI your sales rate and supplier lead time and let it compute the reorder point and show the math.
Review reorder points and dead-stock flags monthly, since sales rates shift.
Keep the variant matrix only as wide as sells; every extra option is another unit to forecast and stock.

🏢 Brand in focus

Brand

Allbirds — launched with a deliberately tiny SKU lineup

Allbirds.com · Allbirds fits because it launched with a deliberately narrow lineup, essentially one wool shoe in a few colorways, which kept its variant matrix and inventory simple enough to forecast and restock accurately in the early days. The lesson for a small seller is that fewer, cleaner variants mean fewer stockouts, less dead stock, and reports you can trust. Watch-out: Allbirds later expanded and ran into its own inventory and markdown problems as the catalog grew, which is exactly the reminder that every extra variant is another unit to forecast and stock.

📚 Go deeper — resources

article

Shopify Help: manage variants and inventory tracking

tool

Google Sheets (per-variant reorder-point calculator)

article

Shopify blog: inventory management basics

🏷️ Tags

store-productvariantsinventoryboth

🔗 Related