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_27` 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(30)

Kellogg's(18)

Nature Valley(8)

Kashi(5)

Quaker(4)

General Mills(4)

That’s it.(3)

Nissin(3)

CLIF Bar(3)

Umpqua Oats(2)

Larabar(2)

Kraft(1)

Annie's Homegrown(1)

Jif Bars(1)

Barilla(1)

N'Joy(1)

 
Packing Type

Bar(61)

Cup(17)

Box(5)

Individually Wrapped(2)

Bowl(1)

Microwavable Tray(1)

 
Flavor

Strawberry(4)

Blueberry(3)

Crunchy Peanut Butter(2)

Assorted(2)

Thai Sweet Chili(1)

Chipotle Honey Mustard(1)

Roasted Jalapeno(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Mocha Almond(1)

Almond & Coconut(1)

Peanut Butter Dark Chocolate(1)

Maple Glazed Pecan & Sea Salt(1)

Dark Chocolate Cinnamon Pecan(1)

Dark Chocolate Nuts & Sea Salt(1)

Blueberry Vanilla & Cashew(1)

Oats & Honey with Toasted Coconut(1)

Madagascar Vanilla Almond(1)

Dark Chocolate Chunk(1)

Sweet Cayenne Barbeque(1)

Honey Roasted Nuts & Sea Salt(1)

Creamy Peanut Butter(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Chicken(1)

Apple & Banana(1)

Apple & Blueberry(1)

Mostly Sunny(1)

Kick Start(1)

Apple & Cherry(1)

Beef(1)

Shrimp(1)

Mango Apple Chia(1)

Pineapple Coconut Chia(1)

Fruit & Nut Delight(1)

Cherry Apple Chia(1)

Pineapple Banana Kale Spinach(1)

Morning Harvest(1)

Strawberry Apple Chia(1)

Apricot Pear Carrot Beet(1)

Raspberry Cashew & Chia(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Dark Chocolate(1)

Dark Chocolate and Peanut Butter(1)

Sweet & Salty Nut Almond(1)

Marinara Penne(1)

Chocolate Chip(1)

Oats 'n Honey(1)

Original(1)

White Chocolate Macadamia Nut(1)

Sweet & Salty Nut Peanut(1)

Crunchy Oats’n Honey(1)

Cheerios(1)

Cashew Cookie(1)

Peanut Butter Chocolate Chip(1)

Cinnamon Toast Crunch(1)

Honey Nut Cheerios(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Froot Loops(1)

Frosted Flakes(1)

Trail Mix(1)

Raspberry(1)

Apple Cinnamon(1)

Honey Almond Flax(1)

Frosted Mini Wheats(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Real Aged Cheddar(1)

Cranberry Almond plus Antioxidants(1)

Chocolate & Peanut Butter(1)

Cranberry Almond(1)

Peanut Hemp Crunch(1)

Salted Dark Chocolate and Nuts(1)

Raisin Bran Crunch(1)

Honey Pecan Baklava(1)

Chocolatey Brownie(1)

Chocolate Almond(1)

Chocolatey Mint(1)

Peanut Butter Dark Chocolate plus Protein(1)

 
Manufacturer Part Number

18509(1)

18508(1)

18506(1)

18083(1)

18510(1)

18533(1)

19988(1)

19987(1)

18554(1)

18082(1)

18080(1)

17828(1)

17824(1)

17256(1)

17250(1)

17850(1)

17851(1)

18039(1)

17930(1)

17852(1)

19989(1)

19990(1)

21030(1)

31569(1)

31567(1)

15528(1)

1022BA(1)

1022BL(1)

1202MS(1)

1200KS(1)

1022C(1)

15504(1)

827961(1)

24065(1)

24064(1)

24063(1)

24062(1)

24066(1)

24842(1)

1113342(1)

1113336(1)

1036601(1)

17221(1)

17211(1)

160004(1)

01492(1)

SN44099(1)

SN44066(1)

161009(1)

50120(1)

01246(1)

827622(1)

01641(1)

SN42068(1)

SN42067(1)

SN13897(1)

SN13896(1)

41873(1)

41689(1)

SN13898(1)

SN13899(1)

SN3355(1)

SN3353(1)

SN1512(1)

01468(1)

01474(1)

35945(1)

35845(1)

35745(1)

35645(1)

37947(1)

37949(1)

56926(1)

56924(1)

42799(1)

29190(1)

29186(1)

10513(1)

10511(1)

10507(1)

05872(1)

13970(1)

13972(1)

14746(1)

14606(1)

14604(1)

00058(1)

 
Country of Origin

US(87)

 
Capacity (Volume)

2.5oz(1)

9 oz(1)

 
Capacity (Weight)

1.4 oz(18)

1.2 oz(15)

1.3 oz(6)

1.59 oz(6)

1.6 oz(5)

2.5 oz(4)

1.5 oz(4)

2.4 oz(3)

1.16 oz(2)

35 g(2)

0.88 oz(2)

0.6 oz(2)

2 oz(2)

1.23 oz(2)

2.54 oz(1)

3.08 oz(1)

2.71 oz(1)

2.64 oz(1)

2.46 oz(1)

2.8 oz(1)

1.73 oz(1)

1.8 oz(1)

1.7 oz(1)

9 oz(1)

2.1 oz(1)

1.58 oz(1)

2.01 oz(1)

2.39 oz(1)

 
Food Type

Snack Bar(32)

Cereal Bar(15)

Breakfast Cereal(9)

Protein Bar(7)

Nutrition Bar(6)

Oatmeal(5)

Granola Bar(3)

Soup(3)

Granola Bars(2)

Chewy Bar(2)

Lunch(1)

Meal/Entree Kit(1)

Macaroni and Cheese(1)

 
 
 

© 2017-2018 Legal Name, All Rights Reserved