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 `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 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` WHERE (`category_name` LIKE "Snacks") 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 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(17)

Kellogg's(15)

Nabisco(12)

Keebler(7)

Pop Secret(7)

Sunshine(7)

Planters(6)

Paramount Farms(6)

Annie's Homegrown(5)

Walkers(4)

popchips(4)

Austin(4)

Chex Mix(4)

Combos(4)

Dolcetto(3)

Dirty(3)

Pringles(3)

Pepperidge Farm(3)

Pop Weaver(3)

Stacy's(2)

Glutino(2)

General Mills(2)

Snyder's(2)

Sensible Portions(2)

Diamond of California(2)

Grandma's(2)

Utz(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Stauffer's(1)

Sqwincher(1)

BIGS(1)

Jif Bars(1)

Jif To Go(1)

Shultz(1)

De Beukelaer(1)

Ruffles(1)

Tostitos(1)

Lay's(1)

Rold Gold(1)

Fla-Vor-Ice(1)

Kettle Brand(1)

Kar's(1)

Knott's Berry Farm(1)

Fritos(1)

Cheetos(1)

Nutella(1)

Ocean Spray(1)

Biscoff(1)

Frito-Lay(1)

Doritos(1)

SunChips(1)

Royal Dansk(1)

Recycled

No(1)

Packing Type

Bag(89)

Pack(31)

Box(19)

Tub(6)

Canister(6)

Packs(5)

Tube Package(4)

Tin Container(2)

Bar(2)

Cup(2)

Resealable Bags(1)

Can(1)

Jar(1)

Container(1)

Single-Serve Bag(1)

Packets(1)

Tube(1)

Packet(1)

Variety Pack(1)

Single-Serve Tub(1)

Carton(1)

Flavor

Original(17)

Roasted & Salted(5)

Chocolate Chip(5)

Chocolate(4)

Peanut Butter(4)

Sea Salt(4)

Dry Roasted Almonds(3)

Assorted(3)

Homestyle(3)

Original Marshmallow(3)

Salted(3)

Butter(3)

All Natural Almonds(2)

Cheddar Cheese(2)

Natural Almonds(2)

Sour Cream & Onion(2)

Cashews(2)

Sourdough(2)

Cheddar(2)

White Cheddar(2)

Movie Theater Butter(2)

Extra Butter(2)

Toast & Peanut Butter(2)

Light Salt(2)

Sesame Snax Mix(1)

Cinnamon/Honey(1)

Wasabi Party Mix(1)

Cranberry(1)

Caramel(1)

Crunchy(1)

Nacho Cheese(1)

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

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

Butter Sandwich Cookies w/Fudge Creme Filling(1)

Zesty Ranch(1)

Regular(1)

Vanilla Cream(1)

Pineapple & Papaya(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)

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

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

Hazelnut/Cocoa(1)

Shortbread Fingers(1)

Tropical Fruit & Nut(1)

Nut & Chocolate(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Mixed Nuts(1)

Salted Nuts(1)

Creamy Peanut Butter(1)

Mesquite BBQ(1)

Chocolate Silk(1)

Cheese(1)

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

Hazelnut(1)

Aged White Cheddar(1)

Shortbread(1)

Light Butter(1)

Deluxe Nut Mix(1)

Pistachios(1)

Happy Heart Mix(1)

Danish Butter(1)

Vanilla(1)

Salt & Pepper(1)

Dry Roasted & Salted(1)

Shortbread Highlanders(1)

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

Berry Mix(1)

Cheese & Peanut Butter(1)

Apple Cinnamon(1)

Walnuts(1)

Oreo(1)

Original Fig(1)

Pepperoni Pizza Cracker(1)

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

Pecans(1)

Cocoa Roasted Almonds(1)

Dark Chocolate Cocoa Roast Almonds(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Cheddar Cheese Cracker(1)

Pizzeria Pretzel(1)

Sweet 'N Salty Mix(1)

Chocolate Turtle(1)

Snickerdoodle(1)

Chocolate; Chocolate Chip; Honey(1)

Real Aged Cheddar(1)

Corn(1)

Traditional Mix(1)

Cheddar Cheese Pretzel(1)

Raspberry(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

S'mores Nut Blend(1)

Berry Nut Blend(1)

Cocoa & Vanilla(1)

Mini Fudge Stripes(1)

Club & Cheddar Cheese(1)

Frosted Chocolate Peanut Butter(1)

Original Chips with Honey Dijon Dip(1)

Frosted Blueberry(1)

Brown Sugar Cinnamon(1)

Blueberry(1)

Strawberry(1)

Pepper Jack Cheese(1)

Frosted Strawberry(1)

Original Chips with Jalapeno Cheddar Dip(1)

Reduced Fat(1)

Breakfast Blend(1)

Sweet & Salty Dark Chocolate Peanut Butter(1)

Breakfast Nut Blend(1)

Tropical Blend(1)

Berry Blend(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(1)

Frosted PB&J Strawberry(1)

Original Salty Cracker(1)

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

Sea Salt and Pepper Cashews(1)

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

Manufacturer Part Number

00073(2)

00087(1)

00089(1)

00091(1)

00084(1)

00092(1)

00082(1)

29516(1)

00039(1)

00080(1)

00093(1)

00083(1)

00095(1)

01570(1)

105510(1)

105511(1)

105512(1)

01020(1)

00679(1)

00096(1)

00097(1)

00098(1)

80314(1)

827558(1)

13256(1)

20871(1)

25148(1)

32430(1)

98067(1)

93646(1)

827695(1)

84637(1)

91306(1)

44355(1)

44366(1)

52546(1)

52547(1)

456268(1)

04738(1)

52347(1)

46572(1)

44375(1)

44463(1)

45095(1)

375(1)

53005(1)

884624(1)

06833(1)

06834(1)

011037(1)

07708(1)

07210(1)

00026(1)

00027(1)

01670(1)

21019(1)

21030(1)

827515(1)

827533(1)

827540(1)

827612(1)

55001(1)

827575(1)

1011039(1)

827582(1)

159200201(1)

77700(1)

72200(1)

0617(1)

042322F2OA(1)

042722C35S(1)

070146A25M(1)

W-536(1)

W-176(1)

655(1)

656(1)

W-116(1)

072142A25X(1)

072142WTV(1)

13539(1)

883590(1)

21812PK(1)

71100(1)

1051900(1)

05051(1)

091842A25S(1)

601049(1)

00408(1)

827554(1)

827548(1)

14231(1)

16686(1)

24680(1)

24696(1)

12592(1)

04231(1)

07133(1)

15923(1)

30357(1)

30378(1)

27182(1)

28781(1)

53664(1)

54325(1)

57690(1)

57706(1)

34895(1)

34325CT(1)

33364(1)

33664(1)

34325(1)

03744(1)

02104(1)

SN28086(1)

SN35181(1)

SN35182(1)

SN37301(1)

SN16794(1)

SN08387(1)

00058(1)

00074(1)

32021(1)

SN43037(1)

04006(1)

42007(1)

42008(1)

00470(1)

00798(1)

42006(1)

42005(1)

04034(1)

59636(1)

610(1)

84170(1)

84325(1)

21771(1)

26547(1)

31031(1)

31131(1)

21167(1)

21165(1)

12514(1)

12653(1)

21163(1)

31732(1)

40975(1)

827118(1)

827544(1)

827545(1)

00019(1)

58402(1)

58399(1)

51158(1)

56924(1)

56926(1)

12511(1)

12501(1)

88917(1)

88934(1)

93017(1)

93064(1)

88834(1)

88434(1)

86364(1)

88317(1)

88417(1)

93364(1)

93817(1)

12061(1)

122264(1)

12233(1)

12496(1)

11714(1)

10892(1)

94017(1)

92100(1)

01008(1)

827553(1)

Country of Origin

US(165)

GB(4)

ID(4)

DE(2)

IN(2)

TH(1)

United Kingdom(1)

Weight (Approximate)

4.94 oz(1)

Capacity (Volume)

3 oz(1)

19oz(1)

1 oz(1)

1.375oz(1)

1.5 oz(1)

Capacity (Weight)

1.5 oz(18)

2 oz(15)

1 oz(9)

5 oz(7)

6.3 oz(6)

1.8 oz(5)

1.75 oz(5)

2.5 oz(5)

3 1/2 oz(4)

8 oz(4)

5.5 oz(4)

32 oz(4)

0.63 oz(4)

1.4 oz(4)

0.8 oz(4)

40 oz(3)

1.25 oz(3)

3 oz(3)

1.38 oz(3)

1.06 oz(2)

6.75 oz(2)

3.67 oz(2)

48 oz(2)

44 oz(2)

38 oz(2)

26 oz(2)

3.75 oz(2)

4.5 oz(2)

0.88 oz(2)

1.76 oz(2)

24 oz(2)

2.8 oz(2)

1.2 oz(2)

0.7 oz(1)

2.17 oz(1)

6.2 oz(1)

50 oz(1)

34 oz(1)

5.35 oz(1)

1.75 oz; 1.5 oz(1)

0.9 oz(1)

16 oz(1)

1.69 oz(1)

14 oz(1)

19 oz(1)

6 lb(1)

15 oz(1)

0.81 oz(1)

1.0 oz(1)

12 oz(1)

.78 oz(1)

0.56 oz(1)

6 oz(1)

0.2 oz(1)

.39 oz(1)

3.5 oz(1)

2.4 oz(1)

2.01 oz(1)

14.1 oz(1)

4/5 oz(1)

1.3 oz(1)

3.52 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

0.22 oz(1)

3.71 oz(1)

1.375 oz(1)

0.74 oz(1)

3.4 oz(1)

3.25 oz(1)

22 oz(1)

Product Type

Cookie(1)

Packaged Quantity

48 / Box(1)

Food Type

Nuts(37)

Cookies(28)

Crackers(23)

Snack(18)

Chips(12)

Popcorn(11)

Pretzel(10)

Pastry(6)

Trail Mix(5)

Potato Chip(4)

Potato Chips(3)

Dried Fruit(3)

Cookie(3)

Cereal Bar(2)

Puffed Rice(1)

Candy(1)

Sunflower Seeds(1)

Granola Bar(1)

Snack Mix(1)

Freezer Bar(1)

Graham Crackers(1)

Macaroni and Cheese(1)

Veggie Straw(1)

Apple Straw(1)

Snacks(1)

Rice Krispy Treat(1)

Nut Butter(1)

Price Range

$0-$49.99(172)

$50-$99.99(7)

To  GO

 
 
1%
Searching for your Best Results.....
 

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