Optimize Shipping Costs

Build a ShopifyQL report on shipping costs by carrier, service, and zone from your store's live order data to find the highest-cost segments.

View as Markdown

📋 Prompt

Run in Sidekick

Help me build a ShopifyQL report on shipping costs using my store’s live order data, to find where the cost is concentrated.

Time period: [e.g., last 90 days]
Carriers used: [e.g., USPS, UPS]
Biggest shipping cost concern: [Domestic rates / International rates / Returns / Packaging]

Please:


  Build a ShopifyQL query/report pulling shipping cost per order broken down by carrier, shipping service/rate, and destination zone for [TIME_PERIOD].
  Sort or highlight the highest-cost carrier/service/zone segments.
  Run the report and show me the results.
  Export the report so I can review it outside the admin.


When reviewing results, look for: a single zone or service driving a disproportionate share of cost, and any carrier where average cost per order is notably higher than the rest — flag these directly from the data, not as generic advice.

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