You are here:
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. This topic applies to B2C Commmerce.
SKU Coverage:
- Is a ratio value from 0.0 through 1.0
- Salesforce B2C Commerce computes this value in real time
- Can’t be imported or exported
- Isn’t 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 represented product variations. SKU coverage is affected by turnover, so if the Available to Sell (ATS) calculation of a simple product is 100 and turnover is 10, skuCoverage = 0.9
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 's 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 's 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
