---
schema_version: "1"
id: 9560be577a163a8ef975b578a0d0c7a9893f4cfe670aa38981fc843b94c82682
title: Value Calculation for Active Data
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/cc/264-0-0/b2c_value_calculation_for_active_data.md
canonical_url: https://help.salesforce.com/s/articleView?id=cc.b2c_value_calculation_for_active_data.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d69bfd41b178007f62d876047ebbb6308bfaf7891b9d9166703bc847afbadea9
description: In B2C Commerce, base product calculations ignore variations that have null or stale data when calculating the value of an attribute. Sliced variation calculations ignore sliced variations that have null or stale data when calculating the value of an attribute.
products:
  - Commerce
  - B2C Commerce
release: "264"
---
# Value Calculation for Active Data

In B2C Commerce, base product calculations ignore variations that have null or stale data when calculating the value of an attribute. Sliced variation calculations ignore sliced variations that have null or stale data when calculating the value of an attribute.

## Value Calculation for Attributes with Null Values

Product sets ignore products in the set with null or stale data when calculating the value of an attribute. Null data isn't the same as a 0.0 value. If a 0.0 value is provided as current data, it's included in the calculation.

For example, to calculate the cost price for a base product with five variation products, where only four have data, divide the sum of those four variation products by four.

```
Base Product MP-1
Var-1: Cost Price = $40.00
Var-2: Cost Price = $40.00
Var-3: Cost Price = $40.00
Var-4: Cost Price = $0.00 
Var-5:  

Average online variation product for MP-1 =  
sum(CostPrice, variation product) / count(variation products)
($40.00 + $40.00 + $40.00 + $0.00) / 4 = $30.00 
```

## Active Data Attribute Exceptions

B2C Commerce calculates active data attributes that aren't imported from other available attributes.

There are two exceptions to active data attribute calculations.

- B2C Commerce doesn’t compute values for custom attributes of active data system objects (ProductActiveData) that aren’t assigned to a category. Without the category assignment, the base product active data customer attribute value is set to value = 0.
- The active data custom attribute value for a base product isn’t calculated when its variation products have slicing configured. Including when the base product is assigned to a category. For example:
    - The variation product active data custom attribute has a value, but the base product has a value = 0
    - The variation product active data customer attribute has a value but slicing prohibits the value from showing on the storefront.

## Active Data Attribute Calculation Formulas

This table shows how B2C Commerce calculates each active data attribute by product type.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:9.233610341643583%">
          <col style="width:6.9252077562326875%">
          <col style="width:12.742382271468145%">
          <col style="width:15.974145891043397%">
          <col style="width:14.219759926131118%">
          <col style="width:14.958448753462603%">
          <col style="width:25.94644506001847%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e99">Sorting Attribute</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e102">Type</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e105">Standard or Bundle</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e108">Main</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e111">Product Set</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e115">Slicing</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e118">Variation Group</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">AvailableDate</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Date</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">
              <p style="margin-bottom:0;">Active Data Value (user-provided)</p>
            </td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">Active Data Value (user-provided)</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">Active Data Value (user-provided)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">Active Data Value from Main&nbsp; (user-provided)</td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">Active Data Value (user-provided)</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">AvgGrossMarginPercent</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">AvgGrossMarginValue / AvgSalesPrice * 100.0</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">AvgGrossMarginValue / AvgSalesPrice * 100.0</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">AvgGrossMarginValue / AvgSalesPrice * 100.0</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">Value from Main</td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e118 ">AvgGrossMarginValue / AvgSalesPrice * 100.0</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">AvgGrossMarginValue</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">AvgSalesPrice - CostPrice</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">AvgSalesPrice - CostPrice</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">AvgSalesPrice - CostPrice</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">Value from Main</td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">AvgSalesPrice - CostPrice</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">AvgSalesPrice</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Revenue / Units</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">Average online variation products sum(Revenue, variation
              products) / sum(Units, variation products)</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">sum(AvgSalesPrice, set_products) </p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Average all variation products in slicing group</p>
              <p style="margin-bottom:0;"> sum(Revenue, variation products) / sum(Units, variation products)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">Average online variation products sum(Revenue, variation products) /
              sum(Units, variation products)</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">Conversion</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Orders(product) / Visits(site)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">
              <p>Average online variations sum(Orders, variations) / (sum(Views,
                variations) + view(base product)</p>
              <p style="margin-bottom:0;">(This is the same as LookToBookRatio.)</p>
            </td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">Average online set products sum(Conversion*Units, set_products) / sum
                (Units, set_products)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Average online variation products in slicing group </p>
              <p style="margin-bottom:0;">sum(Conversion*Units, variation products) / sum (Units, variation
                products)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">
              <p>Average online variation products sum(Orders, variation products) /
                (sum(Views, variation products) + view(variation group))</p>
              <p style="margin-bottom:0;">(This is the same as LookToBookRatio.)</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">CostPrice</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Active Data Value (user-provided)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">Average online variation products sum(CostPrice, variation
              products) / count(variation products)</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">Sum of online set products sum(CostPrice, set_products)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Average online variation products in slicing group</p>
              <p style="margin-bottom:0;">sum(CostPrice, variation products) / count(variation products)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">Average online variation products sum(CostPrice, variation products) /
              count(variation products)</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">CreationDate</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Date</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">System data</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">System data</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">System data</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">System data from Main&nbsp;</td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">System data</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">DaysAvailable</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">
              <p>(CurrentDate - AvailableDate) / 24 h </p>
              <p>or </p>
              <p>(Current - CreationDate) / 24 h</p>
              <p style="margin-bottom:0;">If there’s no availableDate set, creationDate is used instead.</p>
            </td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">sum(DaysAvailable, variations + base
              product)/count(variations + base product)</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">CurrentDate - (AvailableDate) / 24 h or Current - (CreationDate)/24h</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">Value from Main</td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">sum(DaysAvailable, variations + variation group)/count(variations +
              variation group)</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">Impressions</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Integer</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Impressions(product/bundle)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">Sum online variations + base product value sum(Impressions,
              variations) + Impressions(base product)</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">Impressions(product set)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Sum online variations in slicing group + base product value</p>
              <p style="margin-bottom:0;">sum(Impressions, variations) + Impressions(base product)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">Sum online variation products in variation group+ variation group value
              sum(Impressions, variation products) + Impressions(variation group)</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">LastModified</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Date</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Product Value</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">Product Value</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">Product Value</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">Value from Main</td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">Product Value</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">LookToBookRatio</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">
              <p>Min(100, 100 * Orders/Views) </p>
              <p>0 if Orders == 0 </p>
              <p style="margin-bottom:0;">100 if Views == 0</p>
            </td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">Average online variations sum(Orders, variation products) /
              (sum(Views, variation products) + view(base product))</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">Sum of online set products sum(LookToBookRatio*Units, set_products) / sum
                (Units, set_products)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Average online variation products in slicing group</p>
              <p style="margin-bottom:0;">sum(LookToBookRatio, variation products) / count(variation products)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">Average online variation products sum(Orders, variation products) /
              (sum(Views, variation products) + view(variation group))</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">Orders</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Integer</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Orders(product/bundle)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">Sum all variation products sum(Orders, variation
              products)</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">Sum of online set products sum(Orders, set_products)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Sum all variation products in slicing group </p>
              <p style="margin-bottom:0;">sum(Orders, variation products)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">Sum all variation products in variation group sum(Orders, variation
              products)</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">ReturnRate</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Active Data Value (user-provided)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">Average all variation products sum(ReturnRate * UnitsYear,
              variation product) / sum(UnitsYear, variation products)</td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">Average all set products sum(ReturnRate * UnitsYear, set_products) /
                sum(UnitsYear, set_products)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Average all variation products in slicing group </p>
              <p style="margin-bottom:0;">sum(ReturnRate * UnitsYear, variation product) / sum(UnitsYear, variation
                products)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">Average all variation products in variation group sum(ReturnRate *
              UnitsYear, variation product) / sum(UnitsYear, variation products)</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">Revenue</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Revenue(product/bundle)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">
              <p>Sum all variation products </p>
              <p style="margin-bottom:0;">sum(Revenue, variation products)</p>
            </td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p>Sum of online set products</p>
              <p style="margin-bottom:0;">sum(Revenue, set_products)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Sum all variation products in slicing group </p>
              <p style="margin-bottom:0;">sum(Revenue, variation products)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">
              <p>Sum all variation products in variation group</p>
              <p style="margin-bottom:0;">sum(Revenue, variation products)</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">SalesVelocity</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Units / (24.0 * min(1.0, DaysAvailable)) FeedImportDate +
              24 h - AvailabilityDate or CreationDate</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">
              <p>Sum online variation products </p>
              <p style="margin-bottom:0;">sum(SalesVelocity, variation products)</p>
            </td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p>Maximum online set products</p>
              <p style="margin-bottom:0;">max(SalesVelocity, set_products)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Sum online variation products in slicing group</p>
              <p style="margin-bottom:0;">Sum(SalesVelocity, variation products)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">
              <p>Sum online variation products in variation group</p>
              <p style="margin-bottom:0;">Sum(SalesVelocity, variation products)</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">Units</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Double</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Units(product/bundle)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">
              <p>Sum all variations</p>
              <p style="margin-bottom:0;">Sum(Units, variation products)</p>
            </td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p>Sum of online set products </p>
              <p style="margin-bottom:0;">Sum(Units, set_products)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Sum all variation products in slicing group</p>
              <p style="margin-bottom:0;">Sum(Units, variation products)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">
              <p>Sum all variations in variation group</p>
              <p style="margin-bottom:0;">Sum(Units, variations)</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e99 ">Views</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e102 ">Integer</td>

            <td data-label="Standard or Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e105 ">Views(product/bundle)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e108 ">
              <p>Sum all variations + base product value </p>
              <p style="margin-bottom:0;">Sum(views, variations) + views(base product)</p>
            </td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e111 ">
              <p style="margin-bottom:0;">views(product set)</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e115 ">
              <p>Sum all variations in slicing group + base product value</p>
              <p style="margin-bottom:0;">sum(views, variations) + views(main product)</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e118 ">
              <p>Sum all variation products + variation group value</p>
              <p style="margin-bottom:0;">sum(views, variations) + views(variation group)</p>
            </td>

          </tr>
        </tbody>
      </table>

## Sorting Attributes

The following attributes are used in sorting rules. This table describes how they’re calculated for different product types.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:11.1%">
          <col style="width:13.900000000000002%">
          <col style="width:4.7%">
          <col style="width:7.000000000000001%">
          <col style="width:10.6%">
          <col style="width:15.2%">
          <col style="width:15.6%">
          <col style="width:21.9%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e799">Sorting Attribute</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e802">Documentation</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e805">Product</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e808">Bundle</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e811">Main</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e815">Product Set</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e818">Slicing</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d166120e821">Variation Group</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e799 ">String Attribute like name, description</td>

            <td data-label="Documentation" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e802 ">
              <p>Locale specific sorting of the string value. The locale of the index is
                used. </p>
              <p style="margin-bottom:0;">Null values are always last.</p>
            </td>

            <td data-label="Product" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e805 ">Product Value</td>

            <td data-label="Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e808 ">Product Value (Bundle)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e811 ">
              <p>Value of the base product if it's defined. </p>
              <p style="margin-bottom:0;">Fall back to variations represented by search hit.</p>
            </td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e815 ">
              <p>Value of the product set if it's defined.</p>
              <p style="margin-bottom:0;">Fall back to set products represented by search hit.</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e818 ">
              <p>Value of the base product if it's defined. </p>
              <p style="margin-bottom:0;">Fall back to variations at the group represented by search hit.</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e821 ">
              <p>Value of the variation group if it's defined.</p>
              <p style="margin-bottom:0;">Fall back to variations represented by search hit.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e799 ">Date attributes</td>

            <td data-label="Documentation" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e802 ">
              <p>Sorting of date values.</p>
              <p style="margin-bottom:0;">Null values are always last.</p>
            </td>

            <td data-label="Product" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e805 ">Product Value</td>

            <td data-label="Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e808 ">Product Value (Bundle)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e811 ">
              <p>Value of the base product if it's defined. </p>
              <p style="margin-bottom:0;">Fall back to variations represented by search hit.</p>
            </td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e815 ">
              <p>Value of the product set if it's defined. </p>
              <p style="margin-bottom:0;">Fall back to set products represented by search hit.</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e818 ">
              <p>Value of the base product if it's defined. </p>
              <p style="margin-bottom:0;">Fall back to variations at the group represented by search hit.</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e821 ">
              <p>Value of the variation group if it's defined.</p>
              <p style="margin-bottom:0;">Fall back to variations represented by search hit.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e799 ">Numeric attributes</td>

            <td data-label="Documentation" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e802 ">
              <p>Sorting of numeric values.</p>
              <p style="margin-bottom:0;">Null values are always last.</p>
            </td>

            <td data-label="Product" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e805 ">Product Value</td>

            <td data-label="Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e808 ">Product Value (Bundle)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e811 ">
              <p>Value of the base product if it's defined. </p>
              <p style="margin-bottom:0;">Fall back to variations represented by search hit.</p>
            </td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e815 ">
              <p>Value of the product set if it's defined. </p>
              <p style="margin-bottom:0;">Fall back to set products represented by search hit.</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e818 ">
              <p>Value of the base product if it's defined.</p>
              <p style="margin-bottom:0;">Fall back to variations at the group represented by search hit.</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e821 ">
              <p>Value of the variation group if it's defined.</p>
              <p style="margin-bottom:0;">Fall back to variations represented by search hit.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e799 ">Category-specific attributes (search rank and search
              placement)</td>

            <td data-label="Documentation" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e802 ">
              <p>Value of product in currently selected refinement category. </p>
              <p style="margin-bottom:0;">Null values are always last.</p>
            </td>

            <td data-label="Product" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e805 ">Product Value</td>

            <td data-label="Bundle" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e808 ">Product Value (Bundle)</td>

            <td data-label="Main" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e811 ">
              <p>Value of the base product if it's defined. </p>
              <p style="margin-bottom:0;">Fall back to variations represented by search hit.</p>
            </td>

            <td data-label="Product Set" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e815 ">
              <p>Value of the product set if it's defined.</p>
              <p style="margin-bottom:0;"> Fall back to set products represented by search hit.</p>
            </td>

            <td data-label="Slicing" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e818 ">
              <p>Value of the base product if it's defined. </p>
              <p style="margin-bottom:0;">Fall back to variations at the group represented by search hit.</p>
            </td>

            <td data-label="Variation Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e821 ">
              <p>Value of the variation group if it's defined.</p>
              <p style="margin-bottom:0;">Fall back to variations represented by search hit.</p>
            </td>

          </tr>
        </tbody>
      </table>

## Special Sorting Attributes

These sorting rule attributes are calculated differently than most attributes.

       
| Sorting Attribute | Documentation | Product | Bundle | Main | ProductSet | Slicing | Variation Group |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Availability Rank | Creates two groups of search hits based on the attribute 'Availability' and a configurable threshold: "high availability" and "low or no availability". A search hit belongs to either the one or the other. Sorting direction is always descending and then group 'high availability' is shown before 'low availability'. | Product Value | Product Value (Bundle) | Highest Availability of all variation products represented by search hit. | Highest Availability of all set products represented by search hit. | Highest Availability of all variation products at the group represented by search hit. | Highest Availability of all variation products represented by search hit. |
| Category Position | Position of product in currently selected refinement category. Always ascending (highest positioned first). | Product Value | Product Value (Bundle) | Product Value (Main) | Product Value (Product Set) | Main Value | Product Value (VariationGroup) |
| Price | The price book price currently active. Either ascending or descending. | Product Value | Product Value (Bundle) | Lowest/highest price of all variation products represented by search hit. | Lowest/highest price of all set products represented by search hit. | Lowest/highest price of all variation products at the group represented by search hit. | Lowest/highest price of all variation products represented by search hit. |
| Text Relevance | The relevance based on search keyword. Always descending (most relevant first). | Product Value | Product Value (Bundle) | Most relevant variation represented by search hit. | Most relevant set product represented by search hit. | Most relevant variation at the group represented by search hit. | Most relevant variation at the group represented by search hit. |

## Product Attributes

This table lists these product attributes, used for active data, by product type.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:7.3999999999999995%">
          <col style="width:6.3%">
          <col style="width:9.700000000000001%">
          <col style="width:18.3%">
          <col style="width:14.099999999999998%">
          <col style="width:11.700000000000001%">
          <col style="width:13.4%">
          <col style="width:19.1%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e1276">Sorting Attribute</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e1279">Type</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e1282">Product</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e1285">
              <p>Bundle</p>
              <p>all bundled products</p>
              <p style="margin-bottom:0;">online bundled products</p>
            </th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e1297">
              <p>Main</p>
              <p>all variations</p>
              <p style="margin-bottom:0;">online variations</p>
            </th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e1310">
              <p>Product Set </p>
              <p> all set products</p>
              <p style="margin-bottom:0;"> online set products</p>
            </th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d166120e1322">
              <p> Slicing</p>
              <p> all variations of group</p>
              <p style="margin-bottom:0;"> online variations of group </p>
            </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d166120e1334">
              <p>Variation Group</p>
              <p>all variations of group</p>
              <p style="margin-bottom:0;">online variations of group</p>
            </th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1276 ">ATS</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1279 ">BigDecimal</td>

            <td data-label="Product" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1282 ">Product Value (Inventory Record)</td>

            <td data-label="Bundle all bundled products online bundled products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1285 ">
              <p>Product Value (Bundle) if it's defined </p>
              <p style="margin-bottom:0;">Sum ATS of online bundled products (sum(ATS))</p>
            </td>

            <td data-label="Main all variations online variations" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1297 ">
              <p>Product Value (Main) if it's defined </p>
              <p style="margin-bottom:0;">Sum ATS of online variations (sum(ATS))</p>
            </td>

            <td data-label="Product Set all set products online set products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1310 ">
              <p>Product Value (ProductSet) if it's defined </p>
              <p style="margin-bottom:0;"> Sum ATS of online set products (sum(ATS))</p>
            </td>

            <td data-label="Slicing all variations of group online variations of group" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1322 ">
              <p>Main Value if it's defined </p>
              <p style="margin-bottom:0;">Sum ATS of online variations the group (sum(ATS))</p>
            </td>

            <td data-label="Variation Group all variations of group online variations of group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e1334 ">
              <p>Product Value (VariationGroup) if it's defined</p>
              <p style="margin-bottom:0;">Sum ATS of online bundled products (sum(ATS))</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1276 ">Availability</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1279 ">double</td>

            <td data-label="Product" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1282 ">Product Value (Inventory Record)</td>

            <td data-label="Bundle all bundled products online bundled products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1285 ">
              <p> Product Value (Bundle) if it's defined and UseBundleInventoryOnly </p>
              <p style="margin-bottom:0;">Min Availability of bundle and all bundled products
                (min(Availability))</p>
            </td>

            <td data-label="Main all variations online variations" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1297 ">
              <p>Product Value (Main) if it's defined </p>
              <p style="margin-bottom:0;"> Average Availability of online variations (avg(Availability))</p>
            </td>

            <td data-label="Product Set all set products online set products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1310 ">
              <p> Product Value (ProductSet) if it's defined </p>
              <p style="margin-bottom:0;"> Max Availability of online set products (max(Availability))</p>
            </td>

            <td data-label="Slicing all variations of group online variations of group" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1322 ">
              <p>Main Value if it's defined </p>
              <p style="margin-bottom:0;">Average Availability of online variations at the group
                (avg(Availability)) </p>
            </td>

            <td data-label="Variation Group all variations of group online variations of group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e1334 ">
              <p>Product Value (VariationGroup) if it's defined</p>
              <p style="margin-bottom:0;">Average Availability of online variations (avg(Availability))</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1276 ">Orderable</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1279 ">boolean</td>

            <td data-label="Product" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1282 ">Product Value (Inventory Record)</td>

            <td data-label="Bundle all bundled products online bundled products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1285 ">
              <p>Product Value (Bundle) if it's defined and UseBundleInventoryOnly</p>
              <p style="margin-bottom:0;">true in case all bundled products are orderable (no online check)</p>
            </td>

            <td data-label="Main all variations online variations" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1297 ">
              <p> Product Value (Main) if it's defined </p>
              <p style="margin-bottom:0;">true in case one variation is orderable, false otherwise (no online
                check) </p>
            </td>

            <td data-label="Product Set all set products online set products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1310 ">
              <p> Product Value (Product Set) if it's defined </p>
              <p style="margin-bottom:0;">true in case one set product is orderable, false otherwise (no online
                check) </p>
            </td>

            <td data-label="Slicing all variations of group online variations of group" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1322 ">
              <p> Main Value if it's defined </p>
              <p style="margin-bottom:0;">true in case one variation at the group is orderable, false otherwise (no
                online check) </p>
            </td>

            <td data-label="Variation Group all variations of group online variations of group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e1334 ">
              <p>Product Value (VariationGroup) if it's defined</p>
              <p style="margin-bottom:0;">true in case one variation is orderable, false otherwise (no online
                check)</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1276 ">SKUCoverage</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1279 ">double</td>

            <td data-label="Product" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1282 ">Product Value (Inventory Record)</td>

            <td data-label="Bundle all bundled products online bundled products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1285 ">
              <p style="margin-bottom:0;">1 in case all online bundled products are in stock, 0 otherwise</p>
            </td>

            <td data-label="Main all variations online variations" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1297 ">
              <p style="margin-bottom:0;"> Average SKUCoverage of online variations (avg(SKUCoverage))</p>
            </td>

            <td data-label="Product Set all set products online set products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1310 ">
              <p style="margin-bottom:0;"> The ratio of orderable SKUs in the product set over the total number of
                online SKUs in the product set. </p>
            </td>

            <td data-label="Slicing all variations of group online variations of group" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1322 ">
              <p style="margin-bottom:0;">1 in case one of the online variations at the group is in stock, 0
                otherwise </p>
            </td>

            <td data-label="Variation Group all variations of group online variations of group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e1334 ">Average SKUCoverage of online variations (avg(SKUCoverage))</td>

          </tr>
          <tr class="">
            <td data-label="Sorting Attribute" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1276 ">TTOOS</td>

            <td data-label="Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1279 ">double</td>

            <td data-label="Product" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1282 ">Product Value (Inventory Record)</td>

            <td data-label="Bundle all bundled products online bundled products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1285 ">
              <p>Product Value (Bundle) if it's defined </p>
              <p style="margin-bottom:0;">Min TTOOS of online bundled products (min(TTOOS))</p>
            </td>

            <td data-label="Main all variations online variations" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1297 ">
              <p style="margin-bottom:0;"> Max TTOOS of online variations (max(TTOOS))</p>
            </td>

            <td data-label="Product Set all set products online set products" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1310 ">
              <p style="margin-bottom:0;"> Max TTOOS of online set products (max(TTOOS)) </p>
            </td>

            <td data-label="Slicing all variations of group online variations of group" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d166120e1322 ">
              <p style="margin-bottom:0;">Max TTOOS of online variations at the group (max(TTOOS))</p>
            </td>

            <td data-label="Variation Group all variations of group online variations of group" class="slds-cell-wrap" style="vertical-align:top;" headers="d166120e1334 ">Max TTOOS of online variations (max(TTOOS))</td>

          </tr>
        </tbody>
      </table>

## Value Calculation Example

            
| Product Data | ​​ | ​ | ​ | Inventory Record | ​ | Active Data | ​ | ​ | Calculated (don’t change) | ​ | ​ | ​ |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| SKU | Color | Size | Online | Allocation | ATS | Orders | Views | Units | Availability | SKU Coverage | Sales Velocity | TTOS |
| Variation group | Red |   |   |   |   | n/a |   |   | 5.00 | 1.00 | 0.96 | 120 |
| 1234A | Red | s | 1 | 2 | 10 | 2 | 250 | 2 | 5.00 | 1 | 0.08 | 120 |
| 1234B | Red | m | 1 | 2 | 10 | 8 | 0 | 8 | 5.00 | 1 | 0.33 | 30 |
| 1234C | Red | l | 1 | 2 | 10 | 10 | 0 | 10 | 5.00 | 1 | 0.42 | 24 |
| 1234D | Red | xl | 1 | 2 | 10 | 3 | 0 | 3 | 5.00 | 1 | 0.13 | 80 |