How I read an Etsy order export in the browser without uploading it

说明与用途

该工具允许Etsy卖家在浏览器中本地分析订单导出，计算欧盟订单比例和包装需求，确保买家数据保密。

问题

Sellers needed to determine how many orders shipped to the EU for EPR compliance without exposing buyer addresses.

结果

The tool allows sellers to compute EU shipment share and packaging requirements locally, preserving buyer privacy.

工作流

• 1. Drop the Order Items CSV onto the eprkilo web page.
• 2. The page uses papaparse with a FileReader to parse the file client‑side.
• 3. Header names are matched case‑insensitively to locate required columns.
• 4. Rows are grouped by distinct Order ID to count orders and compute per‑order and per‑item packaging weights.
• 5. Sales totals are bucketed by currency code without conversion.
• 6. The UI shows the percentage of EU orders and total packaging weight.
• 7. No data is sent to the server except minimal counter pings (≤74 bytes).

证据

The page hands the File object to papaparse. Without a download option, papaparse reads it through a FileReader, so the bytes never become a request.

来源

The contents of the file never leave the browser.

来源

I wrapped this in a free page called eprkilo. You drop the Order Items file and the first screen shows what share of your orders went to the EU... The source is public under MIT, and I built it.

来源