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_36` 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(21)

Kellogg's(16)

Nature Valley(8)

General Mills(4)

CLIF Bar(3)

That’s it.(3)

Quaker(2)

Kashi(2)

Kraft(1)

Annie's Homegrown(1)

 
Packing Type

Bar(44)

Cup(12)

Box(4)

Individually Wrapped(1)

 
Flavor

Strawberry(3)

Blueberry(2)

Crunchy Peanut Butter(2)

Assorted(2)

Dark Chocolate Chunk(1)

Dark Chocolate Nuts & Sea Salt(1)

Oats & Honey with Toasted Coconut(1)

Maple Glazed Pecan & Sea Salt(1)

Madagascar Vanilla Almond(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Peanut Butter Dark Chocolate plus Protein(1)

Fruit & Nut Delight(1)

Almond & Coconut(1)

Peanut Butter Dark Chocolate(1)

Dark Chocolate Mocha Almond(1)

Apple Walnut Oatmeal+(1)

Pineapple Banana Kale Spinach(1)

Summer Berry Oatmeal+(1)

Apple & Banana(1)

Apple & Cherry(1)

Apple & Blueberry(1)

Cherry Apple Chia(1)

Mango Apple Chia(1)

Dark Chocolate Almond & Coconut(1)

Cranberry Almond plus Antioxidants(1)

Dark Chocolate Almond Mint(1)

Raspberry Cashew & Chia(1)

Honey Roasted Nuts & Sea Salt(1)

Caramel Almond & Sea Salt(1)

Trail Mix(1)

Crunchy Oats’n Honey(1)

Chewy Trail Mix(1)

Sweet & Salty Nut Peanut(1)

Sweet & Salty Nut Almond(1)

Chocolate Chip(1)

Lucky Charms(1)

Honey Nut Cheerios(1)

Peanut Butter Chocolate(1)

Dark Chocolate Cherry(1)

Cheerios(1)

Cinnamon Toast Crunch(1)

White Chocolate Macadamia Nut(1)

Original(1)

Apple Cinnamon(1)

Chocolate & Peanut Butter(1)

Raspberry(1)

Real Aged Cheddar(1)

Honey Almond Flax(1)

Chocolatey Mint(1)

Chocolatey Brownie(1)

Oats 'n Honey(1)

Froot Loops(1)

Frosted Flakes(1)

Raisin Bran Crunch(1)

Frosted Mini Wheats(1)

 
Manufacturer Part Number

17850(1)

17828(1)

17851(1)

17930(1)

18082(1)

18080(1)

17824(1)

17256(1)

56924(1)

42799(1)

56926(1)

17211(1)

17250(1)

17221(1)

18083(1)

18533(1)

15504(1)

24065(1)

15528(1)

1022BA(1)

1022C(1)

1022BL(1)

24064(1)

24063(1)

19987(1)

18554(1)

19988(1)

19989(1)

19990(1)

37949(1)

37947(1)

SN42067(1)

SN3355(1)

SN42068(1)

160004(1)

50120(1)

161009(1)

SN3353(1)

SN1512(1)

489550(1)

31849(1)

SN13896(1)

SN13897(1)

SN13899(1)

SN13898(1)

01641(1)

827622(1)

29190(1)

29186(1)

35645(1)

35745(1)

35945(1)

35845(1)

14746(1)

13972(1)

01468(1)

01246(1)

01474(1)

05872(1)

13970(1)

00058(1)

 
Country of Origin

US(61)

 
Capacity (Weight)

1.4 oz(15)

1.2 oz(12)

1.3 oz(6)

1.5 oz(5)

1.59 oz(4)

2.4 oz(3)

2 oz(2)

0.88 oz(2)

35 g(2)

2.5 oz(1)

2.64 oz(1)

2.46 oz(1)

2.1 oz(1)

1.8 oz(1)

1.73 oz(1)

2.01 oz(1)

2.8 oz(1)

2.39 oz(1)

 
Food Type

Snack Bar(21)

Cereal Bar(13)

Breakfast Cereal(9)

Nutrition Bar(6)

Protein Bar(5)

Granola Bar(3)

Oatmeal(2)

Lunch(1)

Macaroni and Cheese(1)

 
 
 

© 2018-2019 Legal Name, All Rights Reserved

Powered byDealer Commander