Track Shopify Refunds in Mixpanel

When a refund is created in Shopify, this trigger activates the workflow and captures refund data including {{shopify.order_id}}, {{shopify.created_at}}, {{shopify.transactions}}, {{shopify.refund_line_items}}, and {{shopify.order_adjustments[0].reason}}. The workflow runs for every refund issued in your store, whether full or partial refunds.

This step retrieves the full order record from Shopify using {{shopify.order_id}} from the trigger. It fetches {{shopify_1.id}}, {{shopify_1.name}}, {{shopify_1.email}}, {{shopify_1.customer.first_name}}, {{shopify_1.customer.last_name}}, and the complete {{shopify_1.line_items}} array. This order data is essential because the refund payload only contains refunded line item IDs and quantities, not the full product details like SKUs and titles that are needed for meaningful analytics.

This custom JavaScript step processes the refund and order data to create formatted outputs stored as {{custom}}. The code performs four key calculations:
(1) Loops through {{shopify.transactions}} to calculate the total refund amount (stored as {{custom.total_refund_amount}}),
(2) Extracts and formats product titles from {{shopify.refund_line_items}} into a comma-separated list (stored as {{custom.refunded_line_items_titles}}),
(3) Sums the quantities from {{shopify.refund_line_items}} to get total items refunded (stored as {{custom.refunded_line_items_total_quantity}}), and
(4) Matches refunded line item IDs to the full order's line items from {{shopify_1.line_items}} to extract SKUs and format them as a comma-separated list (stored as {{custom.refunded_line_items_skus}}).

Custom code:
const Mesa = require('vendor/Mesa.js');
module.exports = new (class {
script = (prevResponse, context) => {
const vars = context.steps;
let response = {};

const refundPayload = vars.shopify;
const shopifyOrder = vars.shopify_1;

// Calculate total refund amount from transactions
let refundAmount = 0;
refundPayload.transactions.forEach(transaction => {
refundAmount -= transaction.amount;
});

// Format refunded line items' titles to comma-separated list
const refundedLineItemsTitles = refundPayload.refund_line_items
.map(item => item.line_item.title)
.join(', ');

// Sum total quantity of refunded line items
const refundedLineItemsTotalQuantity = refundPayload.refund_line_items
.reduce((sum, item) => sum + item.quantity, 0);

// Create lookup object for line items by ID
const lineItemsById = {};
shopifyOrder.line_items.forEach(item => {
lineItemsById[item.id] = item;
});

// Extract SKUs for matching refunded line items
const refundedLineItemsSkus = refundPayload.refund_line_items
.map(refundItem => {
const match = lineItemsById[refundItem.line_item_id];
return match ? match.sku : null;
})
.filter(Boolean)
.join(",");

response.total_refund_amount = refundAmount;
response.refunded_line_items_titles = refundedLineItemsTitles;
response.refunded_line_items_total_quantity = refundedLineItemsTotalQuantity;
response.refunded_line_items_skus = refundedLineItemsSkus;

Mesa.output.next(response);
};
})();

This step sends a refund event to Mixpanel with the event name formatted as "Refund - Order {{shopify_1.name}}" (like "Refund - Order #1234"). The event includes extensive properties:

Order ID ({{shopify_1.id}}),
Order Name ({{shopify_1.name}}),
Refund Amount ({{custom.total_refund_amount}}),
Refund Timestamp ({{shopify.created_at}}),
Refund Reason ({{shopify.order_adjustments[0].reason}}),
Refunded Line Items Titles ({{custom.refunded_line_items_titles}}),
Refunded Line Items Total Quantity ({{custom.refunded_line_items_total_quantity}}),
Refunded Line Items SKU ({{custom.refunded_line_items_skus}}),
Billing Customer Name ({{shopify_1.customer.first_name}} {{shopify_1.customer.last_name}}), and
Billing Customer Email ({{shopify_1.email}}).

The query includes project_id and strict validation for data quality. All properties are ready to use in Mixpanel reports, cohorts, and dashboards without modification.