Track Shopify Refunds in Mixpanel

This step automatically activates whenever a refund is processed in your Shopify store, whether it's a full or partial refund. No configuration is needed - MESA connects directly to your Shopify store's refund events and captures essential details like refund amount, timestamp, and order information. The trigger passes this refund data to the next step for order retrieval and enrichment.

This step automatically pulls the full order record associated with the refund using the order ID from the trigger. No configuration is required - the system retrieves comprehensive order data including customer details, billing information, and all line items from the original purchase. This enriched data gets passed to the custom code step for processing and formatting.

This step runs custom JavaScript code that calculates total refund amounts, formats line item titles into readable lists, sums refunded quantities, and extracts SKUs for the refunded products. The code processes transaction amounts to determine the actual refund value and creates comma-separated lists of product information for easy analysis. All calculated values are formatted specifically for Mixpanel's event structure and passed to the final tracking step.

const Mesa = require('vendor/Mesa.js');

/**
 * A MESA Script exports a class with a script() method.
 */
module.exports = new (class {
  /**
   * MESA Script
   *
   * @param {object} prevResponse The response from the previous step
   * @param {object} context Additional context about this task
   */
  script = (prevResponse, context) => {
    // Retrieve the Variables Available to this step
    // Line items from a Shopify Order Created trigger would be available as something like `vars.shopify.line_items`
    const vars = context.steps;

    // For storing response
    let response = {};
    // Get refund payload and Shopify order
    const refundPayload = vars.shopify;
    const shopifyOrder = vars.shopify_1;

    // Loop through transactions on the refund, and total up the refund amount
    let refundAmount = 0;
    refundPayload.transactions.forEach(transaction => {
      refundAmount -= transaction.amount;
    });

    // Format refunded line items' titles to comma-separated list (i.e. Title 1, Title 2, ...)
    const refundedLineItemsTitles = refundPayload.refund_line_items.map(item => item.line_item.title).join(', ');
    // Sum total quantity of refunded line items' quantities
    const refundedLineItemsTotalQuantity = refundPayload.refund_line_items.reduce((sum, item) => sum + item.quantity, 0);

    // Extract line item ids (line_items.id) from shopifyOrder.line_items
    const lineItemsById = {};
    shopifyOrder.line_items.forEach(item => {
      lineItemsById[item.id] = item;
    });

    // Find SKUs for matching refunded line items (refund_line_items)
    // Format SKUs into comma-separated list (i.e. SKU1, SKU2, ...)
    const refundedLineItemsSkus = refundPayload.refund_line_items
      .map(refundItem => {
        const match = lineItemsById[refundItem.line_item_id];
        return match ? match.sku : null;
      })
      .filter(Boolean)
      .join(",");
     
    // Add to response
    response.total_refund_amount = refundAmount;
    response.refunded_line_items_titles = refundedLineItemsTitles;
    response.refunded_line_items_total_quantity = refundedLineItemsTotalQuantity;
    response.refunded_line_items_skus = refundedLineItemsSkus;

    // Call the next step in this workflow
    // response will be the Variables Available from this step
    Mesa.output.next(response);
  };
})();

You'll need to configure your Mixpanel project ID in the "project_id" field to connect this workflow to your Mixpanel account. The step automatically formats all refund data into Mixpanel's event structure, including order details, refund amounts, customer information, and product-specific data like SKUs and quantities. Each refund creates a distinct event in Mixpanel with the order name in the event title for easy identification.