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

Sunshine(7)

Keebler(6)

Planters(6)

Paramount Farms(6)

Walkers(6)

Chex Mix(5)

Dolcetto(4)

Austin(4)

Homefree(4)

popchips(4)

Miss Vickie's(4)

Pop Weaver(3)

Annie's Homegrown(2)

Stacy's(2)

Nutella(2)

Fritos(2)

Pepperidge Farm(2)

Cheetos(2)

Rold Gold(2)

Stauffer's(2)

Kar's(2)

Snyder's(2)

Sensible Portions(2)

Combos(2)

General Mills(2)

Wyler's Italian Ices(2)

Utz(1)

Pirate's Booty(1)

Sqwincher(1)

Royal Dansk(1)

De Beukelaer(1)

SkinnyPop Popcorn(1)

Doritos(1)

Fla-Vor-Ice(1)

Kettle Brand(1)

Knott's Berry Farm(1)

Sheila G’s Brownie Brittle(1)

Justin's(1)

Tostitos(1)

Frito-Lay(1)

Grandma's(1)

Ruffles(1)

Lay's(1)

Biscoff(1)

 
Packing Type

Bag(80)

Pack(43)

Box(15)

Packs(5)

Tub(5)

Tube(4)

Canister(3)

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

All Natural Almonds(2)

Natural Almonds(2)

Dry Roasted Almonds(2)

Dill Pickle Cashews(2)

Jalapeno Cashews(2)

Shortbread(2)

Vanilla(2)

Hazelnut/Cocoa(2)

Assorted(2)

Toast & Peanut Butter(2)

Cheese(2)

Original Marshmallow(2)

White Cheddar(2)

Butter(2)

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

Salted(2)

Sourdough(2)

Cashews(2)

Sriracha Cashews(2)

Cheddar Cheese(2)

Blueberry(2)

Golden Oat(2)

Extra Butter(2)

Cheddar(2)

Mixed Nuts(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)

Sour Cream & Onion(1)

Salted Nuts(1)

Tropical Fruit & Nut(1)

Nut & Chocolate(1)

Parmesan Garlic & Herb(1)

Barbecue(1)

Smokehouse BBQ(1)

Sea Salt & Vinegar(1)

Regular(1)

Vanilla Cream(1)

Caramel(1)

Barbeque(1)

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

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

Sesame Snax Mix(1)

Jalapeno(1)

Danish Butter(1)

Light Butter(1)

Tiramisu(1)

Salt & Pepper(1)

Shortbread Fingers(1)

Dry Roasted & Salted(1)

Ginger & Lemon(1)

Aged White Cheddar(1)

Berry Mix(1)

Pineapple & Papaya(1)

Wasabi Party Mix(1)

Hazelnut(1)

Happy Heart Mix(1)

Deluxe Nut Mix(1)

Pistachios(1)

Barbeque; Sea Salt(1)

Original with M&Ms(1)

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

Apple Cinnamon(1)

Oreo(1)

Original Fig(1)

Salt & Pepper Cashews(1)

Deluxe Mixed Nuts(1)

Cocoa Roasted Almonds(1)

Cocoa Roast Almonds(1)

Walnuts and Almonds(1)

Vanilla Crème(1)

Pepperoni Pizza Cracker(1)

Corn(1)

Chocolate Turtle(1)

Sweet 'N Salty Mix(1)

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

Traditional Mix(1)

Cheddar Mix(1)

Cheddar Cheese Cracker(1)

Raspberry(1)

Chocolate/Peanut Butter(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(1)

Brown Sugar Cinnamon(1)

Frosted Blueberry(1)

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

Frosted Strawberry(1)

Pepper Jack Cheese(1)

Crunchy(1)

Zesty Ranch(1)

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

Club & Cheddar Cheese(1)

Cocoa & Vanilla(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Traditional(1)

Sea Salt and Pepper Cashews(1)

Double Chocolate Chip(1)

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

Reduced Fat(1)

Original Salty Cracker(1)

Classic Almond Butter w/Pretzels(1)

Nacho Cheese(1)

 
Manufacturer Part Number

00073(2)

00080(1)

00082(1)

00084(1)

80401(1)

00083(1)

80314(1)

456268(1)

04738(1)

827558(1)

00087(1)

00091(1)

00097(1)

00098(1)

00679(1)

01020(1)

00096(1)

00095(1)

56628(1)

00092(1)

00093(1)

00089(1)

52547(1)

20871(1)

32430(1)

44355(1)

44366(1)

14672(1)

98067(1)

827553(1)

827695(1)

93646(1)

44375(1)

44441(1)

45095(1)

52347(1)

52546(1)

01021(1)

44463(1)

44458(1)

44443(1)

44446(1)

44451(1)

56627(1)

01022(1)

77700(1)

00026(1)

00027(1)

01670(1)

72200(1)

71100(1)

1051900(1)

13539(1)

21812PK(1)

07210(1)

07708(1)

1011039(1)

827582(1)

159200201(1)

827612(1)

11017(1)

011037(1)

884624(1)

06833(1)

06834(1)

05051(1)

00408(1)

53005(1)

655(1)

656(1)

657(1)

375(1)

105512(1)

01570(1)

105510(1)

105511(1)

W-116(1)

W-536(1)

072142WTV(1)

091842A25S(1)

601049(1)

072142A25X(1)

070146A25M(1)

04474(1)

042322F2OA(1)

042722C35S(1)

827548(1)

827545(1)

30378(1)

12592(1)

16686(1)

24680(1)

30357(1)

15923(1)

03745(1)

04068(1)

07737(1)

24696(1)

27182(1)

33664(1)

33725(1)

33825(1)

34325(1)

33625(1)

33525(1)

28781(1)

28783(1)

33364(1)

03744(1)

02946BX(1)

SN35181(1)

SN35182(1)

SN37301(1)

SN43037(1)

SN28086(1)

SN16794(1)

01224(1)

SN08361(1)

SN08387(1)

59636(1)

42007(1)

02908(1)

02908BX(1)

02946(1)

02104(1)

00798(1)

42008(1)

00176(1)

00470(1)

34325CT(1)

34895(1)

12233(1)

12653(1)

13189(1)

21163(1)

122264(1)

12061(1)

10050(1)

01008(1)

10892(1)

21165(1)

21167(1)

40975(1)

51158(1)

58399(1)

827544(1)

31732(1)

31131(1)

21771(1)

26547(1)

31031(1)

94816BX(1)

94816(1)

86364(1)

93064(1)

93364(1)

93817(1)

84325(1)

57706(1)

53664(1)

54325(1)

57690(1)

93917(1)

94017(1)

01873(1)

01948(1)

92100(1)

01866(1)

01305(1)

94117(1)

94217(1)

827565(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(14)

2 oz(11)

5 oz(8)

1 oz(7)

1.25 oz(6)

1.75 oz(6)

6.3 oz(5)

1.8 oz(5)

1.76 oz(5)

3.2 oz(5)

0.63 oz(4)

2.5 oz(4)

0.8 oz(4)

0.62 oz(4)

32 oz(4)

1.38 oz(3)

3 oz(3)

40 oz(3)

4.9 oz(3)

48 oz(2)

1.4 oz(2)

3.25 oz(2)

44 oz(2)

1.3 oz(2)

38 oz(2)

24 oz(2)

4 oz(2)

3.67 oz(2)

1.2 oz(2)

1.1 oz(2)

3.75 oz(2)

4.5 oz(2)

8 oz(2)

5.5 oz(2)

12 oz(1)

0.7 oz(1)

6.2 oz(1)

2.17 oz(1)

1.0 oz(1)

1.75 oz; 1.5 oz(1)

50 oz(1)

0.9 oz(1)

16 oz(1)

15 oz(1)

34 oz(1)

14 oz(1)

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

1.02 oz(1)

26 oz(1)

3.52 oz(1)

1.06 oz(1)

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

6.75 oz(1)

0.95 oz(1)

.39 oz(1)

2.1 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

22 oz(1)

0.2 oz(1)

2.4 oz(1)

2.32 oz(1)

0.22 oz(1)

1.5oz(1)

0.56 oz(1)

1.7 oz(1)

 
Food Type

Nuts(37)

Cookies(33)

Snack(21)

Crackers(21)

Chips(13)

Popcorn(12)

Pretzel(7)

Potato Chip(4)

Cookie(4)

Freezer Bar(3)

Pastry(3)

Cereal Bar(2)

Dried Fruit(2)

Nut Butter(2)

Trail Mix(2)

Breakfast Biscuits(2)

Snack Mix(1)

Veggie Straw(1)

Apple Straw(1)

Breakfast Biscuit(1)

Snacks(1)

Puffed Rice(1)

 
 
 

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