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(26)

Kellogg's(18)

Quaker(6)

Nature Valley(6)

Kashi(5)

General Mills(4)

Nissin(3)

That’s it.(3)

N'Joy(1)

PowerBar(1)

Sheila G’s Brownie Brittle(1)

Barilla(1)

Kraft(1)

Packing Type

Bar(56)

Cup(14)

Box(3)

Bowl(1)

Microwavable Tray(1)

Bag(1)

Flavor

Strawberry(4)

Assorted(2)

Blueberry(2)

Madagascar Vanilla Almond(1)

Dark Chocolate Mocha Almond(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Almond Mint(1)

Raspberry Cashew & Chia(1)

Almond & Coconut(1)

Roasted Jalapeno Almond(1)

Thai Sweet Chili Almond(1)

Oats & Honey with Toasted Coconut(1)

Maple Glazed Pecan & Sea Salt(1)

Dark Chocolate Chunk(1)

Peanut Butter Dark Chocolate(1)

Honey Roasted Nuts & Sea Salt(1)

Hickory Smoked Almond(1)

Dark Chocolate Nuts & Sea Salt(1)

Mango Apple Chia(1)

Cherry Pistachio(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Apple Nut Harvest(1)

Apple & Banana(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Chicken(1)

Beef(1)

Pineapple Banana Kale Spinach(1)

Cherry Apple Chia(1)

Fruit & Nut Delight(1)

Apricot Pear Carrot Beet(1)

Apple Cinnamon Crisp(1)

Shrimp(1)

Morning Harvest(1)

Pineapple Coconut Chia(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Original(1)

Marinara Penne(1)

Sweet & Salty Nut Almond(1)

Oats 'n Honey(1)

Froot Loops(1)

Raisin Bran Crunch(1)

Frosted Flakes(1)

Sweet & Salty Nut Peanut(1)

Crunchy Peanut Butter(1)

Cinnamon Toast Crunch(1)

Cheerios(1)

Honey Nut Cheerios(1)

Lucky Charms(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Salted Dark Chocolate and Nuts(1)

Peanut Hemp Crunch(1)

Honey Almond Flax(1)

Trail Mix(1)

Raspberry(1)

Frosted Mini Wheats(1)

Cranberry Almond plus Antioxidants(1)

Chocolate Chip(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Apple Cinnamon(1)

Chocolate & Peanut Butter(1)

Chocolatey Salted Caramel(1)

Honey Pecan Baklava(1)

Chocolatey Brownie(1)

Chocolatey Mint(1)

Cranberry Almond(1)

Chocolate Almond(1)

Peanut Butter Dark Chocolate plus Protein(1)

Manufacturer Part Number

18533(1)

18510(1)

18509(1)

18554(1)

19987(1)

19990(1)

19989(1)

19988(1)

18505(1)

18083(1)

17828(1)

17824(1)

17256(1)

17850(1)

17851(1)

18082(1)

18080(1)

17930(1)

24062(1)

24063(1)

31569(1)

31567(1)

15528(1)

31799(1)

31803(1)

1022C(1)

1022BL(1)

1022BA(1)

15504(1)

827961(1)

24066(1)

24065(1)

24064(1)

82654(1)

1036601(1)

1113342(1)

1113336(1)

17250(1)

17221(1)

827622(1)

01641(1)

01492(1)

01246(1)

01283(1)

05872(1)

01474(1)

01468(1)

SN42068(1)

SN42067(1)

SN13898(1)

SN13897(1)

SN13896(1)

SN13899(1)

SN1512(1)

SN3355(1)

SN3353(1)

10507(1)

10511(1)

35845(1)

35745(1)

35645(1)

35945(1)

37947(1)

17211(1)

42799(1)

37949(1)

29190(1)

29186(1)

13970(1)

12522(1)

10513(1)

13972(1)

14604(1)

14746(1)

14606(1)

01224(1)

Country of Origin

US(76)

Capacity (Volume)

2.5oz(1)

9 oz(1)

Capacity (Weight)

1.4 oz(15)

1.2 oz(14)

1.3 oz(6)

1.59 oz(6)

2.5 oz(4)

1.5 oz(4)

1.6 oz(3)

1.34 oz(2)

1.23 oz(2)

1.16 oz(2)

2 oz(2)

35 g(2)

2.46 oz(1)

2.64 oz(1)

3.08 oz(1)

45 g(1)

1.58 oz(1)

9 oz(1)

1.73 oz(1)

1.8 oz(1)

0.81 oz(1)

2.1 oz(1)

0.85 oz(1)

5 oz(1)

2.8 oz(1)

2.39 oz(1)

Food Type

Snack Bar(26)

Cereal Bar(13)

Breakfast Cereal(9)

Protein Bar(7)

Nutrition Bar(4)

Granola Bar(4)

Soup(3)

Oatmeal(3)

Granola Bars(2)

Chewy Bar(2)

Meal/Entree Kit(1)

Lunch(1)

Cookie(1)

Price Range

$0-$49.99(75)

$50-$99.99(1)

To  GO

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

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