Inventory
Replen report, inventory snapshot, reorder point settings, and product records.
The Inventory area helps you keep stock at the right level. It tells you what to reorder, how much coverage you hold, and how each product is set up.
The sidebar splits it into four screens: Replen Report, Inventory Snapshot, Reorder Point Settings, and Products.
Key terms
A Base SKU is the master inventory item you plan against. A Case SKU
packs several base units together, and its base_sku_quantity says how many.
A Product SKU is the sellable listing. The Glossary
defines each one.
Replen Report
The Replen Report is your reorder worksheet. It covers each Base SKU in each warehouse. For each one, it tells you whether stock will run out and how many units to buy.
Rows that need a reorder highlight red.
Columns
Each row shows the inventory type, SKU, and warehouse. It also shows average daily demand, stock on hand, days remaining, reorder point, inbound quantity, and amount to reorder.
The report sorts by amount to reorder, largest first.
What you can do
- Filter by account, warehouse, or SKU activity. Search by name or SKU.
- Run Report — fetch fresh numbers.
- Export CSV — download every sorted row, not just the current page.
How the numbers work
Live inbound overrides the view
The report does not trust the stored inbound figure. It recounts inbound from pending purchase orders. Case line items multiply by their units per case to reach base units.
After it recounts inbound, the app recomputes two fields:
- Additional stock needed = reorder point − stock on hand − inbound. It never drops below zero.
- Amount to reorder rounds that number up to the SKU's order multiple.
The reorder point itself comes from the database. It uses the settings you control on the Reorder Point Settings screen.
Inventory Snapshot
The Snapshot shows one row per Base SKU and one column per warehouse. It answers "How much coverage do I hold, per warehouse?" at a glance.
Cells that need a reorder highlight red.
Pick a metric
A metric selector chooses what each cell shows:
- Days on hand — stock divided by daily demand.
- Days on hand plus inbound — the same, but counts pending inbound.
- Quantity on hand — raw units.
- Quantity on hand plus inbound — units plus pending inbound.
The two "days" metrics leave the grand total blank. You cannot meaningfully add coverage days across warehouses.
What you can do
- Filter by account, warehouse, or SKU activity. Search by name or SKU.
- Run Report — fetch fresh numbers.
- Export to CSV — the server builds this export.
Why the export runs on the server
Large accounts hold more rows than the browser loads at once. The server re-runs the full query and streams the whole file. So your export never misses rows.
Reorder Point Settings
This screen holds the levers behind the reorder math. You set five values per SKU and warehouse.
The five settings
- Trailing days to measure demand (default 14) — the lookback window for average daily demand.
- Order interval in days (default 7) — how often you reorder the item.
- Replen order lead time in days (default 10) — how long an order takes to arrive.
- Safety stock in days (default 3) — the buffer you want to keep.
- Reorder multiple — the smallest order increment.
The database combines these values to compute each SKU's reorder point.
What you can do
- Filter by account, warehouse, or status. Search by name or SKU.
- Change status inline — mark an item active or inactive.
- Edit one warehouse — open a modal and set the five values.
- Bulk edit — select many items and apply the same values at once.
- View related SKUs — see the Product SKUs and Case SKUs linked to a Base SKU.
- Push back to sync queue — re-sync a SKU through ShipHero and N8N.
Bulk edit locks to one account at a time. It writes changes in small batches.
Products
The Products screen is your catalog of Product SKUs. Each one resolves to a Base SKU, a brand, and a category.
List columns
Each row shows the Product SKU, product name, ASIN, bundle count, postage threshold, category, Base SKU, and account.
What you can do
- Search by SKU, name, or ASIN. Filter by account or category.
- Set category in bulk — select many products and assign one category.
- Open a product — click a row to see its full record.
Bulk category assignment guards by brand. Categories belong to one brand, so the products must match.
Product detail
Each product opens to a full record with two tabs.
The Details tab shows product info, category, shipping and dimensions, and Base SKU info. You can edit three fields inline: ASIN, postage threshold, and category. Every other field syncs from ShipHero and stays read-only.
The Base SKU Components tab lists the Base SKUs that make up the product. It acts as the bill of materials for bundles.