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_1` 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 ('10132')) 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(29)

Kellogg's(12)

CLIF Bar(3)

 
Special Features

Two Pop Tarts per Pack, Six Packs per Box-A good source of seven vitamins and minerals, one two-per-pack serving is the equivalent to two bread and grain servings.(1)

Assorted Cereals-Yummy assortment includes your favorite cereals with 9 each of Frosted Flakes, 6 each of Mini-Wheats, 6 each of Froot Loops, 3 each of Apple Jacks, 3 each of Corn Pops and 3 each of Rice Krispies.(1)

Assorted Flavors-A yummy assortment of apple, blueberry, and strawberry bars make it easy to pick your favorite flavor.(1)

 
Flavor

Strawberry(2)

Crunchy Peanut Butter(2)

Assorted(2)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Almond Mint(1)

Raspberry Cashew & Chia(1)

Caramel Almond & Sea Salt(1)

Peanut Butter Dark Chocolate(1)

Dark Chocolate Chunk(1)

Honey Roasted Nuts & Sea Salt(1)

Blueberry Vanilla & Cashew(1)

Oats & Honey with Toasted Coconut(1)

Almond Butter(1)

White Chocolate Cinnamon Almond(1)

Double Dark Chocolate(1)

Toasted Caramel Nut(1)

Dark Chocolate Banana(1)

Dark Chocolate Strawberry(1)

Strawberry Apple Chia(1)

Maple Glazed Pecan & Sea Salt(1)

Dark Chocolate Cocoa(1)

Mango Apple Chia(1)

Dark Chocolate Nuts & Sea Salt(1)

Apple Cinnamon(1)

Blueberry(1)

Raspberry(1)

Frosted Strawberry(1)

Chocolate & Peanut Butter(1)

White Chocolate Macadamia Nut(1)

Frosted Flakes(1)

Raisin Bran Crunch(1)

Frosted Mini Wheats(1)

Cranberry Almond plus Antioxidants(1)

Almond & Coconut(1)

Madagascar Vanilla Almond(1)

Chocolate Chip(1)

Fruit & Nut Delight(1)

Peanut Butter Dark Chocolate plus Protein(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Dark Chocolate Cinnamon Pecan(1)

 
Manufacturer Part Number

18533(1)

19987(1)

19988(1)

19989(1)

18083(1)

18082(1)

17852(1)

17930(1)

18039(1)

18080(1)

19990(1)

24063(1)

26026(1)

26031(1)

26036(1)

26041(1)

25973(1)

25968(1)

24842(1)

25953(1)

25954(1)

17851(1)

17850(1)

14746(1)

29186(1)

29190(1)

31732(1)

05872(1)

01474(1)

161009(1)

50120(1)

01468(1)

35645(1)

35745(1)

17250(1)

17256(1)

17824(1)

17828(1)

17221(1)

17211(1)

35845(1)

35945(1)

42799(1)

160004(1)

 
Country of Origin

US(44)

 
Packing Type

Bar(31)

Individually Wrapped(6)

Box(4)

Cup(3)

 
Capacity (Weight)

1.4 oz(16)

1.2 oz(5)

1.3 oz(5)

1.76 oz(4)

2.4 oz(3)

1.59 oz(2)

50 g(2)

1.34 oz(2)

3.67 oz(1)

2.1 oz(1)

2.8 oz(1)

2.39 oz(1)

2.5 oz(1)

 
Food Type

Snack Bar(21)

Protein Bar(8)

Cereal Bar(5)

Breakfast Cereal(4)

Nutrition Bar(3)

Snack(2)

Pastry(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved