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 ('10132')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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(39)

Kellogg's(21)

Nature Valley(8)

THIS BAR SAVES LIVES(5)

General Mills(4)

Quaker(4)

CLIF Bar(3)

That’s it.(3)

Larabar(2)

Kashi(2)

Annie's Homegrown(1)

Kraft(1)

N'Joy(1)

 
Packing Type

Bar(57)

Cup(12)

Box(10)

Individually Wrapped(9)

Individually Wrapped Bar(5)

Bowl(1)

 
Flavor

Strawberry(4)

Crunchy Peanut Butter(3)

Blueberry(3)

Assorted(2)

Mango Apple Chia(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Cocoa(1)

Almond Butter(1)

Strawberry Apple Chia(1)

Pineapple Banana Kale Spinach(1)

Cherry Apple Chia(1)

Real Aged Cheddar(1)

Dark Chocolate Banana(1)

Raspberry Cashew & Chia(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Mocha Almond(1)

Caramel Almond & Sea Salt(1)

Peanut Butter Dark Chocolate(1)

Dark Chocolate Chunk(1)

Oats & Honey with Toasted Coconut(1)

Honey Roasted Nuts & Sea Salt(1)

Chewy Peanut Butter Chocolate Chip(1)

Chewy Chocolate Chip(1)

Apple Walnut Oatmeal+(1)

Dark Chocolate & Peanut Butter(1)

Wild Blueberry & Pistachio(1)

Madagascar Vanilla & Almond & Honey(1)

Dark Chocolate & Cherry(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Apple & Banana(1)

Summer Berry Oatmeal+(1)

Morning Harvest(1)

Maple Glazed Pecan & Sea Salt(1)

Salted Caramel and Dark Chocolate Nut(1)

Almond Butter Dark Chocolate(1)

Honey Almond Butter(1)

Chocolate Peanut Butter(1)

Toasted Caramel Nut(1)

Double Dark Chocolate(1)

White Chocolate Cinnamon Almond(1)

Chewy Honey Oat(1)

Blueberry Vanilla & Cashew(1)

Madagascar Vanilla Almond(1)

Dark Chocolate Cinnamon Pecan(1)

Dark Chocolate and Peanut Butter(1)

Frosted Flakes(1)

Froot Loops(1)

Oats 'n Honey(1)

Original(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Dark Chocolate(1)

Sweet & Salty Nut Almond(1)

Chocolatey Brownie(1)

Sweet & Salty Nut Peanut(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Honey Nut Cheerios(1)

Cinnamon Toast Crunch(1)

Cheerios(1)

Cashew Cookie(1)

Raisin Bran Crunch(1)

Chocolatey Mint(1)

Dark Chocolate Nuts & Sea Salt(1)

Frosted Mini Wheats(1)

Peanut Butter Chocolate Chip(1)

Almond & Coconut(1)

Fruit & Nut Delight(1)

Peanut Butter Dark Chocolate plus Protein(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Cranberry Almond plus Antioxidants(1)

Honey Almond Flax(1)

Chocolate Almond(1)

Trail Mix(1)

Raspberry(1)

Apple Cinnamon(1)

Frosted Strawberry(1)

Brown Sugar Cinnamon(1)

Frosted Blueberry(1)

Chocolate & Peanut Butter(1)

Cranberry Almond(1)

PB&J(1)

 
Manufacturer Part Number

00058(1)

19989(1)

25968(1)

25954(1)

25953(1)

24842(1)

24065(1)

24064(1)

24063(1)

19990(1)

19988(1)

25987(1)

19987(1)

18554(1)

18533(1)

18083(1)

18082(1)

18080(1)

18039(1)

17930(1)

17852(1)

25973(1)

25988(1)

17850(1)

15528(1)

00447PK(1)

00445PK(1)

00444PK(1)

00443PK(1)

1022C(1)

1022BL(1)

1022BA(1)

31569(1)

31567(1)

15504(1)

25989(1)

1036601(1)

26961(1)

26832(1)

26289(1)

26286(1)

26041(1)

26036(1)

26031(1)

26026(1)

17851(1)

17828(1)

41689(1)

SN44066(1)

01474(1)

01468(1)

01246(1)

827622(1)

01641(1)

50120(1)

161009(1)

160004(1)

SN44099(1)

SN42068(1)

13970(1)

SN42067(1)

SN3355(1)

SN3353(1)

SN1512(1)

SN13899(1)

SN13898(1)

SN13897(1)

SN13896(1)

41873(1)

05872(1)

13972(1)

17824(1)

35945(1)

17256(1)

17250(1)

17221(1)

17211(1)

56926(1)

56924(1)

42799(1)

37949(1)

37947(1)

35845(1)

14604(1)

35745(1)

35645(1)

31732(1)

31131(1)

31031(1)

29190(1)

29186(1)

14746(1)

14606(1)

00473PK(1)

 
Country of Origin

US(94)

 
Capacity (Weight)

1.4 oz(23)

1.2 oz(13)

1.3 oz(8)

1.76 oz(5)

1.59 oz(4)

1.5 oz(4)

0.81 oz(3)

2.4 oz(3)

0.6 oz(2)

0.88 oz(2)

2 oz(2)

1.16 oz(2)

1.34 oz(2)

3.67 oz(2)

50 g(2)

35 g(2)

1.23 oz(2)

3.08 oz(1)

2.64 oz(1)

2.46 oz(1)

2.01 oz(1)

2.5 oz(1)

3.52 oz(1)

1.6 oz(1)

2.8 oz(1)

2.1 oz(1)

1.73 oz(1)

1.8 oz(1)

1.7 oz(1)

2.39 oz(1)

 
Food Type

Snack Bar(32)

Cereal Bar(15)

Protein Bar(11)

Breakfast Cereal(9)

Nutrition Bar(6)

Snackbar(5)

Pastry(3)

Oatmeal(3)

Chewy Bar(2)

Granola Bar(2)

Snack(2)

Granola Bars(2)

Macaroni and Cheese(1)

Lunch(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved