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','out_of_stock') 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(18)

Nabisco(17)

Kellogg's(9)

Sunshine(7)

Planters(6)

Keebler(5)

Office Snax(5)

Sahale Snacks(5)

popchips(4)

Paramount Farms(4)

Miss Vickie's(4)

Pop Secret(4)

Homefree(3)

Chex Mix(3)

Walkers(3)

Austin(3)

Pepperidge Farm(3)

Food Should Taste Good(2)

Nutella(2)

Pop Weaver(2)

Shultz(2)

Frito-Lay(2)

Grandma's(2)

Stauffer's(2)

Cheetos(2)

Snyder's(2)

Kar's(2)

Pirate's Booty(1)

Sqwincher(1)

Royal Dansk(1)

SkinnyPop Popcorn(1)

Annie's Homegrown(1)

Dolcetto(1)

Biscoff(1)

SunChips(1)

Stacy's(1)

Lay's(1)

Doritos(1)

Rold Gold(1)

Tostitos(1)

KIND(1)

Pringles(1)

Kettle Brand(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Utz(1)

 
Packing Type

Bag(56)

Pack(38)

Box(10)

Tube Package(4)

Tub(4)

Canister(4)

Packs(4)

Tube(2)

Pouch(2)

Single-Serve Tub(2)

Packets(2)

Bar(2)

Packet(1)

Carton(1)

Single-Serve Bag(1)

Tin Container(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

Yes(1)

Container(1)

 
Flavor

Original(16)

Peanut Butter(6)

Chocolate Chip(6)

Sea Salt(3)

Roasted & Salted(3)

Original Marshmallow(3)

Cheese(3)

Chocolate(3)

White Cheddar(2)

Dry Roasted Almonds(2)

Jalapeno Cashews(2)

Cheddar Cheese(2)

Movie Theater Butter(2)

Toast & Peanut Butter(2)

Butter(2)

Cocoa Roast Almonds(2)

Golden Oat(2)

Hazelnut/Cocoa(2)

All Natural Almonds(2)

Blueberry(2)

Frosted Strawberry(2)

Assorted(2)

Cashews(2)

Sriracha Cashews(2)

Danish Butter(1)

Extra Butter(1)

Cheddar(1)

Berry Mix(1)

Salted(1)

Honey Wheat(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)

Caramel(1)

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

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

Cinnamon/Honey(1)

Baked Cheddar(1)

Shortbread Fingers(1)

Nut & Chocolate(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)

Tropical Fruit & Nut(1)

Chocolate Chip Shortbread(1)

Sour Cream & Onion(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Vanilla Cream(1)

Aged White Cheddar(1)

Salt & Pepper(1)

Dry Roasted & Salted(1)

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

Frosted Blueberry(1)

Barbecue(1)

Fig Newton(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Salt & Pepper Cashews(1)

Natural Almonds(1)

Homestyle(1)

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

Vanilla Creme(1)

Roasted & Salted Cashew Nuts(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)

Cocoa Roasted Almonds(1)

Sea Salt and Pepper Cashews(1)

Smokehouse BBQ(1)

Multigrain with Sea Salt(1)

Sea Salt & Vinegar(1)

Jalapeno(1)

Nacho Cheese(1)

Chocolate Chip; Peanut Butter; Vanilla Creme; Oatmeal Raisin;Chocolate Brownie(1)

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

Zesty Ranch(1)

Mini Fudge Stripes(1)

Traditional(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

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

Reduced Fat(1)

Original Salty Cracker(1)

Vanilla(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

92268(1)

375(1)

3598(1)

105512(1)

105510(1)

01021(1)

00679(1)

00095(1)

00092(1)

00082(1)

80401(1)

80314(1)

1284253(1)

04738(1)

456268(1)

67652(1)

6270(1)

44375(1)

25719(1)

14672(1)

14867(1)

20871(1)

32430(1)

44366(1)

44441(1)

52546(1)

44443(1)

44446(1)

44451(1)

44458(1)

45095(1)

52347(1)

53005(1)

W-116(1)

98067(1)

900015(1)

07708(1)

884624(1)

06833(1)

06834(1)

011037(1)

11017(1)

900020(1)

01670(1)

900021(1)

900022(1)

900362(1)

1011039(1)

827582(1)

159200201(1)

07210(1)

00027(1)

W1537D(1)

00408(1)

04474(1)

070146A25M(1)

072142A25X(1)

072142WTV(1)

091842A25S(1)

601049(1)

1051900(1)

00026(1)

13539(1)

827562(1)

21812PK(1)

71100(1)

72200(1)

77700(1)

98067CT(1)

93646(1)

81233(1)

33364(1)

52220(1)

30357(1)

12592(1)

27182(1)

28781(1)

28783(1)

33625(1)

03745(1)

33664(1)

33725(1)

33825(1)

34325(1)

34325CT(1)

53664(1)

04068(1)

03744(1)

57706(1)

59636(1)

81237(1)

SN08361(1)

SN08387(1)

SN14839(1)

SN14858(1)

SN14868(1)

00176(1)

02946BX(1)

00470(1)

00798(1)

02104(1)

02908(1)

02908BX(1)

02946(1)

54325(1)

84170(1)

827695(1)

26547(1)

17120(1)

18251(1)

21163(1)

21165(1)

21167(1)

21771(1)

31032(1)

12233(1)

31731(1)

31732(1)

40975(1)

827545(1)

827548(1)

827553(1)

12653(1)

122264(1)

84325(1)

94217(1)

86364(1)

89426(1)

93364(1)

93817(1)

93917(1)

94017(1)

1160588(1)

12061(1)

01305(1)

01866(1)

01873(1)

01008(1)

10003(1)

10892(1)

827612(1)

 
Country of Origin

US(129)

IN(7)

GB(3)

ID(2)

DE(1)

CA(1)

 
Capacity (Volume)

1.38 oz(4)

3 oz(1)

 
Capacity (Weight)

1.5 oz(22)

2 oz(12)

1 oz(7)

5 oz(6)

1.75 oz(6)

1.76 oz(5)

1.25 oz(5)

2.5 oz(4)

1.8 oz(4)

0.8 oz(4)

0.62 oz(3)

0.63 oz(3)

1.38 oz(2)

3.25 oz(2)

3.67 oz(2)

24 oz(2)

3 oz(2)

1.1 oz(2)

32 oz(2)

0.7 oz(2)

3.75 oz(2)

1.2 oz(2)

1.4 oz(2)

44 oz(2)

2.17 oz(1)

4.9 oz(1)

38 oz(1)

2.2 oz(1)

50 oz(1)

12 oz(1)

1.44 oz(1)

1.02 oz(1)

1.75 oz; 1.5 oz(1)

58 oz(1)

16 oz(1)

15 oz(1)

40 oz(1)

1.3 oz(1)

2.32 oz(1)

0.2 oz(1)

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

5.5 oz(1)

1.7 oz(1)

2.4 oz(1)

0.56 oz(1)

3.2 oz(1)

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

0.39 oz(1)

0.22 oz(1)

.78 oz(1)

0.74 oz(1)

3.39 oz(1)

48 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

1.5 oz; 1.13 oz(1)

0.9 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(36)

Crackers(29)

Cookies(23)

Chips(22)

Nutrition & Snack Bars(8)

Popcorn(7)

Pretzels(6)

Nut Butters(2)

Pastry(2)

Pretzel(1)

Potato Chip(1)

Fruit Snacks(1)

Snack Bar(1)

Snack Variety Packs(1)

Snack(1)

Danish/Pastries(1)

Frozen Treats(1)

 
 
 

© 2020-2021 Desert West Office Supply, All Rights Reserved