🚚 Deliveries & ASNs
Upload the supplier's packing list (PDF, Word or Excel), pick the PO and confirm — the ASN is created and confirmed in Ogdens for you, and booked against the PO when Ogdens receives it.
📦 Purchase orders
Import your Auroma PO Excel file — the Product, Oils and Labels sheets are all read.
| SKU | Product | Local Stock | Open POs | Supplier Stock | Total | Sales 7d | Sales 30d | ROS 60d | ROS 90d | ROS/day | Manual ROS | Lead Time | Local Cover | Total Cover | Required | Variance | Status |
|---|
PO Reference
Delivery date
Round qty to nearest
Oil blend %
%
% of a 100ml bottle that is fragrance oil
Oil qty rounding
Product qty recalculates from rounded oil
Import stock
This Month Baseline (£)
£
Enter this month's actual or target revenue · growth % compounds from here
This month growth vs current ROS
+
%
Month on month growth (compounds)
Safety stock (days)
Avg unit price (£)
Add New Supplier
Company name *
Address
Contact name
Phone
Email
Suppliers
Products & Oil Codes
Manage oil codes for both suppliers, choose the oil supplier and product filler per SKU, and add new products.
➕ Add new product
Product name *
SKU *
Oil code
Oil £/kg
Oil supplier
Product filler
Import oil codes
Paste one line per SKU: SKU, OIL CODE, COST/KG — comma or tab separated (copy straight from Excel). Cost is optional.
| SKU | Product | Total Stock | ROS/day | Lead Time | OOS In | Stock at Arrival | Total Cover | Required (inc. LT) | Shortfall | Urgency |
|---|
CSV Import
Upload a Shopify inventory export to update stock levels and sales data.
Steps
1
Shopify Admin → Products → Inventory2
Click Export → export inventory as CSV3
Upload file below — SKU + quantity auto-mapped📂
Click to upload inventory CSV
Columns: SKU, On Hand / Available / Quantity
Live Shopify Sync
Pulls live inventory + 30-day sales directly from the Shopify Admin API via the server backend. No CORS issues.
What gets synced
✓ Live stock levels per SKU (all Shopify locations)
✓ 7-day, 30-day, 60-day & 90-day order history
✓ Product titles from Shopify catalogue
✓ New SKUs added automatically
✓ 7-day, 30-day, 60-day & 90-day order history
✓ Product titles from Shopify catalogue
✓ New SKUs added automatically
API endpoints used
GET /api/products
GET /api/sales?days=7
GET /api/sales?days=30
GET /api/sales?days=60
GET /api/sales?days=90
GET /api/status
GET /api/sales?days=7
GET /api/sales?days=30
GET /api/sales?days=60
GET /api/sales?days=90
GET /api/status
Supplier Stock
Upload stock held at any external supplier or warehouse. Values add directly to your total stock and cover calculations.