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`.`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)

Office Snax(10)

Kellogg's(10)

Sunshine(7)

Pop Secret(7)

Planters(6)

Keebler(5)

Paramount Farms(5)

Sahale Snacks(5)

Miss Vickie's(4)

popchips(4)

Austin(4)

Homefree(4)

Pepperidge Farm(3)

Chex Mix(3)

Pop Weaver(3)

KIND(3)

Walkers(3)

Cheetos(2)

Grandma's(2)

Stauffer's(2)

Food Should Taste Good(2)

Frito-Lay(2)

Snyder's(2)

Shultz(2)

Nutella(2)

Kar's(2)

Sqwincher(1)

Pirate's Booty(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)

Pringles(1)

Kettle Brand(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Utz(1)

 
Packing Type

Bag(64)

Pack(40)

Box(11)

Bar(5)

Tube Package(4)

Tub(4)

Canister(4)

Packs(4)

Tube(2)

Pouch(2)

Single-Serve Tub(2)

Yes(2)

Packets(2)

Packet(1)

Carton(1)

Single-Serve Bag(1)

Tin Container(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

Container(1)

 
Flavor

Original(16)

Chocolate Chip(6)

Peanut Butter(6)

Roasted & Salted(4)

Homestyle(3)

Sea Salt(3)

Original Marshmallow(3)

Chocolate(3)

Cheese(3)

Cocoa Roast Almonds(2)

Frosted Strawberry(2)

Cheddar Cheese(2)

All Natural Almonds(2)

Sriracha Cashews(2)

Dry Roasted Almonds(2)

Toast & Peanut Butter(2)

Cashews(2)

Jalapeno Cashews(2)

Natural Almonds(2)

White Cheddar(2)

Butter(2)

Movie Theater Butter(2)

Golden Oat(2)

Blueberry(2)

Hazelnut/Cocoa(2)

Extra Butter(2)

Assorted(2)

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

Danish Butter(1)

Light Butter(1)

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

Deluxe Nut Mix(1)

Pistachios(1)

Berry Mix(1)

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

Sesame Snax Mix(1)

Wasabi Party Mix(1)

Cinnamon/Honey(1)

Salted(1)

Cheddar(1)

Baked Cheddar(1)

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

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

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)

Barbecue(1)

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

Traditional(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

Cocoa Roasted Almonds(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Salt & Pepper Cashews(1)

Original Fig(1)

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

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Double Chocolate Chip(1)

Smokehouse BBQ(1)

Zesty Ranch(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)

Original Salty Cracker(1)

Frosted Blueberry(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)

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

00092(1)

1284253(1)

80314(1)

80401(1)

00082(1)

00087(1)

00089(1)

00095(1)

456268(1)

00096(1)

00097(1)

00098(1)

00679(1)

01021(1)

105510(1)

105511(1)

04738(1)

92268(1)

3598(1)

44375(1)

25726(1)

26678(1)

14672(1)

14867(1)

20871(1)

32430(1)

44366(1)

44441(1)

67652(1)

44443(1)

44446(1)

44451(1)

44458(1)

45095(1)

52347(1)

52546(1)

105512(1)

375(1)

98067CT(1)

11017(1)

01670(1)

07210(1)

07708(1)

884624(1)

06833(1)

06834(1)

011037(1)

900015(1)

00026(1)

900020(1)

900021(1)

900022(1)

900362(1)

1011039(1)

827582(1)

159200201(1)

00027(1)

77700(1)

53005(1)

072142WTV(1)

6270(1)

W-116(1)

W1537D(1)

04474(1)

042722C35S(1)

070146A25M(1)

072142A25X(1)

091842A25S(1)

72200(1)

601049(1)

00408(1)

1051900(1)

13539(1)

827562(1)

21812PK(1)

71100(1)

25719(1)

98067(1)

81233(1)

28783(1)

12592(1)

16686(1)

24680(1)

24696(1)

27182(1)

28781(1)

33364(1)

52220(1)

33625(1)

33664(1)

33725(1)

33825(1)

34325(1)

34325CT(1)

53664(1)

30357(1)

04068(1)

57706(1)

00176(1)

81237(1)

SN08361(1)

SN08387(1)

SN14839(1)

SN14858(1)

SN14868(1)

59636(1)

00470(1)

03745(1)

00798(1)

02104(1)

02908(1)

02908BX(1)

02946(1)

02946BX(1)

03744(1)

54325(1)

84170(1)

93646(1)

31032(1)

17120(1)

18251(1)

21163(1)

21165(1)

21167(1)

21771(1)

26547(1)

31731(1)

12653(1)

31732(1)

40975(1)

827544(1)

827545(1)

827548(1)

827553(1)

827695(1)

13189(1)

12233(1)

84325(1)

1160588(1)

86364(1)

89426(1)

93364(1)

93817(1)

93917(1)

94017(1)

94217(1)

01305(1)

122264(1)

01866(1)

01873(1)

01948(1)

01008(1)

10003(1)

10892(1)

12061(1)

827612(1)

 
Country of Origin

US(144)

IN(7)

GB(3)

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

2 oz(12)

1 oz(7)

5 oz(6)

2.5 oz(5)

1.75 oz(5)

1.25 oz(5)

1.76 oz(5)

3.2 oz(4)

0.7 oz(4)

1.8 oz(4)

0.8 oz(4)

1.38 oz(3)

32 oz(3)

24 oz(3)

0.62 oz(3)

0.63 oz(3)

3.25 oz(2)

44 oz(2)

1.1 oz(2)

3.67 oz(2)

3.75 oz(2)

1.4 oz(2)

1.2 oz(2)

3 oz(2)

1.44 oz(1)

5.5 oz(1)

34 oz(1)

4.9 oz(1)

2.17 oz(1)

12 oz(1)

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

2.2 oz(1)

26 oz(1)

1.02 oz(1)

58 oz(1)

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

15 oz(1)

16 oz(1)

1.75 oz; 1.5 oz(1)

50 oz(1)

38 oz(1)

1.7 oz(1)

22 oz(1)

3.39 oz(1)

0.95 oz(1)

0.2 oz(1)

.39 oz(1)

2.1 oz(1)

.78 oz(1)

0.74 oz(1)

1.3 oz(1)

48 oz(1)

40 oz(1)

2.4 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.56 oz(1)

0.9 oz(1)

 
Food Type

Nuts(38)

Cookies(30)

Crackers(20)

Snack(14)

Chips(14)

Popcorn(11)

Pretzels(6)

Potato Chips(4)

Breakfast Biscuits(3)

Pastry(3)

Snack Bar(3)

Nut Butter(2)

Cereal Bar(2)

Trail Mix(2)

Veggie Straw(1)

Rice Krispy Treat(1)

Dried Fruit(1)

Puffed Rice(1)

Potato Chip(1)

Snack Mix(1)

 
 
 

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