Inventory Analytics

No file loaded
Upload
Filter & Order
Settings
On Order
On Hand Count
On Hand + On Order
Store Blueprint
Master SKU Report
Store Map
Proforma Order
+
Drop CSV file here or click to browse

inventory-analytics-auto CSV export

Quick Group:
All POG ▼
No filters applied yet

Upload a CSV first, configure settings, then run filters.

Filter Settings by Site + POG

On Order Items

Order Date Site Store UPC SKU Description POG Vendor Qty Ordered Vendor Cost Total Cost Last Received (at order) Action

Master SKU Report Summary

No file loaded

Upload the Banners SKU Report to see UPC counts by Store x POG SubSpace. 72 UPCs per 4ft section.

+
Drop SKU Report XLSX here or click to browse

Banners Sku Report .xlsx

Store / Site / SAP Mapping

Links the three store identifiers used across systems: Store #, Site, and SAP Customer ID.

Proforma Order - Cards

Target-Down Allocation: Starts from Target UPCs, subtracts in-stock + on-order = Gap. Allocates Gap as SW % reorders (best sellers first, auto-expanding window) + remaining % new UPCs. SW/New split controlled by settings. Unsold-received items included as fill candidates.

Sites:
POG Selection: | |
+ days
+ % increase
Preferred SKU List:

Upload preferred UPCs/SKUs for a POG. Priority: 1. SW reorders, 2. Preferred list fills, 3. Other fills.

No proforma generated yet

Upload a CSV, configure settings, then click Generate Proforma.

On Hand Count by Site x POG - 72 UPCs per 4ft section

Shows how many in-stock UPCs each site carries per POG category

Upload a CSV to see capacity data

On Hand + On Order Count by Site x POG

Combines in-stock UPCs (from uploaded CSV) with on-order UPCs (from On Order tab). Shows total committed count per site x POG.

Upload a CSV to see combined data

Store Blueprint

No blueprint loaded

Internal footage model — target UPC counts by Store x POG. Upload to compare against current inventory from the Hallmark master report.

+
Drop Blueprint file here or click to browse

CSV or XLSX with Site, Store, POG and Target footage/UPC columns