A local-first Python tool that solves the bundled kit inventory dilemma. It reads your component stock levels and kit recipe formulas (e.g. 1 Gift Box = 2 Soaps + 1 Towel + 1 Candle), calculates the exact limiting component, applies safety buffer reserves, and outputs true sellable bundle quantities to prevent overselling.
Component inventory CSV (stock on hand) and Kit Recipes CSV (bill of materials).
Local Python script divides component stock by required quantities, identifies the bottleneck item, and subtracts safety buffers.
kit_stock_summary.csv (sellable kit inventory) and component_depletion_report.csv.
Setup scope covers installation on customer-controlled infrastructure, configuration of authorised integrations, functional testing and handover.
Hosting, third-party charges and ongoing support are excluded unless separately agreed. Free workflows must never run on Sanocea-hosted infrastructure.
Selling bundles, gift hampers, or multi-packs requires constant mental math. If you run out of just one component, your bundle listing remains live and customers buy unfulfillable kits.
Overselling bundled kits leads to expensive split shipments, cancelled orders, and unhappy customers expecting complete gift boxes.
Divides your raw component stock by kit recipe requirements, identifies the single bottleneck item, applies safety buffers, and outputs the exact number of complete kits you can sell.
You update bundle quantities accurately and confidently across channels, eliminating overselling without manual calculations.
Shows how the calculator finds the bottleneck component and calculates sellable kit stock.
Components:
SKU-SOAP: 50 in stock (Recipe needs 2)
SKU-TOWEL: 18 in stock (Recipe needs 1)
SKU-CANDLE: 30 in stock (Recipe needs 1)Notice: 50 soaps allow 25 kits, 30 candles allow 30 kits, but 18 towels only allow 18 kits.
kit_sku,max_buildable_kits,safety_buffer,sellable_inventory,bottleneck_component,bottleneck_stock
KIT-SPA-GIFT-BOX,18,2,16,SKU-TOWEL,18Correctly identifies towels as the limiting bottleneck. With a safety buffer of 2, reports 16 sellable kits.
Technical Setup Guidance:
Every deliverable is clean, self-contained, and ready for immediate deployment. You receive the complete files, configuration templates, setup guides, and automated tests.
| File Name | Deliverable Description |
|---|---|
bundle_calculator.py | Core bundled kit stock calculation and BOM inventory engine |
run.sh | Execution wrapper script |
requirements.txt | Test execution requirements (standard library only for runtime) |
README.md | Operational usage guide & schema specifications |
SETUP.md | Step‑by‑step local setup instructions & import guides |
COSTS.md | Zero recurring cost declaration |
LICENSING.md | Sanocea Commercial License |
tests/test_bundle_calculator.py | Pytest suite covering BOM math, bottlenecks, and buffer rules |
data/component_inventory_sample.csv | Sample component SKU inventory dataset |
data/bom_recipes_sample.csv | Sample Bill of Materials kit composition recipe dataset |
For technical teams or developers assisting your business, below is the visual execution architecture and automated verification breakdown:
The script evaluates component inventory and Bill of Materials (BOM) CSVs, applies integer division constraints, identifies limiting bottleneck components, enforces safety stock buffers, and exports store-ready CSV inventory feeds. Zero external network calls are made.
Computes exact kit build capacity using minimum floor division across all component recipe constraints
Pinpoints the exact raw SKU limiting each bundle and reports remaining on-hand stock
Deducts reserve inventory from raw parts prior to bundle calculation to protect against inventory drift
We believe in complete transparency. Review the documented technical boundaries and external service fee breakdown below prior to obtaining the package:
| Component | Estimated Cost | Details & Free Tier Allowances |
|---|---|---|
| Bundled Kit Stock Calculator Toolkit | ₹0 (Free to self-host) | Download full source code and self-host |
| Optional Assisted Setup | ₹500 one-time | Assisted installation, environment setup, and handover |
| Hosting & Third-Party Fees | ₹0 recurring | Standard Python local execution, no third-party APIs needed |
Receive the complete distributable archive containing bundle_calculator.py, step-by-step setup guides, mock fixtures, and automated test suites.
Setup scope covers installation on customer-controlled infrastructure, configuration of authorised integrations, functional testing and handover.
Hosting, third-party charges and ongoing support are excluded unless separately agreed. Free workflows must never run on Sanocea-hosted infrastructure.
It applies mathematical Bill of Materials (BOM) integer division across all required components. For each component, it computes available stock divided by the required units per kit, taking the minimum across all components to ensure bundles cannot oversell.
The bottleneck component is the specific raw SKU that constrains the maximum possible bundle assembly. The engine isolates this component in both bundle_inventory.csv and bundle_bottlenecks.csv so procurement teams know exactly which item requires reordering.
Yes. Most Shopify bundle apps charge $20 to $100+ per month simply to execute basic Bill of Materials division. This tool runs 100% locally on your machine with zero recurring subscription fees.
Yes. Use the --safety-buffer flag (e.g., --safety-buffer 2) to hold back a reserve quantity of each component before calculating kit availability.
How virtual bundles create phantom overselling, why multi-pack math causes fulfillment bottlenecks, and how Bill of Materials algorithms compute sellable stock.
Read Field Guide on Sanocea Insights →A local-first Python tool that prevents inventory overselling and pricing mistakes. It compares your warehouse Google Sheet against your live WooCommerce product export, generating an exact delta preview of which quantities and prices differ—allowing you to audit updates before importing them into your store.
A free, local Python tool that prevents unexpected stockouts on your bestsellers. It scans your inventory spreadsheet, detects items falling below safety reorder points, tracks alert history in a local SQLite database to prevent notification spam, and sends a clean Telegram briefing to your purchasing team.
A local-first Python tool that audits new supplier inventory files against your previous feed. It instantly highlights wholesale price increases (>X%), unexpected stock drops to zero, and new or discontinued SKUs, generating an executive delta report so you can adjust retail prices and reorder with full visibility.
A local-first Python tool that optimizes order fulfillment across multiple fulfillment centers. It matches multi-item customer orders against warehouse inventory balances using configurable strategies (priority, nearest_zone, or no_split), generating exact dispatch manifests, courier shipment routing, and shortage exception logs before you send orders to the warehouse floor.
A free, local Python safety tool that protects your marketplace seller ratings. It scans your product catalog or warehouse feeds, identifies zero-stock and negative-quantity variants, applies configurable safety buffers, and flags unfulfillable items so you can pause listings before marketplace cancellation penalties strike.