Step 1: Configuration
Set Target Days of Stock by Vendor
Upload an inventory file to populate this section.
Step 2: Upload Data Files
The app automatically detects columns and aggregates stock from multiple locations (e.g., Warehouse + The Grove).
Step 3: Inventory by Location KPIs
Step 4: Suggested Purchase Order
Sales Analysis Period
Type:
| SKU | Product Type | Brand | Vendor | Product Name |
Stock
Stock on hand based on the selected location. 'All Locations' shows the consolidated total across all stores.
|
Days of Stock
'Current Stock' / 'Average Daily Sales'. This shows how many days your inventory will last based on recent sales.
|
Suggested Qty
The calculated quantity needed to reach your 'Target Days of Stock' goal. (Target Stock - Current Stock).
|
Vendor Set Sug. Qty
Suggested quantity based on preset days of stock for this specific vendor.
|
Final Order Qty |
|---|
Processing your data, please wait...