⚠️ Packaging Issue Alert — Top Priority
77 rejects across 49 unique SKUs flagged via Agent Comments (seal open/broken, damaged packaging, open box, torn). No formal Return Dept. reason code — re-classified from Agent Comments.
Total Rejects
458
All actions this period
Reject & Refund
435
95.0% of rejects
Reject & Replace
22
4.8% of rejects
Packaging Issues
77
49 unique SKUs · #3 reason
Total Value ($)
13,551
Cost to company
Daily Reject Volume
Reject Reasons

🏆 Top Rejected Items by Value (High → Low)

Click any card to view on shoplc.de

📋 All Packaging Issue SKUs

77 rejects · 49 SKUs
#SKUDescription ↕CategoryRejects ↕
Rejects by Product Category
Top Agents by Volume
#AgentCount
⚠️ Priority Actions — 1 May 2026
🟡 0 courier emails sent today — overdue task handles courier outreach — cooldown active until 02 May 2026 (3-day rule from 29 Apr sends).
🔴 1 parcel in Warehouse Investigate (Beschädigte Sendung — destroyed by courier) — see Warehouse Investigate tab for action required.
🟠 6 open courier replies — see Courier Replies & Actions tab; invoices owed for DP02-78252518 & DP02-78265003.
240 returns in transit feed — auto-pulled from DE IT Support CSV (Apr 30 snapshot).
Returns Pending
240
of 26,694 initiated · ⚠️ Active: 212
Parcels Delayed
14
Need courier email per SOP today
Emails Sent Today
14
Sent to DHL/DPD this morning
Warehouse Investigate
1
Claim Required (Beschädigte Sendung)
CS Team Handover
0
SOP Group B — anomaly cases

📦 Parcel Tracker — 1 May 2026

Source: DE IT Support Courier Reports · 1:30 AM
Ref / Tracking No.InvoiceDispatchCourierStatusValue €GroupActionEmail Status
Ref / Tracking No.InvoiceDispatchCourierStatusValue €ActionEmail Status
Ref / Tracking No.InvoiceDispatchCourierStatusValue €Reason
Ref / Tracking No.InvoiceDispatchCourierStatusValue €Action
Ref / Tracking No.InvoiceDispatchCourierStatusValue €ActionEmail Status
ℹ️ These parcels are within SOP threshold (day 4–5 of 5). Monitor daily — email courier if no movement by tomorrow.
Ref / Tracking No.InvoiceDispatchCourierStatusValue €Action
🔴 Warehouse Investigate — No Courier Emails Sent
These parcels require internal verification before any courier contact. High value parcels (>€500) or status "Auftragsdaten" suggest parcel may not have been physically handed over.
Auftragsdaten >48h
0
See SOP Group A · Email Courier Now
Value >€500
0
Not tracked in current feed
Deadline TODAY
1
🚨 CLAIM REQUIRED — file today
⚠️ Overdue Returns — Initiated >7 Days Ago, Still Not Received (25 parcels — Courier inquiry sent 30 Apr 2026)
🔴 2026-03-31 — 2 DPD returns (30 days) — Not collected from ParcelShop
🔴 2026-04-01 — 3 returns (29 days) — 1 DPD + 2 DHL
🔴 2026-04-08 — 2 DPD returns (22 days) — Not collected from ParcelShop
🔴 2026-04-10 — 3 DPD returns (20 days) — Not collected from ParcelShop
🔴 2026-04-13 — 2 returns (17 days) — 1 DPD + 1 DHL (Export-Paketzentrum)
🔴 2026-04-14 — 1 DHL return (16 days) — Beschädigte Sendung entsorgt ⚠️
🔴 2026-04-15 — 1 DPD return (15 days) — Not collected from ParcelShop
🔴 2026-04-17 — 1 DPD return (13 days) — Not collected from ParcelShop
🔴 2026-04-20 — 3 returns (10 days) — 2 DPD + 1 DHL
🔴 2026-04-21 — 1 DHL return (9 days) — Sendung in Bearbeitung
🔴 2026-04-22 — 6 returns (8 days) — 3 DPD + 3 DHL
Total Pending Delivery
240
Returns in transit to warehouse
Overdue (>7 Days)
14
0 DPD + 14 DHL · per SOP threshold
Total Returns Initiated
26,694
All time (since Mar 30)
Pending Rate
0.9%
240 of 26,694 still in transit
Yesterday's Returns
118
Initiated Apr 30 · in transit

🔴 Overdue Returns (>7 Days) — Individual Tracking Numbers

Courier automation email sent daily · Updated 01 May 2026
⚠️ These return shipments have been in transit for more than 7 days and have not arrived at the warehouse. A courier inquiry email is automatically sent each morning.
Tracking No. Return Init Date Days in Transit Last Known Status Courier Email Sent

📦 Return Pending Delivery — Breakdown by Initiation Date

Source: DE IT Support · Auto-generated daily · 30 Apr 2026
Return Initiation Date Days Ago Total Returns Initiated Pending Delivery % Pending Status
Loading live data from Google Sheets…
Grand Total Backlog
Ongoing + Pending parcels
🟡 Ongoing
Loading…
🔵 Pending
Loading…
DPD Total
DHL DE Total
Courier Split — Ongoing + Pending
Total: parcels
DPD
DHL
DPD:
DHL DE:

🟡 Ongoing — Loading…

Not yet received at warehouse
Date Weekday DPD Parcels DHL DE Parcels Day Total Status

🔵 Pending — Loading…

Awaiting warehouse receipt
Date Weekday DPD Parcels DHL DE Parcels Day Total Status
📊 Source: Return Backlog Tracker (Google Sheets) · Last updated: 01 May 2026 · Only Ongoing and Pending rows shown — Completed rows excluded

🔴 Priority Actions for Gabriel

Updated by daily briefing task
No priority actions logged yet — runs after morning briefing task.

📬 Courier Replies Log

Source: Outlook inbox · Daily briefing task
Date Courier Tracking No. Agent / Ticket Summary Action Required Status
No courier replies logged yet.