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 ('1023')) 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 '%Snacks' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Snacks' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Snacks' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Snacks"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Snacks"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Snacks"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Snacks"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Snacks' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Snacks',`category_4` ='Snacks') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Snacks,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Snacks', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Snacks

Refine Search

  GO
 
Brand

Emerald(20)

Nabisco(18)

Office Snax(15)

Pop Secret(8)

Kellogg's(7)

Sunshine(6)

Paramount Farms(6)

Keebler(6)

Planters(6)

Walkers(6)

Chex Mix(5)

Miss Vickie's(4)

Austin(4)

Justin's(4)

Dolcetto(4)

Pop Weaver(3)

popchips(3)

Homefree(3)

Annie's Homegrown(3)

Pepperidge Farm(2)

Nutella(2)

Stacy's(2)

Fritos(2)

Grandma's(2)

Rold Gold(2)

Snyder's(2)

Sensible Portions(2)

Kar's(2)

General Mills(2)

Combos(2)

Wyler's Italian Ices(2)

Stauffer's(2)

Utz(1)

SkinnyPop Popcorn(1)

Sqwincher(1)

De Beukelaer(1)

Pirate's Booty(1)

Cheetos(1)

Fla-Vor-Ice(1)

Kettle Brand(1)

Knott's Berry Farm(1)

Sheila G’s Brownie Brittle(1)

Tostitos(1)

Doritos(1)

Ocean Spray(1)

Biscoff(1)

Frito-Lay(1)

Ruffles(1)

Royal Dansk(1)

 
Packing Type

Bag(76)

Pack(42)

Box(17)

Packs(5)

Tub(5)

Tube(4)

Canister(3)

Packet(3)

Squeeze Pack(3)

Tin Container(2)

Single-Serve Tub(2)

Bar(2)

Tube Package(2)

Packets(2)

Container(1)

Jar(1)

Can(1)

Carton(1)

Single-Serve Bag(1)

 
Flavor

Original(19)

Peanut Butter(6)

Chocolate Chip(5)

Roasted & Salted(5)

Chocolate(4)

Sea Salt(3)

Movie Theater Butter(3)

Homestyle(3)

Hazelnut/Cocoa(2)

Extra Butter(2)

Natural Almonds(2)

Butter(2)

Jalapeno Cashews(2)

Kiwi Watermelon; Lemon; Orange Crème; Raspberry(2)

Salted(2)

Cashews(2)

Shortbread(2)

Sourdough(2)

Dry Roasted Almonds(2)

Sriracha Cashews(2)

All Natural Almonds(2)

Dill Pickle Cashews(2)

White Cheddar(2)

Toast & Peanut Butter(2)

Cheddar Cheese(2)

Assorted(2)

Original Marshmallow(2)

Blueberry(2)

Golden Oat(2)

Smokehouse BBQ(1)

Sea Salt & Vinegar(1)

Jalapeno(1)

Sesame Snax Mix(1)

Nacho Cheese(1)

Regular(1)

Wasabi Party Mix(1)

Cranberry(1)

Caramel(1)

Pineapple & Papaya(1)

Parmesan Garlic & Herb(1)

Lays Classic;Doritos Nacho Cheese;Cheetos Original;Fritos Original; Lays BBQ;Doritos Cool Ranch(1)

Vanilla Cream(1)

6 Packs Ritz Bits Peanut Butter; 6 Packs Ritz Bits Cheese; 7 Packs Nutter Butter Bites; 7 Packs Mini Nilla Wafers; 7 Packs Mini Oreo; 7 Packs Chips Ahoy(1)

Cinnamon/Honey(1)

Danish Butter(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Hazelnut(1)

Aged White Cheddar(1)

Tropical Fruit & Nut(1)

Nut & Chocolate(1)

Cheese(1)

Salted Peanuts; Honey Roasted Peanuts; Salted Cashews(1)

Salted Nuts(1)

Mixed Nuts(1)

Salt & Pepper(1)

Dry Roasted & Salted(1)

Ginger & Lemon(1)

Deluxe Nut Mix(1)

Pistachios(1)

Fruit & Nut Mix(1)

Light Butter(1)

Crunchy(1)

Shortbread Fingers(1)

Tiramisu(1)

Vanilla(1)

Berry Mix(1)

Reduced Fat(1)

Oreo(1)

Original Fig(1)

Vanilla Crème(1)

Pepperoni Pizza Cracker(1)

Apple Cinnamon(1)

Salt & Vinegar; Salt & Pepper; Backyard Barbeque; Jalapeno(1)

Dark Chocolate Cocoa Roast Almonds(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Salt & Pepper Cashews(1)

Cheddar Cheese Cracker(1)

Raspberry(1)

Sweet 'N Salty Mix(1)

Sweet 'N Spicy; Mango Pineapple; Yogurt Apple Nut(1)

Snickerdoodle(1)

Cheddar(1)

Chocolate Turtle(1)

Corn(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

Traditional Mix(1)

Cocoa Roasted Almonds(1)

Salty Sweet Mix(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

Original with M&Ms(1)

Cocoa & Vanilla(1)

Mini Fudge Stripes(1)

Frosted Blueberry(1)

Choco Cremes, Vanilla Cremes, Lemon Ohs!, Cheese Crackers w/Cheese, Cheese Crackers w/Peanut Butter, Toasty Crackers w/Peanut Butter(1)

Pepper Jack Cheese(1)

Frosted Strawberry(1)

Brown Sugar Cinnamon(1)

Original Salty Cracker(1)

Classic Almond Butter w/Pretzels(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Traditional(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

Double Chocolate Chip(1)

Berry Punch; Grape; Lemon-Lime; Orange; Strawberry; Tropical Punch(1)

Honey Peanut Butter(1)

Chocolate Almond/Hazelnut Butter(1)

Classic Almond Butter(1)

Chocolate Chip; Peanut Butter; Vanilla Crème; Oatmeal Raisin;Chocolate Brownie(1)

 
Manufacturer Part Number

00073(2)

29516(1)

00080(1)

00083(1)

80401(1)

00082(1)

80314(1)

456268(1)

04738(1)

827558(1)

00084(1)

00089(1)

00096(1)

00097(1)

00098(1)

00679(1)

00095(1)

00093(1)

56628(1)

00091(1)

00092(1)

00087(1)

52547(1)

13256(1)

20871(1)

32430(1)

44355(1)

98067(1)

827695(1)

827545(1)

827548(1)

827553(1)

44366(1)

44375(1)

45095(1)

52347(1)

52546(1)

01020(1)

44463(1)

44451(1)

44441(1)

44443(1)

44446(1)

56627(1)

01021(1)

72200(1)

00026(1)

00027(1)

01670(1)

71100(1)

21812PK(1)

05051(1)

1051900(1)

13539(1)

07210(1)

07708(1)

1011039(1)

827582(1)

159200201(1)

827612(1)

11017(1)

011037(1)

884624(1)

06833(1)

06834(1)

00408(1)

601049(1)

375(1)

53005(1)

655(1)

656(1)

105512(1)

105511(1)

01022(1)

01570(1)

105510(1)

657(1)

W-116(1)

072142A25X(1)

072142WTV(1)

091842A25S(1)

070146A25M(1)

042722C35S(1)

W-536(1)

04474(1)

042322F2OA(1)

827544(1)

51158(1)

30357(1)

30378(1)

12592(1)

16686(1)

15923(1)

07737(1)

03744(1)

03745(1)

04068(1)

24680(1)

24696(1)

33625(1)

33664(1)

33725(1)

33825(1)

33525(1)

33364(1)

27182(1)

28781(1)

28783(1)

02946BX(1)

02946(1)

SN28086(1)

SN35181(1)

SN35182(1)

SN37301(1)

SN16794(1)

SN08387(1)

32021(1)

01224(1)

SN08361(1)

SN43037(1)

59636(1)

02104(1)

02908(1)

02908BX(1)

00798(1)

00470(1)

42007(1)

42008(1)

00176(1)

34325(1)

34325CT(1)

10892(1)

12061(1)

122264(1)

12233(1)

01008(1)

10050(1)

00028(1)

00058(1)

00309(1)

12653(1)

13189(1)

31031(1)

31131(1)

31732(1)

40975(1)

26547(1)

21771(1)

21163(1)

21165(1)

21167(1)

94816BX(1)

94816(1)

84325(1)

86364(1)

93064(1)

93364(1)

57706(1)

57690(1)

34895(1)

53664(1)

54325(1)

93817(1)

93917(1)

01873(1)

01948(1)

92100(1)

01305(1)

827565(1)

94017(1)

94117(1)

94217(1)

00019(1)

 
Country of Origin

US(151)

IN(9)

GB(6)

ID(5)

CA(1)

DE(1)

TH(1)

 
Capacity (Volume)

1.375 oz(4)

2 oz(2)

3 oz(1)

1 oz(1)

1.5 oz(1)

1.75 oz(1)

 
Capacity (Weight)

1.5 oz(13)

2 oz(11)

5 oz(8)

1 oz(8)

1.75 oz(6)

1.25 oz(6)

3.2 oz(5)

1.76 oz(5)

6.3 oz(5)

1.8 oz(5)

2.5 oz(5)

32 oz(4)

0.62 oz(4)

0.63 oz(4)

3 oz(3)

0.8 oz(3)

4.9 oz(3)

1.38 oz(3)

1.15 oz(3)

40 oz(3)

3.67 oz(2)

6.75 oz(2)

44 oz(2)

38 oz(2)

4 oz(2)

24 oz(2)

48 oz(2)

1.4 oz(2)

1.3 oz(2)

3.75 oz(2)

1.2 oz(2)

8 oz(2)

4.5 oz(2)

5.5 oz(2)

6.2 oz(1)

0.9 oz(1)

34 oz(1)

0.7 oz(1)

50 oz(1)

15 oz(1)

1.02 oz(1)

1.0 oz(1)

16 oz(1)

1.75 oz; 1.5 oz(1)

14 oz(1)

12 oz(1)

2.17 oz(1)

1.5 oz; 2 oz(1)

1.1 oz(1)

0.95 oz(1)

0.2 oz(1)

2 lb. Net Weight; 10/1.1 oz, 10/0.95 oz, 10/1.1 oz(1)

0.56 oz(1)

2.4 oz(1)

8-1 3/4 oz; 16-1 1/2 oz(1)

.39 oz(1)

2.1 oz(1)

0.22 oz(1)

2.32 oz(1)

22 oz(1)

1.5oz(1)

1.7 oz(1)

3.52 oz(1)

3.71 oz(1)

26 oz(1)

 
Food Type

Nuts(37)

Cookies(34)

Snack(20)

Crackers(19)

Chips(12)

Popcorn(12)

Pretzel(7)

Nut Butter(5)

Cookie(4)

Dried Fruit(3)

Potato Chip(3)

Freezer Bar(3)

Pastry(3)

Breakfast Biscuits(2)

Cereal Bar(2)

Trail Mix(2)

Snack Mix(1)

Puffed Rice(1)

Veggie Straw(1)

Apple Straw(1)

Snacks(1)

Breakfast Biscuit(1)

 
 
 

© 2018-2019 BonTay Business Products, Inc., All Rights Reserved