CSV Export Fields for Returns in ExchangeIt

When exporting return data to CSV in ExchangeIt, merchants can select from a variety of fields. For example, ExchangeIt’s documentation shows fields like Return Number, Original Order Name, Customer Name and Email, Return Request Date, and Requested Return Items details (Name, SKU, Quantity) among the export options. Below are all available fields grouped by category, with a brief description of the data each includes.

• Return Number – Unique identifier for the return request (assigned by the ExchangeIt app).

• Status – Current status of the return (e.g. Approved, Declined, or Resolved).

• Original Order Name – The Shopify order number or name for the original purchase.

• Return Request Date – Date (and time) when the return was requested by the customer.

• Return Note – Any notes or comments attached to the return by the customer or merchant.

• Name – Full name of the customer who made the return.

• Email – Customer’s email address.

(Each returned item will have its own set of these fields.)

• Product ID – The unique identifier for the product being returned (as recorded in your store).

• Product Name – The name of the product being returned.

• Product SKU – The SKU (stock keeping unit) of the product being returned.

• Quantity – Number of units of this product being returned.

• Return Reason – The reason for return selected by the customer.

• Requested Resolution – What the customer requested (e.g. Refund or Exchange).

• Approved – Indicates whether this return item was approved by the merchant (yes/no).

• Received – Indicates whether the returned item has been received back in inventory (yes/no).

• Restocked – Indicates whether the returned item has been restocked into inventory (yes/no).

• Refunded – Indicates whether the item has been refunded to the customer (yes/no).

(If the customer requested an exchange, each requested item has these fields.)

• Name – Name of the product the customer requested in exchange.

• SKU – SKU of the requested exchange product.

• Quantity – Quantity of the exchange product requested.

ExchangeIt can either add exchanged items to the original order or create a new order for the exchange. The fields below capture both cases:

• Item Name (Original Order) – Name of the product added to the original order as part of the exchange.

• SKU (Original Order) – SKU of the product added to the original order in the exchange.

• Quantity (Original Order) – Quantity of that item added to the original order.

• Discount (Original Order) – Any discount applied to the exchange item in the original order.

• Item Name (New Order) – Name of the product in the new order created for the exchange.

• SKU (New Order) – SKU of the product in the new exchange order.

• Quantity (New Order) – Quantity of the item in the new exchange order.

• Discount (New Order) – Any discount applied to the item in the new exchange order.

• Reverse Fulfillment Order LineItem ID – The internal ID of the reverse fulfillment line item created for this return (used by Shopify’s returns API).

• Quantity – Number of items restocked in inventory for this line item.

• Restock Location – The inventory location (warehouse) to which the item was restocked.

(These fields detail any refunds issued for the return.)

• Return LineItem ID – The original order’s line item ID that was refunded.

• Quantity – Number of units refunded for that line item.

• Gift Card (Last 4 digits) – Last four digits of the gift card code used for the refund (if a gift card was used).

• Total Refunded – Total amount refunded for this line item.

• Refund Discount – Portion of the refund amount that is attributed to any discount.

• Tax Refund – Amount of tax refunded.

• Shipping Refund – Shipping cost refunded.

• Refund Fee – Any fee deducted from the refund (for example, a restocking fee).

Each selected field becomes a column in the exported CSV file. Merchants can check or uncheck these fields in the export dialog to customize which columns appear in the final report.