How do I plan production by pickup or delivery date?
On this page
Bakeries, caterers and other made-to-order food shops let customers pick a pickup or local delivery day at checkout. That day is saved on the order as a note attribute (for example Pickup-Date from Zapiet) or on a line item as a property (for example Delivery Date from a product date picker). Shopify’s own export has no column for it and cannot filter by it.
The Production list preset adds up how many of each product to bake or prepare for each day and time slot. The Pickup or delivery date filter limits any export to the days you plan, and the Orders page then lists the orders grouped by pickup or delivery day.
Tell Columna where your dates are
Open Settings > Pickup and delivery dates:
- Date field: the line item property or note attribute your date picker app writes, for example
due date. The app suggests the date fields it finds in your recent orders, with an example value, and shows how that value reads. Leave it on Automatic to use the usual names listed below. - Numeric dates such as 05/06/26: Day first, Month first, or Follow the export date format. When your recent orders show the order (a number above 12), the app says so and warns you if the setting reads them the other way.
- Production list columns: up to 5 line item properties, such as flavour, size or message, shown as their own columns in the production list, the print and the email.
The setting is used by the production list, the pickup or delivery date filter, the grouped Orders page and the production list email.
Export the production list
- Open Templates in the app, then the Food tab.
- On Production list, click Export report. The Orders page opens with the report selected.
- Set the order date range wide enough to include orders placed weeks before the pickup day. Customers order ahead, and the order date range still decides which orders are read.
- Click Pickup or delivery date and choose Today, Tomorrow or This week (Monday to Sunday), pick one day, or enter a range. Days follow your shop’s time zone. Leave the filter empty to list every day.
- Optionally, in Location, keep All locations or pick one pickup location. This field shows only while a pickup or delivery date is set.
- Click Export, choose CSV or Excel, and click Export again. Or click Print in the same window to print the list on a clean sheet titled “Production list”, grouped by day and time slot. Items without a time slot are under “Any time”. Click Done to close it.
Orders are read and summed in your browser. They are not stored by the app.
Other templates show Print sheet in the export window instead of Print.
Pick one pickup location
If you have more than one pickup location, the Location filter limits the Orders page and the export to one of them. The app reads the location from a note attribute or line item property such as Pickup-Location-Company, else from the order’s shipping method (Shopify local pickup). It lists the locations it finds on the orders in the pickup or delivery date range.
Clearing the pickup or delivery date also clears the location. The location is ignored when you export selected orders. History shows it as “Location:” followed by the name.
What each row means
The report has one row per date, time slot, product, variant, SKU and chosen property values:
| Column | Meaning |
|---|---|
| Date | The pickup or delivery date, in the date format of Settings > File format. |
| Time | The time slot, from a time attribute such as Pickup-Time or a time written after the date. Shown only when some item has one; empty means any time. |
| Product | Product title. |
| Variant | Variant title, such as a size or a filling. |
| SKU | Variant SKU. |
| Your property columns | The values of the Production list columns chosen in Settings. |
| Quantity | Units to make, added up over the orders. Units removed in an order edit or refunded are not counted. |
| Orders | Number of orders with this product on this date. |
Rows are sorted by date, then time slot (any time first), then product. A date the app cannot read as a date (for example “Christmas Eve”) is listed as written after the dated rows. Items without any date come last under No date.
Where the date comes from
For each item, the app looks for a date in this order:
- The Date field chosen in Settings, on the item and then on the order.
- A line item property of that item, so a cart with items for different days is split correctly.
- A note attribute of the order.
These names are recognised, in any upper or lower case and with dashes, underscores or spaces: Pickup Date, Delivery Date, Local Delivery Date, Collection Date, Shipping Date and Date, plus names that end in Pick up date, Delivery date, Collection date, Ship date or Order ready date, such as Preferred delivery date. Time attributes such as Pickup-Time are not used for the date.
Dates are read in these forms: 2026-12-24, 2026/12/24, 24.12.2026, 24/12/2026, 24 December 2026, Dec 24, 2026, 22 Oct 26, with or without a weekday in front. A two-digit year such as 26 is read as 2026. When a date such as 05/12/2026 could be either day or month first, the Numeric dates setting decides; on Follow the export date format it is read day first, unless Date format in Settings > File format is month/day/year. A number above 12 always settles it, so 12/24/2026 is read as December 24.
See the orders for a day
With a pickup or delivery date set, the Orders page shows one table per day, headed with the weekday and date and the number of orders, sorted by time slot. Orders with a date outside the range or without a date are not shown. Clear the filter to see the usual order list. Up to 500 orders are grouped. When the page says “Grouped from the newest 500 orders in the order date range.”, narrow the order date range to include older orders.
The pickup or delivery date filter with other templates
The filter works with every template, not only the production list. Only items whose date falls in the range go into the file, and orders without a date in the range are left out. Selected orders are exported as they are, without this filter.
For a day’s pickup counter, use the Pickup & delivery schedule preset (Food tab, Customize). It has one row per order with the pickup or delivery date and time, the customer, the address, the delivery method and the items. For drivers, the Delivery route sheet preset (Delivery tab) adds the address reference, a WhatsApp link and the amount to collect. Both read the date the same way as the production list, including the key you chose in Settings and dates written in Spanish, Portuguese, French, German, Italian or Dutch.
The filter is saved with the export in History, so Run again gives you the same days. It is not used by the Google Sheets sync.
Troubleshooting
- Everything is under “No date”: your date app may save the date under another name. Open Settings > Pickup and delivery dates and choose it as the Date field, or type its name under Another field….
- A day is missing orders: widen the order date range. An order placed in October for a December pickup is only read when October is in the order date range.
- Day and month are swapped: set Numeric dates in Settings > Pickup and delivery dates to match how your date app writes dates.
- You see “No orders for … in this pickup or delivery date range”: no order in the range is picked up at the chosen location. Choose All locations or another location, or widen the pickup or delivery date range.
- You see “No location found on the orders in this pickup or delivery date range.”: the orders carry no pickup location the app can read, so Location has only All locations.