Customer story ·
Membrane built a product explorer for its 500+ SKUs. Each product’s page shows where the stock is, what is on the way, the demand ahead for each channel, and what to order before it runs out.
Product Explorer inside Membrane Workspace
routes and placed orders suggested by the explorer
on the orders placed, after the transfers out with the suggested and planned orders
Amazon 26Wholesale 24Shopify 2 Amazon demand while out of stock
The problem
sells accessories on Amazon, in its own Shopify store, and to wholesale and retail buyers. Its stock sits on order with the supplier, in a third-party warehouse, in AWD (Amazon’s bulk storage) and in Amazon FBA. Each system keeps its own count, and the counts disagree. Purchase orders lived in a spreadsheet.
Every week, someone pulled the exports into that spreadsheet and reconciled them by hand. Now the explorer keeps the count for every product, and the team orders from its suggestions.
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 Allenoperations advisor to the brandInside the explorer
The map shows the product with the supplier, in the warehouse, in AWD and in Amazon FBA, with the orders and transfers between them. A dashed line is a move the explorer suggests.
The warehouse count comes straight from the warehouse system. The brand’s hand-made export had listed products at zero that were sitting on the shelves.
routes and placed orders suggested by the explorer
Amazon and the warehouse run out on different days, so each gets its own line. Each line falls at the rate that place sells and steps up when an order lands. The warehouse line also drops on each day it ships a transfer to Amazon. The shaded bars show what the suggested and planned orders add.
Each purchase order lands at the warehouse, on its own date. The brand’s workbook had dated orders to reach Amazon in six weeks, though they take 8–12 weeks to reach the warehouse.
on the orders placed, after the transfers out with the suggested and planned orders
The explorer suggests an order while there is still time to act: a transfer before Amazon runs out, a purchase order before the warehouse does. It also plans the next transfer, and the warehouse line already counts it.
Each suggestion opens to its math: weekly sales, the stock on hand and on order, the level to reorder at, and the target.
Amazon, the Shopify store and wholesale each get their own forecast. The runway charts and every suggested order use it.
Amazon’s rate counts only the days buyers could buy. Two weeks out of stock don’t read as two weeks of no demand, so the next order isn’t cut short.
Amazon 26Wholesale 24Shopify 2 Amazon demand while out of stock
How it was built
Four sources feed the explorer, and it has run on the brand’s data since August 2026.
AmazonFBA stock, inbound shipments and orders
ShipHeroWarehouse stock and transfers to Amazon
ShopifyStore and wholesale orders
Purchase ordersThe brand’s Excel workbook, now a table it edits itselfBuilt by the team behind Membrane (getmembrane.com). Membrane is an independent service. Not affiliated with, endorsed by, or sponsored by Amazon.