SKU.io Inventory Planner

By SKU.io

Overview

Upload a Shopify orders export, an Amazon FBA inventory report or any CSV with SKU, date and quantity columns. The Inventory Planner calculates reorder points and safety stock, how many units to send to FBA rounded to whole cases, and which products are out of stock, at risk, overstocked or dead stock. Results appear as a sortable table. Files are processed in memory for the one request and never stored. No account is needed.

Tools

check_inventory_health

ChatGPT

Use this when a seller asks which products are dead stock, slow-moving or overstocked, which are at risk of stocking out, how many days of cover each SKU has, or how much cash is tied up in excess inventory. Do not use for inventory age or Amazon aged-inventory surcharges; it has no age data. Needs current stock (SKU, on hand, optionally unit cost) and either sales history or a units-sold-last-30-days column. Classifies every SKU as out of stock, at risk, dead stock, overstock or healthy, with days of cover and stock value when costs are given. Read-only; stores nothing.

plan_fba_restock

ChatGPT

Use this when an Amazon seller asks how many units to send or ship to FBA, what to put in the next inbound shipment, how their own number compares with Amazon's restock recommendation, or which SKUs will run out at Amazon before a shipment arrives. Do not use for reorders from a supplier (use plan_reorder_points), FBA capacity limits or AWD. Needs FBA inventory (SKU, available, optionally inbound) and either sales history or a units-sold-last-30-days column. Returns per-SKU units to send, rounded up to the case pack, and flags SKUs that will stock out before a shipment sent today lands. Read-only; stores nothing.

plan_reorder_points

ChatGPT

Use this when a seller asks when to reorder, how much stock to buy or reorder, what their reorder point or safety stock should be, or which SKUs will run out before a new purchase order from the supplier can arrive. Do not use for a seasonal or peak-period forecast, for grouping quantities into supplier purchase orders, or for units to send to Amazon FBA (use plan_fba_restock). Needs sales history (order lines or daily sales with SKU, date, quantity) and the supplier lead time in days. Current stock is optional; with it, the tool says which SKUs to order now and how many units. Returns per-SKU average daily sales, variability, safety stock, reorder point, order-up-to level and suggested order quantity. Read-only; stores nothing.

Capabilities

Interactive

Example Prompts

Click any prompt to copy it.

Links

Documentation Privacy Policy

Similar Apps

Adzviser Merchant Center

10Signals