Banner1 Banner1
 
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') 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)

Quaker(4)

General Mills(4)

CLIF Bar(3)

That’s it.(3)

Kashi(2)

Larabar(2)

Kraft(1)

Annie's Homegrown(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)

Cherry Apple Chia(1)

Pineapple Banana Kale Spinach(1)

Mango Apple Chia(1)

Almond Butter(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Cocoa(1)

Honey Roasted Nuts & Sea Salt(1)

Strawberry Apple Chia(1)

Raspberry Cashew & Chia(1)

Dark Chocolate Chunk(1)

Oats & Honey with Toasted Coconut(1)

Blueberry Vanilla & Cashew(1)

Maple Glazed Pecan & Sea Salt(1)

Peanut Butter Dark Chocolate(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Mocha Almond(1)

Dark Chocolate Banana(1)

Chewy Peanut Butter Chocolate Chip(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Apple & Banana(1)

Summer Berry Oatmeal+(1)

Dark Chocolate & Cherry(1)

Madagascar Vanilla & Almond & Honey(1)

PB&J(1)

Dark Chocolate & Peanut Butter(1)

Wild Blueberry & Pistachio(1)

Apple Walnut Oatmeal+(1)

Morning Harvest(1)

Double Dark Chocolate(1)

White Chocolate Cinnamon Almond(1)

Chewy Honey Oat(1)

Dark Chocolate Cinnamon Pecan(1)

Toasted Caramel Nut(1)

Chocolate Peanut Butter(1)

Salted Caramel and Dark Chocolate Nut(1)

Almond Butter Dark Chocolate(1)

Honey Almond Butter(1)

Chewy Chocolate Chip(1)

Almond & Coconut(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Dark Chocolate(1)

Dark Chocolate and Peanut Butter(1)

Original(1)

Oats 'n Honey(1)

Raisin Bran Crunch(1)

Frosted Flakes(1)

Froot Loops(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Cheerios(1)

Cashew Cookie(1)

Peanut Butter Chocolate Chip(1)

Cinnamon Toast Crunch(1)

Honey Nut Cheerios(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Chocolatey Brownie(1)

Chocolatey Mint(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Cranberry Almond plus Antioxidants(1)

Frosted Mini Wheats(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Peanut Butter Dark Chocolate plus Protein(1)

Madagascar Vanilla Almond(1)

Real Aged Cheddar(1)

Fruit & Nut Delight(1)

Honey Almond Flax(1)

Trail Mix(1)

Chocolate & Peanut Butter(1)

Cranberry Almond(1)

Chocolate Almond(1)

Frosted Blueberry(1)

Brown Sugar Cinnamon(1)

Raspberry(1)

Apple Cinnamon(1)

Frosted Strawberry(1)

Dark Chocolate Nuts & Sea Salt(1)

 
Manufacturer Part Number

24064(1)

24063(1)

19990(1)

19989(1)

24065(1)

24842(1)

25973(1)

25968(1)

25954(1)

25953(1)

19988(1)

19987(1)

17930(1)

17852(1)

17851(1)

17850(1)

18039(1)

18080(1)

18554(1)

18533(1)

18083(1)

18082(1)

25987(1)

25988(1)

1022BL(1)

1022BA(1)

31569(1)

31567(1)

1022C(1)

00443PK(1)

00473PK(1)

00447PK(1)

00445PK(1)

00444PK(1)

15528(1)

15504(1)

26036(1)

26031(1)

26026(1)

25989(1)

26041(1)

26286(1)

1036601(1)

26961(1)

26832(1)

26289(1)

17828(1)

17824(1)

50120(1)

161009(1)

160004(1)

SN44099(1)

01641(1)

827622(1)

05872(1)

01474(1)

01468(1)

01246(1)

SN44066(1)

SN42068(1)

SN13897(1)

SN13896(1)

41873(1)

41689(1)

SN13898(1)

SN13899(1)

SN42067(1)

SN3355(1)

SN3353(1)

SN1512(1)

13970(1)

13972(1)

42799(1)

37949(1)

37947(1)

35945(1)

56924(1)

56926(1)

17256(1)

17250(1)

17221(1)

17211(1)

35845(1)

35745(1)

29186(1)

14746(1)

14606(1)

14604(1)

29190(1)

31031(1)

35645(1)

31732(1)

31131(1)

00058(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.5 oz(4)

1.59 oz(4)

0.81 oz(3)

2.4 oz(3)

35 g(2)

0.88 oz(2)

50 g(2)

1.23 oz(2)

1.34 oz(2)

3.67 oz(2)

1.16 oz(2)

0.6 oz(2)

2 oz(2)

1.7 oz(1)

3.08 oz(1)

2.64 oz(1)

1.6 oz(1)

2.46 oz(1)

1.8 oz(1)

1.73 oz(1)

3.52 oz(1)

2.01 oz(1)

2.8 oz(1)

2.5 oz(1)

2.1 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)

Oatmeal(3)

Pastry(3)

Granola Bars(2)

Chewy Bar(2)

Snack(2)

Granola Bar(2)

Lunch(1)

Macaroni and Cheese(1)

 
 
 

© 2019-2020 Dependable Office Supply, All Rights Reserved