Creating a Calculated Attribute for Shopify Orders
How can I create a calculated attribute for Shopify refunds and cancellations?
To create a calculated attribute for Shopify refunds and cancellations, use Zendesk Explore's report builder. After setting up your report, go to the calculations menu and select 'Standard calculated attribute'.
Name the attribute 'Refunded and cancelled Shopify tickets' and use the formula:IF INCLUDES_ANY([Ticket tags], "shopify_cancelled") THEN "Order cancelled" ELIF INCLUDES_ANY([Ticket tags], "shopify_refunded") THEN "Order refunded" ENDIF. This attribute will categorize your tickets, providing more detailed insights into the status of each order.
More related questions
How can I report on Shopify refunds and cancellations in Zendesk?
You can report on Shopify refunds and cancellations in Zendesk by using the tags added by the Shopify integration. When an order is refunded or cancelled, the integration adds specific tags to a ticket: 'shopify_refunded' for refunded orders and…
What tags does the Shopify integration add for refunds and cancellations?
The Shopify integration adds specific tags to tickets for refunds and cancellations. For refunded orders, the tag 'shopifyrefunded' is added, and for cancelled orders, the tag 'shopifycancelled' is used. These tags are crucial for creating…
What do I need to create a report on Shopify refunds and cancellations?
To create a report on Shopify refunds and cancellations, you'll need a few things. First, ensure you have Zendesk Explore Professional or Enterprise, as well as Editor or Admin permissions. You'll also need ticket data in Zendesk Support and the…
How do I create a calculated metric for Shopify refunds and cancellations?
Creating a calculated metric for Shopify refunds and cancellations involves using Zendesk Explore. Start by opening a new report and selecting the Support - Tickets dataset. Then, in the calculations menu, choose to create a standard calculated…
How can I exclude non-refund or cancellation tickets from my report?
To exclude non-refund or cancellation tickets from your report, use the calculated attribute you created in Zendesk Explore. After adding the 'Refunded and cancelled Shopify tickets' attribute to your report, click on it and navigate to the…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
