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

Kellogg's(16)

Nature Valley(8)

General Mills(4)

Kashi(4)

That’s it.(3)

Nissin(3)

CLIF Bar(3)

Quaker(2)

Kraft(1)

Annie's Homegrown(1)

 
Packing Type

Bar(50)

Cup(15)

Box(6)

Individually Wrapped(1)

 
Flavor

Strawberry(3)

Assorted(2)

Crunchy Peanut Butter(2)

Blueberry(2)

Roasted Jalapeno(1)

Madagascar Vanilla Almond(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Mocha Almond(1)

Almond & Coconut(1)

Dark Chocolate Almond & Coconut(1)

Thai Sweet Chili(1)

Peanut Butter Dark Chocolate(1)

Oats & Honey with Toasted Coconut(1)

Blueberry Vanilla & Cashew(1)

Dark Chocolate Chunk(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Nuts & Sea Salt(1)

Maple Glazed Pecan & Sea Salt(1)

Raspberry Cashew & Chia(1)

Apple Walnut Oatmeal+(1)

Chicken(1)

Beef(1)

Summer Berry Oatmeal+(1)

Apple & Banana(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Shrimp(1)

Dark Chocolate Cocoa(1)

Mango Apple Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Cherry Apple Chia(1)

Pineapple Banana Kale Spinach(1)

Almond Butter(1)

Strawberry Apple Chia(1)

Fruit & Nut Delight(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Chocolate Chip(1)

White Chocolate Macadamia Nut(1)

Oats 'n Honey(1)

Original(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Dark Chocolate Cherry(1)

Peanut Butter Chocolate(1)

Cheerios(1)

Cinnamon Toast Crunch(1)

Lucky Charms(1)

Honey Nut Cheerios(1)

Froot Loops(1)

Frosted Flakes(1)

Honey Almond Flax(1)

Trail Mix(1)

Frosted Mini Wheats(1)

Cranberry Almond plus Antioxidants(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Real Aged Cheddar(1)

Raspberry(1)

Apple Cinnamon(1)

Salted Dark Chocolate and Nuts(1)

Raisin Bran Crunch(1)

Honey Pecan Baklava(1)

Chocolatey Brownie(1)

Chocolate & Peanut Butter(1)

Chocolatey Mint(1)

Peanut Butter Dark Chocolate plus Protein(1)

 
Manufacturer Part Number

18082(1)

18080(1)

18039(1)

18083(1)

18509(1)

18554(1)

18533(1)

18510(1)

17930(1)

17851(1)

17250(1)

17221(1)

17211(1)

17256(1)

17824(1)

17850(1)

17828(1)

19987(1)

19988(1)

15504(1)

827961(1)

1113342(1)

15528(1)

1022BA(1)

1022C(1)

1022BL(1)

1113336(1)

25954(1)

24063(1)

19990(1)

19989(1)

24064(1)

24065(1)

25953(1)

24842(1)

56926(1)

56924(1)

160004(1)

SN42068(1)

SN42067(1)

161009(1)

50120(1)

827622(1)

01641(1)

SN3355(1)

SN3353(1)

SN13896(1)

489550(1)

31849(1)

SN13897(1)

SN13898(1)

SN1512(1)

SN13899(1)

01246(1)

01468(1)

35845(1)

35745(1)

35645(1)

35945(1)

37947(1)

42799(1)

37949(1)

29190(1)

29186(1)

10507(1)

05872(1)

01474(1)

10513(1)

13970(1)

14746(1)

13972(1)

00058(1)

 
Country of Origin

US(72)

 
Capacity (Volume)

2.5oz(1)

 
Capacity (Weight)

1.4 oz(16)

1.2 oz(13)

1.59 oz(6)

1.3 oz(6)

1.5 oz(5)

2.5 oz(4)

2.4 oz(3)

2 oz(2)

0.88 oz(2)

1.6 oz(2)

50 g(2)

35 g(2)

2.64 oz(1)

2.46 oz(1)

2.8 oz(1)

1.8 oz(1)

1.73 oz(1)

2.1 oz(1)

2.01 oz(1)

2.39 oz(1)

 
Food Type

Snack Bar(25)

Cereal Bar(13)

Breakfast Cereal(9)

Protein Bar(9)

Nutrition Bar(6)

Soup(3)

Granola Bar(3)

Oatmeal(2)

Macaroni and Cheese(1)

Lunch(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved