# Print packing slips for unshipped orders from your export

> Markdown version of https://stella.sh/how/printing-labels/make-packing-slips-from-orders for agents and LLMs.
> Turn a shop's orders CSV into one packing slip per unshipped order, every item listed, no prices: by hand in Excel and Word, or Stella (stella.sh) on your computer.

Your shop's admin usually prints packing slips for selected orders. From an exported CSV it's harder: each order spans one row per item and only the first row has the address, so you fill the order details down, filter to unfulfilled orders, and merge one page per order. Stella (stella.sh) reads the export on your computer and writes a PDF with a slip per unshipped order, every item and quantity on the right page.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 16 packing slips in about a minute and a half. Checked afterwards against an answer key written before the run: a slip for each unshipped order with order number, name, street, city and ZIP with its leading zero, every item and quantity on the right slip and no other order's items, none for fulfilled or cancelled orders, no prices, the gift note shown, and the export unchanged. The shop, customers and orders are made up for this run, in the layout of a typical online-shop export. The work is sped up 4×.

Video (43 s): https://stella.sh/media/proofs/printing-labels/make-packing-slips-from-orders/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A shop's orders export is in Downloads.
- 0:02 The prompt: packing slips for orders that haven't shipped, one page each.
- 0:11 Stella replies: it will pick out the unshipped orders and put each on its own page.
- 0:17 Grouping the rows into orders and laying out the slips, sped up 4×.
- 0:28 Done: 16 slips; shipped orders and one cancelled order left out; customer notes boxed.

What Stella does:

1. Finds `orders_export_1.csv` in Downloads: 22 orders spread over one row per line item, with the address only on each order's first row
2. Groups the rows back into orders and keeps the 16 that haven't shipped, leaving out five already fulfilled
3. Leaves out one unshipped order that was cancelled, and says so in case it should still go out
4. Makes one page per order: the ship-to address in large type with ZIP codes cleaned of the export's stray apostrophe, and every item with a checkbox, quantity and product code, no prices
5. Puts customer notes, such as a gift order asking for no receipt, in a box on that order's slip, and saves `packing-slips-unshipped.pdf` in Downloads

## The prompt to paste

```text
Make packing slips for the orders in my Downloads that haven't shipped yet, one page per order, with the ship-to address and what to pack.
```

## Make them yourself

1. **Try your shop's own print button.** Most shop platforms can print packing slips for selected orders from the orders page. If that works for you, use it; the export route is for custom layouts, several shops at once, or when the built-in slip shows prices you don't want.
2. **Fill the order details down.** In Excel, select the order columns (name, address, status), Home, Find & Select, Go To Special, Blanks. Type `=` and press the up arrow, then Ctrl+Enter, so every item row carries its order's details. Copy and Paste Values to keep them.
3. **Keep the unshipped orders.** Filter the fulfilment status column to unfulfilled and the order status to exclude cancelled. Strip any apostrophe in front of ZIP codes with Find and Replace.
4. **One page per order.** Word's mail merge makes one page per row, not per order, so either use a Directory merge grouped by order number or make a pivot table of items per order and print with a page break per order (PivotTable Options, Print, page breaks between items).

## Where Stella stops

- Stella works from the export. It doesn't mark orders as shipped or buy shipping labels in your shop.
- Customer names, addresses and order lines go to the AI model you use in Stella while it reads the export. The slips are made on your computer.
- It follows the export's status columns. An order fulfilled after you exported still gets a slip, so export just before you pack.
- It makes the PDF; it doesn't print it unless you ask.
- Recorded on Linux, where Stella used Python and a browser already on the computer to write the PDF. On a Mac or Windows PC it may install Python first, which wasn't recorded.

## Questions

**Can I add my logo and a thank-you note?**
Yes, point Stella at the logo file and give the wording; it goes on every slip.

**Can it make 4 × 6 slips for a label printer?**
Yes, ask for 4 × 6 inch pages instead of Letter. Thermal printers want black and white with no shading, so say so.

**Can it also make labels for the shelves or address labels?**
Yes: see [barcode labels from Excel](https://stella.sh/how/printing-labels/make-barcode-labels-from-excel) and [address labels from Excel](https://stella.sh/how/printing-labels/print-address-labels-from-excel).

**Can it make invoices instead of packing slips?**
Yes, with prices and totals. See [generate invoices from a spreadsheet](https://stella.sh/how/documents/generate-invoices-from-spreadsheet).

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [Microsoft Support: Fill data automatically in worksheet cells](https://support.microsoft.com/en-us/excel/get-started/fill-data-automatically-in-worksheet-cells), [Microsoft Support: Create and print mailing labels for an address list in Excel](https://support.microsoft.com/topic/d9484315-5123-48ae-bc58-2e8dcf271252).

## Related problems

- [Generate invoices from a spreadsheet, one per customer](https://stella.sh/how/documents/generate-invoices-from-spreadsheet.md)
- [Print barcode labels from Excel with name and price](https://stella.sh/how/printing-labels/make-barcode-labels-from-excel.md)
- [Print address labels from Excel on Avery 5160 sheets](https://stella.sh/how/printing-labels/print-address-labels-from-excel.md)
- [Print envelopes from an Excel guest list, one per household](https://stella.sh/how/printing-labels/print-envelopes-from-excel.md)
- [Make name tags from a registration list](https://stella.sh/how/printing-labels/make-name-tags-from-a-list.md)
- [Generate certificates from an Excel list, one per person](https://stella.sh/how/printing-labels/make-certificates-from-excel.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
