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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions