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_36` 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_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(46)

Kellogg's(19)

Quaker(8)

Nature Valley(7)

THIS BAR SAVES LIVES(6)

Kashi(5)

Umpqua Oats(4)

General Mills(3)

CLIF Bar(3)

That’s it.(3)

Annie's Homegrown(1)

Barilla(1)

Kraft(1)

PowerBar(1)

N'Joy(1)

 
Packing Type

Bar(73)

Cup(14)

Box(7)

Individually Wrapped(6)

Individually Wrapped Bar(6)

Microwavable Tray(1)

Bowl(1)

Pouch(1)

 
Flavor

Strawberry(5)

Blueberry(3)

Crunchy Peanut Butter(3)

Kick Start(2)

Chewy Chocolate Chip(2)

Assorted(2)

Pineapple Banana Kale Spinach(1)

Dark Chocolate Banana(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Cocoa(1)

Almond Butter(1)

Strawberry Apple Chia(1)

Caramel Almond Pumpkin Spice(1)

Apricot Pear Carrot Beet(1)

Real Aged Cheddar(1)

Cherry Apple Chia(1)

White Chocolate Cinnamon Almond(1)

Pineapple Coconut Chia(1)

Black Truffle Almond & Sea Salt(1)

Honey Roasted Nuts & Sea Salt(1)

Raspberry Cashew & Chia(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Mocha Almond(1)

Caramel Almond & Sea Salt(1)

Roasted Jalapeno Almond(1)

Mango Apple Chia(1)

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

Double Dark Chocolate(1)

Apple & Blueberry(1)

Mostly Sunny(1)

PB&J(1)

Dark Chocolate & Coconut(1)

Dark Chocolate & Peanut Butter(1)

Wild Blueberry & Pistachio(1)

Madagascar Vanilla & Almond & Honey(1)

Dark Chocolate & Cherry(1)

Apple & Cherry(1)

Apple & Banana(1)

Toasted Caramel Nut(1)

Apple Nut Harvest(1)

Cherry Pistachio(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Morning Harvest(1)

Apple Cinnamon Crisp(1)

Peanut Butter(1)

Salted Caramel and Dark Chocolate Nut(1)

Honey Mustard Almond(1)

Thai Sweet Chili Almond(1)

Vanilla Blueberry(1)

Honey Smoked BBQ Almond(1)

Original(1)

Chocolatey Brownie(1)

Chocolatey Salted Caramel(1)

Honey Pecan Baklava(1)

Peanut Hemp Crunch(1)

Salted Dark Chocolate and Nuts(1)

Raisin Bran Crunch(1)

Frosted Flakes(1)

Froot Loops(1)

Oats 'n Honey(1)

White Chocolate Macadamia Nut(1)

Chocolate Almond(1)

Chocolate Chip(1)

Marinara Penne(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Crunchy Oats'n Honey(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Cinnamon Toast Crunch(1)

Cheerios(1)

Chocolatey Mint(1)

Chocolate & Peanut Butter(1)

Hickory Smoked Almond(1)

Madagascar Vanilla Almond(1)

Chewy Strawberry Yogurt(1)

Peanut Butter Dark Chocolate(1)

Dark Chocolate Chunk(1)

Maple Pumpkin Seeds with Sea Salt(1)

Oats & Honey with Toasted Coconut(1)

Blueberry Vanilla & Cashew(1)

Maple Glazed Pecan & Sea Salt(1)

Dark Chocolate Cinnamon Pecan(1)

Dark Chocolate Nuts & Sea Salt(1)

Almond & Coconut(1)

Apple Cinnamon(1)

Fruit & Nut Delight(1)

Peanut Butter Dark Chocolate plus Protein(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Cranberry Almond plus Antioxidants(1)

Frosted Mini Wheats(1)

Honey Almond Flax(1)

Trail Mix(1)

Raspberry(1)

Jackpot(1)

 
Manufacturer Part Number

00058(1)

24063(1)

26026(1)

25973(1)

25968(1)

25954(1)

25953(1)

24842(1)

24482(1)

24066(1)

24065(1)

24064(1)

24062(1)

26036(1)

19991(1)

19990(1)

19989(1)

19988(1)

19987(1)

18554(1)

18533(1)

18510(1)

18509(1)

18508(1)

18506(1)

26031(1)

26041(1)

18084(1)

1022BA(1)

1217JP(1)

1202MS(1)

1200KS(1)

00473PK(1)

00457PK(1)

00447PK(1)

00445PK(1)

00444PK(1)

00443PK(1)

1022C(1)

1022BL(1)

31803(1)

26678(1)

31799(1)

31569(1)

31567(1)

15528(1)

15504(1)

11827BX(1)

11827(1)

1036601(1)

82654(1)

27742(1)

26961(1)

18505(1)

18083(1)

SN13158(1)

01641(1)

12522(1)

10513(1)

10511(1)

10507(1)

05872(1)

01474(1)

01468(1)

01283(1)

01246(1)

827622(1)

50120(1)

13972(1)

161009(1)

160004(1)

01492(1)

SN42068(1)

SN42067(1)

SN3355(1)

SN3353(1)

SN1512(1)

SN13899(1)

SN13897(1)

SN13896(1)

13970(1)

14604(1)

18082(1)

17221(1)

18081(1)

18080(1)

18039(1)

17930(1)

17852(1)

17851(1)

17850(1)

17828(1)

17824(1)

17256(1)

17250(1)

17211(1)

14746(1)

56926(1)

56924(1)

42799(1)

37949(1)

37947(1)

35945(1)

35845(1)

35745(1)

35645(1)

29190(1)

29186(1)

1635KSP(1)

 
Country of Origin

US(109)

 
Capacity (Volume)

9 oz(1)

 
Capacity (Weight)

1.4 oz(27)

1.2 oz(18)

1.59 oz(6)

1.3 oz(6)

1.6 oz(5)

1.76 oz(4)

1.34 oz(4)

1.5 oz(4)

2.4 oz(3)

1.23 oz(2)

0.84 oz(2)

35 g(2)

0.88 oz(2)

2 oz(2)

50 g(2)

2.71 oz(1)

2.46 oz(1)

2.54 oz(1)

2.64 oz(1)

3.08 oz(1)

45 g(1)

2.53 oz(1)

2.01 oz(1)

2.5 oz(1)

0.7 oz(1)

2.39 oz(1)

1.16 oz(1)

0.85 oz(1)

1.58 oz(1)

2.8 oz(1)

2.1 oz(1)

0.81 oz(1)

9 oz(1)

1.73 oz(1)

2.29 oz(1)

 
Food Type

Nutrition & Snack Bars(48)

Snack Bar(12)

Granola(11)

Breakfast Cereal(8)

Oatmeal(7)

Cereal Bar(5)

Protein Bar(5)

Nutrition Bar(4)

Granola Bars(3)

Granola Bar(2)

Meal/Entree(1)

Meal/Entree Kit(1)

Lunch(1)

Chewy Bar(1)

 
 
 

© 2020-2021 Horizon Business Products, All Rights Reserved