Examples
Examples
Try the starting example
- Offers: ID, source units, published units, source-updated timestamp, published-updated timestamp
- A,2,0,2026-10-20T11:00,2026-10-20T10:00 B,3,1,2026-10-20T10:00,2026-10-20T11:00 C,0,0,2026-10-20T10:00,2026-10-20T10:00
- Availability-status mismatches
- A
- Quantity mismatches
- A, B
- Published timestamp older than source timestamp
- A
- Compared offers
- 3
- Availability mismatch share (%)
- 33.333333
Try another scenario
- Offers: ID, source units, published units, source-updated timestamp, published-updated timestamp
- A,2,2,2026-10-20T11:00,2026-10-20T11:00 B,3,1,2026-10-20T10:00,2026-10-20T11:00 C,0,0,2026-10-20T10:00,2026-10-20T10:00
- Availability-status mismatches
- None
- Quantity mismatches
- B
- Published timestamp older than source timestamp
- None
- Compared offers
- 3
- Availability mismatch share (%)
- 0
Calculation method
Calculation method
Availability-status mismatches
Flag source>0 and published>0 disagreement.
Quantity mismatches
Flag exact whole-unit count disagreement independently of availability.
Published timestamp older than source timestamp
Flag published update strictly before source update; it is a chronology observation, not proof of stale content.
Compared offers
Count unique offer rows.
Availability mismatch share (%)
Availability-status mismatch count/offer count×100.
Symbols and units
- a
- Offers: ID, source units, published units, source-updated timestamp, published-updated timestamp
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-record comparison, without live stock verification, reservations, retailer matching or automatic publication changes.
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.