Admins can configure order exports to display Promotion information on one or more orders. Contact your Account Manager to enable promotions.
Note: Learn more about promotions with Promotions overview, Create and edit Promotions, and Promotions FAQ. For integrated brands, see also the Promotions implementation guide for integrated brands.
Multiple orders export
Use the Orders page to export details for multiple orders. Admins can configure this export template by going to Settings > Brand Admin > Settings > Order Export Info.
At the bottom of the Order Export Definition section, select New Export Field, and then specify each Header name and Field. Use the arrows on the right to reorder fields.
When selecting fields with Promotion information, choose from the following, based on the type of promotion (Order or Product).
Order promotion fields
Add these fields to your Orders export to provide order-level Promotion discount details.
| Field | Description |
|---|---|
| order.order_discount.discounted_total | Total of the order after the discount. |
| order.order_discount.original_total | Total of the order without the discount. |
| order.order_discount.total_after_line_item_discount | Total of the order after line item discount(s). |
| order.order_discount.total_applied | Total discount applied to the order. |
| order.order_discount.applied.name | Name of the applied promotion. |
| order.order_discount.applied.discount | Amount of the applied discount. |
| order.order_discount.surcharge | Surcharge on the order. |
| order.order_discount.company_manual_discount | Manual discount added by the brand. |
Product promotion fields
Add these fields to your Orders export to provide product-level Promotion discount details.
| Field | Description |
|---|---|
| order.line_item.__line_item_promotion.discounted_total | Total of the product after the discount. |
| order.line_item.__line_item_promotion.original_total | Total of the product without the discount. |
| order.line_item.__line_item_promotion.item_price_after_discount | Total of the product after the discount(s). |
| order.line_item.__line_item_promotion.adjusted_wholesale_string | Discounted price of the product. |
| order.line_item.__line_item_promotion.applied.name | Name of the applied promotion. |
| order.line_item.__line_item_promotion.applied.discount | Amount of the applied discount. |
| order.line_item.__line_item_promotion.company_manual_discount_on_item | Manual discount added by the brand. |
When you’re done, select Save. See Order export information overview for more details on configuring order exports.
To use your configured export, go to Orders from the left navigation menu. Use the checkboxes for one (or more) order(s) and select Export in the upper-right corner.
Choose an export option:
- Full order details: Displays the product-level promotion details. If this report is not populating as expected, contact Support to enable the brand preference to include promotion data in order data.
- Order summary: Displays the order-level promotion details.
In the exported spreadsheet, review the order details, including the selected Promotion information. Below is an example of an Orders export with Promotions fields.
Single order export
Admins can customize the single order export by going to Settings > Brand Admin > Settings > Order Export Template. Edit a template or create a new one.
In the Line Items Options section, select Add new field.
Choose from the following fields, so that the Order Export Template provides details on how the final product price was calculated, based on the applied promotion(s).
| Field | Description |
|---|---|
| Name of applied discount | The name of the qualifying product-level discount. |
| Total of item without discount | The original unit price of the product before a promotion(s) is applied to the product. |
| Total of item after discount | The final discounted unit price after the promotion discount is applied to the product. |
| Total of item after discounts | The final discounted unit price after the promotion discount and the manual product discount are applied to the product. |
| Discounted price of item | The discounted price of the product. |
You can export this file on a single order if this Order Export Template is set as the default template. Learn more about configuring Order Export Templates with Configure order export templates.
From the left navigation menu, go to Orders and choose Download Order XLS from the More actions kabob menu on an order.