SELECT `pinfo`.`sku`,`pinfo`.`vendor`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('1021')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN MATCH(`desc_short`) AGAINST ('MealsandSnackBars' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+MealsandSnackBars' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"MealsandSnackBars"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"MealsandSnackBars"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"MealsandSnackBars"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"MealsandSnackBars"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+MealsandSnackBars' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='MealsandSnackBars',`category_4` ='MealsandSnackBars') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'MealsandSnackBars,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('MealsandSnackBars', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Meals And Snack Bars

Refine Search

  GO
Brand

KIND(52)

Kellogg's(15)

Nature Valley(8)

THIS BAR SAVES LIVES(7)

General Mills(4)

CLIF Bar(3)

Quaker(3)

Larabar(2)

Kashi(2)

Kraft(1)

Annie's Homegrown(1)

N'Joy(1)

Packing Type

Bar(64)

Cup(12)

Individually Wrapped(9)

Individually Wrapped Bar(7)

Box(5)

Pouch(1)

Bowl(1)

Flavor

Crunchy Peanut Butter(3)

Strawberry(3)

Blueberry(3)

Dark Chocolate Nuts & Sea Salt(2)

Salted Caramel & Dark Chocolate Nut + Dark Chocolate Almond & Coconut(2)

Assorted(2)

Peanut Butter(2)

Dark Chocolate(2)

Peanut Butter Dark Chocolate(2)

Madagascar Vanilla & Almond & Honey(2)

Dark Chocolate Banana(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Almond Mint(1)

Chewy Chocolate Chip(1)

Chewy Honey Oat(1)

Chewy Peanut Butter Chocolate Chip(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Cocoa(1)

Almond Butter(1)

Pineapple Banana Kale Spinach(1)

Honey Roasted Nuts & Sea Salt(1)

Mango Apple Chia(1)

Strawberry Apple Chia(1)

Cherry Cashew/Dark Chocolate; Dark Chocolate/Peanut Butter(1)

Raspberry Cashew & Chia(1)

Dark Chocolate Nuts & Sea Salt;Caramel Almond Nuts & Sea Salt(1)

Cherry Apple Chia(1)

Toasted Caramel Nut(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Morning Harvest(1)

Dark Chocolate & Cherry(1)

Wild Blueberry & Pistachio(1)

PB&J(1)

Dark Chocolate & Coconut(1)

Dark Chocolate & Peanut Butter(1)

Peanut Butter Dark Chocolate Peanut Butter(1)

Dark Chocolate Nuts & Sea Salt/Caramel Almond & Sea Salt(1)

Chocolate Peanut Butter(1)

Dark Chocolate Mocha Almond(1)

Double Dark Chocolate(1)

Honey Almond Butter(1)

Almond Butter Dark Chocolate(1)

Dark Chocolate Cherry Cashew(1)

Caramel Almond Nuts & Sea Salt(1)

Salted Caramel and Dark Chocolate Nut(1)

White Chocolate Cinnamon Almond(1)

Oats & Honey with Toasted Coconut(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Dark Chocolate and Peanut Butter(1)

Original(1)

Oats 'n Honey(1)

Raisin Bran Crunch(1)

Frosted Flakes(1)

Froot Loops(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Cheerios(1)

Cashew Cookie(1)

Peanut Butter Chocolate Chip(1)

Cinnamon Toast Crunch(1)

Honey Nut Cheerios(1)

Crunchy Oats'n Honey(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Cranberry Almond(1)

Blueberry; Brown Sugar Cinnamon; Strawberry(1)

Madagascar Vanilla Almond(1)

Almond & Coconut(1)

Fruit & Nut Delight(1)

Dark Chocolate Cinnamon Pecan(1)

Maple Glazed Pecan & Sea Salt(1)

Dark Chocolate Chunk(1)

Real Aged Cheddar(1)

Blueberry Vanilla & Cashew(1)

Peanut Butter Dark Chocolate plus Protein(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Raspberry(1)

Apple Cinnamon(1)

Chocolate & Peanut Butter(1)

Trail Mix(1)

Honey Almond Flax(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Cranberry Almond plus Antioxidants(1)

Frosted Mini Wheats(1)

Caramel Almond & Sea Salt(1)

Country of Origin

US(99)

Capacity (Weight)

1.4 oz(26)

1.2 oz(10)

0.7 oz(10)

1.3 oz(8)

0.81 oz(5)

1.76 oz(5)

1.5 oz(4)

2.4 oz(3)

50 g(2)

35 g(2)

1.59 oz(2)

0.88 oz(2)

1.34 oz(2)

0.6 oz(2)

2 oz(2)

1.23 oz(1)

2.46 oz(1)

3.08 oz(1)

2.64 oz(1)

2.39 oz(1)

1.8 oz(1)

1.7 oz(1)

1.6 oz(1)

1.73 oz(1)

2.1 oz(1)

2.01 oz(1)

1.16 oz(1)

2.8 oz(1)

2.5 oz(1)

Food Type

Nutrition & Snack Bars(67)

Granola(12)

Breakfast Cereal(9)

Snack Bar(4)

Oatmeal(3)

Cereal Bar(2)

Meal/Entree(1)

Lunch(1)

Contains Dairy

Yes(31)

No(4)

Contains Nuts

Yes(54)

No(5)

Gluten Free

Yes(61)

No(2)

Kosher

Yes(72)

Manufacturer Shelf Life

456 Days(32)

365 Days(10)

240 Days(8)

255 Days(7)

273 Days(7)

270 Days(4)

330 Days(3)

248 Days(3)

279 Days(3)

372 Days(3)

75 Days(2)

540 Days(1)

450 Days(1)

456 days(1)

305 Days(1)

280 Days(1)

Non-GMO

Yes(52)

No(3)

Special Features

Madagascar Vanilla & Almond & Honey(2)

PB&J(1)

Dark Chocolate & Coconut(1)

Wild Blueberry & Pistachio(1)

Dark Chocolate & Cherry(1)

Dark Chocolate & Peanut Butter(1)

Sugar Free

No(29)

Yes(1)

Vegan

No(25)

Yes(9)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved