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