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.

Источник