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_38` 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(44)

Kellogg's(20)

Quaker(8)

Nature Valley(7)

THIS BAR SAVES LIVES(7)

Kashi(5)

General Mills(4)

Umpqua Oats(4)

That’s it.(3)

Nissin(3)

CLIF Bar(3)

Larabar(2)

N'Joy(1)

Annie's Homegrown(1)

Barilla(1)

PowerBar(1)

Kraft(1)

 
Packing Type

Bar(74)

Cup(18)

Individually Wrapped Bar(7)

Box(7)

Individually Wrapped(6)

Pouch(1)

Bowl(1)

Microwavable Tray(1)

 
Flavor

Strawberry(5)

Crunchy Peanut Butter(3)

Blueberry(3)

Kick Start(2)

Assorted(2)

Chewy Chocolate Chip(2)

Madagascar Vanilla & Almond & Honey(2)

Pineapple Banana Kale Spinach(1)

Cherry Apple Chia(1)

Apricot Pear Carrot Beet(1)

Caramel Almond Pumpkin Spice(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Cocoa(1)

Almond Butter(1)

Strawberry Apple Chia(1)

Mango Apple Chia(1)

Black Truffle Almond & Sea Salt(1)

Roasted Jalapeno Almond(1)

Caramel Almond & Sea Salt(1)

Thai Sweet Chili Almond(1)

Honey Mustard Almond(1)

Honey Smoked BBQ Almond(1)

Dark Chocolate Mocha Almond(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Banana(1)

Honey Roasted Nuts & Sea Salt(1)

Raspberry Cashew & Chia(1)

Dark Chocolate Almond Mint(1)

Pineapple Coconut Chia(1)

Salted Caramel and Dark Chocolate Nut(1)

Dark Chocolate & Cherry(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Apple & Banana(1)

Wild Blueberry & Pistachio(1)

Dark Chocolate & Peanut Butter(1)

Jackpot(1)

Mostly Sunny(1)

PB&J(1)

Dark Chocolate & Coconut(1)

Apple Nut Harvest(1)

Cherry Pistachio(1)

Apple Cinnamon Crisp(1)

Hickory Smoked Almond(1)

Toasted Caramel Nut(1)

Double Dark Chocolate(1)

Morning Harvest(1)

Shrimp(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Chicken(1)

Beef(1)

White Chocolate Cinnamon Almond(1)

Dark Chocolate Chunk(1)

Oats 'n Honey(1)

Froot Loops(1)

Original(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Frosted Flakes(1)

Raisin Bran Crunch(1)

Chocolatey Salted Caramel(1)

Honey Pecan Baklava(1)

Peanut Hemp Crunch(1)

Salted Dark Chocolate and Nuts(1)

Marinara Penne(1)

Sweet & Salty Nut Almond(1)

Cheerios(1)

Chewy Strawberry Yogurt(1)

Cashew Cookie(1)

Peanut Butter Chocolate Chip(1)

Cinnamon Toast Crunch(1)

Honey Nut Cheerios(1)

Sweet & Salty Nut Peanut(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Chocolatey Brownie(1)

Chocolatey Mint(1)

Dark Chocolate Nuts & Sea Salt(1)

Dark Chocolate Cinnamon Pecan(1)

Madagascar Vanilla Almond(1)

Almond & Coconut(1)

Fruit & Nut Delight(1)

Maple Glazed Pecan & Sea Salt(1)

Blueberry Vanilla & Cashew(1)

Peanut Butter Dark Chocolate(1)

Real Aged Cheddar(1)

Maple Pumpkin Seeds with Sea Salt(1)

Oats & Honey with Toasted Coconut(1)

Peanut Butter Dark Chocolate plus Protein(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Apple Cinnamon(1)

Chocolate & Peanut Butter(1)

Cranberry Almond(1)

Chocolate Almond(1)

Raspberry(1)

Trail Mix(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Cranberry Almond plus Antioxidants(1)

Frosted Mini Wheats(1)

Honey Almond Flax(1)

Vanilla Blueberry(1)

 
Manufacturer Part Number

24482(1)

24842(1)

24066(1)

24065(1)

24063(1)

24064(1)

25953(1)

25954(1)

26031(1)

26036(1)

26026(1)

25973(1)

25968(1)

24062(1)

19991(1)

18508(1)

18509(1)

18506(1)

18505(1)

18084(1)

18510(1)

18533(1)

19989(1)

19990(1)

19988(1)

19987(1)

18554(1)

26041(1)

26961(1)

00444PK(1)

00445PK(1)

00444CT(1)

00443PK(1)

1022BL(1)

1022C(1)

00447PK(1)

00457PK(1)

1217JP(1)

1635KSP(1)

1202MS(1)

1200KS(1)

00473PK(1)

1022BA(1)

31803(1)

1113342(1)

827961(1)

1113336(1)

1036601(1)

82654(1)

11827(1)

11827BX(1)

31569(1)

31799(1)

31567(1)

15528(1)

15504(1)

18083(1)

18082(1)

01246(1)

01283(1)

827622(1)

01641(1)

161009(1)

50120(1)

01468(1)

01474(1)

10513(1)

12522(1)

10511(1)

10507(1)

05872(1)

160004(1)

01492(1)

SN13896(1)

SN13897(1)

SN13158(1)

41873(1)

41689(1)

SN13898(1)

SN13899(1)

SN42067(1)

SN42068(1)

SN3355(1)

SN3353(1)

SN1512(1)

13970(1)

13972(1)

17824(1)

17828(1)

17256(1)

17250(1)

17211(1)

17221(1)

17850(1)

17851(1)

18080(1)

18081(1)

18039(1)

17930(1)

17852(1)

56926(1)

56924(1)

29186(1)

29190(1)

14746(1)

14606(1)

14604(1)

35645(1)

35745(1)

37949(1)

42799(1)

37947(1)

35945(1)

35845(1)

00058(1)

 
Country of Origin

US(115)

 
Capacity (Volume)

2.5oz(1)

9 oz(1)

 
Capacity (Weight)

1.4 oz(27)

1.2 oz(18)

1.6 oz(6)

1.59 oz(6)

1.3 oz(6)

1.5 oz(4)

2.5 oz(4)

1.34 oz(4)

1.76 oz(4)

2.4 oz(3)

1.23 oz(2)

0.84 oz(2)

35 g(2)

50 g(2)

0.88 oz(2)

1.16 oz(2)

2 oz(2)

2.46 oz(1)

2.64 oz(1)

1.7 oz(1)

3.08 oz(1)

2.71 oz(1)

2.29 oz(1)

2.53 oz(1)

2.54 oz(1)

45 g(1)

1.8 oz(1)

1.58 oz(1)

2.39 oz(1)

2.01 oz(1)

2.8 oz(1)

2.1 oz(1)

1.73 oz(1)

9 oz(1)

0.81 oz(1)

0.85 oz(1)

 
Food Type

Snack Bar(38)

Cereal Bar(16)

Protein Bar(13)

Breakfast Cereal(9)

Oatmeal(7)

Nutrition Bar(7)

Snackbar(7)

Granola Bar(4)

Granola Bars(4)

Soup(3)

Chewy Bar(2)

Snack(2)

Meal/Entree Kit(1)

Macaroni and Cheese(1)

Lunch(1)

 
 
 

© 2019-2020 NBJ Form & Function Inc. , All Rights Reserved