Field & Form Main stockroom

Buying worksheet

Check recent-order inputs and withheld rows before placing your next stock order.

Fictional demonstration dataSource read marked complete · reorder-csv-v0.2-local.1Source label and read checks are evidence about this scan, not a guarantee of historical completeness.

Your buying policy

One common policy.
Adjust case packs per row.

Supplier lead timedaysOrder placed to arrivalReview cycledaysTime until you buy againAdditional bufferdaysExtra cover beyond reserved stockDefault case packunitsFor variants without an override

Confirm the store fits this modelThe store traded throughout the entire 28-day period. I understand that unrecorded stockouts and demand are not reconstructed.One supplier lead time and review cycle are suitable for the variants I intend to use. Different case-pack multiples can be set below.

Settings are assumptions, not Shopify facts. Saving does not change the existing worksheet.

Buying worksheet

2 eligible/6 withheld/8 rows shown

8 order records · 8 line-item records
Test and cancelled orders excluded from the model

All observed variants, including withheld rows. Units to buy is blank when a recommendation is withheld. Case-pack inputs are draft settings until a successful refresh.
Net units 28-day cohort	Available	Incoming	Case pack next refresh	Cover days	Units to buy	Result
56	10	0	Case pack for LIN-TEA-01	5	24	Calculated4 case packs of 6
28	40	0	Case pack for SOAP-CL-02	40	0	CoveredNo additional units in this model
42	2	24	Case pack for TOTE-INK-03	—	—	WithheldIncoming stock has no supported arrival timing. Reorder quantity is withheld.
14	4	0	Case pack for CNDL-FIG-04	—	—	WithheldVariant was created within the analysis window. A full 28-day existence window is unavailable.
0	8	0	Case pack for BTL-SAGE-05	—	—	WithheldNo net units were recorded on this order cohort. This is not evidence of zero demand.
28	-2	0	Case pack for APRON-NV-06	—	—	WithheldAvailable is negative. Backorder planning is unsupported.
28	3	0	Case pack for CUP-STN-07	—	—	WithheldOn hand does not reconcile to Available + Committed + Unavailable.
0	0	0	Case pack for GIFT-08	—	—	WithheldInventory tracking is disabled.

Withheld quantities stay blank in the CSV. A calculated 0 means no additional units under the report’s assumptions. No recorded sales is not evidence of zero demand. Exact calculation inputs and all exclusions are included in the export.

A useful report before you choose a plan

Demonstration only. No Shopify account, plan or payment is connected.

Proposed plan: USD19/month with a 14-day trial. Approval and trial access are separate from a verified collected payment.

Inspect the working

Linen tea towel · oat

Every field below is included in the CSV

56 net units ÷ 28 days × 17 policy days − 10 AvailableNeed 672 / 28; round up to packs of 6 = 24 units

Report

Model version: reorder-csv-v0.2-local.1
Presentation state: input_snapshot
Source type: fictional_fixture
Source label: Field & Form sample · all records are fictional
Inventory quantity mapping: supplied-values
Unavailable input definition: Inventory states were supplied in the input. Unavailable is a supplied value; its mapping to Shopify API states has not been verified.
Live verification: Not live-verified
Store: Field & Form
Store ID: demo-shop
Store timezone: Europe/Zurich
First local date: 2026-09-19
Local end date (exclusive): 2026-10-17
Window start (UTC, inclusive): 2026-09-18T22:00:00Z
Window end (UTC, exclusive): 2026-10-16T22:00:00Z
Calendar days in model: 28
Report generated (UTC): 2026-10-17T12:05:00Z

Read evidence

Source read started (UTC): 2026-10-17T12:00:00Z
Source read completed (UTC): 2026-10-17T12:00:03Z
Source read status: complete
Catalog scan ended: true
Location scan ended: true
Order scan ended: true
Line-item scans ended: true
Order change check passed: true
Source read issues: —
Declared full-window trading history: confirmed
Declared common replenishment policy: confirmed
Active variants observed: 8
Order records observed: 8
Line-item records observed: 8
Test orders excluded: 1
Cancelled orders excluded: 1
Orders outside period excluded: 0

Variant

Variant ID: demo-variant-1
SKU: LIN-TEA-01
Product / variant: Linen tea towel · oat
Variant created (UTC): 2026-01-10T09:00:00Z
Stock location ID: demo-location-1
Stock location: Main stockroom

Inventory and demand

Available: 10
On hand: 20
Committed: 7
Unavailable: 3
Incoming: 0
Net units on order cohort: 56
Net units per calendar day: 2

Assumptions

Lead time (days): 7
Review cycle (days): 7
Additional buffer (days): 3
Case-pack multiple: 6

Result

Available cover (days): 5
Exact unrounded need numerator: 672
Exact need denominator: 28
Need before pack rounding: 24
Units to buy: 24
Result status: calculated
Withheld reason codes: —
Withheld reasons: —
Order-cohort policy: createdAt in [start,end); exclude test/cancelled; sum currentQuantity; include edits/refunds as currently reported, irrespective of payment status
Model limitations: No correction for stockouts, seasonality, promotions or unobserved demand. No incoming-arrival or backorder model.

Inspect complete report JSON

This is the saved report shown above. A changed buying policy is applied only after a successful refresh.

{
  "freshness": "input_snapshot",
  "modelVersion": "reorder-csv-v0.2-local.1",
  "source": {
    "kind": "fictional_fixture",
    "label": "Field & Form sample · all records are fictional"
  },
  "shop": {
    "id": "demo-shop",
    "name": "Field & Form",
    "timeZone": "Europe/Zurich"
  },
  "generatedAt": "2026-10-17T12:05:00Z",
  "period": {
    "timeZone": "Europe/Zurich",
    "startLocalDate": "2026-09-19",
    "endLocalDateExclusive": "2026-10-17",
    "start": "2026-09-18T22:00:00Z",
    "end": "2026-10-16T22:00:00Z",
    "days": 28
  },
  "read": {
    "startedAt": "2026-10-17T12:00:00Z",
    "completedAt": "2026-10-17T12:00:03Z",
    "status": "complete",
    "catalogComplete": true,
    "locationsComplete": true,
    "ordersComplete": true,
    "lineItemsComplete": true,
    "stableOrders": true,
    "issues": []
  },
  "suitability": {
    "fullWindowTradingHistory": "confirmed",
    "commonReplenishmentPolicy": "confirmed"
  },
  "assumptions": {
    "leadDays": 7,
    "reviewDays": 7,
    "bufferDays": 3,
    "defaultPack": 1,
    "packOverrides": {
      "demo-variant-1": 6,
      "demo-variant-2": 6
    }
  },
  "issues": [],
  "rows": [
    {
      "variantId": "demo-variant-1",
      "sku": "LIN-TEA-01",
      "title": "Linen tea towel · oat",
      "createdAt": "2026-01-10T09:00:00Z",
      "location": {
        "id": "demo-location-1",
        "name": "Main stockroom",
        "active": true,
        "externalFulfillment": false
      },
      "stock": {
        "available": 10,
        "onHand": 20,
        "committed": 7,
        "unavailable": 3,
        "incoming": 0
      },
      "netUnits": 56,
      "packSize": 6,
      "dailyRate": 2,
      "coverDays": 5,
      "exactNeedNumerator": "672",
      "unroundedNeed": 24,
      "buyUnits": 24,
      "status": "calculated",
      "reasons": [],
      "notes": []
    },
    {
      "variantId": "demo-variant-2",
      "sku": "SOAP-CL-02",
      "title": "Olive soap · classic",
      "createdAt": "2026-01-10T09:00:00Z",
      "location": {
        "id": "demo-location-1",
        "name": "Main stockroom",
        "active": true,
        "externalFulfillment": false
      },
      "stock": {
        "available": 40,
        "onHand": 50,
        "committed": 7,
        "unavailable": 3,
        "incoming": 0
      },
      "netUnits": 28,
      "packSize": 6,
      "dailyRate": 1,
      "coverDays": 40,
      "exactNeedNumerator": "0",
      "unroundedNeed": 0,
      "buyUnits": 0,
      "status": "calculated",
      "reasons": [],
      "notes": []
    },
    {
      "variantId": "demo-variant-3",
      "sku": "TOTE-INK-03",
      "title": "Canvas tote · ink",
      "createdAt": "2026-01-10T09:00:00Z",
      "location": {
        "id": "demo-location-1",
        "name": "Main stockroom",
        "active": true,
        "externalFulfillment": false
      },
      "stock": {
        "available": 2,
        "onHand": 12,
        "committed": 7,
        "unavailable": 3,
        "incoming": 24
      },
      "netUnits": 42,
      "packSize": 1,
      "dailyRate": null,
      "coverDays": null,
      "exactNeedNumerator": null,
      "unroundedNeed": null,
      "buyUnits": null,
      "status": "withheld",
      "reasons": [
        {
          "code": "incoming",
          "message": "Incoming stock has no supported arrival timing. Reorder quantity is withheld."
        }
      ],
      "notes": []
    },
    {
      "variantId": "demo-variant-4",
      "sku": "CNDL-FIG-04",
      "title": "Fig candle · small",
      "createdAt": "2026-10-05T10:00:00Z",
      "location": {
        "id": "demo-location-1",
        "name": "Main stockroom",
        "active": true,
        "externalFulfillment": false
      },
      "stock": {
        "available": 4,
        "onHand": 14,
        "committed": 7,
        "unavailable": 3,
        "incoming": 0
      },
      "netUnits": 14,
      "packSize": 1,
      "dailyRate": null,
      "coverDays": null,
      "exactNeedNumerator": null,
      "unroundedNeed": null,
      "buyUnits": null,
      "status": "withheld",
      "reasons": [
        {
          "code": "insufficient-history",
          "message": "Variant was created within the analysis window. A full 28-day existence window is unavailable."
        }
      ],
      "notes": []
    },
    {
      "variantId": "demo-variant-5",
      "sku": "BTL-SAGE-05",
      "title": "Water bottle · sage",
      "createdAt": "2026-01-10T09:00:00Z",
      "location": {
        "id": "demo-location-1",
        "name": "Main stockroom",
        "active": true,
        "externalFulfillment": false
      },
      "stock": {
        "available": 8,
        "onHand": 18,
        "committed": 7,
        "unavailable": 3,
        "incoming": 0
      },
      "netUnits": 0,
      "packSize": 1,
      "dailyRate": null,
      "coverDays": null,
      "exactNeedNumerator": null,
      "unroundedNeed": null,
      "buyUnits": null,
      "status": "withheld",
      "reasons": [
        {
          "code": "no-recorded-sales",
          "message": "No net units were recorded on this order cohort. This is not evidence of zero demand."
        }
      ],
      "notes": []
    },
    {
      "variantId": "demo-variant-6",
      "sku": "APRON-NV-06",
      "title": "Workshop apron · navy",
      "createdAt": "2026-01-10T09:00:00Z",
      "location": {
        "id": "demo-location-1",
        "name": "Main stockroom",
        "active": true,
        "externalFulfillment": false
      },
      "stock": {
        "available": -2,
        "onHand": 8,
        "committed": 7,
        "unavailable": 3,
        "incoming": 0
      },
      "netUnits": 28,
      "packSize": 1,
      "dailyRate": null,
      "coverDays": null,
      "exactNeedNumerator": null,
      "unroundedNeed": null,
      "buyUnits": null,
      "status": "withheld",
      "reasons": [
        {
          "code": "negative-available",
          "message": "Available is negative. Backorder planning is unsupported."
        }
      ],
      "notes": []
    },
    {
      "variantId": "demo-variant-7",
      "sku": "CUP-STN-07",
      "title": "Stoneware cup · chalk",
      "createdAt": "2026-01-10T09:00:00Z",
      "location": {
        "id": "demo-location-1",
        "name": "Main stockroom",
        "active": true,
        "externalFulfillment": false
      },
      "stock": {
        "available": 3,
        "onHand": 99,
        "committed": 7,
        "unavailable": 3,
        "incoming": 0
      },
      "netUnits": 28,
      "packSize": 1,
      "dailyRate": null,
      "coverDays": null,
      "exactNeedNumerator": null,
      "unroundedNeed": null,
      "buyUnits": null,
      "status": "withheld",
      "reasons": [
        {
          "code": "stock-state-mismatch",
          "message": "On hand does not reconcile to Available + Committed + Unavailable."
        }
      ],
      "notes": []
    },
    {
      "variantId": "demo-variant-8",
      "sku": "GIFT-08",
      "title": "Digital gift card",
      "createdAt": "2026-01-10T09:00:00Z",
      "location": {
        "id": "demo-location-1",
        "name": "Main stockroom",
        "active": true,
        "externalFulfillment": false
      },
      "stock": {
        "available": 0,
        "onHand": 10,
        "committed": 7,
        "unavailable": 3,
        "incoming": 0
      },
      "netUnits": 0,
      "packSize": 1,
      "dailyRate": null,
      "coverDays": null,
      "exactNeedNumerator": null,
      "unroundedNeed": null,
      "buyUnits": null,
      "status": "withheld",
      "reasons": [
        {
          "code": "untracked",
          "message": "Inventory tracking is disabled."
        },
        {
          "code": "non-physical",
          "message": "This is not a supported physical-stock variant."
        },
        {
          "code": "no-recorded-sales",
          "message": "No net units were recorded on this order cohort. This is not evidence of zero demand."
        }
      ],
      "notes": []
    }
  ],
  "summary": {
    "observedVariants": 8,
    "observedOrders": 8,
    "observedLineItems": 8,
    "calculated": 2,
    "withheld": 6,
    "buyUnits": 24,
    "excludedOrders": {
      "test": 1,
      "cancelled": 1,
      "outsidePeriod": 0
    }
  }
}

What these numbers mean

Net units are current quantities on orders created in the period. Test and cancelled orders are excluded. Refunds and edits are reflected as currently reported; payment status is not a filter. This is a recent-sales-based planning model, not fulfilled sales or an accounting report.

Know when to hold back

No correction for historical stockouts, promotions, seasonality or unobserved demand. Incoming stock, negative Available and insufficient history withhold recommendations. The model supports one active stocked location and a common lead time and review policy.