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_19` 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(39)

Kellogg's(16)

Nature Valley(8)

THIS BAR SAVES LIVES(7)

General Mills(4)

CLIF Bar(3)

Quaker(3)

Larabar(2)

Kashi(2)

Annie's Homegrown(1)

Kraft(1)

N'Joy(1)

 
Packing Type

Bar(52)

Cup(12)

Individually Wrapped(9)

Individually Wrapped Bar(7)

Box(6)

Bowl(1)

 
Flavor

Strawberry(4)

Crunchy Peanut Butter(3)

Madagascar Vanilla & Almond & Honey(2)

Blueberry(2)

Assorted(2)

Real Aged Cheddar(1)

Cherry Apple Chia(1)

Dark Chocolate Cocoa(1)

Almond Butter(1)

Strawberry Apple Chia(1)

Pineapple Banana Kale Spinach(1)

Raspberry Cashew & Chia(1)

Mango Apple Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Mocha Almond(1)

Caramel Almond & Sea Salt(1)

Peanut Butter Dark Chocolate(1)

Dark Chocolate Chunk(1)

Dark Chocolate Strawberry(1)

Chewy Chocolate Chip(1)

Dark Chocolate Banana(1)

Salted Caramel and Dark Chocolate Nut(1)

Dark Chocolate & Coconut(1)

Dark Chocolate & Peanut Butter(1)

Wild Blueberry & Pistachio(1)

Dark Chocolate & Cherry(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Morning Harvest(1)

Almond Butter Dark Chocolate(1)

Blueberry Vanilla & Cashew(1)

Honey Almond Butter(1)

Chocolate Peanut Butter(1)

Toasted Caramel Nut(1)

Double Dark Chocolate(1)

White Chocolate Cinnamon Almond(1)

Chewy Honey Oat(1)

Chewy Peanut Butter Chocolate Chip(1)

Oats & Honey with Toasted Coconut(1)

Dark Chocolate Nuts & Sea Salt(1)

Maple Glazed Pecan & Sea Salt(1)

Sweet & Salty Nut Almond(1)

Oats 'n Honey(1)

Original(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Dark Chocolate(1)

Dark Chocolate and Peanut Butter(1)

Sweet & Salty Nut Peanut(1)

Frosted Flakes(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Honey Nut Cheerios(1)

Cinnamon Toast Crunch(1)

Cheerios(1)

Cashew Cookie(1)

Froot Loops(1)

Raisin Bran Crunch(1)

Dark Chocolate Cinnamon Pecan(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 Almond(1)

Frosted Mini Wheats(1)

Honey Almond Flax(1)

Trail Mix(1)

Raspberry(1)

Apple Cinnamon(1)

Chocolate & Peanut Butter(1)

Cranberry Almond(1)

PB&J(1)

 
Manufacturer Part Number

00058(1)

19989(1)

25968(1)

25954(1)

25953(1)

24842(1)

24065(1)

24064(1)

24063(1)

19990(1)

19988(1)

25987(1)

19987(1)

18554(1)

18533(1)

18083(1)

18082(1)

18080(1)

18039(1)

17930(1)

25973(1)

25988(1)

17851(1)

15504(1)

00457PK(1)

00447PK(1)

00445PK(1)

00444PK(1)

00444CT(1)

00443PK(1)

31567(1)

15528(1)

1036601(1)

25989(1)

26961(1)

26832(1)

26289(1)

26286(1)

26041(1)

26036(1)

26031(1)

26026(1)

17852(1)

17850(1)

41689(1)

SN42068(1)

01246(1)

827622(1)

01641(1)

50120(1)

161009(1)

160004(1)

SN44099(1)

SN44066(1)

SN42067(1)

01474(1)

SN3355(1)

SN3353(1)

SN1512(1)

SN13899(1)

SN13898(1)

SN13897(1)

SN13896(1)

41873(1)

01468(1)

05872(1)

17828(1)

37949(1)

17824(1)

17256(1)

17250(1)

17221(1)

17211(1)

56926(1)

56924(1)

42799(1)

37947(1)

14604(1)

35945(1)

35845(1)

35745(1)

35645(1)

29190(1)

29186(1)

14746(1)

14606(1)

00473PK(1)

 
Country of Origin

US(87)

 
Capacity (Weight)

1.4 oz(25)

1.2 oz(10)

1.3 oz(8)

1.76 oz(5)

1.5 oz(4)

0.81 oz(3)

2.4 oz(3)

0.88 oz(2)

50 g(2)

35 g(2)

1.59 oz(2)

1.34 oz(2)

0.6 oz(2)

1.16 oz(2)

2 oz(2)

3.08 oz(1)

2.64 oz(1)

2.46 oz(1)

2.01 oz(1)

2.39 oz(1)

2.5 oz(1)

1.6 oz(1)

2.8 oz(1)

2.1 oz(1)

1.73 oz(1)

1.8 oz(1)

1.7 oz(1)

1.23 oz(1)

 
Food Type

Snack Bar(32)

Cereal Bar(15)

Breakfast Cereal(9)

Protein Bar(9)

Snackbar(7)

Nutrition Bar(3)

Oatmeal(3)

Chewy Bar(2)

Granola Bar(2)

Snack(2)

Macaroni and Cheese(1)

Lunch(1)

Granola Bars(1)

 
 
 

© 2020-2021 Office Industries Corporation, All Rights Reserved