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

Nature Valley(7)

General Mills(3)

CLIF Bar(3)

Larabar(2)

Kashi(2)

Quaker(2)

Annie's Homegrown(1)

THIS BAR SAVES LIVES(1)

 
Packing Type

Bar(60)

Cup(9)

Individually Wrapped(8)

Box(5)

Pouch(1)

Individually Wrapped Bar(1)

 
Flavor

Strawberry(4)

Crunchy Peanut Butter(3)

Peanut Butter(2)

Peanut Butter Dark Chocolate(2)

Dark Chocolate Nuts & Sea Salt(2)

Assorted(2)

Cherry Apple Chia(1)

Dark Chocolate Banana(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Cocoa(1)

Almond Butter(1)

Strawberry Apple Chia(1)

Real Aged Cheddar(1)

Mango Apple Chia(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)

Chewy Chocolate Chip(1)

Chewy Honey Oat(1)

Chewy Peanut Butter Chocolate Chip(1)

Dark Chocolate(1)

Apple Walnut Oatmeal+(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)

Dark Chocolate Cherry Cashew(1)

Caramel Almond Nuts & Sea Salt(1)

Salted Caramel and Dark Chocolate Nut(1)

Oats & Honey with Toasted Coconut(1)

Almond Butter Dark Chocolate(1)

Honey Almond Butter(1)

Chocolate Peanut Butter(1)

Toasted Caramel Nut(1)

Double Dark Chocolate(1)

White Chocolate Cinnamon Almond(1)

Dark Chocolate Chunk(1)

Dark Chocolate Cinnamon Pecan(1)

Blueberry Vanilla & Cashew(1)

Sweet & Salty Nut Almond(1)

Frosted Flakes(1)

Froot Loops(1)

Oats 'n Honey(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Dark Chocolate and Peanut Butter(1)

Sweet & Salty Nut Peanut(1)

Cranberry Almond(1)

Crunchy Oats'n Honey(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Honey Nut Cheerios(1)

Cinnamon Toast Crunch(1)

Cashew Cookie(1)

Raisin Bran Crunch(1)

Blueberry; Brown Sugar Cinnamon; Strawberry(1)

Maple Glazed Pecan & Sea Salt(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Peanut Butter Chocolate Chip(1)

Madagascar Vanilla Almond(1)

Almond & Coconut(1)

Fruit & Nut Delight(1)

Peanut Butter Dark Chocolate plus Protein(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Cranberry Almond plus Antioxidants(1)

Chocolate & Peanut Butter(1)

Frosted Mini Wheats(1)

Honey Almond Flax(1)

Trail Mix(1)

Raspberry(1)

Blueberry(1)

Apple Cinnamon(1)

Madagascar Vanilla & Almond & Honey(1)

 
Manufacturer Part Number

00058(1)

24064(1)

25988(1)

25987(1)

25973(1)

25968(1)

25954(1)

25953(1)

24842(1)

24063(1)

26026(1)

19990(1)

19989(1)

19988(1)

19987(1)

18554(1)

18533(1)

18083(1)

18082(1)

25989(1)

26031(1)

18039(1)

27960(1)

31567(1)

15504(1)

27970(1)

27967(1)

27964(1)

27962(1)

27961(1)

27959(1)

26036(1)

27896(1)

27895(1)

27742(1)

26961(1)

26832(1)

26289(1)

26286(1)

26041(1)

18080(1)

17930(1)

41689(1)

SN44066(1)

01474(1)

01468(1)

01246(1)

827622(1)

50120(1)

161009(1)

160004(1)

SN42068(1)

14606(1)

SN42067(1)

SN3355(1)

SN3353(1)

SN1512(1)

SN13899(1)

SN13898(1)

SN13897(1)

41873(1)

05872(1)

14746(1)

17852(1)

56924(1)

17851(1)

17850(1)

17828(1)

17824(1)

17256(1)

17250(1)

17221(1)

17211(1)

42799(1)

22526(1)

37949(1)

37947(1)

35945(1)

35845(1)

35745(1)

35645(1)

29190(1)

29186(1)

00444CT(1)

 
Country of Origin

US(84)

 
Capacity (Weight)

1.4 oz(20)

1.2 oz(9)

0.7 oz(7)

1.3 oz(7)

1.76 oz(5)

0.81 oz(5)

1.5 oz(4)

2.4 oz(3)

1.59 oz(2)

1.34 oz(2)

50 g(2)

35 g(2)

0.88 oz(2)

2.01 oz(1)

2.64 oz(1)

2.5 oz(1)

1.16 oz(1)

2.39 oz(1)

1.6 oz(1)

2.8 oz(1)

2.1 oz(1)

0.6 oz(1)

1.73 oz(1)

1.8 oz(1)

2 oz(1)

1.7 oz(1)

1.23 oz(1)

 
Food Type

Nutrition & Snack Bars(61)

Granola(12)

Breakfast Cereal(8)

Meal/Entree(1)

Cereal Bar(1)

Oatmeal(1)

 
 
 

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