Generate pick list
generate_pick_listUse this when the user wants a pick list or picking list ("pick list template", "warehouse pick list", "how many of each SKU do I need for these orders") from several orders, without packing slips. Convert pasted text or an image of orders into order objects, or pass the attached Shopify, Etsy, WooCommerce or Amazon order export. Adds up the quantity of each SKU (or item name and variant when there is no SKU) across all orders, sorted by bin location then SKU, with the orders that need each one and a tick box, as a PDF and CSV. Whole-number totals; lines with a missing or odd quantity are flagged. Does not check stock levels or change orders in the store; for packing slips use generate_packing_slips.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | No | Optional order export: CSV, TSV or Excel .xlsx from Shopify (Orders export), Etsy (Order Items), WooCommerce or Amazon (unshipped orders report), or any sheet with order, ship-to, SKU, item and quantity columns, e.g. orders_export.csv. | |
| sheet | No | Excel sheet to read, e.g. Orders. | |
| orders | No | The orders, one slip each. Convert what the user pasted or showed in an image into order objects first, e.g. [{"order_number":"1001","ship_to":{"name":"Jane Smith","address1":"123 Main St","city":"Springfield","state":"IL","zip":"62704"},"items":[{"sku":"MUG-BL","name":"Blue mug","qty":2}],"gift_message":"Happy birthday"}]. Pasted export CSV text with its header row also works. | |
| columns | No | Column mapping when headings are unusual, field to heading, e.g. {"order":"Ref","qty":"Pcs","sku":"Code"}. Fields: order, date, name, address1, address2, city, state, zip, country, item, variant, sku, qty, price, notes, gift, method, location. | |
| page_size | No | letter (default) or a4. | |
| home_country | No | Country you ship from, e.g. US. Only affects how addresses are read. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| notes | Yes | ||
| units | Yes | ||
| orders | Yes | ||
| source | Yes | ||
| assumed | Yes | ||
| problems | Yes | ||
| downloads | Yes | ||
| file_name | Yes | ||
| pick_list | Yes | ||
| sku_lines | Yes | ||
| item_lines | Yes | ||
| pick_pages | Yes | ||
| pick_list_count | No | ||
| links_expire_minutes | Yes | ||
| orders_with_problems | Yes |