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

Kellogg's(16)

Nature Valley(6)

THIS BAR SAVES LIVES(6)

General Mills(4)

CLIF Bar(3)

Quaker(3)

Kashi(2)

Kraft(1)

Annie's Homegrown(1)

N'Joy(1)

 
Packing Type

Bar(44)

Cup(12)

Individually Wrapped Bar(6)

Box(6)

Individually Wrapped(4)

Bowl(1)

 
Flavor

Strawberry(4)

Crunchy Peanut Butter(3)

Blueberry(2)

Assorted(2)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Raspberry Cashew & Chia(1)

PB&J(1)

Mango Apple Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Dark Chocolate Mocha Almond(1)

Caramel Almond & Sea Salt(1)

Maple Glazed Pecan & Sea Salt(1)

Dark Chocolate Cinnamon Pecan(1)

Blueberry Vanilla & Cashew(1)

Oats & Honey with Toasted Coconut(1)

Peanut Butter Dark Chocolate(1)

Dark Chocolate Chunk(1)

Dark Chocolate & Coconut(1)

Cherry Apple Chia(1)

Apple Walnut Oatmeal+(1)

Morning Harvest(1)

Summer Berry Oatmeal+(1)

Dark Chocolate & Peanut Butter(1)

Madagascar Vanilla & Almond & Honey(1)

Dark Chocolate & Cherry(1)

Toasted Caramel Nut(1)

Double Dark Chocolate(1)

Dark Chocolate Nuts & Sea Salt(1)

Pineapple Banana Kale Spinach(1)

Strawberry Apple Chia(1)

Almond Butter(1)

White Chocolate Cinnamon Almond(1)

Dark Chocolate Cocoa(1)

Wild Blueberry & Pistachio(1)

Fruit & Nut Delight(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Original(1)

Oats 'n Honey(1)

Frosted Flakes(1)

Froot Loops(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Cinnamon Toast Crunch(1)

Cheerios(1)

Honey Nut Cheerios(1)

Lucky Charms(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Raisin Bran Crunch(1)

Chocolate Almond(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Cranberry Almond plus Antioxidants(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Peanut Butter Dark Chocolate plus Protein(1)

Almond & Coconut(1)

Real Aged Cheddar(1)

Frosted Mini Wheats(1)

Honey Almond Flax(1)

Chocolate & Peanut Butter(1)

Cranberry Almond(1)

Apple Cinnamon(1)

Raspberry(1)

Trail Mix(1)

Madagascar Vanilla Almond(1)

 
Manufacturer Part Number

19987(1)

18554(1)

18533(1)

19988(1)

19989(1)

24064(1)

24063(1)

19990(1)

18083(1)

18082(1)

17851(1)

17850(1)

17828(1)

17852(1)

17930(1)

18080(1)

18039(1)

24065(1)

24842(1)

00444PK(1)

00443PK(1)

31567(1)

00445PK(1)

00447PK(1)

00473PK(1)

00457PK(1)

15528(1)

15504(1)

26026(1)

25954(1)

25953(1)

26031(1)

26036(1)

1036601(1)

26041(1)

17824(1)

17256(1)

50120(1)

161009(1)

160004(1)

01641(1)

827622(1)

01474(1)

01468(1)

01246(1)

SN42068(1)

SN42067(1)

SN13898(1)

SN13897(1)

SN13896(1)

SN13899(1)

SN1512(1)

SN3355(1)

SN3353(1)

05872(1)

14604(1)

56924(1)

42799(1)

37949(1)

56926(1)

17211(1)

17250(1)

17221(1)

37947(1)

35945(1)

29186(1)

14746(1)

14606(1)

29190(1)

35645(1)

35845(1)

35745(1)

00058(1)

 
Country of Origin

US(73)

 
Capacity (Weight)

1.4 oz(23)

1.2 oz(10)

1.3 oz(6)

1.5 oz(4)

1.76 oz(4)

2.4 oz(3)

1.59 oz(2)

35 g(2)

50 g(2)

0.88 oz(2)

2 oz(2)

1.16 oz(2)

1.23 oz(1)

2.64 oz(1)

3.08 oz(1)

2.46 oz(1)

2.39 oz(1)

1.73 oz(1)

1.8 oz(1)

2.1 oz(1)

2.8 oz(1)

2.01 oz(1)

2.5 oz(1)

 
Food Type

Snack Bar(24)

Cereal Bar(13)

Breakfast Cereal(9)

Protein Bar(8)

Snackbar(6)

Nutrition Bar(3)

Oatmeal(3)

Chewy Bar(2)

Granola Bar(2)

Lunch(1)

Macaroni and Cheese(1)

Granola Bars(1)

 
 
 

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