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

Kellogg's(16)

Nature Valley(8)

General Mills(4)

CLIF Bar(3)

Quaker(3)

Larabar(2)

Kashi(2)

That’s it.(1)

Kraft(1)

Annie's Homegrown(1)

N'Joy(1)

 
Packing Type

Bar(53)

Cup(12)

Individually Wrapped(9)

Box(6)

Bowl(1)

 
Flavor

Strawberry(4)

Crunchy Peanut Butter(3)

Blueberry(2)

Assorted(2)

Honey Roasted Nuts & Sea Salt(1)

Raspberry Cashew & Chia(1)

Mango Apple Chia(1)

Dark Chocolate Cinnamon Pecan(1)

Pineapple Banana Kale Spinach(1)

Cherry Apple Chia(1)

Dark Chocolate Almond Mint(1)

Dark Chocolate Almond & Coconut(1)

Dark Chocolate Chunk(1)

Oats & Honey with Toasted Coconut(1)

Blueberry Vanilla & Cashew(1)

Peanut Butter Dark Chocolate(1)

Caramel Almond & Sea Salt(1)

Strawberry Apple Chia(1)

Dark Chocolate Mocha Almond(1)

Maple Glazed Pecan & Sea Salt(1)

Almond Butter(1)

Almond Butter Dark Chocolate(1)

Honey Almond Butter(1)

Chocolate Peanut Butter(1)

Salted Caramel and Dark Chocolate Nut(1)

Morning Harvest(1)

Apple & Blueberry(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Toasted Caramel Nut(1)

Double Dark Chocolate(1)

Dark Chocolate Banana(1)

Dark Chocolate Strawberry(1)

Dark Chocolate Cocoa(1)

Chewy Chocolate Chip(1)

Chewy Peanut Butter Chocolate Chip(1)

White Chocolate Cinnamon Almond(1)

Chewy Honey Oat(1)

Dark Chocolate Nuts & Sea Salt(1)

Fruit & Nut Delight(1)

Dark Chocolate(1)

Dark Chocolate and Peanut Butter(1)

Sweet & Salty Nut Almond(1)

Chocolate Chip(1)

White Chocolate Macadamia Nut(1)

Oats 'n Honey(1)

Original(1)

Sweet & Salty Nut Peanut(1)

Crunchy Oats’n Honey(1)

Cheerios(1)

Cashew Cookie(1)

Peanut Butter Chocolate Chip(1)

Cinnamon Toast Crunch(1)

Honey Nut Cheerios(1)

Chewy Trail Mix(1)

Lucky Charms(1)

Froot Loops(1)

Frosted Flakes(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)

Almond & Coconut(1)

Real Aged Cheddar(1)

Honey Almond Flax(1)

Trail Mix(1)

Chocolate Almond(1)

Raisin Bran Crunch(1)

Cranberry Almond(1)

Chocolate & Peanut Butter(1)

Raspberry(1)

Apple Cinnamon(1)

Madagascar Vanilla Almond(1)

 
Manufacturer Part Number

19989(1)

19988(1)

19987(1)

18554(1)

19990(1)

24063(1)

24842(1)

24065(1)

24064(1)

18533(1)

18083(1)

17851(1)

17850(1)

17828(1)

17852(1)

17930(1)

18082(1)

18080(1)

18039(1)

25953(1)

25954(1)

26961(1)

26832(1)

26289(1)

1036601(1)

15504(1)

1022BL(1)

31567(1)

15528(1)

26286(1)

26041(1)

25987(1)

25973(1)

25968(1)

25988(1)

25989(1)

26036(1)

26031(1)

26026(1)

17824(1)

17256(1)

160004(1)

SN44099(1)

SN44066(1)

SN42068(1)

161009(1)

50120(1)

01246(1)

827622(1)

01641(1)

SN42067(1)

SN3355(1)

SN13896(1)

41873(1)

41689(1)

SN13897(1)

SN13898(1)

SN3353(1)

SN1512(1)

SN13899(1)

01468(1)

01474(1)

42799(1)

37949(1)

37947(1)

56924(1)

56926(1)

17250(1)

17221(1)

17211(1)

35945(1)

35845(1)

14606(1)

14604(1)

05872(1)

14746(1)

29186(1)

35745(1)

35645(1)

29190(1)

00058(1)

 
Country of Origin

US(81)

 
Capacity (Weight)

1.4 oz(18)

1.2 oz(11)

1.3 oz(8)

1.76 oz(5)

1.5 oz(4)

0.81 oz(3)

2.4 oz(3)

35 g(2)

0.88 oz(2)

50 g(2)

1.34 oz(2)

1.59 oz(2)

1.16 oz(2)

0.6 oz(2)

2 oz(2)

1.7 oz(1)

1.6 oz(1)

2.64 oz(1)

1.23 oz(1)

2.46 oz(1)

3.08 oz(1)

1.8 oz(1)

2.8 oz(1)

2.39 oz(1)

2.1 oz(1)

2.5 oz(1)

1.73 oz(1)

2.01 oz(1)

 
Food Type

Snack Bar(32)

Cereal Bar(15)

Breakfast Cereal(9)

Protein Bar(9)

Nutrition Bar(4)

Oatmeal(3)

Granola Bar(2)

Chewy Bar(2)

Snack(2)

Granola Bars(1)

Lunch(1)

Macaroni and Cheese(1)

 
 
 

© 2019-2020 Desert West Office Supply, All Rights Reserved