Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Shopify Return Trigger - How to calculate which product was refunded and how much

  • January 1, 2025
  • 3 replies
  • 57 views
F
Forum|alt.badge.img

Use Case: 

I am connecting Shopify to my Notion Page where I manage all orders. Every order is added there for me to track, basically when someone refunds an order, I wanna find the order and product, and then mark it as refunded and update the amount to the refunded amount.

Problem:
I set the refund trigger on Zapier but it only shows the return id and transaction details which seems confusing, most orders would have multiple products, I would like to know which product was refunded and how much for each products.

Here’s the values from Shopifys Return trigger

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

P
Forum|alt.badge.img+5

Here’s how to set up a Zap in Zapier to identify which product was refunded and the refund amount for each product in Shopify.

 

  1. Trigger: Refund Created in Shopify

    • App & Event: Choose Shopify as the app and "Refund Created" as the trigger event.

    • Set Up Trigger: Connect your Shopify account and test the trigger to ensure it captures refund data.

  2. Action: Get Order Data

    • App & Event: Choose Shopify as the app and "Get Order Data" as the action event.

    • Set Up Action: Map the fields to pull the relevant order details, including line items.

  3. Action: Formatter (Text > Extract)

    • App & Event: Choose "Formatter by Zapier" as the app and "Text" as the action event. Select "Extract" for the operation.

    • Set Up Action: Configure the Formatter to extract product IDs and refund amounts from the order data.

  4. Action: Loop Through Each Product (Using Looping by Zapier)

    • App & Event: Choose "Looping by Zapier" as the app and "Create Loop From Text" as the action event.

    • Set Up Action: Split the extracted product details (IDs and amounts) into individual items to create a loop.

  5. Action: Find Record in Notion

    • App & Event: Choose Notion as the app and "Find Record" as the action event.

    • Set Up Action: Use the product ID from the loop to find the corresponding record in your Notion database.

  6. Action: Update Record in Notion

    • App & Event: Choose Notion as the app and "Update Record" as the action event.

    • Set Up Action: Map the fields to update the product status to "Refunded" and update the refund amount.

Example Workflow

  1. Shopify Trigger: Refund Created

  2. Shopify Action: Get Order Data

  3. Formatter: Extract Product IDs and Refund Amounts

  4. Looping by Zapier: Create Loop From Text

  5. Notion Action: Find Record (using Product IDs)

  6. Notion Action: Update Record (mark as refunded and update refund amount)

This workflow should help you track refunded products and their amounts

    F
    Forum|alt.badge.img
    • Fahad.SBeginner
    • Author
    • Beginner
    • January 3, 2025

     

    1. Action: Get Order Data

      • App & Event: Choose Shopify as the app and "Get Order Data" as the action event.

      • Set Up Action: Map the fields to pull the relevant order details, including line items.

    2. Action: Formatter (Text > Extract)

      • App & Event: Choose "Formatter by Zapier" as the app and "Text" as the action event. Select "Extract" for the operation.

      • Set Up Action: Configure the Formatter to extract product IDs and refund amounts from the order data.

    3. Action: Loop Through Each Product (Using Looping by Zapier)

      • App & Event: Choose "Looping by Zapier" as the app and "Create Loop From Text" as the action event.

      • Set Up Action: Split the extracted product details (IDs and amounts) into individual items to create a loop.

    4.  

    Thanks for this, I tried this but the “Get Order Data” only shows the Line Item Products and the Refunded as 2 separate objects, there’s literally nothing in common between them that I could relate and map with to find the exact amount.

    Or is there something i am missing?

    For ex: 


    The above mentioned screenshot shows the refund object

     


    The above mentioned shows the Line Item/Product Object


    There’s no field I can use to map the right line item from the refund object

    SamB
    Community Manager
    Forum|alt.badge.img+11
    • SamBCommunity Manager
    • Community Manager
    • January 14, 2025

    Hi there, ​@Fahad.S! 👋

    I had a look at the API documentation for Shopify I’d have thought that the New Refund trigger should contain the ID for the item being refunded within refund_line_items section here:

    9c22cc47a7c58c8fae7ab8f7c508d640.png

    But it’s not super clear from their API documentation whether that ID is definitely the ID for the specific product.

    Does the ID highlighted in the screenshot below match the id of a product in your Shopify store?

    339e8b68c0ba3e6a47049c2fb839e9d0.png
     

    Looking forward to hearing from you!

    Terms & ConditionsAccessibility statement