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

Office Snax(16)

Nabisco(14)

Kellogg's(11)

Pop Secret(8)

Justin's(7)

Sunshine(6)

Planters(6)

Keebler(6)

Paramount Farms(6)

Walkers(6)

Annie's Homegrown(5)

Dolcetto(4)

popchips(4)

Austin(4)

Miss Vickie's(4)

Homefree(4)

Combos(4)

Chex Mix(4)

Pepperidge Farm(3)

Sahale Snacks(3)

Dirty(3)

Pop Weaver(3)

Wyler's Italian Ices(2)

Nutella(2)

Kar's(2)

Snyder's(2)

Stauffer's(2)

Stacy's(2)

General Mills(2)

Sensible Portions(2)

Fritos(2)

Rold Gold(2)

KIND(2)

Lay's(2)

Grandma's(2)

Cheetos(2)

Tostitos(1)

Jif Bars(1)

Pringles(1)

Utz(1)

Fla-Vor-Ice(1)

BIGS(1)

Sqwincher(1)

SkinnyPop Popcorn(1)

Kettle Brand(1)

Ruffles(1)

Biscoff(1)

SunChips(1)

Knott's Berry Farm(1)

Doritos(1)

Frito-Lay(1)

Pirate's Booty(1)

Royal Dansk(1)

De Beukelaer(1)

 
Packing Type

Bag(85)

Pack(41)

Box(21)

Tub(6)

Packs(5)

Squeeze Pack(5)

Canister(4)

Tube(4)

Bar(3)

Packet(3)

Tube Package(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(19)

Chocolate Chip(7)

Chocolate(5)

Sea Salt(5)

Roasted & Salted(5)

Homestyle(3)

Movie Theater Butter(3)

Dry Roasted Almonds(3)

Assorted(3)

Peanut Butter(3)

Extra Butter(2)

Hazelnut/Cocoa(2)

All Natural Almonds(2)

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

Butter(2)

Cashews(2)

Original Marshmallow(2)

Jalapeno Cashews(2)

Dill Pickle Cashews(2)

Natural Almonds(2)

Sourdough(2)

Salted(2)

Cheese(2)

Sour Cream & Onion(2)

White Cheddar(2)

Cheddar(2)

Toast & Peanut Butter(2)

Cheddar Cheese(2)

Vanilla(2)

Sriracha Cashews(2)

Cinnamon/Honey(1)

Sesame Snax Mix(1)

Pineapple & Papaya(1)

Berry Mix(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)

Smokehouse BBQ(1)

Barbecue(1)

Sea Salt & Vinegar(1)

Jalapeno(1)

Crunchy(1)

Nacho Cheese(1)

Regular(1)

Vanilla Cream(1)

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

Caramel(1)

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

Parmesan Garlic & Herb(1)

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

Happy Heart Mix(1)

Shortbread Highlanders(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)

Light Butter(1)

Danish Butter(1)

Shortbread(1)

Ginger & Lemon(1)

Deluxe Nut Mix(1)

Tiramisu(1)

Shortbread Fingers(1)

Hazelnut(1)

Aged White Cheddar(1)

Salt & Pepper(1)

Dry Roasted & Salted(1)

Pistachios(1)

Mini Fudge Stripes(1)

Apple Cinnamon(1)

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

Oreo(1)

Original Fig(1)

Pepperoni Pizza Cracker(1)

Salt & Pepper Cashews(1)

Deluxe Mixed Nuts(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(1)

Cocoa Roasted Almonds(1)

Dark Chocolate Cocoa Roast Almonds(1)

Walnuts and Almonds(1)

Cheddar Cheese Cracker(1)

Pizzeria Pretzel(1)

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

Sweet 'N Salty Mix(1)

Snickerdoodle(1)

Chocolate; Chocolate Chip; Honey(1)

Real Aged Cheddar(1)

Chocolate Turtle(1)

Corn(1)

Raspberry(1)

Cheddar Cheese Pretzel(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

Traditional Mix(1)

Sea Salt and Pepper Cashews(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Brown Sugar Cinnamon(1)

Frosted Strawberry(1)

Frosted Blueberry(1)

Cocoa & Vanilla(1)

Cheese & Peanut Butter(1)

Pepper Jack Cheese(1)

Strawberry(1)

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

Almond & Sea Salt; Dark Chocolate Nuts; Sea Salt Caramel(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)

Blueberry(1)

Club & Cheddar Cheese(1)

Original with M&Ms(1)

Maple Almond Butter(1)

Chocolate Almond/Hazelnut Butter(1)

Classic Almond Butter(1)

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

Double Chocolate Chip(1)

Honey Peanut Butter(1)

Vanilla Almond Butter(1)

Reduced Fat(1)

Original Salty Cracker(1)

Maple Almond Butter w/Pretzels(1)

Classic Almond Butter w/Pretzels(1)

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

 
Manufacturer Part Number

00058(2)

00073(2)

00083(1)

00082(1)

00084(1)

00089(1)

00080(1)

00087(1)

80401(1)

04738(1)

827558(1)

80314(1)

00091(1)

00039(1)

00093(1)

01021(1)

01022(1)

01570(1)

105510(1)

00679(1)

00098(1)

456268(1)

00095(1)

00096(1)

00097(1)

00092(1)

67652(1)

44355(1)

44366(1)

44375(1)

44441(1)

32430(1)

20871(1)

25719(1)

25726(1)

13256(1)

14672(1)

44443(1)

44446(1)

52547(1)

56627(1)

56628(1)

105511(1)

52546(1)

52347(1)

44451(1)

44458(1)

44463(1)

45095(1)

6775505(1)

375(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-176(1)

W-536(1)

04474(1)

042322F2OA(1)

W-116(1)

657(1)

98067(1)

53005(1)

655(1)

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

105512(1)

827695(1)

28781(1)

27182(1)

28783(1)

33364(1)

33525(1)

24696(1)

24680(1)

30357(1)

30378(1)

12592(1)

16686(1)

33625(1)

33664(1)

54325(1)

57690(1)

57706(1)

84170(1)

53664(1)

34895(1)

33725(1)

33825(1)

34325(1)

34325CT(1)

37437(1)

15923(1)

SN35181(1)

SN35182(1)

SN37301(1)

SN43037(1)

SN28086(1)

SN16794(1)

00074(1)

32021(1)

SN08361(1)

SN08387(1)

59636(1)

42005(1)

03744(1)

05343(1)

05344(1)

07133(1)

02104(1)

00798(1)

42006(1)

42007(1)

42008(1)

00470(1)

84325(1)

86364(1)

21771(1)

26547(1)

31031(1)

31131(1)

21167(1)

21165(1)

12233(1)

12653(1)

13189(1)

21163(1)

31732(1)

40975(1)

827545(1)

827548(1)

827553(1)

00019(1)

827544(1)

58402(1)

51158(1)

56924(1)

56926(1)

58399(1)

122264(1)

12061(1)

94217(1)

01305(1)

01866(1)

01873(1)

94117(1)

94017(1)

93064(1)

93364(1)

93817(1)

93917(1)

01948(1)

92100(1)

10050(1)

10051(1)

01008(1)

10892(1)

00311(1)

00309(1)

94816(1)

94816BX(1)

00028(1)

00030(1)

84637(1)

 
Country of Origin

US(174)

IN(9)

GB(6)

ID(5)

DE(2)

CA(1)

TH(1)

 
Capacity (Volume)

1.375 oz(4)

2 oz(2)

3 oz(1)

1 oz(1)

1.375oz(1)

1.5 oz(1)

 
Capacity (Weight)

1.5 oz(16)

2 oz(14)

6.3 oz(7)

1 oz(7)

5 oz(7)

1.25 oz(6)

3.2 oz(5)

1.4 oz(5)

1.15 oz(5)

1.8 oz(5)

1.75 oz(5)

2.5 oz(5)

0.8 oz(4)

32 oz(4)

0.62 oz(4)

0.63 oz(4)

3 oz(3)

40 oz(3)

0.7 oz(3)

1.38 oz(3)

1.3 oz(3)

1 1/2 oz(3)

4.9 oz(2)

4 oz(2)

6.75 oz(2)

48 oz(2)

1.06 oz(2)

0.88 oz(2)

3.67 oz(2)

1.2 oz(2)

26 oz(2)

5.5 oz(2)

3.75 oz(2)

4.5 oz(2)

24 oz(2)

8 oz(2)

38 oz(2)

1.1 oz(2)

44 oz(2)

2.17 oz(1)

6.2 oz(1)

34 oz(1)

15 oz(1)

1.75 oz; 1.5 oz(1)

50 oz(1)

0.9 oz(1)

5.35 oz(1)

16 oz(1)

58 oz(1)

1.02 oz(1)

1.0 oz(1)

14 oz(1)

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

2.01 oz(1)

8-1 3/4 oz; 16-1 1/2 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)

1.5oz(1)

1.5 oz; 2 oz(1)

0.74 oz(1)

3.25 oz(1)

3.71 oz(1)

22 oz(1)

 
Food Type

Nuts(41)

Cookies(36)

Snack(23)

Crackers(22)

Chips(18)

Popcorn(12)

Nut Butter(7)

Pretzel(7)

Potato Chip(4)

Freezer Bar(3)

Pastry(3)

Cookie(3)

Snack Bar(2)

Dried Fruit(2)

Cereal Bar(2)

Trail Mix(2)

Macaroni and Cheese(1)

Sunflower Seeds(1)

Snack Mix(1)

Puffed Rice(1)

Granola Bar(1)

Candy(1)

Veggie Straw(1)

Potato Chips(1)

Snacks(1)

Apple Straw(1)

Graham Crackers(1)

 
 
 

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