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') 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(33)

Kellogg's(14)

Nature Valley(6)

THIS BAR SAVES LIVES(6)

General Mills(4)

CLIF Bar(3)

Quaker(3)

Kashi(2)

Kraft(1)

Annie's Homegrown(1)

N'Joy(1)

 
Packing Type

Bar(43)

Cup(12)

Individually Wrapped Bar(6)

Box(6)

Individually Wrapped(6)

Bowl(1)

 
Flavor

Strawberry(4)

Crunchy Peanut Butter(3)

Blueberry(2)

Assorted(2)

Mango Apple Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Cherry Apple Chia(1)

Pineapple Banana Kale Spinach(1)

PB&J(1)

Strawberry Apple Chia(1)

Raspberry Cashew & Chia(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Chunk(1)

Oats & Honey with Toasted Coconut(1)

Peanut Butter Dark Chocolate(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Mocha Almond(1)

Almond Butter(1)

Dark Chocolate Cocoa(1)

Apple Walnut Oatmeal+(1)

Morning Harvest(1)

Summer Berry Oatmeal+(1)

Dark Chocolate & Peanut Butter(1)

Madagascar Vanilla & Almond & Honey(1)

Dark Chocolate & Cherry(1)

Salted Caramel and Dark Chocolate Nut(1)

Toasted Caramel Nut(1)

Blueberry Vanilla & Cashew(1)

Dark Chocolate & Coconut(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Banana(1)

Double Dark Chocolate(1)

White Chocolate Cinnamon Almond(1)

Wild Blueberry & Pistachio(1)

Dark Chocolate Nuts & Sea Salt(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Original(1)

Oats 'n Honey(1)

Frosted Flakes(1)

Froot Loops(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Cinnamon Toast Crunch(1)

Cheerios(1)

Honey Nut Cheerios(1)

Lucky Charms(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Raisin Bran Crunch(1)

Chocolate & Peanut Butter(1)

Fruit & Nut Delight(1)

Peanut Butter Dark Chocolate plus Protein(1)

Almond & Coconut(1)

Madagascar Vanilla Almond(1)

Dark Chocolate Cinnamon Pecan(1)

Real Aged Cheddar(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Raspberry(1)

Apple Cinnamon(1)

Trail Mix(1)

Honey Almond Flax(1)

Cranberry Almond plus Antioxidants(1)

Frosted Mini Wheats(1)

Maple Glazed Pecan & Sea Salt(1)

 
Manufacturer Part Number

19989(1)

19988(1)

19987(1)

19990(1)

24063(1)

24842(1)

24065(1)

24064(1)

18554(1)

18533(1)

17930(1)

17852(1)

17851(1)

18039(1)

18080(1)

18083(1)

18082(1)

25953(1)

25954(1)

00443PK(1)

31567(1)

15528(1)

00444PK(1)

00445PK(1)

00473PK(1)

00457PK(1)

00447PK(1)

15504(1)

1036601(1)

26026(1)

25973(1)

25968(1)

26031(1)

26036(1)

26961(1)

26041(1)

17850(1)

17828(1)

50120(1)

161009(1)

160004(1)

01641(1)

827622(1)

01474(1)

01468(1)

01246(1)

SN42068(1)

SN42067(1)

SN13898(1)

SN13897(1)

SN13896(1)

SN13899(1)

SN1512(1)

SN3355(1)

SN3353(1)

05872(1)

14746(1)

17211(1)

56926(1)

56924(1)

17221(1)

17250(1)

17824(1)

17256(1)

42799(1)

37949(1)

35645(1)

29190(1)

29186(1)

35745(1)

35845(1)

37947(1)

35945(1)

00058(1)

 
Country of Origin

US(74)

 
Capacity (Weight)

1.4 oz(24)

1.2 oz(10)

1.3 oz(6)

1.76 oz(4)

1.5 oz(4)

2.4 oz(3)

0.88 oz(2)

50 g(2)

1.34 oz(2)

35 g(2)

1.59 oz(2)

2 oz(2)

3.08 oz(1)

2.64 oz(1)

2.46 oz(1)

1.23 oz(1)

1.8 oz(1)

1.73 oz(1)

2.39 oz(1)

2.5 oz(1)

2.8 oz(1)

2.1 oz(1)

2.01 oz(1)

 
Food Type

Snack Bar(25)

Cereal Bar(13)

Breakfast Cereal(9)

Protein Bar(8)

Snackbar(6)

Oatmeal(3)

Nutrition Bar(3)

Snack(2)

Granola Bar(2)

Macaroni and Cheese(1)

Granola Bars(1)

Lunch(1)

 
 
 

© 2019-2020 Horizon Business Products, All Rights Reserved