Order Management
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
order-management
reporting
Local Delivery Route Sheet
Pull a daily exportable list of local-delivery orders with addresses and notes for route planning.
đź“‹ Prompt
I run local delivery and need a daily route sheet pulled from Shopify order data. Here are the details: Store name: [YOUR STORE NAME] Local delivery method name: [DELIVERY METHOD NAME] Delivery zones/neighborhoods: [LIST] Cutoff time for same-day inclusion: [TIME] Please build: A ShopifyQL query/report that pulls all unfulfilled orders using delivery method “[DELIVERY METHOD NAME]” placed before [TIME] today, with columns: order number, customer name, phone, full shipping address, order total, and any delivery instructions from the order note. A Shopify Flow that tags each qualifying order with today’s date, e.g. “Delivery-[DATE]”, so the route sheet can be filtered and re-pulled later for records. An export step so the report can be downloaded as CSV for import into a route-planning tool or printed for drivers. A grouping recommendation: sort the exported list by zone/neighborhood using my listed zones so the driver can plan an efficient route manually. A Flow triggered when an order is marked fulfilled same-day that adds the tag “Delivered-[DATE]” so the next day’s report only shows outstanding stops. A short driver checklist: confirm item count against packing slip, capture delivery confirmation (photo or note), and mark the order note with delivery time. The goal is a reliable, repeatable daily export so route planning doesn’t require manually scanning the Orders page every morning.
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions