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
}

Was this page helpful?