Original
0
6-packs · all locations
Lemon
0
6-packs · all locations
Peach
0
6-packs · all locations
UNITS:
Post House Wines — edit stock
Post House Wines
Somerset West · click values to edit
Stock depth
Dispatch recommendation
Johannesburg — edit stock
Johannesburg
Gauteng · click values to edit
Log stock movement
Recent movements
| Date | Type | Flavour | Location | 6-pks | Notes |
|---|
Reorder thresholds & projected runout
| Flavour | In stock | Reorder at | Sales velocity | Projected runout | Status |
Velocity = 6-packs sold on manual invoices over the last 90 days. Runout projects current stock at that rate.
Financial summary
Total revenue (all invoices)
R0
Shopify revenue
R0
product subtotal · excl. shipping
Total canning costs (lifetime)
R0
Revenue by channel
| Channel | Revenue | % of total | Gross margin |
|---|
Monthly revenue trend
Margin analysis
Based on avg R16.17 cost/can
Top customers by invoiced revenue
| Customer | Invoices | Total spend |
|---|
Performance by channel
Retail stockists
R0
14.7% margin
Website / private
R0
41.7% margin
Retail stockist breakdown| Stockist | Outstanding | Invoiced | Collected | Invoices |
|---|
Website / private customers
Shopify orders
Import Shopify Orders
Export orders from Shopify as CSV (Orders → Export → All orders) and upload here weekly.
All Shopify orders — INV1001 to INV1042
| INV # | Shopify | Date | Customer | City | Items | Subtotal | Total | Status |
|---|
Canning costs — fully editable
Expense tracker
Canning & ProductionR0
MarketingR0
Transport / LogisticsR0
OtherR0
| Date | Category | Description | Amount (R) | |
|---|