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_1` 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(29)

Kellogg's(16)

Nature Valley(8)

General Mills(4)

Kashi(4)

CLIF Bar(3)

That’s it.(3)

Nissin(3)

Quaker(2)

N'Joy(1)

Kraft(1)

Annie's Homegrown(1)

 
Packing Type

Bar(48)

Cup(15)

Box(6)

Individually Wrapped(5)

Bowl(1)

 
Flavor

Strawberry(3)

Crunchy Peanut Butter(3)

Blueberry(2)

Assorted(2)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Mocha Almond(1)

Dark Chocolate Almond Mint(1)

Mango Apple Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Raspberry Cashew & Chia(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Nuts & Sea Salt(1)

Madagascar Vanilla Almond(1)

Maple Glazed Pecan & Sea Salt(1)

Blueberry Vanilla & Cashew(1)

Dark Chocolate Chunk(1)

Oats & Honey with Toasted Coconut(1)

Peanut Butter Dark Chocolate(1)

Pineapple Banana Kale Spinach(1)

Apple Walnut Oatmeal+(1)

Chicken(1)

Beef(1)

Summer Berry Oatmeal+(1)

Apple & Banana(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Shrimp(1)

Morning Harvest(1)

Almond Butter(1)

Strawberry Apple Chia(1)

Almond & Coconut(1)

Dark Chocolate Cocoa(1)

White Chocolate Cinnamon Almond(1)

Toasted Caramel Nut(1)

Double Dark Chocolate(1)

Cherry Apple Chia(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Chocolate Chip(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

White Chocolate Macadamia Nut(1)

Original(1)

Froot Loops(1)

Oats 'n Honey(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Dark Chocolate Cherry(1)

Peanut Butter Chocolate(1)

Cheerios(1)

Cinnamon Toast Crunch(1)

Lucky Charms(1)

Honey Nut Cheerios(1)

Frosted Flakes(1)

Raisin Bran Crunch(1)

Frosted Mini Wheats(1)

Honey Almond Flax(1)

Cranberry Almond plus Antioxidants(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Peanut Butter Dark Chocolate plus Protein(1)

Real Aged Cheddar(1)

Trail Mix(1)

Raspberry(1)

Honey Pecan Baklava(1)

Salted Dark Chocolate and Nuts(1)

Chocolatey Brownie(1)

Chocolatey Mint(1)

Apple Cinnamon(1)

Chocolate & Peanut Butter(1)

Fruit & Nut Delight(1)

 
Manufacturer Part Number

18533(1)

18083(1)

18082(1)

18554(1)

19987(1)

19990(1)

19989(1)

19988(1)

18080(1)

18039(1)

17824(1)

17256(1)

17250(1)

17828(1)

17850(1)

17930(1)

17851(1)

24063(1)

24064(1)

827961(1)

1113342(1)

1113336(1)

15504(1)

15528(1)

1022C(1)

1022BL(1)

1022BA(1)

1036601(1)

26041(1)

25953(1)

24842(1)

24065(1)

25954(1)

26026(1)

26036(1)

26031(1)

17221(1)

17211(1)

160004(1)

SN42068(1)

SN42067(1)

161009(1)

50120(1)

01246(1)

827622(1)

01641(1)

SN3355(1)

SN3353(1)

SN13896(1)

489550(1)

31849(1)

SN13897(1)

SN13898(1)

SN1512(1)

SN13899(1)

01468(1)

01474(1)

35945(1)

35845(1)

35745(1)

37947(1)

37949(1)

56926(1)

56924(1)

42799(1)

35645(1)

29190(1)

10513(1)

10507(1)

05872(1)

13970(1)

13972(1)

29186(1)

14746(1)

00058(1)

 
Country of Origin

US(75)

 
Capacity (Volume)

2.5oz(1)

 
Capacity (Weight)

1.4 oz(16)

1.2 oz(13)

1.59 oz(6)

1.3 oz(6)

1.5 oz(5)

1.76 oz(4)

2.5 oz(4)

2.4 oz(3)

2 oz(2)

50 g(2)

0.88 oz(2)

35 g(2)

3.08 oz(1)

2.46 oz(1)

2.64 oz(1)

2.39 oz(1)

1.8 oz(1)

1.73 oz(1)

2.1 oz(1)

2.8 oz(1)

2.01 oz(1)

 
Food Type

Snack Bar(23)

Cereal Bar(13)

Protein Bar(13)

Breakfast Cereal(9)

Nutrition Bar(6)

Granola Bar(3)

Soup(3)

Oatmeal(3)

Macaroni and Cheese(1)

Lunch(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved