Examples
Examples
Try the starting example
- Products: SKU, supplied stock, minimum stock, planned launch date
- A,2,1,2026-10-25 B,0,1,2026-10-25
- Required asset roles joined by |
- main|copy
- Asset records: SKU, role, approved yes/no, confirmed date or none; whole input none means no records
- A,main,yes,2026-10-20 A,copy,yes,2026-10-26 B,main,yes,2026-10-20 B,copy,no,none
- Products meeting supplied launch prerequisites
- None
- Blockers by SKU
- A: copy (after launch); B: stock, copy (not approved)
- Products meeting all prerequisites (%)
- 0
- Latest confirmed asset date by SKU, independent of stock
- A: 2026-10-26; B: Incomplete
Try another scenario
- Products: SKU, supplied stock, minimum stock, planned launch date
- A,2,1,2026-10-25 B,0,1,2026-10-25
- Required asset roles joined by |
- main|copy
- Asset records: SKU, role, approved yes/no, confirmed date or none; whole input none means no records
- A,main,yes,2026-10-20 A,copy,yes,2026-10-24 B,main,yes,2026-10-20 B,copy,no,none
- Products meeting supplied launch prerequisites
- A
- Blockers by SKU
- A: None; B: stock, copy (not approved)
- Products meeting all prerequisites (%)
- 50
- Latest confirmed asset date by SKU, independent of stock
- A: 2026-10-24; B: Incomplete
Calculation method
Calculation method
Products meeting supplied launch prerequisites
Require stock≥entered minimum and an approved record for every declared role dated on/before the product launch date.
Blockers by SKU
List insufficient stock, absent/unapproved roles and roles confirmed after launch separately.
Products meeting all prerequisites (%)
Ready product count/all product count×100.
Latest confirmed asset date by SKU, independent of stock
Maximum approved-role date only when all required roles have approved dates; otherwise Incomplete.
Symbols and units
- a
- Products: SKU, supplied stock, minimum stock, planned launch date
- b
- Required asset roles joined by |
- c
- Asset records: SKU, role, approved yes/no, confirmed date or none; whole input none means no records
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 provided-prerequisite audit against planned launch dates. It does not inspect assets, verify approvals, publish products or treat a supplied future date as an independently confirmed event.
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.