One stock ledger, every channel in lockstep
Stop overselling. A single FIFO inventory ledger is the source of truth, and every lot change pushes to WooCommerce and eBay at once — with a daily audit that catches and fixes drift before a customer does.
What it does
Sell on two-plus channels without the spreadsheet
- FIFO inventory lots hold quantity, cost, and condition — the basis for accurate COGS downstream.
- Condition gating keeps refurbished, used, and new stock from being sold as the wrong grade.
- Push-on-mutation sync writes storefront quantity to WooCommerce and eBay on every lot change.
- Daily drift audit compares channel quantities to the ledger, auto-resyncs mismatches, and emails a report.
- UPC reconciliation normalizes identifiers across the multiple meta locations WooCommerce stores them in.
- Fast client-side search index built for large catalogs (proven at ~43k SKUs).
| Source of truth | inventory_lots (FIFO, condition-aware) in tenant MariaDB |
|---|---|
| Sync mechanism | Poller REST PUT to WooCommerce + eBay on each lot mutation |
| Drift control | Daily audit cron, auto-resync, email report |
| Identifier hygiene | UPC backfill across 7 WooCommerce meta locations + cache flush |
| Search | Hashed client-side JSON index, lazily loaded |
Integrations
| Integration | Required |
|---|---|
| WooCommerce REST | Yes |
| MariaDB | Yes |
| eBay Sell API | If selling on eBay |
In practice
What the stock ledger looks like
| SKU | On hand | WooCommerce | eBay | Status |
|---|---|---|---|---|
| PMP-4820 | 6 | $612.50 | $629.00 | LOW · reorder at 10 |
| SNS-1200 | 240 | $184.00 | in sync | OK |
| DRV-0630 | 18 | $1,145.00 | $1,180.00 | OK |
| CBL-0410 | 0 | — | — | OUT · delisted |
Representative data for a fictional distributor.
Reading the grid
One ledger drives both channels. PMP-4820 has dropped to 6 units — below its reorder point of 10 — so it’s flagged low and an alert lands on the dashboard before you stock out. CBL-0410 hit zero and was automatically pulled from WooCommerce and eBay, so no one can buy what you can’t ship.
The eBay column shows live parity with the storefront. When a unit sells on either channel, both counts drop within the next sync cycle, and the nightly audit reconciles any drift it finds.
- No overselling: a sale on one channel updates the other
- Reorder alerts before zero, not after
- Condition-gated: only sellable grades reach the storefront
Pair it with quoting and shipping
Inventory sync is one of the two most common starting wedges. Add fulfillment and accounting as you scale.
See plans Pick, pack & ship →