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.
Previous supplier CSV feed and new/current supplier CSV feed.
Local Python script matches SKUs, calculates percentage price deltas and stock changes, and filters threshold breaches.
price_stock_deltas.csv (all differences) and critical_alerts.csv (price spikes & stockouts).
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.
Suppliers regularly increase wholesale prices and discontinue SKUs without highlighting changes in their daily email spreadsheets, leaving you selling at thin or negative margins.
Failing to catch wholesale price jumps before receiving orders means selling products at a loss. Missing stockouts leads to unfulfillable customer orders.
Compares your latest supplier CSV with the previous version, computes percentage cost increases and stock reductions, and outputs an urgent alert list.
You spot price hikes and supplier stockouts instantly, adjusting your retail pricing and purchase orders before margin leaks occur.
Shows how the delta engine detects an unnoticed wholesale price surge and sudden stockout between supplier shipments.
Previous: SKU-LEATHER-BELT, Cost: $18.50, Stock: 45
New: SKU-LEATHER-BELT, Cost: $24.00, Stock: 0sku,old_cost,new_cost,cost_change_pct,old_stock,new_stock,severity,alert_type
SKU-LEATHER-BELT,18.50,24.00,+29.7%,45,0,CRITICAL,COST_SPIKE_AND_STOCKOUTInstantly flags a 29.7% cost increase and complete stockout so you can update store prices before losing margin.
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 |
|---|---|
delta_engine.py | Core price and stock delta calculation 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 |
COSTS.md | Zero recurring cost declaration |
LICENSING.md | Sanocea Commercial License |
tests/test_delta.py | Pytest suite covering all reconciliation edge cases |
data/store_catalog.csv | Sample store catalog CSV dataset |
data/supplier_feed.csv | Sample supplier feed CSV dataset |
For technical teams or developers assisting your business, below is the visual execution architecture and automated verification breakdown:
The script reads store catalog and supplier feed CSVs, performs SKU matching, detects critical supplier stockouts, computes price deltas, and generates delta_updates.csv. No external network calls are made.
Flags items where store stock > 0 but supplier stock is 0
Calculates price deltas and flags margin compression above threshold
Identifies new supplier SKUs and flags discontinued products
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 |
|---|---|---|
| Supplier Delta 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 delta_engine.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 intercepts critical stockouts: items where your store shows positive inventory but the supplier feed shows zero stock. These are flagged with CRITICAL_SUPPLIER_STOCKOUT so you can zero out store stock before customers place unfulfillable orders.
No. The engine runs 100% locally on your machine using Python's standard library with zero third-party software subscriptions, cloud fees, or recurring charges.
Yes. Pass the --threshold flag (e.g. --threshold 5.0) to flag only wholesale cost increases that exceed 5% of your catalog price, preventing alert fatigue from fractional currency rounding.
No. By design, it operates safely offline in dry-run mode. It generates an audited delta_updates.csv file that you review and import through your platform's standard product import interface.
How vendor wholesale price increases quietly compress merchant profit margins, why discontinued catalog items cause sudden stockouts, and how automated delta engines protect profitability.
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 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.
An enterprise-grade continuous catalog monitor that audits your complete online inventory 24/7 on Sanocea VPS infrastructure. It catches accidental zero prices, inverted compare-at discounts, missing barcodes, and broken image URLs within minutes of publication, notifying your operations team via Telegram before shoppers exploit errors.