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','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(29)

Kellogg's(12)

CLIF Bar(3)

 
Special Features

Assorted Flavors-A yummy assortment of apple, blueberry, and strawberry bars make it easy to pick your favorite flavor.(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)

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)

 
Flavor

Crunchy Peanut Butter(2)

Assorted(2)

Strawberry(2)

Chocolate Chip(1)

Honey Roasted Nuts & Sea Salt(1)

Dark Chocolate Chunk(1)

Peanut Butter Dark Chocolate(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Almond Mint(1)

Raspberry Cashew & Chia(1)

Almond Butter(1)

Mango Apple Chia(1)

Strawberry Apple Chia(1)

Blueberry Vanilla & Cashew(1)

Dark Chocolate Cocoa(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Banana(1)

White Chocolate Cinnamon Almond(1)

Double Dark Chocolate(1)

Oats & Honey with Toasted Coconut(1)

Dark Chocolate Nuts & Sea Salt(1)

Maple Glazed Pecan & Sea Salt(1)

Frosted Mini Wheats(1)

Frosted Flakes(1)

Raisin Bran Crunch(1)

Chocolate & Peanut Butter(1)

Frosted Strawberry(1)

Apple Cinnamon(1)

Blueberry(1)

Raspberry(1)

Cranberry Almond plus Antioxidants(1)

Dark Chocolate Cinnamon Pecan(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Peanut Butter Dark Chocolate plus Protein(1)

Fruit & Nut Delight(1)

Almond & Coconut(1)

Madagascar Vanilla Almond(1)

White Chocolate Macadamia Nut(1)

Toasted Caramel Nut(1)

 
Manufacturer Part Number

160004(1)

19990(1)

18039(1)

18080(1)

18082(1)

18083(1)

18533(1)

19987(1)

19988(1)

19989(1)

24063(1)

17852(1)

24842(1)

25953(1)

25954(1)

25968(1)

25973(1)

26026(1)

26031(1)

26036(1)

17930(1)

17851(1)

161009(1)

35645(1)

50120(1)

01468(1)

01474(1)

05872(1)

14746(1)

29186(1)

29190(1)

31732(1)

35745(1)

17850(1)

35845(1)

35945(1)

42799(1)

17211(1)

17221(1)

17250(1)

17256(1)

17824(1)

17828(1)

26041(1)

 
Country of Origin

US(44)

 
Packing Type

Bar(31)

Individually Wrapped(6)

Box(4)

Cup(3)

 
Capacity (Weight)

1.4 oz(16)

1.3 oz(5)

1.2 oz(5)

1.76 oz(4)

2.4 oz(3)

1.59 oz(2)

50 g(2)

1.34 oz(2)

2.1 oz(1)

2.8 oz(1)

2.39 oz(1)

3.67 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)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved