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

Nabisco(19)

Office Snax(10)

Pop Secret(8)

Kellogg's(7)

Sunshine(7)

Keebler(6)

Planters(6)

Paramount Farms(6)

Sahale Snacks(5)

Austin(4)

popchips(4)

Miss Vickie's(4)

Homefree(4)

Walkers(4)

KIND(3)

Chex Mix(3)

Pop Weaver(3)

Pepperidge Farm(3)

Nutella(2)

Stacy's(2)

Frito-Lay(2)

Food Should Taste Good(2)

Shultz(2)

Cheetos(2)

Fritos(2)

Rold Gold(2)

Grandma's(2)

Stauffer's(2)

Sensible Portions(2)

Snyder's(2)

Kar's(2)

De Beukelaer(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Sqwincher(1)

Annie's Homegrown(1)

Lay's(1)

Royal Dansk(1)

Dolcetto(1)

Biscoff(1)

SunChips(1)

Ruffles(1)

Doritos(1)

Tostitos(1)

Pringles(1)

Kettle Brand(1)

Knott's Berry Farm(1)

General Mills(1)

Utz(1)

 
Packing Type

Bag(74)

Pack(42)

Box(9)

Bar(5)

Packs(5)

Tube Package(4)

Canister(4)

Tub(4)

Tube(3)

Packets(2)

Yes(2)

Pouch(2)

Single-Serve Tub(2)

Tin Container(2)

Can(1)

Jar(1)

Packet(1)

Resealable Bag in Box(1)

Single-Serve Bag(1)

Carton(1)

Container(1)

 
Flavor

Original(19)

Peanut Butter(7)

Chocolate Chip(6)

Roasted & Salted(5)

Homestyle(3)

Sea Salt(3)

Chocolate(3)

Original Marshmallow(3)

Cheese(3)

Movie Theater Butter(3)

Toast & Peanut Butter(2)

All Natural Almonds(2)

Butter(2)

Cocoa Roast Almonds(2)

Sriracha Cashews(2)

Dry Roasted Almonds(2)

Jalapeno Cashews(2)

Dill Pickle Cashews(2)

Cashews(2)

Natural Almonds(2)

Cheddar Cheese(2)

White Cheddar(2)

Golden Oat(2)

Extra Butter(2)

Blueberry(2)

Assorted(2)

Hazelnut/Cocoa(2)

Cinnamon/Honey(1)

Sesame Snax Mix(1)

Salted(1)

6 Packs Ritz Bits Peanut Butter; 8 Packs Ritz Bits Cheese; 8 Packs Nutter Butter Bites; 9 Packs Mini Oreo; 9 Packs Chips Ahoy(1)

Wasabi Party Mix(1)

Berry Mix(1)

Caramel(1)

Pistachios(1)

Deluxe Nut Mix(1)

Shortbread(1)

Light Butter(1)

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

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

Parmesan Garlic & Herb(1)

Danish Butter(1)

Cheddar(1)

Honey Wheat(1)

Tropical Fruit & Nut(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Tangerine Vanilla(1)

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

Salted Nuts(1)

Mixed Nuts(1)

Nut & Chocolate(1)

Sour Cream & Onion(1)

Shortbread Fingers(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Vanilla Cream(1)

Hazelnut(1)

Aged White Cheddar(1)

Salt & Pepper(1)

Dry Roasted & Salted(1)

Chocolate Chip Shortbread(1)

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

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

Regular(1)

Apple Cinnamon(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

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

Oreo(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Original Fig(1)

Vanilla Crème(1)

Raspberry(1)

Traditional Mix(1)

Cheddar Mix(1)

Sweet 'N Salty Mix(1)

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

Sweet Potato with Sea Salt(1)

Traditional(1)

Vanilla(1)

Barbecue(1)

Zesty Ranch(1)

Smokehouse BBQ(1)

Sea Salt & Vinegar(1)

Jalapeno(1)

Nacho Cheese(1)

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

Salted Caramel & Dark Chocolate Nut + Dark Chocolate Almond & Coconut(1)

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

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

Multigrain with Sea Salt(1)

Double Chocolate Chip(1)

Pepper Jack Cheese(1)

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

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

Original with M&Ms(1)

Reduced Fat(1)

Original Salty Cracker(1)

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

00089(1)

456268(1)

04738(1)

1284253(1)

80314(1)

80401(1)

00082(1)

00087(1)

00092(1)

67652(1)

00095(1)

00096(1)

00097(1)

00098(1)

00679(1)

01021(1)

01570(1)

105510(1)

92268(1)

56628(1)

105512(1)

44441(1)

14672(1)

14867(1)

20871(1)

32430(1)

44355(1)

44366(1)

44375(1)

44443(1)

56627(1)

44446(1)

44451(1)

44458(1)

44463(1)

45095(1)

52347(1)

52546(1)

52547(1)

105511(1)

3598(1)

25726(1)

011037(1)

00027(1)

01670(1)

07210(1)

07708(1)

884624(1)

06833(1)

06834(1)

11017(1)

77700(1)

900015(1)

900020(1)

900021(1)

900022(1)

900362(1)

1011039(1)

827582(1)

159200201(1)

00026(1)

72200(1)

375(1)

072142A25X(1)

53005(1)

6270(1)

W-116(1)

W1537D(1)

04474(1)

042322F2OA(1)

042722C35S(1)

070146A25M(1)

072142WTV(1)

71100(1)

091842A25S(1)

601049(1)

00408(1)

05051(1)

1051900(1)

13539(1)

827562(1)

21812PK(1)

26678(1)

25719(1)

81233(1)

28783(1)

30378(1)

12592(1)

16686(1)

24680(1)

24696(1)

27182(1)

28781(1)

33364(1)

52220(1)

33525(1)

33625(1)

33664(1)

33725(1)

33825(1)

34325(1)

34325CT(1)

53664(1)

30357(1)

15923(1)

57690(1)

00470(1)

81237(1)

SN08361(1)

SN08387(1)

SN14839(1)

SN14858(1)

SN14868(1)

59636(1)

00176(1)

00798(1)

07737(1)

02104(1)

02908(1)

02908BX(1)

02946(1)

02946BX(1)

03744(1)

03745(1)

04068(1)

54325(1)

57706(1)

98067CT(1)

26547(1)

13189(1)

17120(1)

18251(1)

21163(1)

21165(1)

21167(1)

21771(1)

40975(1)

12233(1)

51158(1)

827544(1)

827545(1)

827548(1)

827553(1)

827695(1)

93646(1)

98067(1)

12653(1)

122264(1)

84170(1)

94117(1)

84325(1)

86364(1)

89426(1)

93064(1)

93364(1)

93817(1)

93917(1)

94017(1)

94217(1)

12061(1)

1160588(1)

01305(1)

01866(1)

01873(1)

01948(1)

01008(1)

10003(1)

10892(1)

827612(1)

 
Country of Origin

US(154)

IN(9)

GB(4)

ID(2)

DE(1)

CA(1)

 
Capacity (Volume)

1.375 oz(4)

1.75 oz(1)

1 oz(1)

3 oz(1)

 
Capacity (Weight)

1.5 oz(25)

2 oz(13)

1 oz(8)

5 oz(7)

1.25 oz(6)

2.5 oz(5)

1.8 oz(5)

1.75 oz(5)

1.76 oz(5)

0.7 oz(4)

0.62 oz(4)

3.2 oz(4)

0.8 oz(4)

32 oz(3)

24 oz(3)

1.38 oz(3)

0.63 oz(3)

8 oz(2)

4 oz(2)

3.25 oz(2)

3.75 oz(2)

5.5 oz(2)

44 oz(2)

1.4 oz(2)

1.1 oz(2)

3 oz(2)

1.2 oz(2)

16 oz(1)

38 oz(1)

34 oz(1)

4.9 oz(1)

6.2 oz(1)

50 oz(1)

2.17 oz(1)

14 oz(1)

15 oz(1)

26 oz(1)

1.75 oz; 1.5 oz(1)

12 oz(1)

58 oz(1)

2.2 oz(1)

1.02 oz(1)

1.44 oz(1)

1.3 oz(1)

22 oz(1)

.39 oz(1)

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

1.7 oz(1)

2.4 oz(1)

0.56 oz(1)

3 1/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.2 oz(1)

2.1 oz(1)

40 oz(1)

.78 oz(1)

0.74 oz(1)

48 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

1.5 oz; 1.13 oz(1)

0.22 oz(1)

2.32 oz(1)

0.9 oz(1)

 
Food Type

Nuts(42)

Cookies(33)

Crackers(21)

Chips(17)

Snack(16)

Popcorn(12)

Pretzels(6)

Potato Chips(4)

Snack Bar(3)

Breakfast Biscuits(3)

Cereal Bar(2)

Nut Butter(2)

Trail Mix(2)

Apple Straw(1)

Veggie Straw(1)

Cookie(1)

Rice Krispy Treat(1)

Dried Fruit(1)

Puffed Rice(1)

Potato Chip(1)

Snack Mix(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved