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.