Examples
Examples
Try the starting example
- Styles: name, expected colours joined by |, expected sizes joined by |
- A,Red|Blue,S|M
- Observed variants: style, colour, size, stock units; or none
- A,Red,S,2 A,Red,M,0 A,Blue,S,3
- Listed variant coverage by style (%)
- A: 75
- In-stock variant coverage by style (%)
- A: 50
- Missing colour/size combinations by style
- A: Blue/M
- Expected variant combinations
- 4
- Total observed stock units
- 5
Try another scenario
- Styles: name, expected colours joined by |, expected sizes joined by |
- A,Red|Blue,S|M
- Observed variants: style, colour, size, stock units; or none
- A,Red,S,2 A,Red,M,0 A,Blue,S,3 A,Blue,M,4
- Listed variant coverage by style (%)
- A: 100
- In-stock variant coverage by style (%)
- A: 75
- Missing colour/size combinations by style
- A: None
- Expected variant combinations
- 4
- Total observed stock units
- 9
Calculation method
Calculation method
Listed variant coverage by style (%)
Observed distinct expected combinations / Cartesian expected combinations×100. A zero-stock variant is still listed.
In-stock variant coverage by style (%)
Count observed expected pairs with stock>0 / expected pairs×100.
Missing colour/size combinations by style
Enumerate expected pairs absent from supplied records, not zero-stock pairs.
Expected variant combinations
Sum colour count×size count across styles.
Total observed stock units
Sum recorded stock once per unique style/colour/size record.
Symbols and units
- a
- Styles: name, expected colours joined by |, expected sizes joined by |
- b
- Observed variants: style, colour, size, stock units; or none
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A supplied Cartesian assortment audit. Some colour/size combinations may intentionally not exist; define the expected matrix accordingly. Stock is not fetched or matched across retailers.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Google Merchant Center: product-data terminology and consistency background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.