Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, 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_19` 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') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=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 `pinfo`.`sku` LIKE '%MealsandSnackBars' THEN 1 ELSE 0 END DESC, 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(39)

Kellogg's(16)

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(52)

Cup(12)

Individually Wrapped(9)

Individually Wrapped Bar(7)

Box(6)

Bowl(1)

 
Flavor

Strawberry(4)

Crunchy Peanut Butter(3)

Blueberry(2)

Madagascar Vanilla & Almond & Honey(2)

Assorted(2)

Pineapple Banana Kale Spinach(1)

Cherry Apple Chia(1)

Strawberry Apple Chia(1)

Dark Chocolate Strawberry(1)

Mango Apple Chia(1)

Almond Butter(1)

Dark Chocolate Cocoa(1)

Raspberry Cashew & Chia(1)

Peanut Butter Dark Chocolate(1)

Dark Chocolate Chunk(1)

Oats & Honey with Toasted Coconut(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Mocha Almond(1)

Dark Chocolate Banana(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Honey Roasted Nuts & Sea Salt(1)

Chewy Chocolate Chip(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)

Salted Caramel and Dark Chocolate Nut(1)

Almond Butter Dark Chocolate(1)

White Chocolate Cinnamon Almond(1)

Chewy Honey Oat(1)

Chewy Peanut Butter Chocolate Chip(1)

Double Dark Chocolate(1)

Toasted Caramel Nut(1)

Honey Almond Butter(1)

Chocolate Peanut Butter(1)

Blueberry Vanilla & Cashew(1)

Dark Chocolate Nuts & Sea Salt(1)

Dark Chocolate(1)

Dark Chocolate and Peanut Butter(1)

Sweet & Salty Nut Almond(1)

Chocolate Chip(1)

White Chocolate Macadamia Nut(1)

Froot Loops(1)

Oats 'n Honey(1)

Original(1)

Sweet & Salty Nut Peanut(1)

Crunchy Oats’n Honey(1)

Cheerios(1)

Cashew Cookie(1)

Peanut Butter Chocolate Chip(1)

Cinnamon Toast Crunch(1)

Honey Nut Cheerios(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Frosted Flakes(1)

Raisin Bran Crunch(1)

Peanut Butter Dark Chocolate plus Protein(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Fruit & Nut Delight(1)

Almond & Coconut(1)

Dark Chocolate Cinnamon Pecan(1)

Real Aged Cheddar(1)

Madagascar Vanilla Almond(1)

Cranberry Almond plus Antioxidants(1)

Frosted Mini Wheats(1)

Chocolate & Peanut Butter(1)

Cranberry Almond(1)

Chocolate Almond(1)

Apple Cinnamon(1)

Raspberry(1)

Honey Almond Flax(1)

Trail Mix(1)

Maple Glazed Pecan & Sea Salt(1)

 
Manufacturer Part Number

24065(1)

24064(1)

24063(1)

19990(1)

24842(1)

25953(1)

25973(1)

25968(1)

25954(1)

19989(1)

19988(1)

18080(1)

18039(1)

17930(1)

17852(1)

18082(1)

18083(1)

19987(1)

18554(1)

18533(1)

25987(1)

25988(1)

00444CT(1)

00443PK(1)

31567(1)

15528(1)

00444PK(1)

00445PK(1)

00473PK(1)

00457PK(1)

00447PK(1)

15504(1)

1036601(1)

26036(1)

26031(1)

26026(1)

25989(1)

26041(1)

26286(1)

26961(1)

26832(1)

26289(1)

17851(1)

17850(1)

161009(1)

160004(1)

SN44099(1)

SN44066(1)

50120(1)

01641(1)

01468(1)

01246(1)

827622(1)

SN42068(1)

SN42067(1)

SN13897(1)

SN13896(1)

41873(1)

41689(1)

SN13898(1)

SN13899(1)

SN3355(1)

SN3353(1)

SN1512(1)

01474(1)

05872(1)

17211(1)

56926(1)

56924(1)

42799(1)

17221(1)

17250(1)

17828(1)

17824(1)

17256(1)

37949(1)

37947(1)

29186(1)

14746(1)

14606(1)

14604(1)

29190(1)

35645(1)

35945(1)

35845(1)

35745(1)

00058(1)

 
Country of Origin

US(87)

 
Capacity (Weight)

1.4 oz(25)

1.2 oz(10)

1.3 oz(8)

1.76 oz(5)

1.5 oz(4)

0.81 oz(3)

2.4 oz(3)

35 g(2)

0.88 oz(2)

50 g(2)

1.34 oz(2)

1.59 oz(2)

1.16 oz(2)

0.6 oz(2)

2 oz(2)

1.7 oz(1)

1.6 oz(1)

2.64 oz(1)

1.23 oz(1)

2.46 oz(1)

3.08 oz(1)

1.8 oz(1)

2.8 oz(1)

2.39 oz(1)

2.1 oz(1)

2.5 oz(1)

1.73 oz(1)

2.01 oz(1)

 
Food Type

Snack Bar(32)

Cereal Bar(15)

Breakfast Cereal(9)

Protein Bar(9)

Snackbar(7)

Oatmeal(3)

Nutrition Bar(3)

Snack(2)

Chewy Bar(2)

Granola Bar(2)

Lunch(1)

Macaroni and Cheese(1)

Granola Bars(1)