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_27` 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(48)

Kellogg's(14)

Nature Valley(7)

THIS BAR SAVES LIVES(7)

CLIF Bar(3)

General Mills(3)

Quaker(2)

Kashi(2)

Larabar(2)

Annie's Homegrown(1)

 
Packing Type

Bar(60)

Cup(9)

Individually Wrapped(8)

Individually Wrapped Bar(7)

Box(5)

 
Flavor

Strawberry(4)

Crunchy Peanut Butter(3)

Madagascar Vanilla & Almond & Honey(2)

Assorted(2)

Peanut Butter(2)

Peanut Butter Dark Chocolate(2)

Dark Chocolate Nuts & Sea Salt(2)

Dark Chocolate Cocoa(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Banana(1)

Chewy Honey Oat(1)

Chewy Peanut Butter Chocolate Chip(1)

Chewy Chocolate Chip(1)

Almond Butter(1)

Mango Apple Chia(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Mocha Almond(1)

Raspberry Cashew & Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Cherry Apple Chia(1)

White Chocolate Cinnamon Almond(1)

Strawberry Apple Chia(1)

Chocolate Peanut Butter(1)

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

Peanut Butter Dark Chocolate Peanut Butter(1)

Dark Chocolate Nuts & Sea Salt/Caramel Almond & Sea Salt(1)

Apple Walnut Oatmeal+(1)

Dark Chocolate & Cherry(1)

Dark Chocolate & Coconut(1)

Dark Chocolate & Peanut Butter(1)

Wild Blueberry & Pistachio(1)

Dark Chocolate Cherry Cashew(1)

Caramel Almond Nuts & Sea Salt(1)

Caramel Almond & Sea Salt(1)

PB&J(1)

Toasted Caramel Nut(1)

Honey Almond Butter(1)

Almond Butter Dark Chocolate(1)

Dark Chocolate(1)

Salted Caramel and Dark Chocolate Nut(1)

Double Dark Chocolate(1)

Oats & Honey with Toasted Coconut(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Dark Chocolate and Peanut Butter(1)

Oats 'n Honey(1)

Froot Loops(1)

Cranberry Almond(1)

Raisin Bran Crunch(1)

Frosted Flakes(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Cinnamon Toast Crunch(1)

Cashew Cookie(1)

Peanut Butter Chocolate Chip(1)

Honey Nut Cheerios(1)

Lucky Charms(1)

Crunchy Oats'n Honey(1)

Chewy Trail Mix(1)

Chocolate & Peanut Butter(1)

Apple Cinnamon(1)

Madagascar Vanilla Almond(1)

Almond & Coconut(1)

Fruit & Nut Delight(1)

Dark Chocolate Cinnamon Pecan(1)

Maple Glazed Pecan & Sea Salt(1)

Real Aged Cheddar(1)

Blueberry Vanilla & Cashew(1)

Peanut Butter Dark Chocolate plus Protein(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Trail Mix(1)

Raspberry(1)

Blueberry(1)

Honey Almond Flax(1)

Frosted Mini Wheats(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Cranberry Almond plus Antioxidants(1)

Dark Chocolate Chunk(1)

 
Manufacturer Part Number

25988(1)

25987(1)

25973(1)

25968(1)

25989(1)

26026(1)

26286(1)

26041(1)

26036(1)

26031(1)

25954(1)

25953(1)

19988(1)

19987(1)

18554(1)

18533(1)

19989(1)

19990(1)

24842(1)

24064(1)

24063(1)

26289(1)

26832(1)

00444CT(1)

00443PK(1)

31567(1)

15504(1)

00444PK(1)

00445PK(1)

00473PK(1)

00457PK(1)

00447PK(1)

27970(1)

27967(1)

27896(1)

27895(1)

27742(1)

26961(1)

27959(1)

27960(1)

27964(1)

27962(1)

27961(1)

18083(1)

18082(1)

827622(1)

50120(1)

161009(1)

160004(1)

01246(1)

01468(1)

14746(1)

14606(1)

05872(1)

01474(1)

SN44066(1)

SN42068(1)

SN13898(1)

SN13897(1)

41873(1)

41689(1)

SN13899(1)

SN1512(1)

SN42067(1)

SN3355(1)

SN3353(1)

29186(1)

29190(1)

17850(1)

17828(1)

17824(1)

17256(1)

17851(1)

17852(1)

18080(1)

18039(1)

17930(1)

17250(1)

17221(1)

35945(1)

35845(1)

35745(1)

35645(1)

37947(1)

37949(1)

17211(1)

56924(1)

42799(1)

00058(1)

 
Country of Origin

US(89)

 
Capacity (Weight)

1.4 oz(26)

1.2 oz(9)

1.3 oz(7)

0.7 oz(7)

0.81 oz(5)

1.76 oz(5)

1.5 oz(4)

2.4 oz(3)

1.59 oz(2)

35 g(2)

50 g(2)

1.34 oz(2)

2.5 oz(1)

2.64 oz(1)

1.23 oz(1)

0.88 oz(1)

1.16 oz(1)

1.8 oz(1)

2 oz(1)

1.7 oz(1)

1.6 oz(1)

1.73 oz(1)

0.6 oz(1)

2.01 oz(1)

2.8 oz(1)

2.1 oz(1)

2.39 oz(1)

 
Food Type

Nutrition & Snack Bars(66)

Granola(12)

Breakfast Cereal(8)

Oatmeal(1)

Cereal Bar(1)

Meal/Entree(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved