Dashboard
Total SKUs
—
Warehouse Stock
—
units (0%+30%+100%)
Amazon FBA
—
units
Open POs
—
Unpaid Balance
—
USD (scheduled)
Pending Supplier Cost
—
still owed for stock at 0%/30%
Est. Shipping Pending
—
for stock at 100%, not yet shipped
| Date | SKU | Type | Qty |
|---|
| PO | Type | Due | USD |
|---|
Stock Levels
| SKU | Name | Mkt | Category | Color | Weight kg | 0% | 30% | 100% | 🏭 Warehouse | 📦 FBA | Total | Days Cover | Suggested Reorder |
|---|
Purchase Orders
| PO Number | Supplier | Date | Lines | Total USD | Remaining (Total) |
|---|
Shipping Invoices
Every shipping invoice must be tied to a Purchase Order — pick the PO first, then choose which line items (and how much of each) this shipment covers. Cost splits by weight automatically.
| Invoice # | PO | Date | Total USD | Weight kg | Allocated |
|---|
Amazon Reports
Manual entry until SP-API integration. Multi-currency supported with exchange rate conversion.
| Date | Mkt | SKU | Units | Revenue | Fees | FBA Fees | Net | Ccy |
|---|
Month-End Report
Finds the settlement period that was accumulating right up to the selected month's last day, then sums every Amazon transaction from that period's start through exactly 23:59 UTC on that day — reproducible any time you re-run this report, not just "whatever the balance is today." Requires Amazon Fulfillment role access to the Finances API.
Seller Central → Payments → Deferred Transactions → download the CSV, upload it here. This report only contains transactions not yet rolled into a closed settlement, so summing everything dated on or before month-end gives a reproducible historical open-balance figure. Each upload replaces the previous one.
| SKU | Name | Mkt | Category | 0% | 30% | 100% | 🏭 Warehouse | 📦 FBA | Cost USD | Value USD | Value EUR |
|---|
Exchange Rates
Month-end ECB rates (Jan–Apr 2026) can be imported via the SQL file. Live rates from open.er-api.com.
| From | To | Rate | Date | Source |
|---|
SKU Manager
Click weight field to edit inline| SKU | Name | Mkt | Category | Color | Weight (kg) | Cost USD | Last Shipping $/Unit | Active |
|---|
Amazon SP-API
| Mkt | Marketplace ID | Seller ID | Region | Refresh Token | Last Inventory Sync | Last Sales Sync |
|---|
Reconciles Amazon's real FBA quantities into your stock ledger as adjustment entries. Also auto-fills each SKU's ASIN, which the nightly sales-velocity cron needs for days-of-cover calculations.
| When | Type | Mkt | Status | Detail |
|---|