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`.`desc_short` LIKE 'MealsandSnackBar%' THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`desc_long` LIKE 'MealsandSnackBar%' THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`sku` LIKE '%MealsandSnackBar' THEN 1 ELSE 0 END DESC, 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(28)

Kellogg's(18)

Nature Valley(8)

Kashi(5)

General Mills(4)

Quaker(4)

CLIF Bar(3)

That’s it.(3)

Nissin(3)

Barilla(1)

Kraft(1)

Annie's Homegrown(1)

N'Joy(1)

 
Packing Type

Bar(54)

Cup(15)

Box(8)

Bowl(1)

Individually Wrapped(1)

Microwavable Tray(1)

 
Flavor

Strawberry(4)

Blueberry(3)

Assorted(2)

Crunchy Peanut Butter(2)

Thai Sweet Chili(1)

Sweet Cayenne Barbeque(1)

Roasted Jalapeno(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Mocha Almond(1)

Peanut Butter Dark Chocolate(1)

Fruit & Nut Delight(1)

Blueberry Vanilla & Cashew(1)

Maple Glazed Pecan & Sea Salt(1)

Madagascar Vanilla Almond(1)

Oats & Honey with Toasted Coconut(1)

Dark Chocolate Chunk(1)

Almond & Coconut(1)

Dark Chocolate Nuts & Sea Salt(1)

Raspberry Cashew & Chia(1)

Chicken(1)

Beef(1)

Shrimp(1)

Apple Walnut Oatmeal+(1)

Summer Berry Oatmeal+(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Apple & Banana(1)

Morning Harvest(1)

Dark Chocolate Cocoa(1)

Mango Apple Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Peanut Butter Dark Chocolate plus Protein(1)

Cherry Apple Chia(1)

Pineapple Banana Kale Spinach(1)

Almond Butter(1)

Strawberry Apple Chia(1)

Dark Chocolate Almond Mint(1)

Cranberry Almond plus Antioxidants(1)

Chocolate Chip(1)

Marinara Penne(1)

Sweet & Salty Nut Almond(1)

White Chocolate Macadamia Nut(1)

Original(1)

Froot Loops(1)

Oats 'n Honey(1)

Sweet & Salty Nut Peanut(1)

Crunchy Oats’n Honey(1)

Cheerios(1)

Dark Chocolate Cherry(1)

Peanut Butter Chocolate(1)

Cinnamon Toast Crunch(1)

Honey Nut Cheerios(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Frosted Flakes(1)

Raisin Bran Crunch(1)

Trail Mix(1)

Raspberry(1)

Apple Cinnamon(1)

Honey Almond Flax(1)

Frosted Mini Wheats(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Real Aged Cheddar(1)

Chocolate & Peanut Butter(1)

Cranberry Almond(1)

Peanut Hemp Crunch(1)

Salted Dark Chocolate and Nuts(1)

Honey Pecan Baklava(1)

Chocolatey Brownie(1)

Chocolate Almond(1)

Chocolatey Mint(1)

Chocolate Cherry Cashew plus Antioxidants(1)

 
Manufacturer Part Number

18506(1)

18083(1)

18082(1)

18080(1)

18509(1)

18510(1)

19987(1)

18554(1)

18533(1)

18039(1)

17930(1)

17250(1)

17221(1)

17211(1)

17256(1)

17824(1)

17851(1)

17850(1)

17828(1)

19988(1)

19989(1)

15528(1)

15504(1)

827961(1)

31567(1)

31569(1)

1022C(1)

1022BL(1)

1022BA(1)

1113342(1)

1113336(1)

24064(1)

24063(1)

19990(1)

24065(1)

24842(1)

1036601(1)

25954(1)

25953(1)

56926(1)

56924(1)

160004(1)

01492(1)

SN42068(1)

161009(1)

50120(1)

01246(1)

827622(1)

01641(1)

SN42067(1)

SN3355(1)

SN13896(1)

489550(1)

31849(1)

SN13897(1)

SN13898(1)

SN3353(1)

SN1512(1)

SN13899(1)

01468(1)

01474(1)

35745(1)

35645(1)

29190(1)

35845(1)

35945(1)

42799(1)

37949(1)

37947(1)

29186(1)

14746(1)

10511(1)

10507(1)

05872(1)

10513(1)

13970(1)

14606(1)

14604(1)

13972(1)

00058(1)

 
Country of Origin

US(80)

 
Capacity (Volume)

2.5oz(1)

9 oz(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)

1.6 oz(3)

2.4 oz(3)

0.88 oz(2)

1.16 oz(2)

35 g(2)

50 g(2)

2 oz(2)

1.23 oz(2)

2.46 oz(1)

3.08 oz(1)

2.64 oz(1)

1.58 oz(1)

1.73 oz(1)

1.8 oz(1)

9 oz(1)

2.1 oz(1)

2.01 oz(1)

2.8 oz(1)

2.39 oz(1)

 
Food Type

Snack Bar(26)

Cereal Bar(13)

Protein Bar(10)

Breakfast Cereal(9)

Nutrition Bar(6)

Soup(3)

Granola Bar(3)

Oatmeal(3)

Granola Bars(2)

Chewy Bar(2)

Macaroni and Cheese(1)

Lunch(1)

Meal/Entree Kit(1)

 
 
 

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