OQOrderQuill

Etsy order CSV workflow

Create Packing Slips From an Etsy Order CSV

Download the sold-order data you need, map Etsy receipt and item columns, and prepare a batch without sharing your Etsy password or installing a browser extension.

Receipt and item mappingConsolidated product quantitiesCustomer data stays in your browser

START HERE

Bring your order file

Processed locally
No account · Free up to 20 orders

Etsy sold-order mapping

Keep receipts, products, and buyer details together

Etsy reports can vary by locale and report type. Map the fields available in your download, then check personalization and gift details before printing.

01

Map the export you receive

Etsy export columns can vary by report and locale. OrderQuill suggests common receipt, buyer, quantity, title, SKU, and shipping fields, while still letting you choose every mapping.

02

Collect repeated products once

When the same SKU appears across several receipts, the pick list totals the quantity and keeps the related receipt numbers visible for the packing step.

03

Keep gifts and personalization visible

Map an available note or instruction column so packers can review important order details. Always confirm personalized options in the preview before printing.

Etsy CSV mapping

Find the receipt and item fields used for packing

Choose columns by what they mean in the report you downloaded. Fields that exist only for tax, payment, or marketplace accounting can remain unmapped.

Look for in your CSVMap to OrderQuillUsed for
Receipt ID, order ID, or transaction groupOrder IDGroups line items onto the correct Etsy packing slip
SKU, item number, listing title, or item titleSKU or Product nameIdentifies products and consolidates repeated items
Quantity or item quantityQuantityTotals the units required across the sold-order batch
Buyer or recipient plus available shipping fieldsCustomer and address fieldsCreates the recipient block when the report contains those values
Personalization, gift message, or buyer note when presentOrder noteSurfaces an available instruction for manual review

Not every Etsy download includes every personalization or shipping field. Compare customized orders with Shop Manager before sealing the package.

Platform workflow

From an Etsy spreadsheet to a pack-ready batch

Etsy provides downloadable CSV reports for sold transactions. Choose the report that contains the item, receipt, and shipping fields needed by your packing workflow.

Etsy official sold-transaction download guide ↗
  1. 01

    Download sold-order data

    Open Shop Manager and download the relevant sold-order CSV for the dates you plan to fulfill. Keep the original file as a reference instead of editing customer data by hand.

  2. 02

    Confirm receipt and item fields

    Upload the CSV, then map the receipt or order identifier, quantity, SKU or item title, buyer name, shipping address, and any instruction field available in that report.

  3. 03

    Review before printing

    Check missing SKUs, quantities, and addresses. Download the consolidated pick list first, then preview individual packing slips and select the correct paper size.

Questions, answered

Before you upload

Does this require my Etsy login?+

No. You download a CSV from Etsy and open it locally. OrderQuill does not ask for Etsy credentials or connect to the shop.

Will all Etsy personalization fields be included?+

Only fields present in the CSV can be mapped. Review the preview and the original Etsy order when a personalized item has details that are not included in the downloaded report.

Can multiple Etsy receipts be combined into one pick list?+

Yes. Matching SKUs or item names are aggregated while their receipt references remain visible.

Are buyer addresses uploaded to OrderQuill?+

No. CSV parsing and document creation run in the browser. Stripe receives payment details only when you choose a paid plan, not the order CSV.