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 `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 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` WHERE (`category_name` LIKE "Meals & Snack Bars") 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 MATCH(`desc_short`) AGAINST ('MealsandSnackBar' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+MealsandSnackBar' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"MealsandSnackBar"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"MealsandSnackBar"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"MealsandSnackBar"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"MealsandSnackBar"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+MealsandSnackBar' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='MealsandSnackBar',`category_4` ='MealsandSnackBar') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'MealsandSnackBar,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('MealsandSnackBar', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Meals And Snack Bars

Refine Search

  GO
Brand

KIND(31)

Kellogg's(16)

Nature Valley(6)

Kashi(5)

Quaker(4)

General Mills(4)

That’s it.(3)

Umpqua Oats(3)

Nissin(3)

N'Joy(1)

Barilla(1)

Sheila G’s Brownie Brittle(1)

Kraft(1)

Packing Type

Bar(56)

Cup(17)

Box(3)

Bowl(1)

Microwavable Tray(1)

Bag(1)

Flavor

Strawberry(3)

Blueberry(2)

Assorted(2)

Raspberry Cashew & Chia(1)

Roasted Jalapeno Almond(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Mocha Almond(1)

Thai Sweet Chili Almond(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Chipotle Honey Mustard(1)

Blueberry Vanilla & Cashew(1)

Maple Glazed Pecan & Sea Salt(1)

Dark Chocolate Cinnamon Pecan(1)

Oats & Honey with Toasted Coconut(1)

Dark Chocolate Chunk(1)

Sweet Cayenne Barbeque(1)

Hickory Smoked Almond(1)

Peanut Butter Dark Chocolate(1)

Honey Roasted Nuts & Sea Salt(1)

Black Truffle Almond & Sea Salt(1)

Apple & Banana(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Apple & Blueberry(1)

Apple & Cherry(1)

Jackpot(1)

Mostly Sunny(1)

Kick Start(1)

Chicken(1)

Beef(1)

Cherry Apple Chia(1)

Mango Apple Chia(1)

Pineapple Coconut Chia(1)

Pineapple Banana Kale Spinach(1)

Apricot Pear Carrot Beet(1)

Shrimp(1)

Morning Harvest(1)

Dark Chocolate Nuts & Sea Salt(1)

Almond & Coconut(1)

Oats 'n Honey(1)

Original(1)

Marinara Penne(1)

Froot Loops(1)

Frosted Flakes(1)

Salted Dark Chocolate and Nuts(1)

Raisin Bran Crunch(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Honey Nut Cheerios(1)

Cinnamon Toast Crunch(1)

Cheerios(1)

Lucky Charms(1)

Chewy Trail Mix(1)

Crunchy Peanut Butter(1)

Crunchy Oats’n Honey(1)

Peanut Hemp Crunch(1)

Honey Pecan Baklava(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Cranberry Almond plus Antioxidants(1)

Frosted Mini Wheats(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Peanut Butter Dark Chocolate plus Protein(1)

Chocolate Chip(1)

Fruit & Nut Delight(1)

Honey Almond Flax(1)

Trail Mix(1)

Chocolate Almond(1)

Chocolatey Mint(1)

Chocolatey Brownie(1)

Cranberry Almond(1)

Chocolate & Peanut Butter(1)

Raspberry(1)

Apple Cinnamon(1)

Madagascar Vanilla Almond(1)

Manufacturer Part Number

18533(1)

18510(1)

18509(1)

18554(1)

19987(1)

19990(1)

19989(1)

19988(1)

18508(1)

18506(1)

17930(1)

17852(1)

17851(1)

18039(1)

18080(1)

18505(1)

18083(1)

18082(1)

19991(1)

24062(1)

1022BA(1)

31569(1)

31567(1)

1022BL(1)

1022C(1)

1217JP(1)

1202MS(1)

1200KS(1)

15528(1)

15504(1)

24065(1)

24064(1)

24063(1)

24066(1)

1036601(1)

827961(1)

1113342(1)

1113336(1)

17850(1)

17828(1)

01246(1)

827622(1)

01641(1)

01468(1)

01474(1)

10511(1)

10507(1)

05872(1)

01492(1)

SN42068(1)

SN13898(1)

SN13897(1)

SN13896(1)

SN13899(1)

SN1512(1)

SN42067(1)

SN3355(1)

SN3353(1)

10513(1)

13970(1)

42799(1)

37949(1)

37947(1)

17211(1)

17221(1)

17824(1)

17256(1)

17250(1)

35945(1)

35845(1)

14606(1)

14604(1)

13972(1)

14746(1)

29186(1)

35745(1)

35645(1)

29190(1)

01224(1)

Country of Origin

US(79)

Capacity (Volume)

2.5oz(1)

9 oz(1)

Capacity (Weight)

1.4 oz(18)

1.2 oz(14)

1.3 oz(6)

1.59 oz(6)

1.6 oz(5)

2.5 oz(4)

1.5 oz(4)

35 g(2)

1.23 oz(2)

1.16 oz(2)

2 oz(2)

2.46 oz(1)

2.64 oz(1)

2.71 oz(1)

2.53 oz(1)

2.54 oz(1)

3.08 oz(1)

1.8 oz(1)

5 oz(1)

1.58 oz(1)

2.39 oz(1)

2.1 oz(1)

1.73 oz(1)

9 oz(1)

2.8 oz(1)

Food Type

Snack Bar(31)

Cereal Bar(11)

Breakfast Cereal(9)

Protein Bar(7)

Oatmeal(6)

Soup(3)

Nutrition Bar(3)

Granola Bars(2)

Chewy Bar(2)

Granola Bar(2)

Meal/Entree Kit(1)

Cookie(1)

Lunch(1)

Price Range

$0-$49.99(78)

$50-$99.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved