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`.`desc_short` LIKE 'Snack%' THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`desc_long` LIKE 'Snack%' THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`sku` LIKE '%Snack' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Snack' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Snack' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Snack"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Snack"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Snack"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Snack"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Snack' IN BOOLEAN MODE),1,0))) END END DESC, CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Snack',`category_4` ='Snack') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Snack,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Snack', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Snacks

Refine Search

  GO
 
Brand

Emerald(22)

Nabisco(19)

Office Snax(15)

Kellogg's(9)

Pop Secret(8)

Justin's(7)

Chex Mix(6)

Planters(6)

Keebler(6)

Paramount Farms(6)

Walkers(6)

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

KIND(3)

Dirty(3)

Pop Weaver(3)

Nutella(2)

Wyler's Italian Ices(2)

Stauffer's(2)

Snyder's(2)

Stacy's(2)

Kar's(2)

General Mills(2)

Sensible Portions(2)

Lay's(2)

Grandma's(2)

Cheetos(2)

Rold Gold(2)

Fritos(2)

Tostitos(1)

Sheila G’s Brownie Brittle(1)

Jif Bars(1)

Sqwincher(1)

Utz(1)

Fla-Vor-Ice(1)

BIGS(1)

De Beukelaer(1)

Knott's Berry Farm(1)

Ruffles(1)

Frito-Lay(1)

Biscoff(1)

Kettle Brand(1)

Royal Dansk(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Doritos(1)

SunChips(1)

 
Packing Type

Bag(88)

Pack(46)

Box(21)

Tub(5)

Squeeze Pack(5)

Packs(5)

Tube(4)

Tube Package(3)

Bar(3)

Packet(3)

Canister(3)

Tin Container(2)

Packets(2)

Single-Serve Tub(2)

Jar(1)

Container(1)

Can(1)

Carton(1)

Single-Serve Bag(1)

Variety Pack(1)

Resealable Bag in Box(1)

 
Flavor

Original(19)

Chocolate Chip(8)

Peanut Butter(5)

Roasted & Salted(5)

Chocolate(5)

Sea Salt(5)

Dry Roasted Almonds(3)

Movie Theater Butter(3)

Homestyle(3)

Sriracha Cashews(2)

Dill Pickle Cashews(2)

Butter(2)

Natural Almonds(2)

Salt & Pepper(2)

Jalapeno Cashews(2)

Traditional(2)

White Cheddar(2)

Assorted(2)

Original Marshmallow(2)

Toast & Peanut Butter(2)

Cheese(2)

Hazelnut/Cocoa(2)

Sourdough(2)

Cashews(2)

Vanilla(2)

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

Salted(2)

Shortbread(2)

All Natural Almonds(2)

Sour Cream & Onion(2)

Blueberry(2)

Cheddar Cheese(2)

Extra Butter(2)

Cinnamon/Honey(1)

Classic Fruit Nut(1)

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

Cashew Pom Vanilla(1)

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

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

Honey Glazed Almond(1)

Creamy Peanut Butter(1)

Bacon(1)

Jalapeno(1)

Nacho Cheese(1)

Crunchy(1)

Mesquite BBQ(1)

Sea Salt & Vinegar(1)

Smokehouse BBQ(1)

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

Vanilla Cream(1)

Regular(1)

Barbecue(1)

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

Mixed Nuts(1)

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

Danish Butter(1)

Light Butter(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Tiramisu(1)

Shortbread Fingers(1)

Dry Roasted & Salted(1)

Aged White Cheddar(1)

Hazelnut(1)

Ginger & Lemon(1)

Barbeque(1)

Nut & Chocolate(1)

Pineapple & Papaya(1)

Sesame Snax Mix(1)

Wasabi Party Mix(1)

Berry Mix(1)

Tropical Fruit & Nut(1)

Deluxe Nut Mix(1)

Pistachios(1)

Fruit & Nut Mix(1)

Salted Nuts(1)

Original with M&Ms(1)

Golden Oat(1)

Original Fig(1)

Vanilla Crème(1)

Pepperoni Pizza Cracker(1)

Cheddar Cheese Cracker(1)

Oreo(1)

Apple Cinnamon(1)

Walnuts and Almonds(1)

Dark Chocolate Cocoa Roast Almonds(1)

Deluxe Mixed Nuts(1)

Salt & Pepper Cashews(1)

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

Pizzeria Pretzel(1)

Cheddar Cheese Pretzel(1)

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

Sweet 'N Salty Mix(1)

Snickerdoodle(1)

Chocolate; Chocolate Chip; Honey(1)

Cheddar(1)

Chocolate Turtle(1)

Corn(1)

Raspberry(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

Traditional Mix(1)

Cocoa Roasted Almonds(1)

Salty Sweet Mix(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)

Almond/Cranberry; Honey Roasted Nuts & Salt(1)

Cherry Cashew/Dark Chocolate; Dark Chocolate/Peanut Butter(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)

Frosted Strawberry(1)

Original Salty Cracker(1)

Maple Almond Butter w/Pretzels(1)

Double Chocolate Chip(1)

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

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

Classic 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)

00080(1)

80401(1)

00082(1)

00083(1)

00084(1)

80314(1)

827558(1)

67652(1)

6775505(1)

456268(1)

04738(1)

00087(1)

00091(1)

00679(1)

00098(1)

01020(1)

01021(1)

01022(1)

00097(1)

00096(1)

56628(1)

00092(1)

00093(1)

00095(1)

00089(1)

56627(1)

14672(1)

13256(1)

20871(1)

32430(1)

44355(1)

25726(1)

25719(1)

827553(1)

827695(1)

98067(1)

25712(1)

44366(1)

44375(1)

45095(1)

52347(1)

52546(1)

52547(1)

44463(1)

44458(1)

44441(1)

44443(1)

44446(1)

44451(1)

01570(1)

105510(1)

06833(1)

884624(1)

06834(1)

011037(1)

11017(1)

07708(1)

07210(1)

77700(1)

00026(1)

00027(1)

01670(1)

21030(1)

900327(1)

827515(1)

827533(1)

827540(1)

827612(1)

55003(1)

159200201(1)

900328(1)

900330(1)

1011039(1)

827582(1)

72200(1)

71100(1)

W-116(1)

657(1)

W-536(1)

04474(1)

042322F2OA(1)

656(1)

655(1)

105511(1)

105512(1)

375(1)

53005(1)

042722C35S(1)

070146A25M(1)

1051900(1)

13539(1)

827562(1)

21812PK(1)

05051(1)

00408(1)

072142A25X(1)

072142WTV(1)

091842A25S(1)

601049(1)

827548(1)

827544(1)

12592(1)

30378(1)

16686(1)

24680(1)

24696(1)

30357(1)

15923(1)

05343(1)

05344(1)

07133(1)

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

03744(1)

SN35181(1)

SN28086(1)

SN35182(1)

SN37301(1)

SN43037(1)

SN16794(1)

SN08387(1)

00074(1)

32021(1)

01224(1)

SN08361(1)

59636(1)

42005(1)

02104(1)

02908(1)

02908BX(1)

02946(1)

00798(1)

00470(1)

42006(1)

42007(1)

42008(1)

00176(1)

54325(1)

57690(1)

122264(1)

12061(1)

12233(1)

12653(1)

13189(1)

10892(1)

10003(1)

00311(1)

10050(1)

10051(1)

01008(1)

21163(1)

21165(1)

40975(1)

51158(1)

58402(1)

00019(1)

31732(1)

31131(1)

21167(1)

21771(1)

26547(1)

31031(1)

00309(1)

00058(1)

93817(1)

93364(1)

93917(1)

94017(1)

94117(1)

93064(1)

86364(1)

57706(1)

80895(1)

84170(1)

84325(1)

94217(1)

1160588(1)

94816(1)

94816BX(1)

00028(1)

00030(1)

92100(1)

01948(1)

827565(1)

01305(1)

01866(1)

01873(1)

827545(1)

 
Country of Origin

US(180)

IN(9)

GB(6)

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

2 oz(15)

5 oz(9)

1 oz(7)

6.3 oz(7)

1.75 oz(6)

1.25 oz(6)

1.15 oz(5)

3.2 oz(5)

2.5 oz(5)

1.8 oz(5)

32 oz(4)

0.62 oz(4)

0.63 oz(4)

0.7 oz(4)

0.8 oz(4)

1.76 oz(4)

4.9 oz(3)

40 oz(3)

1.3 oz(3)

1.38 oz(3)

1.4 oz(3)

8 oz(3)

3 oz(3)

1 1/2 oz(3)

4 oz(2)

3.67 oz(2)

4.5 oz(2)

48 oz(2)

44 oz(2)

6.75 oz(2)

3.75 oz(2)

38 oz(2)

24 oz(2)

1.2 oz(2)

5.5 oz(2)

1.1 oz(2)

34 oz(1)

2.17 oz(1)

12 oz(1)

6.2 oz(1)

1.0 oz(1)

15 oz(1)

16 oz(1)

5.35 oz(1)

50 oz(1)

58 oz(1)

0.9 oz(1)

1.75 oz; 1.5 oz(1)

14 oz(1)

1.02 oz(1)

3.52 oz(1)

0.56 oz(1)

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

0.95 oz(1)

0.2 oz(1)

0.81 oz(1)

4/5 oz(1)

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

1.7 oz(1)

2.4 oz(1)

.39 oz(1)

2.1 oz(1)

1.375 oz(1)

0.22 oz(1)

2.32 oz(1)

22 oz(1)

1.5oz(1)

1.5 oz; 2 oz(1)

1.06 oz(1)

3.25 oz(1)

3.71 oz(1)

26 oz(1)

 
Food Type

Nuts(42)

Cookies(37)

Snack(25)

Crackers(21)

Chips(18)

Popcorn(12)

Nut Butter(7)

Pretzel(7)

Cookie(5)

Potato Chip(4)

Snack Bar(3)

Pastry(3)

Freezer Bar(3)

Trail Mix(2)

Cereal Bar(2)

Dried Fruit(2)

Veggie Straw(1)

Granola Bar(1)

Sunflower Seeds(1)

Snack Mix(1)

Graham Crackers(1)

Puffed Rice(1)

Snacks(1)

Breakfast Biscuit(1)

Apple Straw(1)

Breakfast Biscuits(1)

 
 
 

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