Batch fulfillment view
Order CSV Pick and Pack Worksheet
Stop opening orders one by one to see what to pick. Group a plain Shopify order export into a per-order worksheet with items, quantities, fulfillment status, and shipping method.
Browser-side scan
Drop an order export for pick-pack
No CSV selected
Use this pick-pack worksheet generator when the Shopify admin orders page hides the actual ordered items and clicking into every order slows fulfillment. Upload a standard order export CSV and the tool groups line items by order, carries the order-level fulfillment status, shipping method, and a city-level destination onto every line, and flags missing SKUs or unparseable quantities that would slow a picker. The exported worksheet deliberately keeps only city, province, and country — no street addresses, customer names, or emails — so it can be printed or shared with warehouse staff. Everything is processed locally in your browser.
Import blockers
Common causes this scan checks
- The admin orders list shows totals but not the actual line items to pick.
- Opening hundreds of orders individually makes batch picking impractical.
- Line items without SKUs force pickers to guess which product variant to pull.
- Full order exports carry customer addresses that should not go to the warehouse floor.
Workflow
How to use the cleaned CSV
- Export orders from Shopify admin and upload the CSV here.
- Review findings for missing SKUs, missing quantities, and unfulfilled lines.
- Export the pick-pack worksheet grouped by order.
- Print or share the redacted worksheet and fulfill orders in batches.
Auto-fix policy
What the export can safely change
- Detects order name, line item name, SKU, quantity, fulfillment status, and shipping columns.
- Groups line items by order and carries order-level context onto every line.
- Reduces the destination to city, province, and country so street-level data stays out of the worksheet.
- Marks fulfilled, no-ship, and missing-SKU lines with explicit pick notes.
CSV example
CSV example: order export pick-pack worksheet
The worksheet keeps the order number, item, SKU, and quantity together with a city-level destination only — street address, customer name, and email never reach the pick list handed to warehouse staff.
Name,Fulfillment Status,Lineitem quantity,Lineitem name,Lineitem sku,Shipping Method,Shipping City,Shipping Country #1001,unfulfilled,2,Coffee Mug - Blue,MUG-BLUE,Standard,Berlin,DE
Order,Fulfillment status,Shipping method,Destination,Lineitem SKU,Lineitem name,Quantity,Line status,Pick note #1001,unfulfilled,Standard,"Berlin, DE",MUG-BLUE,Coffee Mug - Blue,2,,Pick
FAQ
Shopify CSV questions
Does the worksheet expose customer addresses?
No. It keeps only city, province, and country for routing context. Street addresses, names, and emails are never written into the export.
Which export does this work with?
Shopify's standard order export CSV, which carries one row per line item with Name, Lineitem name, Lineitem quantity, and fulfillment columns.
Can it mark orders as fulfilled in Shopify?
No. It is a read-only worksheet for picking and packing. Fulfillment still happens in Shopify admin or your shipping tool.
Is order data uploaded anywhere?
No. The export is parsed locally in your browser with the File API and nothing is stored or transmitted.
Feedback
How is this tool working for you?
Found a bug, a false alarm, or a missing check? Tell me — a human reads every note.