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