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)

Sunshine(7)

Kellogg's(7)

Planters(6)

Sahale Snacks(5)

Keebler(5)

Office Snax(5)

Pop Secret(4)

Miss Vickie's(4)

Paramount Farms(4)

popchips(4)

Homefree(3)

Pepperidge Farm(3)

Chex Mix(3)

Stacy's(2)

Frito-Lay(2)

Nutella(2)

Walkers(2)

Shultz(2)

Stauffer's(2)

Doritos(2)

Cheetos(2)

Austin(2)

Kar's(2)

Grandma's(2)

Food Should Taste Good(2)

Utz(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Kettle Brand(1)

Sqwincher(1)

Royal Dansk(1)

SunChips(1)

Lay's(1)

Rold Gold(1)

Tostitos(1)

Biscoff(1)

Annie's Homegrown(1)

Pop Weaver(1)

Dolcetto(1)

Pringles(1)

 
Packing Type

Bag(56)

Pack(38)

Box(8)

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

Peanut Butter(6)

Chocolate Chip(5)

Chocolate(3)

Sea Salt(3)

Roasted & Salted(3)

Cheese(3)

Original Marshmallow(3)

Nacho Cheese(2)

Sriracha Cashews(2)

Dry Roasted Almonds(2)

Jalapeno Cashews(2)

All Natural Almonds(2)

Cocoa Roast Almonds(2)

Cashews(2)

Movie Theater Butter(2)

Hazelnut/Cocoa(2)

Assorted(2)

White Cheddar(2)

Cheddar Cheese(2)

Golden Oat(2)

Blueberry(2)

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

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Cinnamon/Honey(1)

Extra Butter(1)

Berry Mix(1)

Salted(1)

Caramel(1)

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

Vanilla Cream(1)

Barbecue(1)

Raspberry Crumble Cashew Trail Mix(1)

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

Classic Fruit Nut(1)

Parmesan Garlic & Herb(1)

Tangerine Vanilla(1)

Danish Butter(1)

Nut & Chocolate(1)

Smokehouse BBQ(1)

Aged White Cheddar(1)

Baked Cheddar(1)

Tropical Fruit & Nut(1)

Barbeque; Sea Salt(1)

Sour Cream & Onion(1)

Salt & Pepper(1)

Mixed Nuts(1)

Honey Wheat(1)

Barbeque(1)

Shortbread Fingers(1)

Chocolate Chip Shortbread(1)

Dry Roasted & Salted(1)

Salted Nuts(1)

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

Mini Fudge Stripes(1)

Homestyle(1)

Butter(1)

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

Natural Almonds(1)

Salt & Pepper Cashews(1)

Cocoa Roasted Almonds(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Fig Newton(1)

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

Roasted & Salted Cashew Nuts(1)

Sea Salt and Pepper Cashews(1)

Frosted Strawberry(1)

Frosted Blueberry(1)

Cheddar(1)

Zesty Ranch(1)

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

Jalapeno(1)

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

Toast & Peanut Butter(1)

Cheese & Peanut Butter(1)

Vanilla(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Traditional(1)

Original Salty Cracker(1)

Reduced Fat(1)

Club & Cheddar Cheese(1)

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

Sea Salt & Vinegar(1)

 
Manufacturer Part Number

00073(2)

04738(1)

1284253(1)

80314(1)

456268(1)

92268(1)

52547(1)

62737(1)

80401(1)

00082(1)

3598(1)

375(1)

105512(1)

00679(1)

00092(1)

00095(1)

52546(1)

45095(1)

20871(1)

30501(1)

32430(1)

14867(1)

14672(1)

98067(1)

98067CT(1)

44366(1)

44375(1)

44458(1)

53005(1)

44451(1)

44446(1)

44441(1)

44443(1)

52347(1)

6270(1)

884624(1)

06833(1)

06834(1)

07708(1)

07210(1)

00027(1)

01670(1)

011037(1)

11017(1)

900362(1)

159200201(1)

827612(1)

900022(1)

900021(1)

900015(1)

900020(1)

00026(1)

77700(1)

072142A25X(1)

072142WTV(1)

091842A25S(1)

070146A25M(1)

04474(1)

W-116(1)

W1537D(1)

601049(1)

00408(1)

71100(1)

72200(1)

21812PK(1)

827562(1)

1051900(1)

13539(1)

93646(1)

827695(1)

12592(1)

27182(1)

28781(1)

30357(1)

52220(1)

03745(1)

04068(1)

28783(1)

33364(1)

34325(1)

34325CT(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)

53664(1)

54325(1)

17120(1)

18251(1)

21163(1)

12653(1)

12233(1)

12061(1)

122264(1)

21165(1)

21167(1)

40975(1)

827545(1)

31732(1)

31031(1)

21771(1)

26547(1)

10892(1)

10003(1)

89426(1)

93364(1)

93817(1)

86364(1)

84325(1)

57706(1)

84170(1)

93917(1)

94017(1)

01873(1)

01008(1)

01866(1)

01305(1)

94217(1)

1160588(1)

827553(1)

 
Country of Origin

US(125)

IN(7)

GB(2)

ID(2)

DE(1)

CA(1)

 
Capacity (Volume)

1.38 oz(4)

3 oz(1)

 
Capacity (Weight)

1.5 oz(23)

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)

0.8 oz(4)

1.8 oz(4)

0.62 oz(3)

0.63 oz(3)

3.25 oz(2)

44 oz(2)

3.67 oz(2)

1.4 oz(2)

24 oz(2)

32 oz(2)

3 oz(2)

1.2 oz(2)

3.75 oz(2)

1.1 oz(2)

38 oz(1)

2.32 oz(1)

40 oz(1)

1.75 oz; 1.5 oz(1)

0.7 oz(1)

12 oz(1)

15 oz(1)

58 oz(1)

0.22 oz(1)

1.02 oz(1)

16 oz(1)

2.2 oz(1)

1.44 oz(1)

0.74 oz(1)

1.38 oz(1)

0.56 oz(1)

3.2 oz(1)

2.4 oz(1)

1.7 oz(1)

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

5.5 oz(1)

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

0.2 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

2.875 oz(1)

48 oz(1)

1.3 oz(1)

0.39 oz(1)

.78 oz(1)

1.5 oz; 1.13 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(36)

Crackers(28)

Chips(24)

Cookies(22)

Nutrition & Snack Bars(8)

Popcorn(6)

Pretzels(5)

Nut Butters(2)

Fruit Snacks(1)

Frozen Treats(1)

Potato Chip(1)

Danish/Pastries(1)

Pastry(1)

Snack(1)

Snack Variety Packs(1)

 
 
 

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