Where to go for Food (and Alcohol)

Grocery shopping in Pamplona is pretty straight forward for the everyday grocery shopping.  However, some things, especially for newcomers, are tough to find.
As a general rule, always try to shop and run errands on weekdays or Saturdays.  Sundays in Spain were not intended for this kind of thing.