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)

General Mills(1)

 
Flavor

Assorted(2)

Crunchy Peanut Butter(2)

Strawberry(2)

Cinnamon Toast Crunch(1)

Honey Roasted Nuts & Sea Salt(1)

Oats & Honey with Toasted Coconut(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)

Strawberry Apple Chia(1)

Mango Apple Chia(1)

Maple Glazed Pecan & Sea Salt(1)

Almond Butter(1)

Dark Chocolate Cocoa(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Banana(1)

White Chocolate Cinnamon Almond(1)

Double Dark Chocolate(1)

Blueberry Vanilla & Cashew(1)

Dark Chocolate Nuts & Sea Salt(1)

Dark Chocolate Cinnamon Pecan(1)

Raspberry(1)

White Chocolate Macadamia Nut(1)

Frosted Flakes(1)

Raisin Bran Crunch(1)

Chocolate & Peanut Butter(1)

Frosted Strawberry(1)

Apple Cinnamon(1)

Blueberry(1)

Frosted Mini Wheats(1)

Chocolate Chip(1)

Cranberry Almond plus Antioxidants(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)

Toasted Caramel Nut(1)

 
Manufacturer Part Number

SN13897(1)

19989(1)

17930(1)

18039(1)

18080(1)

18082(1)

18083(1)

18533(1)

19987(1)

19988(1)

19990(1)

17851(1)

24063(1)

24842(1)

25953(1)

25954(1)

25968(1)

25973(1)

26026(1)

26031(1)

26036(1)

17852(1)

17850(1)

160004(1)

31732(1)

161009(1)

50120(1)

01468(1)

01474(1)

05872(1)

14746(1)

29186(1)

29190(1)

35645(1)

17828(1)

35745(1)

35845(1)

35945(1)

42799(1)

17211(1)

17221(1)

17250(1)

17256(1)

17824(1)

26041(1)

 
Country of Origin

US(45)

 
Packing Type

Bar(31)

Individually Wrapped(6)

Cup(4)

Box(4)

 
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 oz(1)

2.1 oz(1)

2.8 oz(1)

2.39 oz(1)

3.67 oz(1)

2.5 oz(1)

 
Food Type

Nutrition & Snack Bars(37)

Breakfast Cereal(5)

Granola(2)

Danish/Pastries(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved