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 ('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(22)

Kellogg's(15)

Quaker(9)

Nature Valley(7)

Umpqua Oats(4)

General Mills(4)

Thats it.(3)

Office Snax(3)

Kashi(2)

Bumble Bee(2)

udi's(2)

Barilla(2)

Kraft(1)

Nissin(1)

Lipton(1)

 
Packing Type

Bar(50)

Cup(15)

Bowl(5)

Box(2)

Microwavable Tray(2)

Pack(2)

Pouch(1)

Packets(1)

 
Flavor

Strawberry(4)

Blueberry(3)

Kick Start(2)

Chewy Chocolate Chip(2)

Hickory Smoked Almond(1)

Vanilla Blueberry(1)

Honey Smoked BBQ Almond(1)

Honey Mustard Almond(1)

Almond & Coconut(1)

Thai Sweet Chili Almond(1)

Peanut Butter Dark Chocolate(1)

Dark Chocolate Chunk(1)

Dark Chocolate Cinnamon Pecan(1)

Dark Chocolate Nuts & Sea Salt(1)

Blueberry Vanilla & Cashew(1)

Oats & Honey with Toasted Coconut(1)

Roasted Jalapeno Almond(1)

Maple Pumpkin Seeds with Sea Salt(1)

Madagascar Vanilla Almond(1)

Dark Chocolate Mocha Almond(1)

Apple & Banana(1)

Apple Nut Harvest(1)

Cherry Pistachio(1)

Apple & Blueberry(1)

Apple & Cherry(1)

Jackpot(1)

Mostly Sunny(1)

Summer Berry Oatmeal+(1)

Apple Walnut Oatmeal+(1)

Chicken(1)

Fruit & Nut Delight(1)

Brown Sugar(1)

Pure Honey(1)

Chewy Variety Pack: Chocolate Chunk, Oatmeal Raisin, Peanut Butter(1)

Maple(1)

Caramel Almond & Sea Salt(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Cranberry Almond Omega(1)

Tuna Salad(1)

Chicken Salad(1)

Chocolate Chip Antioxidant(1)

Marinara Penne(1)

Chicken Noodle(1)

Meat Sauce Gemelli(1)

Sweet & Salty Nut Almond(1)

Sweet & Salty Nut Peanut(1)

Honey Nut Cheerios(1)

Cinnamon Toast Crunch(1)

Cheerios(1)

Lucky Charms(1)

Chewy Trail Mix(1)

Crunchy Peanut Butter(1)

Crunchy Oatsn Honey(1)

Original(1)

Oats 'n Honey(1)

Honey Almond Flax(1)

Trail Mix(1)

Raspberry(1)

Frosted Mini Wheats(1)

Cranberry Almond plus Antioxidants(1)

Chewy Strawberry Yogurt(1)

Pomegranate Blueberry Pistachio plus Antioxidants(1)

Apple Cinnamon(1)

Chocolate & Peanut Butter(1)

Frosted Flakes(1)

Froot Loops(1)

Raisin Bran Crunch(1)

Maple Brown Sugar Crunch(1)

Chocolatey Salted Caramel(1)

Cranberry Almond(1)

Peanut Butter Dark Chocolate plus Protein(1)

 
Manufacturer Part Number

18506(1)

18505(1)

18084(1)

18508(1)

18509(1)

18554(1)

18533(1)

18510(1)

18083(1)

18082(1)

17850(1)

17828(1)

17824(1)

17851(1)

17852(1)

18081(1)

18080(1)

18039(1)

827961(1)

00074(1)

1022BL(1)

1022BA(1)

31803(1)

1022C(1)

1200KS(1)

1635KSP(1)

1217JP(1)

1202MS(1)

31799(1)

31569(1)

11827(1)

00076(1)

00075(1)

11827BX(1)

11834(1)

31567(1)

15528(1)

15504(1)

17256(1)

17250(1)

80730(1)

80729(1)

SN70777(1)

01492(1)

1000010470(1)

827622(1)

01641(1)

03487(1)

SN70350(1)

SN42068(1)

SN13898(1)

SN13897(1)

SN13896(1)

SN13899(1)

SN1512(1)

SN42067(1)

SN3355(1)

SN3353(1)

01246(1)

01283(1)

35945(1)

35845(1)

35745CT(1)

37947(1)

37949(1)

17221(1)

17211(1)

42799(1)

35745(1)

35645(1)

10371(1)

01474(1)

01468(1)

10372(1)

12522(1)

29190(1)

29186(1)

SN13158(1)

 
Country of Origin

US(76)

CA(2)

 
Capacity (Volume)

2.5oz(1)

9 oz(1)

 
Capacity (Weight)

1.4 oz(12)

1.2 oz(12)

1.3 oz(6)

1.6 oz(5)

1.23 oz(4)

1.5 oz(4)

0.84 oz(3)

1.34 oz(2)

35 g(2)

2.5 oz(2)

1.83 oz(2)

1.59 oz(2)

9 oz(2)

3.5 oz(2)

2 oz(2)

2.46 oz(1)

2.64 oz(1)

2.71 oz(1)

2.29 oz(1)

2.53 oz(1)

2.54 oz(1)

1.8 oz(1)

2.66 oz(1)

0.81 oz(1)

0.85 oz(1)

2.1 oz(1)

1.27 oz(1)

1.73 oz(1)

2.8 oz(1)

2.49 oz(1)

2.47 oz(1)

 
Food Type

Snack Bar(22)

Cereal Bar(14)

Oatmeal(11)

Breakfast Cereal(8)

Granola Bars(7)

Granola Bar(4)

Nutrition Bar(3)

Protein Bar(2)

Soup(2)

Lunch Kit(2)

Meal/Entree Kit(2)

Lunch(1)

 
 
 

© 2018-2019 Onestop, Inc., All Rights Reserved