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 ('60120')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 '%Plungers' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Plungers' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Plungers' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Plungers"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Plungers"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Plungers"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Plungers"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Plungers' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Plungers',`category_4` ='Plungers') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Plungers,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Plungers', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Plungers

Refine Search

  GO
 
Brand

Durable(17)

Durable Sherpa(1)

Fellowes(1)

 
For Use With

Durable InstaView Unit(2)

Durable 535710, 535810, 535900, 536000, 536100, 551500, 554100, 554200, 555200, 556900, 569800, 576200(1)

Durable 554200(1)

Durable 595010, 595110(1)

 
Mounting Details

Desktop(11)

Wall(4)

Desktop; Wall(1)

Free Standing(1)

 
Country of Origin

DE(14)

PL(2)

CN(2)

TW(1)

 
Height

16.5"(1)

13.88"(1)

13.5"(1)

13"(1)

5.1"(1)

18.63"(1)

 
Width

10"(2)

21.25"(1)

8.5"(1)

20.78"(1)

11.38"(1)

21.13"(1)

 
Depth

15.13"(1)

5.63"(1)

5.88"(1)

6"(1)

14.5"(1)

7.13"(1)

 
Color(s)

Gray(9)

Black(2)

Graphite(1)

Clear(1)

Gray/Black(1)

Blue/Gray; Clear(1)

Platinum(1)

 
Material(s)

Polypropylene(8)

Metal(4)

Polypropylene; PVC(1)

Heavy-Gauge Steel(1)

Fiber(1)

Plastic(1)

 
Sheet Capacity

20(12)

10(3)

40(1)

2(1)

24(1)

 
Compartment Width

8.5"(1)

 
Number of Compartments

10(13)

5(3)

20(1)

1(1)

12(1)

 
Compartment Height

11"(1)

 
Tilt (Degrees)

30; 60(2)

25 to 70(1)

45(1)

 
Border Color(s)

Black; Blue; Green; Red; Yellow(10)

Black(2)

Gray(2)

Assorted(1)

Blue/Gray(1)

 
Compartment Types

Double-Sided Letter(7)

Double-Sided Letter; Panels(3)

Pockets(1)

 
Compartment Size

Letter(14)

1"(1)

 
Index

Snap-On Index Tabs(1)

1/5 Cut Catalog Rack Index(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved