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','out_of_stock') 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(20)

Office Snax(16)

Kellogg's(12)

Pop Secret(8)

Justin's(8)

Walkers(7)

Sunshine(7)

Paramount Farms(6)

Chex Mix(6)

Planters(6)

Keebler(6)

Dolcetto(4)

popchips(4)

Miss Vickie's(4)

Austin(4)

Annie's Homegrown(4)

Homefree(4)

Combos(4)

Pepperidge Farm(3)

Pop Weaver(3)

Dirty(3)

Wyler's Italian Ices(2)

Frito-Lay(2)

General Mills(2)

Sensible Portions(2)

Nutella(2)

Stauffer's(2)

Stacy's(2)

Grandma's(2)

Kar's(2)

Doritos(2)

Fritos(2)

Rold Gold(2)

Snyder's(2)

Cheetos(2)

KIND(2)

Shultz(1)

BIGS(1)

De Beukelaer(1)

Sqwincher(1)

Jif Bars(1)

Lay's(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Royal Dansk(1)

Ocean Spray(1)

Biscoff(1)

SunChips(1)

Ruffles(1)

Tostitos(1)

Pringles(1)

Fla-Vor-Ice(1)

Kettle Brand(1)

Knott's Berry Farm(1)

Utz(1)

 
Packing Type

Bag(94)

Pack(48)

Box(18)

Squeeze Pack(6)

Tub(6)

Packs(5)

Bar(5)

Tube(4)

Tube Package(4)

Canister(4)

Packet(3)

Single-Serve Tub(2)

Packets(2)

Tin Container(2)

Yes(1)

Carton(1)

Single-Serve Bag(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

Container(1)

 
Flavor

Original(20)

Chocolate Chip(7)

Peanut Butter(6)

Sea Salt(5)

Roasted & Salted(5)

Chocolate(4)

Dry Roasted Almonds(3)

Original Marshmallow(3)

Movie Theater Butter(3)

Cheese(3)

Homestyle(3)

Assorted(3)

Nacho Cheese(2)

Natural Almonds(2)

Dill Pickle Cashews(2)

Sriracha Cashews(2)

Jalapeno Cashews(2)

All Natural Almonds(2)

Cocoa Roast Almonds(2)

Hazelnut/Cocoa(2)

Shortbread(2)

Sourdough(2)

Cashews(2)

Traditional(2)

Salted(2)

Vanilla(2)

Butter(2)

White Cheddar(2)

Extra Butter(2)

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

Golden Oat(2)

Blueberry(2)

Cheddar(2)

Cheddar Cheese(2)

Toast & Peanut Butter(2)

Frosted Strawberry(2)

Sour Cream & Onion(2)

Cranberry(1)

Jalapeno(1)

Sea Salt & Vinegar(1)

Smokehouse BBQ(1)

Barbecue(1)

Cinnamon/Honey(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)

Regular(1)

Vanilla Cream(1)

Caramel(1)

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

Parmesan Garlic & Herb(1)

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

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

Wasabi Party Mix(1)

Cocoa & Vanilla(1)

Sesame Snax Mix(1)

Hazelnut(1)

Bacon(1)

Creamy Peanut Butter(1)

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

Salted Nuts(1)

Mixed Nuts(1)

Nut & Chocolate(1)

Tropical Fruit & Nut(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Aged White Cheddar(1)

Pineapple & Papaya(1)

Salt & Pepper(1)

Dry Roasted & Salted(1)

Shortbread Highlanders(1)

Shortbread Fingers(1)

Tiramisu(1)

Light Butter(1)

Ginger & Lemon(1)

Deluxe Nut Mix(1)

Pistachios(1)

Happy Heart Mix(1)

Berry Mix(1)

Danish Butter(1)

Original with M&Ms(1)

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

Cheddar Cheese Cracker(1)

Cocoa Roasted Almonds(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Salt & Pepper Cashews(1)

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

Apple Cinnamon(1)

Oreo(1)

Fig Newton(1)

Vanilla Creme(1)

Pepperoni Pizza Cracker(1)

Pizzeria Pretzel(1)

Salty Sweet Mix(1)

Cheddar Cheese Pretzel(1)

Raspberry(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

Traditional Mix(1)

Corn(1)

Chocolate Turtle(1)

Sweet 'N Salty Mix(1)

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

Snickerdoodle(1)

Chocolate; Chocolate Chip; Honey(1)

Berry Nut Blend(1)

Roasted & Salted Cashew Nuts(1)

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

Reduced Fat(1)

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

Zesty Ranch(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)

Brown Sugar Cinnamon(1)

Frosted Blueberry(1)

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

Original Salty Cracker(1)

Sea Salt and Pepper Cashews(1)

Maple Almond Butter w/Pretzels(1)

Classic Almond Butter w/Pretzels(1)

Vanilla Almond Butter(1)

Honey Peanut Butter(1)

Chocolate Almond/Hazelnut Butter(1)

Maple Almond Butter(1)

Honey Almond Butter(1)

Classic Almond Butter(1)

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

Double Chocolate Chip(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Mesquite BBQ(1)

 
Manufacturer Part Number

00073(2)

00019(1)

56628(1)

62737(1)

67652(1)

92268(1)

456268(1)

04738(1)

827558(1)

80314(1)

80401(1)

29516(1)

00039(1)

00080(1)

00082(1)

00083(1)

00084(1)

00087(1)

00089(1)

00091(1)

00092(1)

00093(1)

00095(1)

00096(1)

00097(1)

56627(1)

52547(1)

52546(1)

20871(1)

827548(1)

827553(1)

827695(1)

84637(1)

93646(1)

98067(1)

25719(1)

25726(1)

13256(1)

14672(1)

32430(1)

52347(1)

44355(1)

44366(1)

44375(1)

44441(1)

44443(1)

44446(1)

44451(1)

44458(1)

44463(1)

45095(1)

00098(1)

01020(1)

00679(1)

06834(1)

71100(1)

72200(1)

77700(1)

00026(1)

00027(1)

01670(1)

07210(1)

07708(1)

884624(1)

06833(1)

011037(1)

827562(1)

11017(1)

21030(1)

1011039(1)

827582(1)

159200201(1)

827575(1)

55003(1)

827515(1)

827533(1)

827540(1)

21812PK(1)

13539(1)

01021(1)

W-116(1)

01022(1)

01570(1)

105510(1)

105511(1)

105512(1)

375(1)

53005(1)

655(1)

656(1)

657(1)

W-176(1)

1051900(1)

W-536(1)

04474(1)

042322F2OA(1)

042722C35S(1)

070146A25M(1)

072142A25X(1)

072142WTV(1)

091842A25S(1)

601049(1)

00408(1)

05051(1)

827545(1)

827544(1)

827118(1)

27182(1)

07133(1)

07737(1)

15923(1)

37437(1)

30357(1)

30378(1)

12592(1)

16686(1)

24680(1)

24696(1)

28781(1)

03745(1)

28783(1)

33364(1)

33525(1)

33625(1)

33664(1)

33725(1)

33825(1)

34325(1)

34325CT(1)

34895(1)

04068(1)

03744(1)

54325(1)

59636(1)

00074(1)

32021(1)

SN08361(1)

SN08387(1)

SN16794(1)

SN28086(1)

SN35181(1)

SN35182(1)

SN37301(1)

SN43037(1)

42005(1)

02946BX(1)

42006(1)

42007(1)

42008(1)

00176(1)

00470(1)

00798(1)

02104(1)

02908(1)

02908BX(1)

02946(1)

53664(1)

57690(1)

58402(1)

21163(1)

10050(1)

10051(1)

01008(1)

10003(1)

10892(1)

12061(1)

122264(1)

12233(1)

12653(1)

13189(1)

21165(1)

00309(1)

21167(1)

21771(1)

26547(1)

31031(1)

31131(1)

31731(1)

31732(1)

40975(1)

51158(1)

58399(1)

00311(1)

00058(1)

57706(1)

94117(1)

84170(1)

84325(1)

84337(1)

86364(1)

88417(1)

93064(1)

93364(1)

93817(1)

93917(1)

94017(1)

94217(1)

00030(1)

1160588(1)

827565(1)

01305(1)

01866(1)

01873(1)

01948(1)

92100(1)

94816(1)

94816BX(1)

00028(1)

00029(1)

827612(1)

 
Country of Origin

US(186)

IN(9)

GB(7)

ID(5)

DE(2)

CA(1)

TH(1)

 
Capacity (Volume)

1.38 oz(4)

2 oz(2)

1.75 oz(1)

1.5 oz(1)

1 oz(1)

3 oz(1)

 
Capacity (Weight)

1.5 oz(19)

2 oz(15)

1 oz(9)

6.3 oz(7)

5 oz(7)

1.75 oz(7)

1.15 oz(6)

1.25 oz(6)

1.8 oz(5)

1.4 oz(5)

2.5 oz(5)

1.76 oz(5)

0.63 oz(4)

0.62 oz(4)

32 oz(4)

0.8 oz(4)

3 oz(4)

8 oz(3)

1.38 oz(3)

3 1/2 oz(3)

4.9 oz(3)

40 oz(3)

0.7 oz(3)

1.3 oz(3)

3.67 oz(2)

4 oz(2)

44 oz(2)

1.06 oz(2)

3.25 oz(2)

38 oz(2)

24 oz(2)

48 oz(2)

6.75 oz(2)

26 oz(2)

1.1 oz(2)

4.5 oz(2)

3.75 oz(2)

5.5 oz(2)

1.2 oz(2)

0.9 oz(1)

6 lb(1)

22 oz(1)

34 oz(1)

1.02 oz(1)

50 oz(1)

12 oz(1)

6.2 oz(1)

2.17 oz(1)

16 oz(1)

15 oz(1)

58 oz(1)

14 oz(1)

1.75 oz; 1.5 oz(1)

3.52 oz(1)

2.32 oz(1)

0.2 oz(1)

8-1.75 oz; 16-1.5 oz(1)

1.7 oz(1)

2.4 oz(1)

3.5 oz(1)

0.56 oz(1)

3.2 oz(1)

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

0.95 oz(1)

0.39 oz(1)

0.22 oz(1)

2.1 oz(1)

3.39 oz(1)

.78 oz(1)

0.74 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

2.875 oz(1)

1.5 oz; 1.13 oz(1)

5.35 oz(1)

 
Food Type

Cookies(36)

Trail Mix, Nuts & Seeds(30)

Crackers(29)

Chips(26)

Snack(17)

Nuts(14)

Popcorn(12)

Nutrition & Snack Bars(7)

Nut Butter(6)

Pretzel(5)

Pretzels(4)

Freezer Bar(3)

Pastry(3)

Dried Fruit(2)

Snack Bar(2)

Nut Butters(2)

Granola Bar(1)

Potato Chip(1)

Frozen Treats(1)

Fruit Snacks(1)

Candy(1)

Danish/Pastries(1)

Snacks(1)

Potato Chips(1)

Rice Krispy Treat(1)

Apple Straw(1)

Cookie(1)

Graham Crackers(1)

Sunflower Seeds(1)

 
 
 

© 2020-2021 Service Office Supplies, All Rights Reserved