Operations · Data ingest
Upload Reports
Drop the weekly Fosdick lot report here. Add received-quantity numbers separately. The dashboard updates within seconds of saving.
1. Weekly Fosdick Inventory
Drop the Fosdick "Lot Report by Facility" Excel files here — both NV and CT can be selected at once. The tool parses lot codes, current stock, expiration, and status. This replaces the current snapshot.
No uploads yet — built-in snapshot in use.
2. Customer Addresses
Used for the "By City" view on the dashboard. Best source: Shopify → Customers → Export CSV. Then paste or upload a file with these columns:
Existing entries are kept — uploading new emails just adds them.
email,city,state (or email,city,state,country).Existing entries are kept — uploading new emails just adds them.
No addresses loaded yet.
3. Lot Received Quantities
Enter the received (opening) quantity per lot so we can compute shipped = received − in stock. Two ways:
A. Paste CSV with two columns:
B. Upload a spreadsheet — first column = lot code, second column = received qty
New entries merge with existing — uploading just one lot updates only that lot.
A. Paste CSV with two columns:
lot,received_qty (header optional)B. Upload a spreadsheet — first column = lot code, second column = received qty
New entries merge with existing — uploading just one lot updates only that lot.
No received quantities loaded yet.