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.
Google Sheets inventory CSV export and WooCommerce product export CSV.
Local Python script aligns SKUs, calculates stock/price differences, and isolates mismatches.
sync_preview_delta.csv (exact changes to review) and missing_skus_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.
Warehouse teams update quantities in shared Google Sheets, but copy-pasting numbers directly into WooCommerce without verifying stock deltas leads to accidental overselling or overwriting live prices.
Syncing mismatched spreadsheets directly to a live store causes unfulfillable orders and incorrect customer charges.
Reads your warehouse Google Sheet export and WooCommerce product CSV, aligns matching SKUs, computes quantity and price deltas, and isolates any missing items into a clean preview file.
You see exactly what will change before any data touches your store, eliminating blind spreadsheet imports.
Demonstrates how the delta preview isolates warehouse changes without blindly overwriting your live store.
[Google Sheet (Warehouse)]: SKU-101, Stock: 25, Price: 49.00
[WooCommerce (Live Store)]: SKU-101, Stock: 5, Price: 45.00sku,store_stock,sheet_stock,stock_delta,store_price,sheet_price,price_delta,action
SKU-101,5,25,+20,45.00,49.00,+4.00,UPDATE_STOCK_AND_PRICEClear actionable row showing exact differences. You review the delta before applying it to WooCommerce.
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 |
|---|---|
sync.py | Core CSV reconciliation script |
run.sh | Convenient wrapper to invoke the script |
requirements.txt | Test execution requirements (standard library only for runtime) |
README.md | Usage guide & description |
SETUP.md | Step‑by‑step local‑first setup |
COSTS.md | Zero recurring cost declaration |
LICENSING.md | Sanocea Commercial License |
tests/test_main.py | Pytest suite covering all edge cases |
data/google_sheets_export.csv | Sample inventory CSV file |
For technical teams or developers assisting your business, below is the visual execution architecture and automated verification breakdown:
The script reads a CSV export, performs SKU matching, detects duplicates, and produces a preview report. No external calls are made.
Shows mismatches without mutating any store data
Flags colliding SKUs in the CSV
Gracefully reports missing columns or invalid numbers
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 |
|---|---|---|
| Inventory Sync 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 sync.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.
Direct live sync plugins often overwrite healthy stock levels on accidental bulk edits or when formula errors occur in spreadsheets. This toolkit generates a dry-run preview report and clean verified CSV, guaranteeing zero accidental store overwrites.
No. It runs entirely on your local machine using Python's standard library with zero third-party software subscriptions or monthly fees.
The script scans your inventory sheet and identifies colliding SKUs, reporting line numbers so you can resolve catalog duplicates before importing to WooCommerce.
Yes. Any spreadsheet tool capable of exporting standard UTF-8 comma-separated (CSV) files works seamlessly.
How manual spreadsheet copy-pasting corrupts store inventory, why unverified imports overwrite live prices, and how offline delta auditing validates stock counts before upload.
Read Field Guide on Sanocea Insights →A free, local Python tool that audits your online store products for catastrophic listing errors. It flags items accidentally priced at ₹0, products missing critical SKU codes, and listings with no images—sending a priority Telegram alert or terminal summary so you can fix mistakes before opportunistic buyers order.
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.