Automation work · e-commerce operations

One inventory truth, every channel

Shopify, Etsy and Amazon stop fighting over stock. One Sheets-based inventory brain syncs every channel in real time, pauses for humans only when it must, and reordered stock before anyone noticed it was low. Zero oversells since launch; $85k of revenue protected in the first quarter.

See the 5 automated stages
What goes in → what gets written. No human in between.
overselling incidents
0
revenue protected
$85k+
saved weekly
25 hrs
channels, one truth
3
Delivered · Retail Brand · Shopify + Etsy + AmazonRetail Brand3 weeks
$diagnose

What the manual version costs you

Three channels, three stock counts, one very predictable disaster — every oversell was a refund, an apology, and a marketplace penalty.

Channels that lie to each other

Shopify said 4 units, Etsy said 4, Amazon said 4. Eight orders later, three customers paid for stock that did not exist.

Penalties for being wrong

Marketplaces punish overselling with ranking demotions and account strikes. The brand was funding its own demotion.

Nightly reconciliation ritual

Hours every evening re-counting and re-keying stock across dashboards — accurate until the next morning’s first sale.

Reorders by memory

Low stock was discovered when it became zero stock. Suppliers need lead time the brand kept forgetting to give them.

$the solution

One pipeline. 5 automated stages.

A unified inventory system: Google Sheets as the single ledger, bidirectional webhooks to every platform, and reorder emails that fire before the shelf goes empty.

The delivered system, end to end — each stage runs without a human in the loop.
  1. 01Sale lands anywhere

    A webhook fires the instant any channel sells — Shopify, Etsy or Amazon. Real time, not nightly.

  2. 02Ledger decrements

    The Sheets ledger is the one stock count that matters. One subtraction, applied everywhere, atomically.

  3. 03All channels updated

    Remaining counts push back out to every platform within moments. No channel ever quotes stale stock.

  4. 04Conflict → human

    When two sales race the same last unit, the system pauses that SKU and raises a flag instead of guessing. Machines pause; they don’t gamble.

  5. 05Reorder triggered

    Crossing the low-water mark emails the supplier a reorder request with a copy to the owner — restock starts before the out-of-stock page can.

$before / after

The same job, with the automation on

The same last unit, sold twice — prevented.

StepBy handAutomated
Stock countThree channels, three answersOne ledger, zero drift
Sync cadenceNightly manual passWebhooks, within moments
Last-unit racesOversell, refund, penaltySKU pauses, human decides
ReorderingAt zero, apologeticallyAt the low-water mark, automatically
Revenue at risk$85k+/quarter exposedProtected, continuously

Recognize your own workflow? Get it automated →

$the stack

Runs on tools you already pay for

No new platform to buy, no migration project. The pipeline runs on your existing workspace — and bends to fit whatever it needs to talk to.

Shopify APIEtsy APIAmazon SP-APIGoogle SheetsApps Script webhooks

Also adapts to

WooCommerceeBayTikTok Shopyour 3PLyour ERP
$outcome

What the delivered build measured

First-quarter results after cutover from the nightly ritual.

overselling incidents since launch
0
revenue protected in Q1 alone
$85k+
per week returned to the team
25 hrs
sync without a nightly pass
24/7
$field notes

What made it work

    Sync conflicts must pause for a human, never guess

    Real-time beats nightly for revenue-protecting stock counts

    $85k+ in oversells prevented in the first quarter

Your stock is one race condition away from a refund.

Free 30-minute call: we map your channels and you get a fixed quote for a single-ledger sync that never guesses. Built on your stack, owned by you.

  • Fixed written quote
  • You own 100% of the code
  • Reply within one business day