
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 had no system either 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 calculate the quantities that could be manufactured 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 several location types: storage for raw components, picking locations for finished goods ready to ship, and production locations for manufacturing. 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 bills of materials (BOMs). 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:
- Sellable stock multiplied by 3 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
Sellable stock per variant tripled overnight, from 300kg to 1,000kg for each scent. The 4 sites now show fewer stockouts and can capture more sales. Manufacturing orders are triggered automatically by incoming demand instead of manual forecasts. The system is currently being deployed for businesses that both manufacture and sell their products.
See this case explained in a 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
Explore more case studies
How We Built an Omnichannel B2B2C System Connecting Retail Stores to E-Commerce Inventory
E-commerce + retail storesRead storyHome equipment retailHow We Guaranteed Profitability Across 10+ Marketplaces for a Home Equipment Retailer
10+ marketplaces, thousands of SKUsRead storyBedroom products e-commerceHow We Replaced Scissors with Algorithms for a Multi-Country Bedroom Products Seller
5 Shopify sites + 20 marketplaces, FR + ESRead storyGifts & gadgets retailHow a UK Retailer Turned 5 Stores Into Omnichannel Fulfillment Nodes
5 physical stores + Shopify onlineRead storyHunting & outdoor equipmentHow a Hunting Equipment Specialist Sells the Full Warehouse Catalog From Any Store Counter
2 physical locations + online storeRead storyGardening & pet supplies retailHow a Gardening Retailer Got 34% More Clicks Without Raising Ad Spend
25,000+ SKUs, 50+ year-old family businessRead storyOrganic cosmeticsHow Similar Matching Gave an Organic Cosmetics Brand Competitive Visibility for the First Time
5,000+ SKUs, Magento + Google ShoppingRead storyHigh-tech / Consumer electronicsHow AutoPilot AI Focuses Repricing on the Products That Actually Matter
~1,000 SKUs, multiple marketplacesRead storyAutomotive body parts e-commerceHow We Automated Multi-Supplier Cross-Dock for an Auto Parts Distributor with 500K SKUs
200K-500K SKUsRead storyGifts & gadgets retailHow a UK Retailer Escaped Shopify POS and Unified 5 Stores on One Platform
5 physical stores + Shopify onlineRead storyParapharmacy / Health & wellnessHow Inverted Pricing Reports Turned Market Data into Supplier Negotiation Leverage
5,000-6,000 SKUs, Shopify + Google ShoppingRead storyHunting & outdoor equipmentHow a Hunting Equipment Specialist Deploys 5 POS Terminals in Minutes at Trade Shows
2 physical locations + online storeRead storyPharmacy & parapharmacyHow a Pharmacy Brings Three Storage Areas Into One Picking Flow
25,000+ SKUs · ~200 orders/dayRead storyPharmacy & parapharmacyHow an Online Pharmacy Traces Every Parcel in a Batch Recall
~20,000 SKUs · 1 warehouseRead storyFashion & accessories DTCHow a DTC Fashion Brand Re-Internalized Logistics from Their 3PL in 3 Days
2,000+ orders/monthRead storyPharmacy & parapharmacyHow a Pharmacy Runs Its Own Courier Delivery Rounds
Two delivery rounds a dayRead storyLifestyle & seasonal goodsHow a Lifestyle Retailer Eliminated Stockouts with Intelligent Replenishment Forecasting
12,000+ SKUsRead storyThird-party logistics (3PL)How We Built Error-Proof Warehouse Workflows for a Lyon-Based 3PL
Local e-commerce clientsRead storyE-commerce (multi-industry)How 50% of Our Clients Automate Cross-Dock and Dropship Supplier Fulfillment
50%+ of myFulfillment clientsRead 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 storyMotorcycle parts & accessoriesHow AI Matching Achieved 99% Accuracy on 200,000 Complex Motorcycle Parts
200,000+ SKUs, PrestaShop + Google ShoppingRead storyHealth supplements & cosmeticsHow a Health & Wellness Retailer Achieved 100% Lot Traceability with FIFO Enforcement
800+ SKUs with expiry datesRead storyHome & garden e-commerceHow a Multi-Channel Retailer Replaced Excel Chaos with One-Screen Order Management
5 sales channelsRead 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-minute call · No commitment