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

Kashi(5)

Quaker(4)

General Mills(4)

CLIF Bar(3)

Nissin(3)

That’s it.(3)

Larabar(2)

Umpqua Oats(1)

Jif Bars(1)

N'Joy(1)

Annie's Homegrown(1)

Barilla(1)

Kraft(1)

 
Packing Type

Bar(61)

Cup(16)

Box(5)

Individually Wrapped(3)

Bowl(1)

Microwavable Tray(1)

 
Flavor

Strawberry(4)

Blueberry(3)

Assorted(2)

Crunchy Peanut Butter(2)

Thai Sweet Chili(1)

Chipotle Honey Mustard(1)

Sweet Cayenne Barbeque(1)

Roasted Jalapeno(1)

Caramel Almond & Sea Salt(1)

Fruit & Nut Delight(1)

Dark Chocolate Mocha Almond(1)

Peanut Butter Dark Chocolate(1)

Almond & Coconut(1)

Blueberry Vanilla & Cashew(1)

Maple Glazed Pecan & Sea Salt(1)

Dark Chocolate Cinnamon Pecan(1)

Madagascar Vanilla Almond(1)

Oats & Honey with Toasted Coconut(1)

Dark Chocolate Chunk(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Nuts & Sea Salt(1)

Raspberry Cashew & Chia(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Chicken(1)

Beef(1)

Creamy Peanut Butter(1)

Apple & Banana(1)

Kick Start(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Shrimp(1)

Morning Harvest(1)

Pineapple Coconut Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Peanut Butter Dark Chocolate plus Protein(1)

Mango Apple Chia(1)

Cherry Apple Chia(1)

Strawberry Apple Chia(1)

Apricot Pear Carrot Beet(1)

Pineapple Banana Kale Spinach(1)

Dark Chocolate Almond Mint(1)

Cranberry Almond plus Antioxidants(1)

Dark Chocolate and Peanut Butter(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Dark Chocolate(1)

Marinara Penne(1)

Original(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Dark Chocolate Cherry(1)

Cashew Cookie(1)

Peanut Butter Chocolate Chip(1)

Cheerios(1)

Cinnamon Toast Crunch(1)

Lucky Charms(1)

Honey Nut Cheerios(1)

Oats 'n Honey(1)

Froot Loops(1)

Raspberry(1)

Apple Cinnamon(1)

Chocolate & Peanut Butter(1)

Trail Mix(1)

Honey Almond Flax(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Real Aged Cheddar(1)

Frosted Mini Wheats(1)

Cranberry Almond(1)

Chocolate Almond(1)

Salted Dark Chocolate and Nuts(1)

Raisin Bran Crunch(1)

Frosted Flakes(1)

Peanut Hemp Crunch(1)

Honey Pecan Baklava(1)

Chocolatey Mint(1)

Chocolatey Brownie(1)

Chocolate Cherry Cashew plus Antioxidants(1)

 
Manufacturer Part Number

18506(1)

18083(1)

18082(1)

18080(1)

18508(1)

18509(1)

19987(1)

18554(1)

18533(1)

18510(1)

18039(1)

17930(1)

17256(1)

17250(1)

17221(1)

17211(1)

17824(1)

17828(1)

17852(1)

17851(1)

17850(1)

19988(1)

19989(1)

31569(1)

31567(1)

15528(1)

15504(1)

21030(1)

1022BA(1)

1200KS(1)

1022C(1)

1022BL(1)

827961(1)

1113342(1)

24064(1)

24063(1)

24062(1)

19990(1)

24065(1)

24066(1)

1113336(1)

1036601(1)

24842(1)

56926(1)

56924(1)

SN44099(1)

SN44066(1)

SN42068(1)

SN42067(1)

01492(1)

160004(1)

01641(1)

50120(1)

161009(1)

SN3355(1)

SN3353(1)

489550(1)

41873(1)

41689(1)

31849(1)

SN13896(1)

SN13897(1)

SN1512(1)

SN13899(1)

SN13898(1)

827622(1)

01246(1)

35745(1)

35645(1)

29190(1)

29186(1)

35845(1)

35945(1)

42799(1)

37949(1)

37947(1)

14746(1)

14606(1)

10507(1)

05872(1)

01474(1)

01468(1)

10511(1)

10513(1)

14604(1)

13972(1)

13970(1)

00058(1)

 
Country of Origin

US(88)

 
Capacity (Volume)

2.5oz(1)

9 oz(1)

 
Capacity (Weight)

1.4 oz(18)

1.2 oz(15)

1.59 oz(6)

1.3 oz(6)

1.6 oz(5)

2.5 oz(4)

1.5 oz(4)

2.4 oz(3)

1.16 oz(2)

1.23 oz(2)

0.88 oz(2)

35 g(2)

0.6 oz(2)

2 oz(2)

2.71 oz(1)

3.08 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(4)

Granola Bar(4)

Soup(3)

Granola Bars(2)

Chewy Bar(2)

Meal/Entree Kit(1)

Lunch(1)

Macaroni and Cheese(1)

 
 
 

© 2018-2019 Legal Name, All Rights Reserved