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

Nabisco(22)

Office Snax(16)

Kellogg's(11)

Pop Secret(8)

Justin's(8)

Walkers(7)

Sunshine(7)

Planters(6)

Chex Mix(6)

Keebler(6)

Paramount Farms(6)

Dolcetto(4)

popchips(4)

Annie's Homegrown(4)

Austin(4)

Miss Vickie's(4)

Homefree(4)

Combos(4)

Pop Weaver(3)

Pepperidge Farm(3)

Dirty(3)

Stauffer's(2)

Stacy's(2)

Kar's(2)

General Mills(2)

Sensible Portions(2)

Frito-Lay(2)

Wyler's Italian Ices(2)

Nutella(2)

Snyder's(2)

Cheetos(2)

Grandma's(2)

Rold Gold(2)

Fritos(2)

KIND(2)

De Beukelaer(1)

BIGS(1)

Utz(1)

Shultz(1)

SkinnyPop Popcorn(1)

Sqwincher(1)

Jif Bars(1)

Ocean Spray(1)

Tostitos(1)

Doritos(1)

Pringles(1)

Fla-Vor-Ice(1)

Kellogg's®(1)

Lay's(1)

Ruffles(1)

Royal Dansk(1)

Knott's Berry Farm(1)

Kettle Brand(1)

Biscoff(1)

SunChips(1)

Pirate's Booty(1)

 
Packing Type

Bag(92)

Pack(49)

Box(19)

Tub(6)

Squeeze Pack(6)

Packs(5)

Bar(5)

Tube(4)

Canister(4)

Tube Package(4)

Packet(3)

Packets(2)

Tin Container(2)

Single-Serve Tub(2)

Yes(2)

Jar(1)

Container(1)

Can(1)

Resealable Bag in Box(1)

Single-Serve Bag(1)

Carton(1)

 
Flavor

Original(20)

Chocolate Chip(7)

Peanut Butter(6)

Chocolate(5)

Roasted & Salted(5)

Sea Salt(5)

Dry Roasted Almonds(3)

Movie Theater Butter(3)

Homestyle(3)

Original Marshmallow(3)

Assorted(3)

Natural Almonds(2)

Dill Pickle Cashews(2)

Salted(2)

Butter(2)

White Cheddar(2)

Vanilla(2)

Jalapeno Cashews(2)

Traditional(2)

Hazelnut/Cocoa(2)

Shortbread(2)

Cocoa Roast Almonds(2)

Cashews(2)

Sriracha Cashews(2)

All Natural Almonds(2)

Sourdough(2)

Extra Butter(2)

Sour Cream & Onion(2)

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

Cheddar Cheese(2)

Toast & Peanut Butter(2)

Golden Oat(2)

Blueberry(2)

Cheese(2)

Cheddar(2)

Frosted Strawberry(2)

Cranberry(1)

Wasabi Party Mix(1)

Jalapeno(1)

Regular(1)

Barbecue(1)

Smokehouse BBQ(1)

Cinnamon/Honey(1)

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

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

BBQ; Cheddar & Sour Cream; Classic; Crunchy; Sour Cream & Onion(1)

Sea Salt & Vinegar(1)

Crunchy(1)

Nacho Cheese(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)

Parmesan Garlic & Herb(1)

Caramel(1)

Vanilla Cream(1)

Danish Butter(1)

Barbeque(1)

Tropical Fruit & Nut(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Hazelnut(1)

Nut & Chocolate(1)

Mixed Nuts(1)

Bacon(1)

Mesquite BBQ(1)

Creamy Peanut Butter(1)

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

Salted Nuts(1)

Aged White Cheddar(1)

Salt & Pepper(1)

Pistachios(1)

Deluxe Nut Mix(1)

Happy Heart Mix(1)

Berry Mix(1)

Pineapple & Papaya(1)

Ginger & Lemon(1)

Light Butter(1)

Shortbread Highlanders(1)

Dry Roasted & Salted(1)

Shortbread Fingers(1)

Tiramisu(1)

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

Sesame Snax Mix(1)

Original with M&Ms(1)

Chunky Chocolate Chip(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)

Cocoa Roasted Almonds(1)

Berry Nut Blend(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Salt & Pepper Cashews(1)

Cheddar Cheese Cracker(1)

Pizzeria Pretzel(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)

Raspberry(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(1)

Cheese & Peanut Butter(1)

Mini Fudge Stripes(1)

Club & Cheddar Cheese(1)

Cocoa & Vanilla(1)

Reduced Fat(1)

Frosted Blueberry(1)

Brown Sugar Cinnamon(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)

Original Salty Cracker(1)

Maple Almond Butter w/Pretzels(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)

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)

80314(1)

827558(1)

80401(1)

29516(1)

00039(1)

04738(1)

92268(1)

56627(1)

52547(1)

56628(1)

67652(1)

00080(1)

456268(1)

00082(1)

00095(1)

00093(1)

00096(1)

00097(1)

00098(1)

00092(1)

00091(1)

00083(1)

00084(1)

00087(1)

00089(1)

52546(1)

52347(1)

98067(1)

93646(1)

25719(1)

25726(1)

13256(1)

84637(1)

827695(1)

827544(1)

827545(1)

827548(1)

827553(1)

14672(1)

20871(1)

44451(1)

44446(1)

44458(1)

44463(1)

45095(1)

44443(1)

44441(1)

32430(1)

44355(1)

44366(1)

44375(1)

00679(1)

01021(1)

07210(1)

01670(1)

07708(1)

884624(1)

06833(1)

00027(1)

00026(1)

21812PK(1)

827562(1)

71100(1)

72200(1)

77700(1)

06834(1)

011037(1)

827515(1)

55003(1)

827533(1)

827540(1)

827612(1)

827575(1)

159200201(1)

11017(1)

21030(1)

1011039(1)

827582(1)

13539(1)

1051900(1)

53005(1)

375(1)

655(1)

656(1)

657(1)

105512(1)

105511(1)

827118(1)

01022(1)

01570(1)

105510(1)

W-116(1)

W-176(1)

091842A25S(1)

072142WTV(1)

601049(1)

00408(1)

05051(1)

072142A25X(1)

070146A25M(1)

W-536(1)

04474(1)

042322F2OA(1)

042722C35S(1)

01020(1)

58402(1)

12592(1)

30378(1)

16686(1)

24680(1)

24696(1)

30357(1)

37437(1)

05085(1)

05061(1)

07133(1)

07737(1)

15923(1)

27182(1)

28781(1)

34325(1)

33825(1)

34325CT(1)

34895(1)

53664(1)

33725(1)

33664(1)

28783(1)

33364(1)

33525(1)

33625(1)

04068(1)

03745(1)

SN35182(1)

SN35181(1)

SN37301(1)

SN43037(1)

59636(1)

SN28086(1)

SN16794(1)

00074(1)

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

54325(1)

57690(1)

12061(1)

10892(1)

122264(1)

12233(1)

12653(1)

10003(1)

01008(1)

00309(1)

00311(1)

10050(1)

10051(1)

13189(1)

21163(1)

31732(1)

31731(1)

40975(1)

51158(1)

58399(1)

31131(1)

31031(1)

21165(1)

21167(1)

21771(1)

26547(1)

00058(1)

00030(1)

93364(1)

93064(1)

93817(1)

93917(1)

94017(1)

88417(1)

86364(1)

57706(1)

84170(1)

84325(1)

84337(1)

94117(1)

94217(1)

94816(1)

92100(1)

94816BX(1)

00028(1)

00029(1)

01948(1)

01873(1)

1160588(1)

827565(1)

01305(1)

01866(1)

00019(1)

 
Country of Origin

US(187)

IN(9)

GB(7)

ID(5)

DE(2)

CA(1)

TH(1)

 
Capacity (Volume)

1.375 oz(4)

1.75 oz(2)

2 oz(2)

3 oz(1)

1 oz(1)

1.5 oz(1)

 
Capacity (Weight)

1.5 oz(19)

2 oz(15)

1 oz(8)

5 oz(7)

6.3 oz(7)

1.25 oz(6)

1.75 oz(6)

1.15 oz(6)

1.76 oz(5)

1.8 oz(5)

1.4 oz(5)

3 oz(5)

3.2 oz(5)

2.5 oz(5)

0.62 oz(4)

0.63 oz(4)

0.8 oz(4)

32 oz(4)

0.7 oz(3)

1.3 oz(3)

8 oz(3)

4.9 oz(3)

1.38 oz(3)

40 oz(3)

1.06 oz(2)

6.75 oz(2)

44 oz(2)

48 oz(2)

24 oz(2)

26 oz(2)

38 oz(2)

4 oz(2)

3.25 oz(2)

3.67 oz(2)

1.2 oz(2)

5.5 oz(2)

1.1 oz(2)

4.5 oz(2)

3.75 oz(2)

34 oz(1)

1.02 oz(1)

6.2 oz(1)

1.0 oz(1)

12 oz(1)

2.17 oz(1)

58 oz(1)

0.9 oz(1)

6 lb(1)

5.35 oz(1)

50 oz(1)

1.75 oz; 1.5 oz(1)

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

15 oz(1)

16 oz(1)

14 oz(1)

22 oz(1)

.78 oz(1)

0.74 oz(1)

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

0.95 oz(1)

3.39 oz(1)

.39 oz(1)

0.2 oz(1)

3.52 oz(1)

0.56 oz(1)

3.71 oz(1)

3.9 oz(1)

2.4 oz(1)

2.1 oz(1)

4.15 oz(1)

2.32 oz(1)

1.5 oz; 2 oz(1)

0.22 oz(1)

1.7 oz(1)

 
Food Type

Cookies(44)

Nuts(40)

Snack(25)

Crackers(23)

Chips(18)

Popcorn(12)

Nut Butter(8)

Pretzel(4)

Pretzels(4)

Potato Chips(4)

Pastry(4)

Breakfast Biscuits(3)

Dried Fruit(3)

Freezer Bar(3)

Cereal Bar(2)

Trail Mix(2)

Snack Bar(2)

Potato Chip(1)

Snack Mix(1)

Sunflower Seeds(1)

Granola Bar(1)

Puffed Rice(1)

Candy(1)

Apple Straw(1)

Veggie Straw(1)

Rice Krispy Treat(1)

Snacks(1)

Graham Crackers(1)