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

Currently Filtered by

Category

Hand Sanitizer Dispensers

Refine Search
  GO
 
Brand

PURELL(28)

Boraxo(2)

HLS Commercial(2)

AbilityOne(2)

SC Johnson Professional(2)

BK Resources(1)

GN1(1)

PURELL®(1)

 
Size

3.79" x 17.68" x 9.18"(1)

 
For Use With

PURELL ES6 Hand Sanitizer Refills(3)

PURELL CS8 Hand Sanitizer Refills(3)

1902-02(2)

PURELL ES10 Refill 8351-02; 8353-02; 8357-02(2)

PURELL ES8 Hand Sanitizer Refills(2)

Boraxo Orange Heavy Duty Hand Cleaner Cartridges(2)

PURELL CS4 Hand Sanitizer Refills(2)

Gel Hand Sanitizer(1)

SC Johnson Professional 55857, IFC1L(1)

PURELL 8803-03, 8804-03, 8806-03, 8805-03(1)

PURELL 1,200-ml ADX-12 Refill(1)

PURELL 8704-04, 8705-04, 8706-04, 8703-04(1)

PURELL CS6 Hand Sanitizer Refills(1)

PURELL ES6 Dispenser Refills(1)

PURELL 1,200 mL Refill Cartridges(1)

PURELL ES4 Dispenser Refills(1)

PURELL ES4 Hand Sanitizer Refills(1)

PURELL ES4(1)

PURELL ES1 Sanitizer Refills(1)

PURELL CS2 Hand Sanitizer Refills(1)

0770-02(1)

PURELL LTX Dispensers; PURELL TFX Dispensers(1)

1303-03(1)

Hand Sanitizer(1)

SJN56827(1)

 
Form Factor

Floor(1)

 
Mounting Details

Wall(30)

Floor Stand(5)

Counter Top; Rail; Wall(1)

 
Country of Origin

US(27)

CN(9)

TW(1)

CA(1)

 
Height

12.13"(6)

10"(3)

15.64"(3)

9.25"(2)

10.5"(2)

10.31"(2)

6.75"(2)

28.5"(1)

17"(1)

63"(1)

11.25"(1)

11 1/4"(1)

9.75"(1)

51"(1)

51.57"(1)

10.81"(1)

11"(1)

5.81"(1)

10.58"(1)

8.62"(1)

51.63"(1)

11.38"(1)

 
Width

5.25"(6)

5.79"(3)

5.75"(3)

4.33"(2)

10.49"(2)

4.92"(2)

13"(2)

3.12"(1)

5.14"(1)

6.6"(1)

6.12"(1)

4.88"(1)

6.5"(1)

13.16"(1)

13.5"(1)

3.75"(1)

4 1/2"(1)

4.5"(1)

4.6"(1)

5.13"(1)

5"(1)

12"(1)

 
Depth

4"(7)

8.56"(6)

3.93"(3)

4.6"(2)

4.5"(2)

3.96"(2)

4.98"(2)

11.5"(1)

3.5"(1)

5"(1)

16.63"(1)

16"(1)

8.19"(1)

5.13"(1)

5.88"(1)

3.83"(1)

11.4"(1)

4.48"(1)

 
Color(s)

White(13)

Graphite(11)

Gray(3)

Blue(2)

Chrome/Black(2)

Silver(2)

Silver/White/Black(1)

White/Gray(1)

Chrome(1)

Dove Gray(1)

Silver/White(1)

 
Material(s)

Plastic(32)

Acrylic(2)

Plastic; Metal(1)

 
Quantity

1 each(2)

 
Mounting

Wall(1)

 
Holds

1,200 mL(23)

1,000 mL(6)

2 Liters(2)

700 mL(2)

450 mL(1)

1200 mL(1)

1 L(1)

1 Liter(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander