SKU Coverage

SKU Coverage is the normalized ratio between the total number and the number of available variations of a base product. SKU Coverage is the same for all sites that share an Inventory list, so it's a site-specific value.

SKU Coverage:

  • Is a ratio value from 0.0 through 1.0
  • Is computed in real time in Salesforce B2C Commerce
  • Cannot be imported or exported
  • Is not staged, so its value is specific to an instance

Standard Product

  • If product is in stock, SKUCoverage = 1.0
  • If product isn't in stock, SKUCoverage = 0.0

Base Product

The SKU coverage for a base product is equal to the average of all the product variations.

SKUCoverage(mp) = SUM(SKUCoverage(vpX)) / X

Where:

  • mp is a base product
  • vpX are online variations of the base product
  • X is the number of online variation products

Example 1: All Products in Stock

  X-Small Small Medium Large X-Large
black sweatshirt orderable online orderable online orderable online orderable online orderable online
gray sweatshirt orderable online orderable online orderable online orderable online orderable online

In this case, there are 10 variation products. To calculate SKUCoverage, divide the number of variation products that are available to sell online (10) by the total number of variation products (10): 10/10=1.0

Example 2: Not All Products in Stock

Variation products

InStock: true

  X-Small Small Medium Large X-Large
black sweatshirt orderable online sold out online orderable online sold out online orderable online
gray sweatshirt orderable online orderable online sold out online orderable online orderable online

In this case, there are 10 variation products. To calculate SKUCoverage, divide the number of variation products that are available to sell online (7) by the total number of variation products (10): 7/10-.7

Product Bundle

  • If any bundled products are out of stock, SKUCoverage = 0.0
  • If all bundled products are in stock, SKUCoverage = 1.0

Example 1: Not All Products in Stock

Products in bundle

Product 1 - InStock: true

Product 2 - InStock: false

Product Bundle SKUCoverage: 0.0

Example 2: All Products in Stock

Products in bundle

Product 1 - InStock: true

Product 2 - InStock: true

Product Bundle SKUCoverage: 1.0

Product Set

The SKU coverage for a product set is the ratio of orderable SKUs in the product set over the total number of online SKUs in the product set.

Product Set Example:

Product Set Type SKU Orderable Online
Set Product 1 Variation      
    SKU-1 1 TRUE
    SKU-2 0 FALSE
    SKU-3 1 TRUE
Set Product 2 Variation      
    SKU-4 0 TRUE
    SKU-5 0 TRUE
    SKU-6 1 TRUE
Set Product 2 Standard SKU-7 1 TRUE

Total number of online SKUs in product set: 6

Number of orderable SKUs in the product set: 4

SKUCoverage of product set: 4/6 = 0.66