Corporate Gift Orders to Many Addresses, Without Spreadsheets
Short answer: Corporate gift orders go wrong in the gap between the client's spreadsheet and your order system: misspelt postcodes, messages pasted into the wrong row, and one invoice that somehow becomes sixty. A better process gives the client a fixed upload template, checks addresses before anything ships, keeps one gift message per recipient, lets them choose a dispatch date, and produces a single invoice with tracking per recipient. On WooCommerce, a multiple-addresses extension covers part of this; on Shopify, draft orders plus an import step or app is the usual route.
A worked example (hypothetical)
Let's follow a fictional chocolatier in York, "Ouse & Cocoa", through one corporate order.
The request. In mid-November, an office manager at a Leeds accountancy firm emails: 60 boxes of truffles for clients, each with a personal message from a partner, delivered in the week before Christmas. She attaches a spreadsheet.
What the spreadsheet looks like. Names in one column, full addresses crammed into another, postcodes sometimes missing, messages in a third column with line breaks that split rows. Two recipients appear twice. One message mentions the wrong company name.
The old way. Someone at the shop retypes 60 orders into the shop system over two afternoons, catches some errors, misses others, and the client receives 60 separate order confirmations. Three parcels come back undelivered.
The better way. Here's how the same order runs with a proper setup.
1. The client downloads a template
On the corporate gifting page there's a "Download recipient template" link. The CSV has one column per field:
| Column | Notes |
|---|---|
| Recipient first name | Required |
| Recipient last name | Required |
| Company | Optional |
| Address line 1 | Required |
| Address line 2 | Optional |
| Town | Required |
| Postcode | Required |
| Gift message | Up to 200 characters |
| Product code | From the corporate range list |
| Quantity | Default 1 |
The page also explains message length, cut-off dates and how many working days dispatch takes.
2. The upload is checked before anything is created
The office manager uploads her completed file through a form. The shop's system, or a member of staff using a checklist, does four things:
- Flags missing required fields. Row 14 has no postcode.
- Checks postcodes are in a valid UK format and, if you use an address lookup service, that they match a real address.
- Spots duplicates. Two rows for the same person at the same address.
- Checks message length against what fits on the card.
She gets back a short list of problems to fix, not 60 orders to proofread.
3. She picks a dispatch date
The upload form offers a dispatch week, with blocked dates for when the kitchen is fully booked. The WooCommerce Ship to Multiple Addresses extension, for example, includes a date picker per address, settings for valid delivery days, and excluded dates (its documentation gives "no deliveries on Christmas Day" as an example).
4. One quote, one invoice
The shop creates one order, or one parent order linked to 60 shipments, and sends a single invoice. On Shopify, draft orders suit this: Shopify's developer documentation describes creating a draft order for a business customer and sending an invoice for it, and the draft order API accepts line items and a shipping address. Because a draft order carries one shipping address, multi-recipient orders typically need either one draft order per recipient grouped under a single invoice by an app, or a separate fulfilment step that splits the order. Check what your chosen app does before promising one invoice.
5. Gift packaging without prices
None of the 60 recipients should see a price. The WooCommerce extension's "gift packages" option marks shipments to an address as gifts, which its documentation describes as a signal that the customer doesn't want an invoice included in that parcel. Whatever your platform, make sure the packing slip for these orders shows the message, not the price.
6. Labels in one go
Rather than creating 60 labels by hand, the shop exports the recipient list in its carrier's import format. Some carrier shipping tools accept a CSV import; check your carrier's current guidance for the exact columns.
7. Status the client can see
The office manager gets one summary email when the order is dispatched, with a link to a page listing each recipient and their tracking number. When a client asks "did Mrs Patel's box arrive?", she can check herself.
Setting it up for your shop
Decide your order model
- Under about ten recipients: a multi-address checkout may be enough. The WooCommerce extension lets customers split a cart between addresses, duplicate a cart to ship the same contents to several people, and add delivery notes per address.
- Ten to a few hundred recipients: a spreadsheet upload with validation, feeding draft orders or an order import app.
- Repeat corporate clients: a simple account area where they can reuse past recipient lists.
Build the corporate gifting page
Include: the corporate range with product codes, minimum order quantity if you have one, the template download, message rules, lead times and Christmas cut-off dates, how invoicing works, and a contact for large orders.
Write down the checks
Even with automation, someone at the shop should approve each corporate order before it goes to production. A short checklist (addresses validated, messages proofread, dates confirmed, invoice sent) prevents the expensive mistakes.
Keep messages structured
Store each gift message as its own field linked to the recipient, never as a block of text in an order note. That's what lets you print the right card for the right box.
FAQ
Can customers do this through my normal checkout?
For a handful of addresses, yes, with a multi-address extension or app. For dozens, an upload is faster and less error-prone than filling in a checkout form 40 times.
Should I charge for corporate order handling?
That's your call. If you do, show it in the quote before the invoice, not as a surprise line.
What if the client sends their own spreadsheet anyway?
Paste their data into your template yourself and run the same checks. Over time, point repeat clients to the template.
How do I handle undeliverable parcels?
Set a rule in your terms (redelivery at cost, or credit), and make sure returned parcels are logged against the right recipient.
Taking more corporate orders this Christmas and want the upload, checks and invoicing joined up? Tell us how you handle them now.