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_27` 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®(8)

Sunshine®(7)

Planters®(6)

Office Snax®(6)

Keebler®(5)

Sahale Snacks®(5)

popchips®(4)

Miss Vickie's®(4)

Pop Secret®(4)

Paramount Farms®(4)

Homefree®(3)

Chex Mix®(3)

Pepperidge Farm®(3)

Shultz(2)

Nutella®(2)

Walkers(2)

Frito-Lay(2)

Stauffer's®(2)

Grandma's®(2)

Kar's(2)

Pop Weaver(2)

Food Should Taste Good™(2)

Cheetos®(2)

Austin®(2)

Utz®(1)

Royal Dansk®(1)

Pirate's Booty®(1)

SkinnyPop® Popcorn(1)

Snyder's®(1)

Sqwincher®(1)

Lay's®(1)

Pringles®(1)

Tostitos®(1)

Kettle® Brand(1)

Sensible Portions®(1)

General Mills(1)

Knott's Berry Farm®(1)

Rold Gold®(1)

Doritos®(1)

SunChips®(1)

Biscoff(1)

Doritos(1)

Stacy's®(1)

Annie's Homegrown(1)

Dolcetto®(1)

 
Packing Type

Bag(57)

Pack(38)

Box(9)

Tube Package(4)

Tub(4)

Canister(3)

Packs(3)

Single-Serve Tub(2)

Tube(2)

Pouch(2)

Packets(2)

Can(1)

Resealable Bag in Box(1)

Jar(1)

Container(1)

Packet(1)

Yes(1)

Carton(1)

Bar(1)

Single-Serve Bag(1)

Tin Container(1)

 
Flavor

Original(15)

Peanut Butter(6)

Chocolate Chip(5)

Chocolate(3)

Original Marshmallow(3)

Cheese(3)

Sea Salt(3)

Roasted & Salted(3)

Cocoa Roast Almonds(2)

Butter(2)

Dry Roasted Almonds(2)

Movie Theater Butter(2)

Cheddar Cheese(2)

Sriracha Cashews(2)

Jalapeno Cashews(2)

Blueberry(2)

Nacho Cheese(2)

Cashews(2)

White Cheddar(2)

Hazelnut/Cocoa(2)

Assorted(2)

All Natural Almonds(2)

Golden Oat(2)

Honey Wheat(1)

Danish Butter(1)

Extra Butter(1)

Cinnamon/Honey(1)

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

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

Lays® Classic;Doritos® Nacho Cheese;Cheetos® Original;Fritos® Original; Lays® BBQ;Doritos® Cool Ranch(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)

Salted(1)

Shortbread Fingers(1)

Berry Mix(1)

Baked Cheddar(1)

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

Salted Nuts(1)

Mixed Nuts(1)

Tangerine Vanilla(1)

Honey Glazed Almond(1)

Raspberry Crumble Cashew Trail Mix(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Nut & Chocolate(1)

Tropical Fruit & Nut(1)

Aged White Cheddar(1)

Salt & Pepper(1)

Dry Roasted & Salted(1)

Vanilla Cream(1)

Barbeque; Sea Salt(1)

Sour Cream & Onion(1)

Barbeque(1)

Chocolate Chip Shortbread(1)

Mini Fudge Stripes®(1)

Natural Almonds(1)

Homestyle(1)

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

Salt & Pepper Cashews(1)

Deluxe Mixed Nuts(1)

Roasted & Salted Cashew Nuts(1)

Cocoa Roasted Almonds(1)

Walnuts and Almonds(1)

Original Fig(1)

Vanilla Crème(1)

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

Sweet Potato with Sea Salt(1)

Multigrain with Sea Salt(1)

Sweet 'N Salty Mix(1)

Cheddar Mix(1)

Raspberry(1)

Traditional Mix(1)

Sea Salt and Pepper Cashews(1)

Traditional(1)

Zesty Ranch(1)

Frosted Strawberry(1)

Frosted Blueberry(1)

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

Jalapeno(1)

Smokehouse BBQ(1)

Sea Salt & Vinegar(1)

Cheddar(1)

Toast & Peanut Butter(1)

Original Salty Cracker(1)

Vanilla(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Reduced Fat(1)

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

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

Barbecue(1)

 
Manufacturer Part Number

00073(2)

80314(1)

80401(1)

00082(1)

1284253(1)

04738(1)

92268(1)

456268(1)

00089(1)

00095(1)

3598(1)

375(1)

53005(1)

105512(1)

105510(1)

67652(1)

00679(1)

00092(1)

62737(1)

32430(1)

44366(1)

44375(1)

20871(1)

14867(1)

98067CT(1)

14672(1)

44441(1)

44443(1)

52347(1)

52546(1)

45095(1)

44458(1)

44446(1)

44451(1)

6270(1)

W-116(1)

06833(1)

06834(1)

011037(1)

884624(1)

07708(1)

01670(1)

07210(1)

11017(1)

900015(1)

827582(1)

159200201(1)

827612(1)

900362(1)

900022(1)

900020(1)

900021(1)

00027(1)

00026(1)

072142WTV(1)

091842A25S(1)

601049(1)

072142A25X(1)

070146A25M(1)

W1537D(1)

04474(1)

00408(1)

1051900(1)

72200(1)

77700(1)

71100(1)

21812PK(1)

13539(1)

827562(1)

98067(1)

93646(1)

12592(1)

27182(1)

28781(1)

30357(1)

52220(1)

03745(1)

04068(1)

28783(1)

33364(1)

34325(1)

34325CT(1)

53664(1)

33825(1)

33725(1)

33625(1)

33664(1)

03744(1)

02946BX(1)

SN14839(1)

SN14858(1)

SN14868(1)

SN08387(1)

SN08361(1)

81233(1)

81237(1)

59636(1)

00176(1)

02908BX(1)

02946(1)

02908(1)

02104(1)

00470(1)

00798(1)

54325(1)

57706(1)

18251(1)

21163(1)

21165(1)

17120(1)

12653(1)

122264(1)

12233(1)

21167(1)

21771(1)

827545(1)

827553(1)

40975(1)

31732(1)

26547(1)

31031(1)

12061(1)

10892(1)

93364(1)

93817(1)

93917(1)

89426(1)

86364(1)

84170(1)

84325(1)

94017(1)

94217(1)

01008(1)

10003(1)

01873(1)

01866(1)

1160588(1)

01305(1)

827695(1)

 
Country of Origin

US(127)

IN(7)

GB(2)

ID(2)

DE(1)

CA(1)

 
Capacity (Volume)

1.375 oz(4)

3 oz(1)

1 oz(1)

 
Capacity (Weight)

1.5 oz(22)

2 oz(12)

1 oz(7)

1.75 oz(6)

5 oz(6)

1.76 oz(5)

1.25 oz(5)

2.5 oz(4)

0.8 oz(4)

1.8 oz(4)

0.62 oz(3)

0.63 oz(3)

3.75 oz(2)

32 oz(2)

3.25 oz(2)

24 oz(2)

3.67 oz(2)

3 oz(2)

1.4 oz(2)

44 oz(2)

1.2 oz(2)

1.1 oz(2)

38 oz(1)

40 oz(1)

26 oz(1)

0.7 oz(1)

2.17 oz(1)

1.02 oz(1)

16 oz(1)

1.75 oz; 1.5 oz(1)

0.9 oz(1)

15 oz(1)

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

1.44 oz(1)

2.2 oz(1)

58 oz(1)

12 oz(1)

3.71 oz(1)

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

0.2 oz(1)

.39 oz(1)

5.5 oz(1)

3.2 oz(1)

2.4 oz(1)

1.7 oz(1)

0.56 oz(1)

.78 oz(1)

0.74 oz(1)

2.875 oz(1)

1.5 oz; 1.13 oz(1)

0.22 oz(1)

1.5 oz; 2 oz(1)

1.38 oz(1)

1.3 oz(1)

48 oz(1)

2.32 oz(1)

 
Food Type

Nuts(33)

Cookies(27)

Crackers(19)

Chips(15)

Snack(13)

Popcorn(7)

Pretzels(5)

Potato Chips(4)

Breakfast Biscuits(3)

Nut Butter(2)

Trail Mix(2)

Pastry(2)

Cereal Bar(2)

Potato Chip(1)

Snack Mix(1)

Rice Krispy Treat(1)

Veggie Straw(1)

Dried Fruit(1)

Puffed Rice(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved