Inventory Reorder Planner

Overview

You send stock positions and the policy you buy under, and we return, per item, what is available, the reorder point, whether it is below it, how much to order raw and after your order multiple and minimum, how many days of cover you have left, and a reason code explaining the answer. Every formula is published: available is onHand plus onOrder minus allocated, or onHand minus allocated when rules.includeOnOrder is off; the reorder point is average daily demand times lead time plus safety stock, rounded up to a whole unit; safety stock under DAYS_OF_DEMAND is demand times safetyStockDays, also rounded up; the raw suggestion is the reorder point minus available, or maxStock minus available under MIN_MAX, or the item's reorderQuantity under FIXED_QUANTITY, never below zero; coverDays is available divided by demand truncated to one decimal, floored at 0.0 for an oversold position; and EOQ is the classic square root, taken by integer square root on exact decimals rather than a floating-point library call. There is no forecasting anywhere: demand is an input, not an inference, so this answers "given this demand estimate, what should I order" and not "what will I sell". An item missing what its policy needs comes back INSUFFICIENT_DATA rather than a guess. It suggests; it never orders, reserves or changes anything.

Reorder arithmetic is simple and still gets done differently in three places: one spreadsheet counts stock in transit and another does not, one rounds the order up to a case and another does not, and neither can tell you why a SKU was left off the list. You get one fixed set of formulae, published openly, plus a reason code per item — including an explicit INSUFFICIENT_DATA instead of a quiet zero when an item lacks what its policy needs.

When to use it

Scope

Non-goals

• Does not forecast demand — no moving average, no seasonality, no trend, and no safety stock derived from demand variance and a service level, because that would be a statistical model you cannot inspect
• Does not read stock from anywhere; every position is an input
• Does not order, reserve, allocate or change anything
• Does not read the clock — asOf is yours to supply
• Does not choose a supplier, negotiate a price, or check a lead time
• Does not convert between currencies

Properties

Capabilities

Cost & billing

Flat rate per invocation

File handling

How we handle your data

Input schema

Output schema

API contract

curl -sS -X POST "$BASE/v1/execute" -H "Authorization: Bearer $KEY" -H 'Content-Type: application/json' -d '{"skillKey":"commerce.inventory_reorder","input":{"inventory":[{"sku":"TSHIRT-S-BLACK","onHand":12,"avgDailyDemand":"4","leadTimeDays":7,"safetyStock":10}],"asOf":"2026-07-28"}}'

import { Squillify } from "@squillify/sdk";

const sq = new Squillify({ apiKey: process.env.SQUILLIFY_API_KEY });

const { output } = await sq.execute("commerce.inventory_reorder", {"rules":{"minOrderQuantity":24,"roundTo":12},"asOf":"2026-07-28","inventory":[{"avgDailyDemand":"4","leadTimeDays":7,"sku":"TSHIRT-S-BLACK","safetyStock":10,"onHand":12},{"onOrder":60,"avgDailyDemand":"5","leadTimeDays":14,"sku":"MUG-BLUE-S","onHand":40},{"sku":"LAMP-LED","allocated":1,"onHand":3}]});

Errors

Other limits

Limitations

• Does not forecast demand — no moving average, no seasonality, no trend, and no safety stock derived from demand variance and a service level, because that would be a statistical model you cannot inspect
• Does not read stock from anywhere; every position is an input
• Does not order, reserve, allocate or change anything
• Does not read the clock — asOf is yours to supply
• Does not choose a supplier, negotiate a price, or check a lead time
• Does not convert between currencies
• Forecasting what you will sell next month
• Deciding safety stock from demand variability and a target service level
• Placing the purchase order

How to call

POST /v1/execute (requires authentication)

{
  "skillKey": "commerce.inventory_reorder",
  "input": {
    "rules": {
      "minOrderQuantity": 24,
      "roundTo": 12
    },
    "asOf": "2026-07-28",
    "inventory": [
      {
        "avgDailyDemand": "4",
        "leadTimeDays": 7,
        "sku": "TSHIRT-S-BLACK",
        "safetyStock": 10,
        "onHand": 12
      },
      {
        "onOrder": 60,
        "avgDailyDemand": "5",
        "leadTimeDays": 14,
        "sku": "MUG-BLUE-S",
        "onHand": 40
      },
      {
        "sku": "LAMP-LED",
        "allocated": 1,
        "onHand": 3
      }
    ]
  }
}

Examples

{
  "rules": {
    "minOrderQuantity": 24,
    "roundTo": 12
  },
  "asOf": "2026-07-28",
  "inventory": [
    {
      "avgDailyDemand": "4",
      "leadTimeDays": 7,
      "sku": "TSHIRT-S-BLACK",
      "safetyStock": 10,
      "onHand": 12
    },
    {
      "onOrder": 60,
      "avgDailyDemand": "5",
      "leadTimeDays": 14,
      "sku": "MUG-BLUE-S",
      "onHand": 40
    },
    {
      "sku": "LAMP-LED",
      "allocated": 1,
      "onHand": 3
    }
  ]
}

{
  "summary": {
    "itemCount": 3,
    "reorderCount": 1,
    "totalSuggestedUnits": 36
  },
  "suggestions": [
    {
      "sku": "TSHIRT-S-BLACK",
      "available": 12,
      "reorderPoint": 38,
      "shouldReorder": true,
      "suggestedQuantity": 26,
      "roundedQuantity": 36,
      "coverDays": "3.0",
      "reasonCode": "BELOW_REORDER_POINT"
    },
    {
      "sku": "MUG-BLUE-S",
      "available": 100,
      "reorderPoint": 70,
      "shouldReorder": false,
      "suggestedQuantity": 0,
      "roundedQuantity": 0,
      "coverDays": "20.0",
      "reasonCode": "ALREADY_ON_ORDER"
    },
    {
      "sku": "LAMP-LED",
      "available": 2,
      "shouldReorder": false,
      "suggestedQuantity": 0,
      "roundedQuantity": 0,
      "reasonCode": "INSUFFICIENT_DATA"
    }
  ],
  "rules": {
    "policy": "REORDER_POINT",
    "safetyStockMode": "EXPLICIT",
    "roundTo": 12,
    "minOrderQuantity": 24,
    "includeOnOrder": true,
    "economicOrderQuantity": false
  },
  "asOf": "2026-07-28"
}

{
  "rules": {
    "policy": "MIN_MAX",
    "economicOrderQuantity": true,
    "orderingCost": "45.00",
    "holdingCostPerUnitPerYear": "3.50",
    "currency": "EUR",
    "roundTo": 10
  },
  "asOf": "2026-07-28",
  "inventory": [
    {
      "avgDailyDemand": "2",
      "maxStock": 120,
      "sku": "TENT-2P",
      "unitCost": "84.00",
      "leadTimeDays": 21,
      "onHand": 5
    }
  ]
}

{
  "summary": {
    "itemCount": 1,
    "reorderCount": 1,
    "totalSuggestedUnits": 120,
    "totalSuggestedCost": "10080.00",
    "costedItemCount": 1
  },
  "suggestions": [
    {
      "sku": "TENT-2P",
      "available": 5,
      "reorderPoint": 42,
      "shouldReorder": true,
      "suggestedQuantity": 115,
      "roundedQuantity": 120,
      "coverDays": "2.5",
      "economicOrderQuantity": 138,
      "reasonCode": "BELOW_REORDER_POINT"
    }
  ],
  "rules": {
    "policy": "MIN_MAX",
    "safetyStockMode": "EXPLICIT",
    "roundTo": 10,
    "minOrderQuantity": 0,
    "includeOnOrder": true,
    "economicOrderQuantity": true,
    "orderingCost": "45.00",
    "holdingCostPerUnitPerYear": "3.50",
    "currency": "EUR"
  },
  "asOf": "2026-07-28"
}

Recommended use cases

• Produce a nightly buy list from the stock snapshot your ERP already exports
• See which SKUs are only technically covered, because the stock is still in transit
• Compare a min-max policy against a reorder-point one on the same positions

Avoid for

• Forecasting what you will sell next month
• Deciding safety stock from demand variability and a target service level
• Placing the purchase order

Related skills

Composable with

Safety & privacy

• Runs without calling any external service.
• Your payloads are never stored permanently.
• Telemetry captures metadata only — never your payload contents.
• We never train models on your payloads.
• No human reviews your payloads.

Tags