0

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

Nabisco(24)

Office Snax(15)

Kellogg's(11)

Justin's(8)

Pop Secret(8)

Sunshine(7)

Walkers(7)

Planters(6)

Keebler(6)

Paramount Farms(6)

Chex Mix(6)

Annie's Homegrown(4)

Dolcetto(4)

popchips(4)

Austin(4)

Miss Vickie's(4)

Combos(4)

Homefree(4)

Pepperidge Farm(3)

Sahale Snacks(3)

Pop Weaver(3)

Dirty(3)

Nutella(2)

Wyler's Italian Ices(2)

Kar's(2)

Snyder's(2)

Stauffer's(2)

Stacy's(2)

General Mills(2)

Sensible Portions(2)

Rold Gold(2)

Fritos(2)

Lay's(2)

Grandma's(2)

KIND(2)

Cheetos(2)

Sheila G’s Brownie Brittle(1)

Jif Bars(1)

Pringles(1)

Fla-Vor-Ice(1)

Utz(1)

BIGS(1)

Shultz(1)

Sqwincher(1)

Tostitos(1)

SkinnyPop Popcorn(1)

Ocean Spray(1)

Biscoff(1)

SunChips(1)

Ruffles(1)

Kettle Brand(1)

Doritos(1)

Frito-Lay(1)

Pirate's Booty(1)

Royal Dansk(1)

Knott's Berry Farm(1)

De Beukelaer(1)

 
Packing Type

Bag(94)

Pack(52)

Box(20)

Squeeze Pack(6)

Tub(5)

Packs(5)

Canister(4)

Tube(4)

Tube Package(4)

Bar(3)

Packet(3)

Packets(2)

Tin Container(2)

Single-Serve Tub(2)

Jar(1)

Container(1)

Can(1)

Resealable Bag in Box(1)

Single-Serve Bag(1)

Carton(1)

Variety Pack(1)

 
Flavor

Original(20)

Chocolate Chip(9)

Chocolate(6)

Peanut Butter(6)

Roasted & Salted(5)

Sea Salt(5)

Dry Roasted Almonds(3)

Original Marshmallow(3)

Movie Theater Butter(3)

Homestyle(3)

Assorted(2)

Jalapeno Cashews(2)

Dill Pickle Cashews(2)

Sriracha Cashews(2)

Natural Almonds(2)

Butter(2)

All Natural Almonds(2)

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

Cashews(2)

Traditional(2)

Vanilla(2)

Salted(2)

Shortbread(2)

Hazelnut/Cocoa(2)

Salt & Pepper(2)

Sourdough(2)

Cheddar(2)

Extra Butter(2)

Blueberry(2)

Sour Cream & Onion(2)

Toast & Peanut Butter(2)

Golden Oat(2)

Cheese(2)

Cheddar Cheese(2)

White Cheddar(2)

Sesame Snax Mix(1)

Sea Salt & Vinegar(1)

Vanilla Cream(1)

Nacho Cheese(1)

Regular(1)

Cinnamon/Honey(1)

Smokehouse BBQ(1)

Barbecue(1)

Wasabi Party Mix(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)

Crunchy(1)

Pineapple & Papaya(1)

Jalapeno(1)

Jalapeno; Salt & Vinegar; Original; Applewood BBQ; Salt & Pepper(1)

Harvest Cheddar; Original; French Onion; Garden Salsa(1)

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

Caramel(1)

Parmesan Garlic & Herb(1)

Cranberry(1)

Shortbread Fingers(1)

Mixed Nuts(1)

Salted Nuts(1)

Nut & Chocolate(1)

Tropical Fruit & Nut(1)

Barbeque(1)

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

Creamy Peanut Butter(1)

Bacon(1)

Mesquite BBQ(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Ginger & Lemon(1)

Light Butter(1)

Deluxe Nut Mix(1)

Pistachios(1)

Fruit & Nut Mix(1)

Danish Butter(1)

Tiramisu(1)

Aged White Cheddar(1)

Hazelnut(1)

Dry Roasted & Salted(1)

Shortbread Highlanders(1)

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

Berry Mix(1)

Original with M&Ms(1)

Apple Cinnamon(1)

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

Oreo(1)

Chunky Chocolate Chip(1)

Vanilla Crème(1)

Original Fig(1)

Salt & Pepper Cashews(1)

Deluxe Mixed Nuts(1)

Cocoa Roasted Almonds(1)

Berry Nut Blend(1)

Cocoa Roast Almonds(1)

Dark Chocolate Cocoa Roast Almonds(1)

Walnuts and Almonds(1)

Pepperoni Pizza Cracker(1)

Cheddar Cheese Cracker(1)

Sweet 'N Salty Mix(1)

Chocolate Turtle(1)

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

Snickerdoodle(1)

Chocolate; Chocolate Chip; Honey(1)

Corn(1)

Traditional Mix(1)

Cheddar Cheese Pretzel(1)

Pizzeria Pretzel(1)

Raspberry(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(1)

Mini Fudge Stripes(1)

Frosted Blueberry(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

Cocoa & Vanilla(1)

Brown Sugar Cinnamon(1)

Frosted Strawberry(1)

Zesty Ranch(1)

Cherry Cashew/Dark Chocolate; Dark Chocolate/Peanut Butter(1)

Original; Sour Cream & Onion; Cheddar Cheese(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)

Reduced Fat(1)

Original Salty Cracker(1)

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

Classic Almond Butter(1)

Double Chocolate Chip(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Sea Salt and Pepper Cashews(1)

Honey Almond Butter(1)

Maple Almond Butter(1)

Classic Almond Butter w/Pretzels(1)

Maple Almond Butter w/Pretzels(1)

Vanilla Almond Butter(1)

Honey Peanut Butter(1)

Chocolate Almond/Hazelnut Butter(1)

Almond & Sea Salt; Dark Chocolate Nuts; Sea Salt Caramel(1)

 
Manufacturer Part Number

00073(2)

80401(1)

80314(1)

29516(1)

00080(1)

00082(1)

827558(1)

456268(1)

56628(1)

56627(1)

67652(1)

6775505(1)

00083(1)

04738(1)

00084(1)

00097(1)

00096(1)

00098(1)

00679(1)

01020(1)

00095(1)

00093(1)

00087(1)

00089(1)

00091(1)

00092(1)

52547(1)

52347(1)

25719(1)

98067(1)

25726(1)

13256(1)

14672(1)

93646(1)

84637(1)

827545(1)

827544(1)

827548(1)

827553(1)

827695(1)

20871(1)

32430(1)

44458(1)

44451(1)

44463(1)

45095(1)

01021(1)

44446(1)

44443(1)

44355(1)

44366(1)

44375(1)

44441(1)

52546(1)

01570(1)

06833(1)

884624(1)

06834(1)

011037(1)

11017(1)

07708(1)

07210(1)

77700(1)

72200(1)

00026(1)

00027(1)

01670(1)

21030(1)

900327(1)

827515(1)

55003(1)

827533(1)

827540(1)

827612(1)

827575(1)

159200201(1)

900328(1)

900330(1)

1011039(1)

827582(1)

71100(1)

21812PK(1)

657(1)

656(1)

W-116(1)

W-176(1)

W-536(1)

655(1)

53005(1)

105510(1)

827118(1)

105511(1)

105512(1)

375(1)

04474(1)

042322F2OA(1)

05051(1)

00408(1)

1051900(1)

13539(1)

827562(1)

601049(1)

091842A25S(1)

042722C35S(1)

070146A25M(1)

072142A25X(1)

072142WTV(1)

01022(1)

58399(1)

30357(1)

37437(1)

30378(1)

12592(1)

16686(1)

15923(1)

07737(1)

05085(1)

05061(1)

05343(1)

05344(1)

07133(1)

24680(1)

24696(1)

33725(1)

33664(1)

33825(1)

34325(1)

34325CT(1)

33625(1)

33525(1)

27182(1)

28781(1)

28783(1)

33364(1)

04068(1)

03745(1)

SN35182(1)

SN35181(1)

SN37301(1)

SN43037(1)

59636(1)

SN28086(1)

SN16794(1)

32021(1)

00074(1)

01224(1)

SN08361(1)

SN08387(1)

42005(1)

42006(1)

02908BX(1)

02908(1)

02946(1)

02946BX(1)

03744(1)

02104(1)

00798(1)

42007(1)

42008(1)

00176(1)

00470(1)

34895(1)

53664(1)

10892(1)

10003(1)

12061(1)

122264(1)

12233(1)

01008(1)

10051(1)

00058(1)

00030(1)

00309(1)

00311(1)

10050(1)

12653(1)

13189(1)

31732(1)

31131(1)

40975(1)

51158(1)

00019(1)

31031(1)

26547(1)

21163(1)

21165(1)

21167(1)

21771(1)

00029(1)

00028(1)

88417(1)

86364(1)

93064(1)

93364(1)

93817(1)

84337(1)

84325(1)

57690(1)

54325(1)

57706(1)

80895(1)

84170(1)

93917(1)

94017(1)

01948(1)

01873(1)

92100(1)

94816(1)

94816BX(1)

01866(1)

01305(1)

94117(1)

94217(1)

1160588(1)

827565(1)

58402(1)

 
Country of Origin

US(193)

IN(9)

GB(7)

ID(5)

CA(1)

DE(1)

TH(1)

 
Capacity (Volume)

1.375 oz(4)

2 oz(2)

1.75 oz(2)

3 oz(1)

1 oz(1)

1.375oz(1)

1.5 oz(1)

 
Capacity (Weight)

1.5 oz(18)

2 oz(15)

5 oz(9)

1 oz(8)

6.3 oz(7)

1.75 oz(6)

1.25 oz(6)

1.15 oz(6)

2.5 oz(5)

3.2 oz(5)

1.8 oz(5)

1.76 oz(5)

1.4 oz(5)

0.63 oz(4)

0.62 oz(4)

32 oz(4)

0.8 oz(4)

3 oz(4)

1 1/2 oz(3)

4.9 oz(3)

1.3 oz(3)

1.38 oz(3)

0.7 oz(3)

40 oz(3)

8 oz(3)

1.06 oz(2)

6.75 oz(2)

3.25 oz(2)

4 oz(2)

38 oz(2)

24 oz(2)

44 oz(2)

48 oz(2)

3.67 oz(2)

1.2 oz(2)

3.75 oz(2)

5.5 oz(2)

1.1 oz(2)

4.5 oz(2)

6 lb(1)

12 oz(1)

1.02 oz(1)

2.17 oz(1)

6.2 oz(1)

1.7 oz(1)

34 oz(1)

5.35 oz(1)

1.0 oz(1)

14 oz(1)

16 oz(1)

1.75 oz; 1.5 oz(1)

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

15 oz(1)

0.9 oz(1)

58 oz(1)

2.4 oz(1)

50 oz(1)

22 oz(1)

.78 oz(1)

0.56 oz(1)

0.74 oz(1)

0.81 oz(1)

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

3.52 oz(1)

.39 oz(1)

2.1 oz(1)

0.95 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

4.15 oz(1)

3.9 oz(1)

0.2 oz(1)

2.32 oz(1)

0.22 oz(1)

1.5oz(1)

4/5 oz(1)

1.375 oz(1)

26 oz(1)

 
Food Type

Nuts(44)

Cookies(40)

Snack(25)

Crackers(23)

Chips(18)

Popcorn(12)

Nut Butter(8)

Pretzel(8)

Cookie(7)

Potato Chip(4)

Dried Fruit(3)

Pastry(3)

Freezer Bar(3)

Cereal Bar(2)

Trail Mix(2)

Snack Bar(2)

Breakfast Biscuits(2)

Veggie Straw(1)

Granola Bar(1)

Sunflower Seeds(1)

Snack Mix(1)

Graham Crackers(1)

Puffed Rice(1)

Rice Krispy Treat(1)

Snacks(1)

Apple Straw(1)

Breakfast Biscuit(1)

Potato Chips(1)