Documentation & Glass-Box Formula Guide

Every ShelfSteady calculation is deterministic and auditable. Here is how onboarding, reorder velocity, landed-cost COGS, and vendor portals work under the hood.

1. 60-Second Store Sync & Location Roles

Connect via Shopify Admin (App Bridge v4) or sign in directly to the standalone Web Workspace (app.shelfsteady.com) using a Shopify Admin API token or OAuth. ShelfSteady syncs active Shopify locations, physical SKU variants (automatically excluding gift cards and non-physical items), vendor assignments, and 90-day location order velocity.

Each location is tagged as either Warehouse / DC (holds bulk buffer stock and receives vendor POs) or Retail POS Store (eligible for 1-click Fill Shelves replenishment from warehouses). You can toggle any location role at any time.

2. Stockout-Adjusted Velocity & Reorder Math

Naive inventory reports divide 30-day sales by 30 calendar days, cutting reorder suggestions in half whenever an item goes out of stock. ShelfSteady computes active in-stock pace per location:

ActiveInStockDays_30d = max(1, 30 - StockoutDays_30d)
Velocity_30d          = UnitsSold_30d / ActiveInStockDays_30d
BlendedDailyVelocity  = (0.70 * Velocity_30d) + (0.30 * Velocity_90d)
ReorderPoint          = ceil(BlendedDailyVelocity * (LeadTimeDays + SafetyStockDays))
TargetStock           = ceil(BlendedDailyVelocity * (LeadTimeDays + SafetyStockDays + 30))
SuggestedOrderQty     = max(0, TargetStock - (AvailableQty + IncomingPoQty))

3. Weighted-Average Landed Cost & Goods-In

During Goods-In receiving, Freight, Customs/Duty, and Clearance/Insurance costs are allocated across PO lines by subtotal value share. ShelfSteady then blends the incoming landed unit cost with your existing on-hand inventory before updating InventoryItem.unitCost in Shopify:

LineLandedUnitCost   = BaseUnitCost + ((TotalOverhead * LineValueShare) / OrderedQty)
BlendedShopifyCost   = ((ExistingOnHand * OldUnitCost) + (ReceivedNow * LineLandedUnitCost))
                       / (ExistingOnHand + ReceivedNow)

If a supplier short-ships a line item and Auto-split short-shipped balance is enabled, ShelfSteady automatically creates a child Backorder PO (PO-1001-BO1) for the remaining units.

4. Agent & MCP Discovery Endpoints

AI assistants and procurement agents can query ShelfSteady plan quotas, ERP savings math, and store installation links via our read-only Model Context Protocol (MCP) endpoint:

  • POST https://shelfsteady.com/mcp
  • GET https://shelfsteady.com/.well-known/mcp/server-card.json
  • GET https://shelfsteady.com/llms-full.txt

Contact Engineering & Onboarding Support

Email [email protected] directly or send a ticket below.

Topic