Stock Shortage Allocation Preview
Pricing
$50.00 / 1,000 completed stock shortage allocation previews
Stock Shortage Allocation Preview
Preview how limited stock would be distributed across order lines by priority or FIFO. See exact fills, backorders and missing stock scope without reserving inventory.
See how a limited, caller-supplied stock snapshot would be distributed across order lines before anyone changes an ERP. Choose priority then date or first in, first out. The report lists the proposed fill and backorder for every line, remaining stock, and any demand whose SKU/unit has no matching stock row.
This is a review-only what-if calculator. It does not reserve inventory, promise delivery, contact customers or write to purchasing systems.
Quick start
Run the included example. Ten units are available. The first order requests eight at priority 1; the second requests seven at priority 2. The preview assigns eight and two units, leaving a five-unit backorder. Export the dataset as JSON or CSV, or read REPORT from the default key-value store.
Input is one caseJson string containing an object with caseId, policy, coverageConfirmed, stock, and demand. stock rows contain sku, unit, and available. Demand rows contain orderId, lineId, sku, unit, quantity, priority (1–5), and orderDate (YYYY-MM-DD). Available and requested quantities are whole units. Use unreserved available stock, and set coverageConfirmed true only when the stock and demand scope is complete.
PRIORITY_THEN_DATE sorts by ascending priority then order date. FIFO sorts by date then priority. Order and line IDs break final ties, so input row order does not change the allocation. Lower priority numbers mean greater priority. Allocation is greedy within each exact SKU/unit. Partial fills are permitted. Missing stock rows are unknown, never silently interpreted as zero. If scope is incomplete, the overall result is INCOMPLETE_REVIEW, even though known rows have a preview.
Pricing
$0.05 per completed report. A report with shortages or incomplete coverage is still a completed report. Malformed input and runs with insufficient event budget produce no report event. Set an Apify maximum-charge limit when testing. Platform resource usage can apply separately. Check the live Pricing tab before use.
Limits and safety
At most 500 stock rows, 2,000 demand rows and 1 MB of UTF-8 JSON. Identifiers are exact, case-sensitive and limited to 100 characters. The Actor rejects duplicate stock keys, duplicate order/line keys, noninteger quantities, invalid dates and unexpected fields. It makes no external network requests and requires no AI or paid API. Avoid customer names, addresses, bank details and credentials; opaque IDs are enough.
The supplied stock snapshot is not independently verified. Separate runs do not share reservation state; rerun with updated stock before any business decision. The result is never an order approval or reservation. Unit conversion, substitutions, future replenishment, shipping time and customer commitments are outside scope.
Why this tool
Microsoft documents reserving scarce inventory by first ordered or customer priority, and SAP documents FIFO and proportional stock allocation. This Actor offers a compact, auditable preview for teams working from structured exports, without requiring ERP access. Demand evidence does not prove that users will pay for this Actor.
References: Microsoft inventory reservations, SAP allocation.
