CSV Export of returned items and refunds by date

Payments + Shipping & Fulfilment

Topic summary

Request: A simple CSV export of returned items, with each returned SKU on its own row.

Desired fields:

  • Date returned
  • SKU
  • Shipping location
  • Order Number
  • Refund amount

Issue: Existing reports/dimensions tried do not produce this format.

Status: Seeking guidance; no responses or resolution yet.

Summarized with AI on January 12. AI used: gpt-5.
1

Hi - I’m looking for a very simple CSV export of items returned. The export should list each returned SKU on a separate row with

date returned / SKU / Shipping location / Order Number / refund amount

All reports and dimensions I have tried is not working. Any help in guidance would be great.

Thanks!

2

Try Shopify’s Analytics > Reports > **Exploration
**
I’ve found the AI bot gets pretty close when you ask it to find the data you’re looking for or update queries.

FROM sales
SHOW quantity_returned, returns
GROUP BY day, product_variant_sku, order_name, pos_location_name WITH TOTALS
HAVING returns > 0
ORDER BY day ASC
VISUALIZE quantity_returned

1 Like
5

@NCLTD, Hi, You can genreate this report using Items returned by product premade report. Just paste the below SQL query in the report to see the data your are looking for. Find the screenshot for your reference.

Query

FROM sales
SHOW returns, total_returns
WHERE product_title IS NOT NULL
GROUP BY day, product_variant_sku, order_name, shipping_city WITH GROUP_TOTALS,
TOTALS
SINCE startOfDay(-365d) UNTIL today
ORDER BY day ASC, product_variant_sku ASC, order_name ASC, shipping_city ASC
LIMIT 1000
VISUALIZE returns TYPE bar

image (45)
image (45)1364×253 15 KB

Thanks

7

Hi, you can easily create this export with DataChamp. You can either use the refunded template, which you can customize to your requirements, or build the report from scratch to include the specific fields you need. If you have any questions, feel free to reach out!