Examples
Examples
Try the starting example
- Category requirements: category, required attribute keys joined by |
- apparel,color|size|material bag,color|material
- Products: SKU, category, key=value attributes joined by |; NA or blank value is missing
- A,apparel,color=red|size=M B,bag,color=black|material=leather
- Populated required attribute slots (%)
- 80
- Products with all required attributes (%)
- 50
- Missing required fields by SKU
- A: material; B: None
- Missing slots counted by attribute
- material: 1
Try another scenario
- Category requirements: category, required attribute keys joined by |
- apparel,color|size|material bag,color|material
- Products: SKU, category, key=value attributes joined by |; NA or blank value is missing
- A,apparel,color=red|size=M|material=cotton B,bag,color=black|material=leather
- Populated required attribute slots (%)
- 100
- Products with all required attributes (%)
- 100
- Missing required fields by SKU
- A: None; B: None
- Missing slots counted by attribute
- None
Calculation method
Calculation method
Populated required attribute slots (%)
Populated required fields / total required product-field slots×100.
Products with all required attributes (%)
Products with zero missing required fields / product count×100.
Missing required fields by SKU
Compare each product against its declared category requirements.
Missing slots counted by attribute
Aggregate missing required slots by field name; preserve first missing-field order.
Symbols and units
- a
- Category requirements: category, required attribute keys joined by |
- b
- Products: SKU, category, key=value attributes joined by |; NA or blank value is missing
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 presence check against requirements you define. Nonempty values are not automatically truthful, normalized, semantically correct or compliant with a merchant policy.
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.