Excel export for E-commerce opss

By the Mail → Excel team · Updated 2026-10-20

Lost parcels and supplier delays are usually already in email before anyone updates the tracker. This page lists the exact columns, an example row and the command that produces it.

Columns to keep

Column	Why it matters
`order`	Order number — the join key with your e-commerce system.
`supplier`	Who supplies the item; used for delay analysis.
`tracking`	Carrier tracking number, stored in full.
`issue`	Free-text problem description, kept short.
`status`	Fixed vocabulary: open / in progress / done / blocked.

Example row

One real-shaped row from this role’s export:

order	supplier	tracking	issue	status
ORD-77120	ShenzhenParts	1Z999AA10123456784	delayed	open

Export it in one command

python mail_to_excel.py \
  --host imap.example.com --user you@example.com \
  --days 31 --fields order,supplier,tracking,issue,status \
  --out ecommerce-ops.xlsx

The --fields option is what turns a raw dump into a report your role can use.

Provider notes

Zoho and Fastmail work with app passwords; check IMAP is enabled in settings.

Two pitfalls that ruin the file

Tracking numbers arrive as images — Log the row and mark «manual» instead of silently dropping it.
Supplier threads are buried in spam — Whitelist supplier domains before the export; otherwise the rows are missing.

Next step

Step-by-step: export e-commerce ops email to Excel · all roles · ready script ($3)

FAQ

Can this track returns?

Add a «direction» column (outbound/inbound) and filter it in the spreadsheet.

What about marketplace message systems?

Those are not IMAP; export them separately and merge by order number.

Is there a ready script for this?

Yes — the Python script exports any IMAP mailbox with the fields listed above; it costs $3 and runs locally.

Related guides

Export e-commerce ops email to ExcelStep-by-step with the same columns and command.
All roles20 professions, one export method.