SKU coverage
Track SKU coverage in real-time to quickly identify if any product variants need to be restocked. Useful as an admin filter or Flow trigger to streamline product management and maintain availability across your catalog.
This is the normalized ratio between the total number of variants and the number of available variants for a product.
For a product with a single (default) variant, it is calculated as follows:
- If the product is in stock, SKU coverage = 1.0
- If the product isn't in stock, SKU coverage = 0.0
For products with multiple variants, the SKU coverage is calculated as the number of variants with available inventory divided by the total number of variants. The ratio is rounded to the nearest 0.2 multiple, giving a final SKU coverage value between 1.0 and 0.0 in steps of 0.2 - in other words, 6 different logical stock levels. The 1.0 and 0.0 sku coverages are only assigned when all or no variants have available stock, giving a true "fully stocked" or "out of stock" level, respectively.
The calculated SKU coverage value is assigned a label based on the value, as follows:
- 1.0 = Fully stocked
- 0.8 = Well stocked
- 0.6 = Partially stocked
- 0.4 = Limited stock
- 0.2 = Low stock
- 0.0 = Out of stock
This approach gives you easy-to-use admin or collection filter options to determine product availability across variants. You can now identify stock issues, filter & prioritize restocking, improve product completeness for better conversion, optimize marketing & merchandising, and automate inventory actions, all based on the calculated sku coverage.
Details
- Name
espresso.sku_coverage
- Description
Metafield namespace and key
- Name
metaobject_reference
- Description
Metafield type. Using a metaobject reference instead of just a number allows for a better filtering experience in Shopify Admin.
- Name
product
- Description
Scope of Shopify object that owns the metafield
Example content
{
"value": 0.2,
"label": "0.2 Low stock"
}
When you initially enable this metafield, the individual product metafields will be set in a background task. If you have a large catalog, this may take anywhere from a few minutes to a few hours. Once the metafields are set, they will be updated in real-time
Flow trigger
Updates to this metafield fires a trigger that can used to start a Shopify Flow workflow.
- Name
product
- Description
A reference to the product that owns the variants
- Name
skuCoverage
- Description
The rounded SKU coverage, one of 0.0, 0.2, 0.4, 0.6, 0.8, 1.0
- Name
skuCoverageExact
- Description
The calculated SKU coverage, using 2 decimal places
- Name
skuCoverageBefore
- Description
The rounded SKU coverage value before the update.
- Name
skuCoverageExactBefore
- Description
The calculated SKU coverage value before the update.
Example content
{
"product": "gid://shopify/Product/47953429430610",
"skuCoverage": 0.8,
"skuCoverageExact": 0.82,
"skuCoverageBefore": 0.4,
"skuCoverageExactBefore": 0.42
}