Track Price Overrides in Commerce Cloud Endless Aisle

If you let associates or managers conduct price overrides, the application passes the override data at the line item in the order export file. It also passes the employee ID of the associate performing the override.

In the following example, associate 176321 performed a price override by amount. S/he took $15 off and the reason is for a price match. The net price is calculated after the $15 discount.

<product-lineitem>
    <net-price>114.00</net-price>  //the net price is after the $15 discount.
    <tax>5.70</tax>
    <gross-price>119.70</gross-price>
    <base-price>114.00</base-price>
    <lineitem-text>Floral Dress</lineitem-text>
    <tax-basis>114.00</tax-basis>
    <position>1</position>
    <product-id>701644031220</product-id>
    <product-name>Floral Dress</product-name>
    <quantity unit="">1.0</quantity>
    <tax-rate>0.05</tax-rate>
    <shipment-id>00000610</shipment-id>
    <gift>false</gift>
    <custom-attributes>
      <custom-attribute attribute-id="eaEmployeeId">176321</custom-attribute>
      <custom-attribute attribute-id="eaOverrideReasonCode">Price Match</custom-attribute>
      <custom-attribute attribute-id="eaPriceOverrideType">amount</custom-attribute>
      <custom-attribute attribute-id="eaPriceOverrideValue">15</custom-attribute>
    </custom-attributes>
</product-lineitem>

In the following example, associate 176321 performed a price override by discount percentage 15% for a loyal customer.

<product-lineitem>
    <net-price>34.84</net-price> //net price is after price override
    <tax>1.74</tax>
    <gross-price>36.58</gross-price>
    <base-price>34.84</base-price>
    <lineitem-text>Striped Shirt</lineitem-text>
    <tax-basis>34.84</tax-basis>
    <position>3</position>
    <product-id>701643472376</product-id>
    <product-name>Striped Shirt</product-name>
    <quantity unit="">1.0</quantity>
    <tax-rate>0.05</tax-rate>
    <shipment-id>00000610</shipment-id>
    <gift>false</gift>
    <custom-attributes>
      <custom-attribute attribute-id="eaEmployeeId">176321</custom-attribute>
      <custom-attribute attribute-id="eaOverrideReasonCode">Loyal Customer</custom-attribute>
      <custom-attribute attribute-id="eaPriceOverrideType">percent</custom-attribute>
      <custom-attribute attribute-id="eaPriceOverrideValue">0.15</custom-attribute>
    </custom-attributes>
</product-lineitem>

In the following case, a manager (id=854807) performed a price override for associate (176321). It was a customer accommodation to set the price to a fixed price of $25.

<product-lineitem>
    <net-price>25.00</net-price>
    <tax>1.25</tax>
    <gross-price>26.25</gross-price>
    <base-price>25.00</base-price>
    <lineitem-text>Floral Jersey Dress (Petite)</lineitem-text>
    <tax-basis>25.00</tax-basis>
    <position>2</position>
    <product-id>701644111922</product-id>
    <product-name>Floral Jersey Dress (Petite)</product-name>
    <quantity unit="">1.0</quantity>
    <tax-rate>0.05</tax-rate>
    <shipment-id>00000610</shipment-id>
    <gift>false</gift>
    <custom-attributes>
      <custom-attribute attribute-id="eaEmployeeId">176321</custom-attribute>
      <custom-attribute attribute-id="eaManagerEmployeeId">854807</custom-attribute>
      <custom-attribute attribute-id="eaOverrideReasonCode">Customer Accommodation</custom-attribute>
      <custom-attribute attribute-id="eaPriceOverrideType">fixedPrice</custom-attribute>
      <custom-attribute attribute-id="eaPriceOverrideValue">25</custom-attribute>
    </custom-attributes>
</product-lineitem>

In the following example, the associate 854807 took $2 off standard shipping for a customer accommodation. The net price of $9.99 is after the $2 discount.

<shipping-lineitem>
    <net-price>9.99</net-price>
    <tax>0.50</tax>
    <gross-price>10.49</gross-price>
    <base-price>9.99</base-price>
    <lineitem-text>Shipping</lineitem-text>
    <tax-basis>9.99</tax-basis>
    <item-id>STANDARD_SHIPPING</item-id>
    <shipment-id>00000610</shipment-id>
    <tax-rate>0.05</tax-rate>
    <custom-attributes>
      <custom-attribute attribute-id="eaEmployeeId">854807</custom-attribute>
      <custom-attribute attribute-id="eaOverrideReasonCode">Customer Accommodation</custom-attribute>
      <custom-attribute attribute-id="eaPriceOverrideType">amount</custom-attribute>
      <custom-attribute attribute-id="eaPriceOverrideValue">2</custom-attribute>
    </custom-attributes>
</shipping-lineitem>

Related Links

Track Orders in Endless Aisle

Generating GMV Reports for Endless Aisle Sales

Display Store Inventory in the Endless Aisle App

Use Google Analytics

View Endless Aisle Sales Reports