Read any useful headers
Map the names used in your export to OrderQuill fields. Common Shopify, Etsy, WooCommerce, and marketplace-style headers are suggested automatically.
CSV pick list generator
Create One Pick List From Every Order in Your CSV
Stop walking the same aisle for every order. OrderQuill combines repeated SKUs, totals the quantity to pick, and keeps the source orders visible for packing.
Free for up to 20 ordersGrouped by SKUOptional bin and vendor sorting
START HERE
Bring your order file
No account · Free up to 20 orders
Consolidated order picking
Collect each SKU once, then pack by order
Turn line-item rows from several customer orders into one practical warehouse list without losing the order references needed at the packing table.
Consolidate quantities
Repeated product lines are grouped by SKU so each item appears once with a total pick quantity and its related order numbers.
Pick, check, and pack
Use printable checkboxes at the packing table or export the normalized pick list CSV for a warehouse workflow.
Pick-list fields
A useful pick list starts with three mappings
Order ID, quantity, and a SKU or product name are enough to consolidate the batch. Location and vendor fields improve the picking order when your source file includes them.
| Look for in your CSV | Map to OrderQuill | Used for |
|---|---|---|
| Order number, order ID, receipt ID, or sale ID | Order ID | Keeps the source orders visible beside each consolidated product |
| SKU, variant SKU, item code, or product name | SKU or Product name | Defines which line-item rows should be grouped together |
| Quantity, qty, units, or line-item quantity | Quantity | Adds the required units across every order in the batch |
| Bin, shelf, aisle, or warehouse location | Bin location | Sorts the pick list into a faster warehouse route |
| Vendor, supplier, brand, or maker | Vendor | Keeps a useful sourcing or zone reference beside each item |
OrderQuill groups by normalized SKU when one is mapped. If no SKU exists, it uses the product name, so consistent product naming becomes important.
Questions, answered
Before you upload
What is a consolidated pick list?+
It groups matching SKUs across all orders and totals their quantities, so you can collect each product in one pass before packing individual orders.
Can I include warehouse bins?+
Yes. Map an optional bin or location column and it will appear beside each SKU in the pick list.
Will rows with the same SKU be combined?+
Yes. Quantities for the same normalized SKU are summed while the original order references remain visible.
Can I download the result?+
Yes. The consolidated pick list and the validation report can be downloaded as CSV files.