
How BOM-Based Stock Calculation Tripled Sellable Inventory for a Candle Manufacturer
Sellable stock per variant
300 kg → 1,000 kg
Manufacturing orders
Manual → Auto-triggered
A manufacturer based in Grasse, France, producing candle-making components -- primarily scented wax. They sell through 4 e-commerce sites, and their products share a common base: roughly 99% base wax with 1% fragrance oil determining the final variant (vanilla, exotic, berry, etc.). The challenge is that the same raw material can become any variant.
The Challenge
Traditional inventory management forced them into an impossible situation. With 1 tonne of base wax in stock, they had to decide in advance how much to allocate to each scent: 300kg for vanilla, 300kg for exotic, 300kg for berry, and 100kg for another variant. If vanilla sold out, they showed "out of stock" on their website even though they had 700kg of wax that could be turned into vanilla within hours. They also had no system for managing manufacturing orders -- tracking when to fabricate, how much raw material to consume, and when to trigger production based on incoming orders.
Top challenges:
- Manually splitting base wax stock across scent variants creating artificial stockouts
- No tool to project fabricable quantities from raw component inventory
- Managing 4 e-commerce sites with shared raw material stock
The Solution
We designed a solution combining standard myFulfillment features with a custom stock calculation engine.
What We Configured
myFulfillment was set up with multiple depot types: storage depots for raw components, picking depots for finished goods ready to ship, and fabrication depots for the manufacturing process. All 4 e-commerce sites were connected with real-time stock synchronization -- when a product sells on one site, stock updates across all four.
What We Custom-Built
A custom tool calculates theoretical sellable quantities based on BOM (Bill of Materials) nomenclatures. Instead of showing only on-hand finished goods, the system considers raw component stock and manufacturing recipes to compute how many units of each variant could be produced. With 1 tonne of base wax, the system now publishes 1,000kg of sellable capacity for vanilla, AND 1,000kg for exotic, AND 1,000kg for berry -- because any of them can be made from the same base. When customer orders arrive, the system either ships from already-manufactured stock or automatically triggers manufacturing orders to produce the needed variant from raw components.
Bill of Materials based virtual stock: the system sells manufactured product capacity from raw components, not just on-hand finished goods. Since 99% of each product is the same base wax, 1 tonne of wax creates 1 tonne of sellable capacity for every scent variant simultaneously.
Key benefits:
- 3x sellable stock per variant by computing capacity from raw materials
- Automatic manufacturing orders triggered by incoming customer demand
- Real-time stock sync across 4 sites reflecting true production capacity
The Results
Sellable stock per variant
300 kg → 1,000 kg
Manufacturing orders
Manual → Auto-triggered
The sellable stock per variant tripled overnight -- from 300kg to 1,000kg for each scent variant. This directly translates to fewer stockouts, more sales, and better customer experience across all 4 sites. Manufacturing orders are now triggered automatically based on incoming demand rather than manual forecasting. The system is currently being deployed and represents a fundamentally new approach to inventory management for manufacturing-retail businesses.
Understand this case in video
Not just for candles
The same BOM-based virtual stock logic applies to any manufacturer where raw materials can become multiple finished products.
- Cosmetics manufacturers with shared base formulas and variant fragrances or colors
- Food producers selling different flavors from common base ingredients
- Chemical companies blending base compounds into multiple product lines
- Any artisan or small-batch manufacturer selling direct-to-consumer online
Check out more
How Similar Matching Gave a Bio Cosmetics Brand Competitive Visibility for the First Time
5,000+ SKUs, Magento + Google ShoppingRead storyMulti-brand retail / e-commerceHow We Built an Omnichannel B2B2C System Connecting Retail Stores to E-Commerce Inventory
E-commerce + retail storesRead storyBedroom products e-commerceHow We Replaced Scissors with Algorithms for a Multi-Country Bedroom Products Seller
5 Shopify sites + 20 marketplaces, FR + ESRead storyFashion & accessories DTCHow a DTC Fashion Brand Re-Internalized Logistics from Their 3PL in 3 Days
2,000+ orders/monthRead storyGifts & gadgets retailHow a UK Retailer Escaped Shopify POS and Unified 5 Stores on One Platform
5 physical stores + Shopify onlineRead storyHigh-tech / Consumer electronicsHow AutoPilot AI Focuses Repricing on the Products That Actually Matter
~1,000 SKUs, multiple marketplacesRead storyHome & garden e-commerceHow a Multi-Channel Retailer Replaced Excel Chaos with One-Screen Order Management
5 sales channelsRead storyMotorcycle parts & accessoriesHow AI Matching Achieved 99% Accuracy on 200,000 Complex Motorcycle Parts
200,000+ SKUs, PrestaShop + Google ShoppingRead storyParapharmacy / Health & wellnessHow Inverted Pricing Reports Turned Market Data into Supplier Negotiation Leverage
5,000-6,000 SKUs, Shopify + Google ShoppingRead storyThird-party logistics (3PL)How We Built Error-Proof Warehouse Workflows for a Lyon-Based 3PL
Local e-commerce clientsRead storyHunting & outdoor equipmentHow a Hunting Equipment Specialist Deploys 5 POS Terminals in Minutes at Trade Shows
2 physical locations + online storeRead storyHealth supplements & cosmeticsHow a Health & Wellness Retailer Achieved 100% Lot Traceability with FIFO Enforcement
800+ SKUs with expiry datesRead storyElectrical equipment (B2C + pros)How We Built a Custom Cable Cutting Workflow for an Electrical Retailer
B2C + professional electriciansRead storyElectronics e-commerceHow an Electronics Distributor Eliminated 90% of Label Errors with Centralized Shipping
3,000+ daily shipmentsRead storyHome & garden equipmentHow a Brittany Retailer Turned Warehouse Walk-Ins Into 25% of Revenue
€3M revenue, 10+ marketplacesRead storyLifestyle & seasonal goodsHow a Lifestyle Retailer Eliminated Stockouts with Intelligent Replenishment Forecasting
12,000+ SKUsRead storyGifts & gadgets retailHow a UK Retailer Turned 5 Stores Into Omnichannel Fulfillment Nodes
5 physical stores + Shopify onlineRead storyAutomotive body parts e-commerceHow We Automated Multi-Supplier Cross-Dock for an Auto Parts Distributor with 500K SKUs
200K-500K SKUsRead storyHunting & outdoor equipmentHow a Hunting Equipment Specialist Sells the Full Warehouse Catalog From Any Store Counter
2 physical locations + online storeRead storyE-commerce (multi-industry)How 50% of Our Clients Automate Cross-Dock and Dropship Supplier Fulfillment
50%+ of myFulfillment clientsRead storyHome equipment retailHow We Guaranteed Profitability Across 10+ Marketplaces for a Home Equipment Retailer
10+ marketplaces, thousands of SKUsRead storyGardening & pet supplies retailHow a Gardening Retailer Got 34% More Clicks Without Raising Ad Spend
25,000+ SKUs, 50+ year-old family businessRead storyReady to see similar results?
Book a demo and we'll show you how we can solve the same challenges for your business.
Free 20-min call · No commitment