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

Kellogg's(18)

Nature Valley(6)

Kashi(5)

General Mills(4)

Quaker(4)

That’s it.(3)

CLIF Bar(3)

Nissin(3)

Larabar(2)

Kraft(1)

Barilla(1)

Annie's Homegrown(1)

N'Joy(1)

 
Packing Type

Bar(57)

Cup(15)

Box(5)

Bowl(1)

Microwavable Tray(1)

 
Flavor

Strawberry(4)

Blueberry(3)

Assorted(2)

Crunchy Peanut Butter(2)

Peanut Butter Dark Chocolate(1)

Dark Chocolate Chunk(1)

Sweet Cayenne Barbeque(1)

Chipotle Honey Mustard(1)

Roasted Jalapeno(1)

Thai Sweet Chili(1)

Oats & Honey with Toasted Coconut(1)

Peanut Butter Dark Chocolate plus Protein(1)

Dark Chocolate Cinnamon Pecan(1)

Dark Chocolate Nuts & Sea Salt(1)

Almond & Coconut(1)

Maple Glazed Pecan & Sea Salt(1)

Blueberry Vanilla & Cashew(1)

Fruit & Nut Delight(1)

Madagascar Vanilla Almond(1)

Dark Chocolate Mocha Almond(1)

Chicken(1)

Beef(1)

Shrimp(1)

Apple Walnut Oatmeal+(1)

Summer Berry Oatmeal+(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Apple & Banana(1)

Morning Harvest(1)

Pineapple Banana Kale Spinach(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Raspberry Cashew & Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Cherry Apple Chia(1)

Mango Apple Chia(1)

Caramel Almond & Sea Salt(1)

Frosted Mini Wheats(1)

Marinara Penne(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Chocolate Chip(1)

White Chocolate Macadamia Nut(1)

Oats 'n Honey(1)

Original(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Cashew Cookie(1)

Peanut Butter Chocolate Chip(1)

Cheerios(1)

Cinnamon Toast Crunch(1)

Lucky Charms(1)

Honey Nut Cheerios(1)

Froot Loops(1)

Frosted Flakes(1)

Raspberry(1)

Apple Cinnamon(1)

Chocolate & Peanut Butter(1)

Trail Mix(1)

Honey Almond Flax(1)

Cranberry Almond plus Antioxidants(1)

Real Aged Cheddar(1)

Cranberry Almond(1)

Chocolate Almond(1)

Salted Dark Chocolate and Nuts(1)

Raisin Bran Crunch(1)

Peanut Hemp Crunch(1)

Honey Pecan Baklava(1)

Chocolatey Mint(1)

Chocolatey Brownie(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

 
Manufacturer Part Number

18082(1)

18080(1)

18039(1)

18083(1)

18506(1)

18510(1)

18509(1)

18508(1)

17930(1)

17852(1)

17250(1)

17221(1)

17211(1)

17256(1)

17824(1)

17851(1)

17850(1)

17828(1)

18533(1)

18554(1)

15528(1)

15504(1)

827961(1)

31567(1)

31569(1)

1022C(1)

1022BL(1)

1022BA(1)

1113342(1)

1113336(1)

19989(1)

19988(1)

19987(1)

19990(1)

24063(1)

1036601(1)

24065(1)

24064(1)

56926(1)

56924(1)

160004(1)

01492(1)

SN42068(1)

161009(1)

50120(1)

01246(1)

827622(1)

01641(1)

SN42067(1)

SN3355(1)

SN13896(1)

41873(1)

41689(1)

SN13897(1)

SN13898(1)

SN3353(1)

SN1512(1)

SN13899(1)

01468(1)

01474(1)

35745(1)

35645(1)

29190(1)

35845(1)

35945(1)

42799(1)

37949(1)

37947(1)

29186(1)

14746(1)

10511(1)

10507(1)

05872(1)

10513(1)

13970(1)

14606(1)

14604(1)

13972(1)

00058(1)

 
Country of Origin

US(79)

 
Capacity (Volume)

2.5oz(1)

9 oz(1)

 
Capacity (Weight)

1.4 oz(17)

1.2 oz(12)

1.59 oz(6)

1.3 oz(6)

1.6 oz(5)

2.5 oz(4)

1.5 oz(4)

2.4 oz(3)

35 g(2)

0.88 oz(2)

1.16 oz(2)

1.23 oz(2)

2 oz(2)

2.64 oz(1)

3.08 oz(1)

2.46 oz(1)

2.8 oz(1)

1.73 oz(1)

1.8 oz(1)

1.7 oz(1)

9 oz(1)

2.1 oz(1)

1.58 oz(1)

2.01 oz(1)

2.39 oz(1)

 
Food Type

Snack Bar(29)

Cereal Bar(13)

Breakfast Cereal(9)

Protein Bar(7)

Nutrition Bar(6)

Soup(3)

Oatmeal(3)

Granola Bar(2)

Granola Bars(2)

Chewy Bar(2)

Lunch(1)

Meal/Entree Kit(1)

Macaroni and Cheese(1)

 
 
 

© 2018-2019 BonTay Business Products, Inc., All Rights Reserved