Order Management
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
order-management
reporting
Cash on Delivery Order Tracking
Tag and report on cash-on-delivery orders separately so unpaid COD balances stay visible until collected.
đź“‹ Prompt
I offer cash on delivery in some regions and need those orders tracked separately since payment isn’t captured at checkout. Here are the details: Store name: [YOUR STORE NAME] COD payment method name in Shopify: [PAYMENT METHOD NAME] Regions where COD is offered: [LIST] COD order value cap, if any: [DOLLAR AMOUNT] Please build: A Shopify Flow triggered on “Order created” that tags any order using payment method “[PAYMENT METHOD NAME]” as “COD-Pending” and adds a note with the amount to be collected on delivery. A guardrail Flow that also tags orders “COD-Over-Cap” and notifies [STAFF/CHANNEL] for manual review if the order total exceeds [DOLLAR AMOUNT], since larger COD orders carry more non-payment risk. A saved filter (tag:COD-Pending) so staff can see every order still awaiting cash collection. A resolution process: once the driver or carrier confirms payment was collected, staff replace the tag with “COD-Collected” and add the collection date; if payment wasn’t collected, tag “COD-Failed” and route to the reshipment-or-refund decision per policy. A ShopifyQL report totaling outstanding COD balances (“COD-Pending” tag) at any point in time, so I know exactly how much revenue is still uncollected. A weekly report on COD failure rate by region, to evaluate whether to keep offering COD in regions with high non-collection. The goal is COD orders never silently falling through the cracks between “shipped” and “actually got paid.”
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