Consolidate the whole batch
A Shopify export lists every line item separately, so the same SKU can appear on a dozen rows. The pick list merges them into one line with a total quantity — one walk around the shelves instead of twelve.
Shopify orders CSV workflow
Create a Pick List From a Shopify Orders CSV
Export orders from Shopify, map the product and quantity columns, and generate one consolidated pick list for the shelves plus a packing slip per order — no app on your store.
Consolidated pick list per batchOne packing slip per orderNo Shopify app or login required
START HERE
Bring your order file
No account · Free up to 20 orders
Shopify export mapping
Keep line items, quantities, and SKUs together
Shopify order exports put each line item on its own row. Map the fields once and the generator handles the grouping and the totals.
Keep order references visible
While consolidating, the pick list keeps each SKU’s order numbers attached, so a picker can trace any line back to the orders it serves.
Split back into packing slips
After picking, the generator splits the same upload into one packing slip per order with the ship-to address and line items pre-filled — the second half of the pick-and-pack workflow.
Shopify CSV mapping
Find the product and quantity fields used for picking
Shopify order export columns vary by template. Choose the column that represents each packing concept; financial columns such as taxes and payment status can stay unmapped.
| Look for in your CSV | Map to OrderQuill | Used for |
|---|---|---|
| Name, order number, or order ID | Order ID | Groups line items per order and powers the consolidated totals |
| SKU, variant SKU, lineitem sku, or product title | SKU or Product name | Consolidates matching products on the pick list |
| Lineitem quantity or variant inventory quantity | Quantity | Totals the units to pick for each SKU |
| Shipping name, shipping street, shipping city and related fields | Customer and address fields | Builds the ship-to block on each packing slip |
| Notes, note attributes, or tags when present | Order note | Surfaces gift messages and packing instructions on the slip |
Unfulfilled line items and partially refunded orders behave differently across Shopify export templates. Compare the pick list totals against the Shopify Orders screen before packing.
Platform workflow
From a Shopify export to a picked-and-packed batch
Shopify exports order data as CSV from the admin on the web. Choose an export that includes the line-item and shipping fields your workflow needs.
Shopify official order export instructions ↗- 01
Export the orders
In Shopify admin, open Orders, filter to the batch you plan to fulfill, and export the CSV with line-item fields included.
- 02
Map the picking fields
Upload the CSV, then map the order identifier, SKU or product title, quantity, and the shipping name and address fields available in your export.
- 03
Pick, then pack
Print the consolidated pick list and collect the goods, then print the per-order packing slips and check off each box as it is sealed.
Questions, answered
Before you upload
How do I create a pick list in Shopify?+
Shopify has no built-in consolidated pick list. Export the orders you plan to fulfill as CSV, upload it to OrderQuill, and it builds a pick list with total quantities per SKU plus one packing slip per order — free, with no app installed on your store.
Do I need to install a Shopify app?+
No. OrderQuill reads the CSV you export from Shopify. Nothing is installed, no Shopify login is shared, and no store permissions are granted.
Will it handle draft orders and unfulfilled items?+
It handles whatever rows the export contains. Filter your Shopify export to the orders you intend to pack, and compare totals against the admin screen before picking.
Is my store data uploaded to OrderQuill?+
No. The CSV is parsed locally in your browser; the picking and slip generation never send your order data to a server.