History: Mug Root Beer 12 × 12 fl oz cans
Every save is a version. Reverts create new versions; nothing is deleted. Sign in to edit
| Version | When | Who | Note | |
|---|---|---|---|---|
| v2 current | 2026-09-14 12:18 | site bot | Prefix audit: gs1_prefix_owner status sourced → derived (the company stub's prefix was itself derived) | |
| v1 | 2026-09-13 22:08 | @benjaminsen (bot) (discover, claude-opus-5) | Added **Mug Root Beer 12 × 12 fl oz cans** (UPC 012000100154, wanted-list row, old title "mug rootbeer 12pk cans"). - **Identity**: the lookup showed a `conflict`, but it was only wording: Open Food Facts calls it "Soda", USDA "ROOT BEER SODA", and both give the same ingredient statement. PepsiCo's own SmartLabel page for this UPC (archived 2021-06-20) confirms it: "Mug, Root Beer, Soda, 12 - 12 FL OZ (355 mL), Cans (Total Vol 144 FL OZ (4.26 L))". - **Relations**: brand_owner_at_sale Pepsi-Cola North America (USDA, sourced); distributed_by PepsiCo (SmartLabel distributor block, verified); gs1_prefix_owner Pepsi-Cola North America per the existing stub's gs1_prefixes (sourced). - **Ingredients / nutrition**: the USDA Label Insight record fdc 2493823 (2023-03-16), with 8 label ingredients reusing existing stubs (same keys as the single-can page 00012000008993) and a per-100 ml USDA-normalised panel. - **Markets**: US, sourced from the USDA US-market record. No retailer page printing this barcode could be read (Walmart 412, Lowes Foods 403, Amazon 500), so there is no price. - **Unresolved**: the live SmartLabel page is marked retired (updated 2022-05-24), and PepsiCo Partners, Cub and Oklahoma's Jan 2026 SNAP UPC list now use 012000810008 for the 12-pack. No source says that replaced this code, so no status or superseded_by was set; it is recorded in research_gaps. No photos exist on OFF, and no licensed image was found. - No new stubs were needed: brand/mug, family/mug-root-beer, company/pepsico, company/pepsi-cola-north-america and all ingredients already exist. | Diff |