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 ('1021')) 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(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)

Honey Roasted Nuts & Sea Salt(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Mocha Almond(1)

Dark Chocolate Almond & Coconut(1)

Roasted Jalapeno(1)

Raspberry Cashew & Chia(1)

Dark Chocolate Almond Mint(1)

Thai Sweet Chili(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)

Chipotle Honey Mustard(1)

Sweet Cayenne Barbeque(1)

Peanut Butter Dark Chocolate(1)

Black Truffle Almond & Sea Salt(1)

Pineapple Coconut Chia(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)

Pineapple Banana Kale Spinach(1)

Cherry Apple Chia(1)

Mango Apple Chia(1)

Apricot Pear Carrot Beet(1)

Caramel Almond Pumpkin Spice(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

18554(1)

18533(1)

18510(1)

19987(1)

19988(1)

19991(1)

19990(1)

19989(1)

18509(1)

18508(1)

17930(1)

17852(1)

17851(1)

18039(1)

18080(1)

18506(1)

18083(1)

18082(1)

24062(1)

24063(1)

1022BA(1)

31569(1)

31567(1)

1022BL(1)

1022C(1)

1217JP(1)

1202MS(1)

1200KS(1)

15528(1)

15504(1)

24066(1)

24065(1)

24064(1)

24482(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(19)

1.2 oz(14)

1.3 oz(6)

1.59 oz(6)

2.5 oz(4)

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

 
 
 

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