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)

Sunshine(7)

Kellogg's(7)

Planters(6)

Keebler(5)

Office Snax(5)

Sahale Snacks(5)

Pop Secret(4)

Paramount Farms(4)

popchips(4)

Miss Vickie's(4)

Homefree(3)

Chex Mix(3)

Pepperidge Farm(3)

Stauffer's(2)

Food Should Taste Good(2)

Nutella(2)

Walkers(2)

Frito-Lay(2)

Grandma's(2)

Cheetos(2)

Austin(2)

Shultz(2)

Kar's(2)

Pirate's Booty(1)

SkinnyPop Popcorn(1)

Royal Dansk(1)

Annie's Homegrown(1)

Doritos(1)

Pop Weaver(1)

Dolcetto(1)

Biscoff(1)

Stacy's(1)

Lay's(1)

Rold Gold(1)

Tostitos(1)

Pringles(1)

Kettle Brand(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Sqwincher(1)

 
Packing Type

Bag(53)

Pack(38)

Box(7)

Tube Package(4)

Tub(4)

Canister(3)

Packs(3)

Tube(2)

Single-Serve Tub(2)

Pouch(2)

Packets(2)

Bar(1)

Carton(1)

Yes(1)

Single-Serve Bag(1)

Tin Container(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

Packet(1)

 
Flavor

Original(13)

Peanut Butter(6)

Chocolate Chip(5)

Sea Salt(3)

Roasted & Salted(3)

Cheese(3)

Chocolate(3)

Original Marshmallow(3)

Cocoa Roast Almonds(2)

Cheddar Cheese(2)

Sriracha Cashews(2)

White Cheddar(2)

Dry Roasted Almonds(2)

Jalapeno Cashews(2)

Movie Theater Butter(2)

All Natural Almonds(2)

Cashews(2)

Golden Oat(2)

Blueberry(2)

Hazelnut/Cocoa(2)

Assorted(2)

Caramel(1)

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

Shortbread Fingers(1)

BBQ; Cheddar & Sour Cream; Classic; Sour Cream & Onion;Crunchy(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)

Danish Butter(1)

Salted(1)

Cinnamon/Honey(1)

Extra Butter(1)

Berry Mix(1)

Chocolate Chip Shortbread(1)

Cheddar(1)

Dry Roasted & Salted(1)

Mixed Nuts(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)

Nut & Chocolate(1)

Salt & Pepper(1)

Tropical Fruit & Nut(1)

Sour Cream & Onion(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Barbecue(1)

Aged White Cheddar(1)

Vanilla Cream(1)

Toast & Peanut Butter(1)

Smokehouse BBQ(1)

Fig Newton(1)

Deluxe Mixed Nuts(1)

Salt & Pepper Cashews(1)

Natural Almonds(1)

Homestyle(1)

Butter(1)

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

Vanilla Creme(1)

Cocoa Roasted Almonds(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)

Walnuts and Almonds(1)

Roasted & Salted Cashew Nuts(1)

Sea Salt & Vinegar(1)

Multigrain with Sea Salt(1)

Jalapeno(1)

Nacho Cheese(1)

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

Zesty Ranch(1)

Frosted Strawberry(1)

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

Sea Salt and Pepper Cashews(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)

Traditional(1)

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

52546(1)

375(1)

3598(1)

105512(1)

00679(1)

00095(1)

00092(1)

00082(1)

80401(1)

80314(1)

1284253(1)

04738(1)

456268(1)

92268(1)

52347(1)

6270(1)

45095(1)

44458(1)

44451(1)

44446(1)

44443(1)

44441(1)

44375(1)

44366(1)

32430(1)

20871(1)

14867(1)

14672(1)

98067CT(1)

98067(1)

53005(1)

W-116(1)

827695(1)

00027(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

11017(1)

011037(1)

06834(1)

06833(1)

884624(1)

07708(1)

07210(1)

01670(1)

00026(1)

W1537D(1)

77700(1)

72200(1)

71100(1)

21812PK(1)

827562(1)

13539(1)

1051900(1)

00408(1)

601049(1)

091842A25S(1)

072142WTV(1)

072142A25X(1)

070146A25M(1)

04474(1)

93646(1)

827553(1)

81233(1)

03744(1)

33825(1)

33725(1)

33664(1)

33625(1)

33364(1)

28783(1)

28781(1)

27182(1)

12592(1)

30357(1)

52220(1)

04068(1)

03745(1)

02946BX(1)

34325CT(1)

02946(1)

02908BX(1)

02908(1)

02104(1)

00798(1)

00470(1)

00176(1)

59636(1)

SN14868(1)

SN14858(1)

SN14839(1)

SN08387(1)

SN08361(1)

81237(1)

34325(1)

53664(1)

827545(1)

10003(1)

40975(1)

31732(1)

26547(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

17120(1)

12653(1)

12233(1)

122264(1)

12061(1)

10892(1)

01008(1)

54325(1)

01873(1)

01866(1)

01305(1)

1160588(1)

94217(1)

94017(1)

93917(1)

93817(1)

93364(1)

89426(1)

86364(1)

84325(1)

84170(1)

57706(1)

159200201(1)

 
Country of Origin

US(120)

IN(7)

ID(2)

GB(2)

DE(1)

CA(1)

 
Capacity (Volume)

1.38 oz(4)

3 oz(1)

 
Capacity (Weight)

1.5 oz(21)

2 oz(12)

1 oz(7)

1.75 oz(6)

5 oz(6)

1.25 oz(5)

1.76 oz(5)

2.5 oz(4)

1.8 oz(4)

0.8 oz(4)

0.63 oz(3)

0.62 oz(3)

1.4 oz(2)

3 oz(2)

3.25 oz(2)

32 oz(2)

3.75 oz(2)

24 oz(2)

1.1 oz(2)

1.2 oz(2)

1.44 oz(1)

15 oz(1)

12 oz(1)

2.2 oz(1)

44 oz(1)

58 oz(1)

0.7 oz(1)

0.22 oz(1)

16 oz(1)

38 oz(1)

40 oz(1)

1.02 oz(1)

2.32 oz(1)

0.74 oz(1)

1.5 oz; 1.13 oz(1)

3.2 oz(1)

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

5.5 oz(1)

1.7 oz(1)

2.4 oz(1)

1.38 oz(1)

0.56 oz(1)

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

1.5 oz; 2 oz(1)

0.2 oz(1)

0.39 oz(1)

.78 oz(1)

1.3 oz(1)

3.67 oz(1)

48 oz(1)

3.71 oz(1)

1.75 oz; 1.5 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(36)

Crackers(28)

Cookies(22)

Chips(20)

Nutrition & Snack Bars(8)

Popcorn(6)

Pretzels(5)

Nut Butters(2)

Danish/Pastries(1)

Snack(1)

Snack Variety Packs(1)

Fruit Snacks(1)

Potato Chip(1)

Frozen Treats(1)

 
 
 

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