What exports are available for multiple coupon redemptions?

Merchants can report on multiple discounts in the Invoices - Summary, Invoices - Line Items, and our new Invoices - Line Item Coupons exports.

 

Invoices - Summary

This export answers which coupons were applied to the invoice.

  • The coupon_code column will show a comma separated list of coupon codes if the invoice had more than one coupon code applied.
  • The coupon codes are a unique list of coupons applied to the invoice. If the coupon had multiple redemptions applied to the invoice, you will see the coupon mentioned only once in this list.
  • Coupons used to calculate returned credits will show in this list.

See the details of this export in our Invoices - Summary export documentation.

 

Adjustments

This export answers which coupons were applied to the line item and the total discount they created on the line item.

  • The adjustment_discount column will show the total discount for the line item.
  • The adjustment_coupon_code column will show a comma separated list of coupon codes if the line item had more than one coupon code applied.
  • The coupon codes are a unique list of coupons applied to the line item. If the coupon had multiple redemptions applied to the line item, you will see the coupon mentioned only once in this list.
  • Coupons used to calculate returned credits will show in this list.

See the details of this export in our Adjustments export documentation.

 

Adjustments - Coupons

This export answers what the individual discounts were for each coupon applied to the line item. This export will only show if you have the Multiple Coupons Per Account feature enabled in your coupon Settings.

  • This export creates a row for each line item discount. A line item with multiple discounts applied will have multiple rows in the export.
  • The adjustment_discount column will show the portion of the line item discount created by the specific coupon in the adjustment_coupon_code column for that row.
  • The adjustment_coupon_code will only show one coupon code. If you see two rows for the same line item with the same coupon code, it means the coupon was redeemed more than once and more than one redemption discounted the line item.
  • Line items for credits will also show any coupons and discounts applied to calculate the correct credits to return.

See the details of this export in our Adjustments - Coupons export documentation.