OQOrderQuill

Free CSV template

Free Order CSV Template for Pick Lists and Packing Slips

Start with a clean one-row-per-line-item example, or compare its fields with the order CSV your store already exports.

sample-orders.csv

Five line items across three example orders · no real customer data

Download CSV

Minimum required columns

OrderQuill only needs three fields to create a consolidated pick list. Packing slips become more useful as you add item and shipping details.

FieldRequired?ExampleUsed for
Order numberYesOQ-1001Grouping lines into one order
SKU or item nameYesMUG-SAGEGrouping products on the pick list
QuantityYes2Total units to pick
Item nameRecommendedStoneware mugReadable packing documents
Customer and addressOptionalJamie RiveraShip-to block on packing slips
Bin or locationOptionalA-03Faster warehouse picking

How to use the template

  1. Download and open the file in Excel, Numbers, Google Sheets, or another spreadsheet editor.
  2. Replace the sample rows while keeping one line per order item. Repeat the order number when an order has multiple products.
  3. Export as UTF-8 CSV, then open it in OrderQuill and confirm the suggested field mapping.

Your own headers are fine

You do not have to rename a working export. The mapper accepts different header names, and it remembers your choices on the current device.

Turn the completed CSV into warehouse documents

Use the CSV pick list generator to group matching SKUs and total quantities, or open the bulk CSV packing slip generator to print one A4 or 4 × 6 slip per order. Platform-specific exports can follow the Shopify CSV workflow, Etsy sold-orders workflow, or Whatnot Show Report workflow.