Vallarta Supermarket

MERCED, CA 95348 · O1b228fbc1d1a · first seen 2026-10-08
6 sourcesoff premise · grocerychain: Vallarta Supermarketsalcohol: licensed1 licence

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
Vallarta Supermarket 4 other
a licence name in capitals, cleaned (derived; record_title.py)
VALLARTA SUPERMARKETS ca-abcovertureubereats ×3
VALLARTA FOOD ENTERPRISES INC ca-abc (legal name)
vallarta supermarkets la cocina merced doordash
vallarta supermarkets merced doordash
Street
851 WEST OLIVE AVE 4 other
ca-abc
851 W Olive Ave doordash ×2
851 W OLIVE AVE STE 37 ab-inbevvtinfo ×2
851 W. Olive Avenue overture
851 West Olive Ave., #370 ubereats
City
MERCED
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95348
ca-abcno other value
Pin
37.32036, -120.48343 map 5 other
ubereats
151 m away doordash ×2
1374 m away ab-inbev
119 m away ca-abc
100 m away overture
107 m away vtinfo
Phone
8188980088
vtinfono other value
Licences
ca-abc 00670250|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od9f7c59a015c; O21fb55df6794; O1e205f3334b4; Off6bad360a3b; Ob1fc53fc6c0c; O5ad6bdc9817f

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevVALLARTA SUPERMARKET
4966601
851 W OLIVE AVE STE 37, MERCED, CA, 9534837.32854, -120.495082026-11-112026-11-11
ca-abcVALLARTA SUPERMARKETS
legal name: VALLARTA FOOD ENTERPRISES INC
00670250|21|LIC|0
851 WEST OLIVE AVE, MERCED, CA, 9534837.31930, -120.483262026-10-082026-11-05
doordashvallarta supermarkets merced
49154090
851 W Olive Ave, Merced, CA, 9534837.32052, -120.482382026-10-082026-11-06
doordashvallarta supermarkets la cocina merced
49809492
851 W Olive Ave, Merced, CA, 9534837.32112, -120.484842026-10-082026-11-12
overtureVallarta Supermarkets
16e391fc-5f5c-4852-b4a4-a1a5c508f835
851 W. Olive Avenue, Merced, CA, 9534837.32098, -120.482612026-11-062026-11-06
ubereatsVallarta Supermarkets
c1yK44ooUWmwL9eaRT8wLA
851 West Olive Ave., #370, Merced, CA, 9534837.32036, -120.483432026-10-112026-11-03
vtinfoVALLARTA SUPERMARKET
da8e3d1267b52908
851 W OLIVE AVE STE 37, MERCED, CA, 95348818898008837.31946, -120.483022026-11-162026-11-17

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ab-inbev VALLARTA SUPERMARKETvtinfo VALLARTA SUPERMARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1469 m apart · name similarity 1.00
ca-abc VALLARTA SUPERMARKETSdoordash vallarta supermarkets merced1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 156 m apart · name similarity 1.00
ca-abc VALLARTA SUPERMARKETSoverture Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 196 m apart · name similarity 1.00
ca-abc VALLARTA SUPERMARKETSubereats Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash vallarta supermarkets mercedoverture Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 55 m apart · name similarity 1.00
doordash vallarta supermarkets mercedubereats Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 94 m apart · name similarity 1.00
overture Vallarta Supermarketsubereats Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 100 m apart · name similarity 1.00
ab-inbev VALLARTA SUPERMARKETca-abc VALLARTA SUPERMARKETS0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 1465 m apart · name similarity 0.65
ab-inbev VALLARTA SUPERMARKETdoordash vallarta supermarkets merced0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 1434 m apart · name similarity 0.65
ab-inbev VALLARTA SUPERMARKEToverture Vallarta Supermarkets0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 1386 m apart · name similarity 0.65
ab-inbev VALLARTA SUPERMARKETubereats Vallarta Supermarkets0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 1374 m apart · name similarity 0.65
ca-abc VALLARTA SUPERMARKETSdoordash vallarta supermarkets la cocina merced0.65same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cocina · name Jaro-Winkler 0.73 · same street + ZIP · pins 246 m apart · name similarity 0.65
ca-abc VALLARTA SUPERMARKETSvtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 28 m apart · name similarity 0.65
doordash vallarta supermarkets mercedvtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 131 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina mercedoverture Vallarta Supermarkets0.65same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cocina · name Jaro-Winkler 0.73 · same street + ZIP · pins 198 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina mercedubereats Vallarta Supermarkets0.65same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cocina · name Jaro-Winkler 0.73 · same street + ZIP · pins 151 m apart · name similarity 0.65
overture Vallarta Supermarketsvtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 173 m apart · name similarity 0.65
ubereats Vallarta Supermarketsvtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 107 m apart · name similarity 0.65

Attributes

Channel
off_premise · grocery — ca-licence conflicting evidence
Chain
Vallarta Supermarkets — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
VALLARTA FOOD ENTERPRISES INC — 42 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "grocery"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
93 within 1 mi · 370 within 3 mi
Off / on premise
39 / 51 within 1 mi · 115 / 216 within 3 mi
Selling alcohol
42 within 1 mi · 211 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.12 mi
Setting
suburban (2,840 people per sq mi)
People within 3 mi
80,287 (52,641 adults 21+, 24,626 households) from 18 tract(s), tracts within 3 mi
Income
per capita $26,520 · median household ~$66,246 (weighted mean of tract medians)
Age and education
median age ~30.6 · bachelor's or higher 19%
Ethnicity
Hispanic 59% · White 29% · Black 5% · Asian 10%
Adults per alcohol outlet
248
Alcohol spend within 3 mi
$13,872,624 a year ($6,548,006 at home, $7,317,989 away) · $65,437 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-16 14:56insertdoordash 49154090 ↔ vtinfo da8e3d1267b52908same address and namemerged15
2026-11-16 14:56insertca-abc 00670250|21|LIC|0 ↔ vtinfo da8e3d1267b52908same address and namemerged15
2026-11-16 14:56insertubereats c1yK44ooUWmwL9eaRT8wLA ↔ vtinfo da8e3d1267b52908same address and namemerged15
2026-11-16 14:56insertoverture 16e391fc-5f5c-4852-b4a4-a1a5c508f835 ↔ vtinfo da8e3d1267b52908same address and namemerged15
2026-11-16 14:56insertab-inbev 4966601 ↔ vtinfo da8e3d1267b52908same address and namemerged15
2026-11-12 17:29insertca-abc 00670250|21|LIC|0 ↔ doordash 49809492same address and namemerged14
2026-11-12 17:29insertdoordash 49809492 ↔ ubereats c1yK44ooUWmwL9eaRT8wLAsame address and namemerged14
2026-11-12 17:29insertdoordash 49809492 ↔ overture 16e391fc-5f5c-4852-b4a4-a1a5c508f835same address and namemerged14
2026-11-11 12:56insertab-inbev 4966601 ↔ overture 16e391fc-5f5c-4852-b4a4-a1a5c508f835same address and namemerged12
2026-11-11 12:56insertab-inbev 4966601 ↔ ubereats c1yK44ooUWmwL9eaRT8wLAsame address and namemerged12
2026-11-11 12:56insertab-inbev 4966601 ↔ doordash 49154090same address and namemerged12
2026-11-11 12:56insertab-inbev 4966601 ↔ ca-abc 00670250|21|LIC|0same address and namemerged12
2026-11-06 18:13insertoverture 16e391fc-5f5c-4852-b4a4-a1a5c508f835 ↔ ubereats c1yK44ooUWmwL9eaRT8wLAsame address and namemerged11
2026-11-06 18:13insertdoordash 49154090 ↔ overture 16e391fc-5f5c-4852-b4a4-a1a5c508f835same address and namemerged11
2026-11-06 18:13insertca-abc 00670250|21|LIC|0 ↔ overture 16e391fc-5f5c-4852-b4a4-a1a5c508f835same address and namemerged11
2026-11-05 23:10backfilldoordash 49154090 ↔ ubereats c1yK44ooUWmwL9eaRT8wLAsame address and namemerged
2026-11-05 23:10backfillca-abc 00670250|21|LIC|0 ↔ doordash 49154090same address and namemerged
2026-11-03 13:33backfillca-abc 00670250|21|LIC|0 ↔ ubereats c1yK44ooUWmwL9eaRT8wLAsame address and namemerged