Loading DHL data…
Time horizon:
From
to
Overview
By country
By month
Weight & products
Duties
Order details
Monthly cost trend total ex VAT, stacked by row type
Cost components share of total
Top 5 destinations by total cost
Top 10 destinations by cost
All countries click headers to sort
| Country | Parcels | Shipping £ | Duties £ | Total £ | Avg shipping/parcel £ | Avg duties/parcel £ | Avg kg/parcel | Avg order ex VAT £ | Shipping % of order |
|---|
Month-on-month by country total ex VAT per month, with change vs previous month
Monthly spend trend
Monthly breakdown MoM Δ in last column
| Month | Parcels | Shipping £ | Duties £ | Total £ | Avg/parcel £ | MoM Δ | Avg order ex VAT £ | Shipping % of order |
|---|
Parcels by weight band
By product type
Weight band detail
| Weight band | Parcels | Total cost £ | Avg cost £ | £/kg |
|---|
Duties & taxes by month
Top countries by duties paid
| Country | Duty rows | Total duties £ | Avg per row £ |
|---|
Order details one row per shipment · first 500 of 0 matching · DHL duties auto-merged via Shipment #
How to read Net shipping %: (DHL shipping cost − customer paid) ÷ order ex VAT
Order ex VAT = product revenue only (customer's shipping payment AND duties excluded).
● Positive % = Skin Cupid loses on shipping (DHL cost exceeds what the customer paid)
● Negative % = Skin Cupid profits on shipping (customer paid more than the DHL cost)
● 0% = breakeven
Order ex VAT = product revenue only (customer's shipping payment AND duties excluded).
● Positive % = Skin Cupid loses on shipping (DHL cost exceeds what the customer paid)
● Negative % = Skin Cupid profits on shipping (customer paid more than the DHL cost)
● 0% = breakeven
| Month | Ship Date | Order Ref | Country | City | Weight | DHL £ ex VAT | DHL duties £ | Order ex VAT | Customer paid ship | Customer paid duties | Net shipping % |
|---|
Loading DPD data…
Time horizon:
From
to
Overview
By country
By month
By service
Order details
Monthly cost trend total ex VAT
Service mix share of total spend
Top 5 destinations by total cost
Top 10 destinations by cost
All countries
| Country | Parcels | Total £ | Avg/parcel £ | Avg kg | Avg order ex VAT £ | Shipping % of order | % of total |
|---|
Monthly spend trend
Monthly breakdown MoM Δ in last column
| Month | Parcels | Total £ | Avg/parcel £ | MoM Δ | Avg order ex VAT £ | Shipping % of order |
|---|
Parcels by service
Spend by service
Service detail
| Service | Parcels | Total £ | Avg/parcel £ | Avg kg |
|---|
Order details one row per parcel · first 800 of 0 matching
How to read Net shipping %: (DPD shipping cost − customer paid) ÷ order ex VAT
DPD £ ex VAT = shipping only (customs duties excluded). Order ex VAT = product revenue only (customer's shipping payment AND duties excluded).
● Positive % = Skin Cupid loses on shipping (DPD cost exceeds what the customer paid)
● Negative % = Skin Cupid profits on shipping (customer paid more than the DPD cost)
● 0% = breakeven
⚠ RTC parcels (returns to warehouse, Sender = "RTC WND") have no Shopify order ref by design.
DPD £ ex VAT = shipping only (customs duties excluded). Order ex VAT = product revenue only (customer's shipping payment AND duties excluded).
● Positive % = Skin Cupid loses on shipping (DPD cost exceeds what the customer paid)
● Negative % = Skin Cupid profits on shipping (customer paid more than the DPD cost)
● 0% = breakeven
⚠ RTC parcels (returns to warehouse, Sender = "RTC WND") have no Shopify order ref by design.
| Ship Date | Service | Order Ref | Country | Weight | DPD £ ex VAT | DPD duties £ | Order ex VAT | Customer paid ship | Customer paid duties | Net shipping % |
|---|
Loading Royal Mail data…
Time horizon:
From
to
Overview
By month
By service
By channel
By country
Order details
Monthly cost trend total est. ex VAT, stacked by service
Service mix share of total spend
Top channels by parcel count
Monthly spend trend
Monthly breakdown MoM Δ in last column
| Month | Parcels | Est. Net £ | Est. Gross £ | Avg £/parcel | MoM Δ |
|---|
Parcels by service
Spend by service
Service detail
| Service | Code | Parcels | Est. Net £ | Est. Gross £ | Avg £/parcel |
|---|
Parcels by channel
Channel detail
| Channel | Parcels | Est. Gross £ | Avg £/parcel | % of total |
|---|
How country is determined:
● Tracked 24 / Tracked 48 (TPS / TPN) are UK-only — always shown as UNITED KINGDOM
● International (MP7) — derived from the matched Shopify order's shipping address
● Unknown — international parcels with no Shopify match (e.g. In Store, Unleashed Warehouse Transfer)
● Tracked 24 / Tracked 48 (TPS / TPN) are UK-only — always shown as UNITED KINGDOM
● International (MP7) — derived from the matched Shopify order's shipping address
● Unknown — international parcels with no Shopify match (e.g. In Store, Unleashed Warehouse Transfer)
Top 10 destinations by parcels
International only excludes UK domestic for clarity
| Country | Parcels | Est. Gross £ | Avg £/parcel | % of intl |
|---|
All countries including UK domestic
| Country | Parcels | Est. Gross £ | Avg £/parcel | % of total |
|---|
What makes up the cost contracted rate versus what Royal Mail actually bills
Order details one row per parcel · first 800 of 0 matching
Cost basis: Royal Mail prices are flat per service/weight band, so we apply the OBA-derived monthly average rate per parcel. Total reconciles to actual OBA spend within ~1-2%.
How to read Net shipping %: (RM cost − customer paid) ÷ order ex VAT
● Positive % = Skin Cupid loses on shipping ● Negative % = Skin Cupid profits on shipping ● 0% = breakeven
⚠ Non-Shopify channels (In Store, Unleashed Warehouse Transfer) have no Shopify order match by design.
How to read Net shipping %: (RM cost − customer paid) ÷ order ex VAT
● Positive % = Skin Cupid loses on shipping ● Negative % = Skin Cupid profits on shipping ● 0% = breakeven
⚠ Non-Shopify channels (In Store, Unleashed Warehouse Transfer) have no Shopify order match by design.
| Despatch Date | Service | Channel | Country | Order Ref | Tracking | RM £ ex VAT | Order ex VAT | Customer paid ship | Customer paid duties | Net shipping % |
|---|
Loading overhead invoices…
Time horizon:
Source: Fixed Overheads Ledger
Monthly spend by vendor stacked, net £
Vendor breakdown sorted by total spend
| Vendor | Category | Invoices | Total £ | Avg / month £ | Last invoice |
|---|
Loading LCS Cleaning invoices…
Monthly trend net £ vs threshold
Invoices most recent first
| Invoice date | Service period | Invoice # | Net £ | VAT £ | Gross £ | Notes |
|---|
Loading Badger data…
monthly cost USD, stacked by category
cost per order variable versus all-in
Variable is courier, fulfilment, returns and duties — the cost of shipping one more order. All-in divides the whole bill, storage and tech fee included, across the orders shipped. When volume falls the two diverge sharply, which says something about volume rather than about Badger's pricing.
monthly detail partial months are marked
| Month | Weeks | Orders | Storage $ | Courier $ | Fulfilment $ | Goods in $ | Returns $ | Duties $ | Other $ | Total $ | Variable $/order | All-in $/order |
|---|
weekly bills storage is billed monthly, so it lands on one week in four
All-in cost per order is deliberately not shown here. Storage arrives on a single week each month, so a weekly all-in figure swings between roughly $11 and $34 purely on whether storage fell in that week. Use the monthly view for all-in cost; the weekly variable figure is comparable week to week.
| Week | Receipt | Orders | Storage $ | Courier $ | Fulfilment $ | Goods in $ | Returns $ | Duties $ | Other $ | Total $ | Variable $/order |
|---|
order details one row per fulfilled order · 0 orders
Storage and the tech fee carry no order reference on the invoice, so they cannot appear here. A row is what Badger charged to move that specific order.
| Date | Order | Units | Courier $ | Fulfilment $ | Returns $ | Duties $ | Total $ | US goods £ | US delivery paid £ |
|---|
Loading Ellgia invoices…
Monthly trend net £ vs threshold
Invoices most recent first
| Invoice date | Service period | Invoice # | Net £ | VAT £ | Gross £ | Notes |
|---|
Loading Stacatruc invoices…
Monthly trend net £ vs threshold
Invoices most recent first
| Invoice date | Service period | Invoice # | Net £ | VAT £ | Gross £ | Notes |
|---|
Loading EE invoices…
Monthly trend net £ vs threshold
Invoices most recent first
| Invoice date | Service period | Invoice # | Net £ | VAT £ | Gross £ | Notes |
|---|
Loading Water Plus invoices…
Monthly trend net £ vs threshold
Invoices most recent first
| Invoice date | Service period | Invoice # | Net £ | VAT £ | Gross £ | Notes |
|---|
Loading Eon invoices…
Monthly trend net £ vs threshold
Invoices most recent first
| Invoice date | Service period | Invoice # | Net £ | VAT £ | Gross £ | Notes |
|---|
Overall operations cost — coming soon
Combines all suppliers once each module is live.
Loading courier data…
Courier
Flag above
Group by
Min parcels
How this works. For each destination it takes the effective cost per parcel each month — shipping only, duties and admin fees excluded — and compares it against the median of the previous three months with enough volume. A month is flagged when it moves more than the threshold.
Read the weight column before acting. A rate can look like it jumped when parcels simply got heavier. Where average weight moved more than 15%, the row is marked mix: the cause is likely what you shipped, not what you were charged. Rows marked rate had stable weights, so the change is in the pricing.
Read the weight column before acting. A rate can look like it jumped when parcels simply got heavier. Where average weight moved more than 15%, the row is marked mix: the cause is likely what you shipped, not what you were charged. Rows marked rate had stable weights, so the change is in the pricing.
Effective rate £ per parcel per month · shading marks where the price stepped
Time horizon:
From
to
unchanged
stepped up
stepped up sharply
stepped down
service changed
blank = too few parcels to average
Flagged changes largest movements first · 0 found
| Destination | Month | Baseline £/parcel | Actual £/parcel | Change | Parcels | Avg weight | Weight change | Cause |
|---|
Loading courier data…
Comparing
→
You control these
Shipping
—
—
—
Carrier contract · switch lane or renegotiate
DDP admin fee
—
—
—
Carrier handling charge · DHL £5/parcel · DPD prepaid admin · RM 50p
Fixed by regulation
Customs duty
—
—
—
EU Reg 2026/382 · €3 per HS6 subheading
Recovered at checkout
—
—
—
Customer-paid duty · offsets the line to the left
All-in EU cost
—
—
All-in per parcel
—
—
EU parcels
—
—
Cost mix the three streams drawn to scale — bar width is total spend
Shipping
DDP admin fee
Customs duty
Three things changed on 1 July 2026.
EU Regulation 2026/382 introduced a €3 duty per unique HS6 subheading, EU shipments moved to DDP, and some lanes switched carrier.
The regulation created the duty cost whichever Incoterm you ship on — DDP changed who pays it, and carrier switching is where money was saved.
That is why the three streams are never added into one “cost” figure.
Basis. Parcels are counted in the month they were despatched, for all three couriers — not the month the courier invoiced them. DHL invoices can fall in the month after despatch, so an invoice-month view would put pre-1-July shipments in July.
Customs duty is provisional and understated. Only DHL bills identifiable customs duty. DPD’s charge is a prepaid admin fee, booked above; their customs billing has not been located. Royal Mail duty billing has not been identified at all. Treat customs duty as a floor and accrue for duty collected from customers but not yet invoiced by a carrier.
Basis. Parcels are counted in the month they were despatched, for all three couriers — not the month the courier invoiced them. DHL invoices can fall in the month after despatch, so an invoice-month view would put pre-1-July shipments in July.
Customs duty is provisional and understated. Only DHL bills identifiable customs duty. DPD’s charge is a prepaid admin fee, booked above; their customs billing has not been located. Royal Mail duty billing has not been identified at all. Treat customs duty as a floor and accrue for duty collected from customers but not yet invoiced by a carrier.
Carrier switch impact what the parcels routed to DPD would have cost on DHL
| Country | DPD parcels | DPD shipping | DHL shipping | DHL admin fee | Avoided | Per parcel |
|---|
By country three streams per destination, Month B
| Country | Parcels | Shipping | Admin fee | Customs duty | Recovered | Net duty | Status |
|---|
Checkout collection Month B orders — are we charging the customer duty at all?
| Country | Orders | Charged duty | Rate | Avg when charged | Action |
|---|
Loading courier data…
Time horizon:
From
to
Courier rate comparison your rate cards × avg parcel weight per destination
Click to re-pull DHL / DPD / Royal Mail data from Google Sheets
Updating rate cards when new rates arrive (annual contract / renegotiation)
1. Gather the files — collect the latest DHL, DPD and (when available) Royal Mail rate cards in Excel format (same format as the originals — DHL’s GB myDHLi-style workbook, DPD’s per-service tabs workbook).
2. Send to Claude — open a new Claude chat, upload all the XLSX files, and say: "Add these as the new rate card year for the Skin Cupid Ops portal." Claude will extract them into the same JSON structure and produce a patched portal build.
3. Deploy the new build — drop the new index.html into Cloudflare Pages, hard-refresh. The year dropdown above will now offer the new year alongside 2026, so you can A/B compare.
4. (Optional) Add side-by-side year-on-year comparison — once two years of rate cards are live, ask Claude to add a YoY column to the rate comparison table showing the rate change per country.
The current cost (left column) updates whenever you hit Refresh — it reads from Google Sheets where your monthly invoice consolidations land. Only the rate-card prices need this manual swap when contracts change.
1. Gather the files — collect the latest DHL, DPD and (when available) Royal Mail rate cards in Excel format (same format as the originals — DHL’s GB myDHLi-style workbook, DPD’s per-service tabs workbook).
2. Send to Claude — open a new Claude chat, upload all the XLSX files, and say: "Add these as the new rate card year for the Skin Cupid Ops portal." Claude will extract them into the same JSON structure and produce a patched portal build.
3. Deploy the new build — drop the new index.html into Cloudflare Pages, hard-refresh. The year dropdown above will now offer the new year alongside 2026, so you can A/B compare.
4. (Optional) Add side-by-side year-on-year comparison — once two years of rate cards are live, ask Claude to add a YoY column to the rate comparison table showing the rate change per country.
The current cost (left column) updates whenever you hit Refresh — it reads from Google Sheets where your monthly invoice consolidations land. Only the rate-card prices need this manual swap when contracts change.
Duty handling:
USA + Canada — Skin Cupid pays duties (DDP); Europe — IOSS or customer pays. DDP fee applied to DPD prices for USA/CA. DT1 is informational — only relevant where pre-clearance is used.
Current avg £: Shipping cost only — duties paid by Skin Cupid (US/Canada) are excluded so the figure is comparable to rate card prices.
Royal Mail International rate: Shown as actual avg £/parcel from your shipped data (rate card pending). "—" means no RM shipments to that country in this period.
Weight: Avg parcel weight per country; rates rounded up to next weight band.
Transit times: Indicative working days based on each courier’s published guidance — confirm with your account managers for contractual SLAs. DHL varies by destination zone; DPD by chosen service.
Recommendation logic: ★ in the DPD column marks the best-value service (fastest within £2 of the cheapest). The “Cheapest” column only considers options whose transit is within +3 days of the current courier — so a 10-day service won’t be recommended over a 2-day one just on price. DPD options exceeding that band are dimmed.
Current avg £: Shipping cost only — duties paid by Skin Cupid (US/Canada) are excluded so the figure is comparable to rate card prices.
Royal Mail International rate: Shown as actual avg £/parcel from your shipped data (rate card pending). "—" means no RM shipments to that country in this period.
Weight: Avg parcel weight per country; rates rounded up to next weight band.
Transit times: Indicative working days based on each courier’s published guidance — confirm with your account managers for contractual SLAs. DHL varies by destination zone; DPD by chosen service.
Recommendation logic: ★ in the DPD column marks the best-value service (fastest within £2 of the cheapest). The “Cheapest” column only considers options whose transit is within +3 days of the current courier — so a 10-day service won’t be recommended over a 2-day one just on price. DPD options exceeding that band are dimmed.
| Country | Parcels | Avg weight | Current avg £ shipping only |
DHL £ | DPD £ | RM £ | Cheapest | Saving/parcel | Annual saving | Duty |
|---|
— = no rate available (courier doesn’t serve that country, or weight exceeds limit). Rows sorted by annual saving descending. Switching only recommended if saving >£2/parcel and ≥5 parcels in period.
Switch opportunities countries where an alternative is cheaper than current
No switches recommended.
Every country is already on the cheapest viable courier given transit constraints.
| Country ⇅ | Parcels | Currently using | Switch to | Saving/parcel ⇅ | Annual saving ↓ |
|---|
Loading all courier data…
Time horizon:
From
to
Spend by courier monthly trend, stacked
Courier comparison cost per parcel and total
| Courier | Parcels | % of parcels | Total spend £ | % of spend | Avg £/parcel |
|---|
Spend share
Country spend & margin all couriers combined, sortable
Status flags: 🟢 Healthy (shipping <25% of revenue) ·
🟡 Watch (25-40%) ·
🔴 Loss-making (>40%)
Note: Order revenue requires Shopify sync. Royal Mail country requires Shopify match (UK domestic is hardcoded).
Note: Order revenue requires Shopify sync. Royal Mail country requires Shopify match (UK domestic is hardcoded).
| Country | Total parcels | DHL | DPD | RM | Total £ | Avg £/parcel | Order rev £ | Customer paid £ | Shipping % of rev | Status |
|---|
These are real shipments without a matched Shopify order, so revenue and margin can’t be calculated.
Usually means the order ref on the shipment didn’t resolve to a Shopify order (legacy data, B2B orders not in Shopify, or unsynced).
| Country | Total parcels | DHL | DPD | RM | Total £ | Avg £/parcel |
|---|
⚠️ Loss-making destinations countries where shipping cost exceeds 40% of order revenue
Settings
Published Google Sheet CSV. Default is the Skin Cupid DHL Analytics Data sheet.
Published Google Sheet CSV. Default is the DPD Consolidated sheet built by the Apps Script.
Published Google Sheet CSV. Default is the Royal Mail Consolidated sheet built by the Apps Script.
Published Google Sheet CSV. From the Fixed Overheads Ledger workbook: File → Share → Publish to web → Ledger tab → CSV.
Badger Fulfillment workbook → Weekly tab → File → Share → Publish to web → CSV.
Same workbook, Orders tab. Optional — leave blank and the order detail view stays empty.
The Cloudflare Worker that proxies to Shopify Admin API. The token never touches the browser.
Shopify order sync cross-reference DHL parcels with Shopify order values
Loading status…
How it works: The portal loops through each month of your courier data (DHL, DPD, Royal Mail), fetches all Shopify orders from your Worker, and caches them in your browser's IndexedDB. Once cached, the portal matches each DHL parcel to its Shopify order to compute average order value and shipping cost as a percentage of order value.
First sync may take 2–5 minutes depending on order volume. After that, only re-sync if data changes.
First sync may take 2–5 minutes depending on order volume. After that, only re-sync if data changes.