Customer story ·

Amazon ran out with stock in the warehouse. So we built a watch.

had the stock, but not where buyers were looking. We built a watch that says every Monday what to ship to Amazon and what to buy, before the shelf runs empty.

4 h 8 min
from starting the watch to its first plan
Weekly
a new plan every Monday
6 weeks
of stock we keep on the Amazon shelf

The first figure is measured. The other two are rules the watch runs on.

01 · The problem

The Amazon shelf kept running out.

The company’s Amazon shelf kept running out. Amazon’s own records showed the warehouse had stock through almost every recent stockout.

Warehouse
Amazon shelf
Six weeks or more Under six weeks Out of stock

An illustration of the pattern in Amazon’s records. The cells are drawn, not the company’s figures.

02 · How fast

The watch was running by Day 3.

3 daysfrom finding the problem to the watch’s first plan
  1. Day 1Found the causeAmazon’s records showed the warehouse had the stock all along.
  2. Day 3The watch is runningWe built it, and its first plan was up the same afternoon.4 h 8 min
  3. Every MondayA new planWhat to ship to Amazon, and what to buy.

Day 1 is the day Amazon’s records showed the problem. Every day after it counts, weekends too.

03 · What we found

What else the records showed.

Two more problems sat in the company’s own files, so the watch reads the source systems instead.

A plan counting on stock that was weeks away

The company’s plan expected supplier orders at Amazon within six weeks. They take 8–12 weeks just to reach the warehouse.

What we did

The watch counts only stock that is really on its way, so the plan never leans on stock that isn’t coming.

Stock on the shelf that the file called zero

The company’s stock export showed products at zero that the warehouse had in stock.

What we did

The watch reads stock straight from the warehouse, so nothing shows as out when it’s on the shelf.

04 · What we did

A new plan every Monday.

The watch steps through every location one day at a time. It keeps the stores stocked first, then sizes each shipment to Amazon.

  1. Read every feed

    Warehouse stock, Amazon stock and open transfers, read fresh each time.

  2. Look 24 weeks ahead

    Day by day: sales out, each dated arrival in.

  3. Stores first, then Amazon

    The warehouse keeps 6 weeks for stores and wholesale. Each shipment refills Amazon to 6 weeks.

  4. Monday’s plan

    What to ship and what to buy, on the watch’s page and as a file per route.

A new workbook starts a new plan the same day

Demand from in-stock days only

We count sales only on days a product was in stock, so a stockout never looks like low demand.

Bridge shipments

Small shipments from the warehouse keep Amazon selling until a slow supplier order lands.

05 · In their words
I love the inventory diagram that shows every movement, including the suggested ones. You’ve taken something very complex and presented it in a way that’s very clear.
Adam AllenAdam Allen, operations advisor to the company
06 · The job

The job behind this work.

Each job has a fixed price per deliverable, and a named Operator answers for the result.

Job · Stockout PreventionInventory ManagementYour whole inventory operation, run for you — stock numbers reconciled and kept true, demand forecasting, stockout prevention with a revenue receipt, purchase orders owned end to end, and inbound tracking.See the job

More work for the same client

Product explorer · accessories · Amazon, Shopify, wholesale, retailWhere every unit is, and where it will be.Read the story →Missing listings · accessories · AmazonMissing Amazon listings, built the afternoon they were found.Read the story →Catalog refactor · accessories · AmazonNew photos for a whole product line in 11½ hours of work.Read the story →Cost of goods · accessories · four channelsMonth-end cost of goods, tied to every order.Read the story →

Stop wondering if something better is out there.