Skip to content
AutoFlowsEngine

Template · Operations

Low-stock reorder list

Find SKUs below their reorder point in each warehouse and calculate how many units to order and what it will cost.

Steps

  1. 1

    Calculate 6→6

    shortfall = reorder_point - on_hand

  2. 2

    Filter 6→3

    Keep where shortfall > 0

  3. 3

    Calculate 3→3

    order_qty = shortfall + reorder_point

  4. 4

    Calculate 3→3

    order_cost = order_qty * unit_cost

  5. 5

    Sort 3→3

    By order_cost descending

  6. 6

    Keep fields 3→3

    Keep warehouse, sku, product, on_hand, order_qty, order_cost

Open in engine

OUTPUT ON SAMPLE DATA · 3 ITEMS

[
  {
    "warehouse": "Miami",
    "sku": "HD-GRY-M",
    "product": "Hoodie grey M",
    "on_hand": 6,
    "order_qty": 44,
    "order_cost": 814
  },
  {
    "warehouse": "Miami",
    "sku": "TS-BLK-M",
    "product": "T-shirt black M",
    "on_hand": 14,
    "order_qty": 66,
    "order_cost": 409.2
  },
  {
    "warehouse": "Dallas",
    "sku": "CP-NVY",
    "product": "Cap navy",
    "on_hand": 9,
    "order_qty": 51,
    "order_cost": 242.25
  }
]