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

Office Snax(16)

Nabisco(14)

Kellogg's(12)

Pop Secret(8)

Justin's(8)

Ocean Spray(7)

Keebler(6)

Sunshine(6)

Paramount Farms(6)

Walkers(6)

Planters(6)

Annie's Homegrown(5)

Lay's(5)

popchips(4)

Dolcetto(4)

Austin(4)

Miss Vickie's(4)

Chex Mix(4)

Homefree(4)

Combos(4)

Pop Weaver(3)

Dirty(3)

Pepperidge Farm(3)

Sensible Portions(2)

Stauffer's(2)

Wyler's Italian Ices(2)

Kar's(2)

General Mills(2)

Nutella(2)

Cheetos(2)

Snyder's(2)

Fritos(2)

Rold Gold(2)

BIGS(2)

Grandma's(2)

Stacy's(2)

Pringles(1)

Utz(1)

De Beukelaer(1)

Shultz(1)

Sqwincher(1)

Jif Bars(1)

Knott's Berry Farm(1)

Ruffles(1)

Doritos(1)

Fla-Vor-Ice(1)

Tostitos(1)

Frito-Lay(1)

SunChips(1)

Pirate's Booty(1)

Royal Dansk(1)

Kettle Brand(1)

Biscoff(1)

SkinnyPop Popcorn(1)

 
Packing Type

Bag(101)

Pack(44)

Box(19)

Tub(6)

Squeeze Pack(6)

Packs(5)

Tube Package(5)

Canister(4)

Tube(4)

Bar(3)

Packet(3)

Single-Serve Tub(2)

Tin Container(2)

Packets(2)

Can(1)

Container(1)

Resealable Bag in Box(1)

Jar(1)

Cup(1)

Variety Pack(1)

Carton(1)

Single-Serve Bag(1)

 
Flavor

Original(21)

Chocolate Chip(7)

Chocolate(5)

Sea Salt(5)

Roasted & Salted(5)

Peanut Butter(3)

Assorted(3)

Dry Roasted Almonds(3)

Movie Theater Butter(3)

Original Marshmallow(3)

Homestyle(3)

Jalapeno Cashews(2)

Extra Butter(2)

Dill Pickle Cashews(2)

Natural Almonds(2)

All Natural Almonds(2)

Vanilla(2)

Salted(2)

Sourdough(2)

Cranberry Almond(2)

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

Cashews(2)

Hazelnut/Cocoa(2)

Cranberry(2)

Sriracha Cashews(2)

Butter(2)

Toast & Peanut Butter(2)

Sour Cream & Onion(2)

White Cheddar(2)

Cheddar Cheese(2)

Cheddar(2)

Cheese(2)

Cranberry Chocolate(1)

Nacho Cheese(1)

Barbecue(1)

Smokehouse BBQ(1)

Cinnamon/Honey(1)

Sea Salt & Vinegar(1)

Yogurt Covered Cranberries(1)

Cranberry Granola(1)

Jalapeno(1)

Caramel(1)

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

Jalapeno Cheddar(1)

Parmesan Garlic & Herb(1)

Crunchy(1)

Harvest Cheddar; Original; French Onion; Garden Salsa(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)

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

Regular(1)

Salt & Vinegar(1)

Shortbread(1)

Barbeque(1)

Tropical Fruit & Nut(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Aged White Cheddar(1)

Hazelnut(1)

Nut & Chocolate(1)

Mixed Nuts(1)

Bacon(1)

Mesquite BBQ(1)

Dill Pickle(1)

Creamy Peanut Butter(1)

Salted Nuts(1)

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

Salt & Pepper(1)

Dry Roasted & Salted(1)

Pistachios(1)

Deluxe Nut Mix(1)

Happy Heart Mix(1)

Berry Mix(1)

Sesame Snax Mix(1)

Pineapple & Papaya(1)

Ginger & Lemon(1)

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

Shortbread Fingers(1)

Shortbread Highlanders(1)

Tiramisu(1)

Danish Butter(1)

Light Butter(1)

Wasabi Party Mix(1)

Club & Cheddar Cheese(1)

Salt & Pepper Cashews(1)

Deluxe Mixed Nuts(1)

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

Apple Cinnamon(1)

Original Fig(1)

Oreo(1)

Walnuts and Almonds(1)

Dark Chocolate Cocoa Roast Almonds(1)

Berry Blend(1)

Tropical Blend(1)

Berry Nut Blend(1)

S'mores Nut Blend(1)

Cocoa Roast Almonds(1)

Cocoa Roasted 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)

Real Aged Cheddar(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)

Breakfast Nut Blend(1)

Breakfast Blend(1)

Cheese & Peanut Butter(1)

Mini Fudge Stripes(1)

Cocoa & Vanilla(1)

Original with M&Ms(1)

Original Salty Cracker(1)

Reduced Fat(1)

Frosted Blueberry(1)

Brown Sugar Cinnamon(1)

Blueberry(1)

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

Strawberry(1)

Pepper Jack Cheese(1)

Frosted Strawberry(1)

Maple Almond Butter w/Pretzels(1)

Classic Almond Butter w/Pretzels(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Double Chocolate Chip(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

Sweet & Salty Dark Chocolate Peanut Butter(1)

Salty Sweet Mix(1)

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

Classic Almond Butter(1)

Honey Peanut Butter(1)

Vanilla Almond Butter(1)

Chocolate Almond/Hazelnut Butter(1)

Maple Almond Butter(1)

Honey Almond Butter(1)

Original; Sour Cream & Onion; Cheddar Cheese(1)

 
Manufacturer Part Number

00058(2)

00073(2)

22465(1)

22464(1)

29441(1)

00039(1)

21074(1)

29516(1)

03719(1)

827558(1)

04738(1)

80314(1)

80401(1)

00080(1)

21073(1)

00083(1)

00095(1)

00093(1)

00096(1)

00097(1)

00098(1)

00092(1)

00091(1)

456268(1)

00084(1)

00087(1)

00089(1)

00082(1)

67652(1)

32430(1)

25115(1)

44355(1)

44366(1)

44375(1)

25113(1)

25111(1)

98067(1)

13256(1)

14672(1)

20871(1)

44441(1)

44443(1)

52547(1)

52546(1)

56627(1)

56628(1)

00679(1)

52347(1)

45095(1)

44446(1)

44451(1)

44458(1)

44463(1)

6775505(1)

01022(1)

07708(1)

07210(1)

884624(1)

06833(1)

06834(1)

01670(1)

00027(1)

71100(1)

21812PK(1)

72200(1)

77700(1)

00026(1)

011037(1)

11017(1)

827515(1)

55003(1)

827533(1)

827540(1)

827612(1)

55002(1)

827575(1)

21030(1)

1011039(1)

827582(1)

159200201(1)

827562(1)

13539(1)

655(1)

53005(1)

656(1)

657(1)

W-116(1)

375(1)

105512(1)

84637(1)

01570(1)

105510(1)

105511(1)

W-176(1)

W-536(1)

601049(1)

091842A25S(1)

00408(1)

05051(1)

1051900(1)

072142WTV(1)

072142A25X(1)

04474(1)

042322F2OA(1)

042722C35S(1)

070146A25M(1)

01021(1)

827553(1)

33525(1)

33364(1)

33625(1)

33664(1)

33725(1)

28783(1)

28781(1)

16686(1)

12592(1)

24680(1)

24696(1)

27182(1)

33825(1)

34325(1)

84325(1)

84170(1)

84337(1)

86364(1)

88317(1)

57706(1)

57690(1)

34325CT(1)

34895(1)

53664(1)

54325(1)

30378(1)

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

05344(1)

05343(1)

07133(1)

15923(1)

37437(1)

03744(1)

02104(1)

42007(1)

42008(1)

00470(1)

00798(1)

88417(1)

88434(1)

21167(1)

21165(1)

21771(1)

26547(1)

31031(1)

21163(1)

13189(1)

12061(1)

10892(1)

122264(1)

12233(1)

12653(1)

31131(1)

31732(1)

827544(1)

827118(1)

827545(1)

827548(1)

00019(1)

58402(1)

58399(1)

40975(1)

51158(1)

56924(1)

56926(1)

01008(1)

10051(1)

93917(1)

93817(1)

94017(1)

94117(1)

94217(1)

93364(1)

93064(1)

88834(1)

88917(1)

88934(1)

93017(1)

01305(1)

01866(1)

00030(1)

00029(1)

00309(1)

00311(1)

10050(1)

00028(1)

94816BX(1)

01873(1)

01948(1)

92100(1)

94816(1)

827695(1)

 
Country of Origin

US(191)

IN(9)

GB(6)

ID(5)

DE(2)

CA(1)

TH(1)

 
Capacity (Volume)

1.375 oz(7)

2 oz(2)

3 oz(1)

1 oz(1)

1.375oz(1)

1.5 oz(1)

 
Capacity (Weight)

1.5 oz(21)

2 oz(14)

1 oz(8)

6.3 oz(7)

5 oz(7)

1.15 oz(6)

1.25 oz(6)

1.4 oz(5)

1.75 oz(5)

3.2 oz(5)

1.8 oz(5)

8 oz(5)

2.5 oz(5)

32 oz(4)

0.63 oz(4)

0.8 oz(4)

5.5 oz(4)

0.62 oz(4)

1.375 oz(4)

40 oz(3)

3 oz(3)

1.38 oz(3)

1.3 oz(3)

3.67 oz(2)

48 oz(2)

1.06 oz(2)

6.75 oz(2)

5.35 oz(2)

4.9 oz(2)

44 oz(2)

24 oz(2)

38 oz(2)

1.413 oz(2)

26 oz(2)

4 oz(2)

0.88 oz(2)

3.75 oz(2)

4.5 oz(2)

1.1 oz(2)

1.2 oz(2)

12 oz(1)

1.02 oz(1)

6.2 oz(1)

34 oz(1)

0.7 oz(1)

1.0 oz(1)

2.17 oz(1)

58 oz(1)

50 oz(1)

0.9 oz(1)

6 lb(1)

2.01 oz(1)

1.75 oz; 1.5 oz(1)

16 oz(1)

2.4 oz(1)

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

15 oz(1)

14 oz(1)

22 oz(1)

0.74 oz(1)

3.25 oz(1)

3.71 oz(1)

0.95 oz(1)

.78 oz(1)

3.52 oz(1)

.39 oz(1)

0.2 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

0.56 oz(1)

0.81 oz(1)

2.1 oz(1)

6 oz(1)

8.0 oz(1)

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

0.22 oz(1)

2.32 oz(1)

4/5 oz(1)

 
Food Type

Nuts(43)

Cookies(36)

Snack(24)

Crackers(22)

Chips(21)

Popcorn(12)

Pretzel(8)

Nut Butter(8)

Trail Mix(7)

Dried Fruit(6)

Potato Chip(4)

Freezer Bar(3)

Pastry(3)

Cookie(3)

Cereal Bar(2)

Sunflower Seeds(2)

Snack Mix(1)

Puffed Rice(1)

Macaroni and Cheese(1)

Granola Bar(1)

Potato Chips(1)

Graham Crackers(1)

Veggie Straw(1)

Rice Krispy Treat(1)

Apple Straw(1)

Snacks(1)

Candy(1)

 
 
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved