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

Currently Filtered by

Category

Hand Sanitizer Refills

Refine Search

  GO
 
Brand

PURELL(21)

Scott(5)

Dial Professional(3)

Rubbermaid Commercial(2)

Georgia Pacific Professional(1)

 
Special Features

For Use with Dial Professional Duo Manual Dispenser(2)

Value Pack-Stock up and save!(2)

For ES6 Dispensers(1)

With Alcohol(1)

Foam Hand Sanitizer Refill-PURELL ADX-12T Dispensers(1)

Foam Hand Sanitizer Refill(1)

Gel Hand Sanitizer Refill-PURELL ADX-7T Dispensers(1)

For ES8 Dispenser(1)

For ES8 Dispensers(1)

Gel Hand Sanitizer Refill(1)

For Use with Dial Professional Duo Touch-Free Dispenser(1)

Gel Hand Sanitizer Refill-Contains aloe.(1)

Gel Hand Sanitizer Refill-Dries quickly with no sticky residue.(1)

For ES4 Dispensers(1)

Foam Hand Sanitizer Refill-PURELL LTX-12T Dispensers.(1)

Foam Hand Sanitizer Refill-PURELL LTX-12T Dispensers(1)

Gel Hand Sanitizer Refill-PURELL LTX-12T Dispensers(1)

Alcohol-Free Formula(1)

 
For Use With

Dial Duo Manual Dispensers(2)

PURELL 2120-06(2)

Kimberly-Clark Professional* Electronic Cassette Skin Care and Soap Dispensers(2)

PURELL ADX-7 dispensers (sold separately.)(2)

PURELL 2720-12(2)

Rubbermaid Commercial AutoFoam Dispenser RCP-RG750127(2)

PURELL ADX-12 or LTX-12 dispensers (sold separately.)(2)

2120-06(1)

PURELL ADX-12 dispensers (sold separately.)(1)

KLEENEX Hand Sanitizer Dispensers(1)

Kimberly-Clark Professional* Cassette Skin Care Dispensers(1)

PURELL LTX-7 Dispensers(1)

Pacific Blue Ultra Soap & Sanitizer Dispenser(1)

PURELL Bag-in-Box Dispensers(1)

800-mL Bag-in-Box Dispenser(1)

PURELL LTX-12 dispensers (sold separately.)(1)

PURELL ES4 Sanitizer Dispensers(1)

PURELL Hand Sanitizer ES8 Dispenser(1)

PURELL ES8 Sanitizer Dispensers(1)

Dial Duo Touch-Free Dispensers(1)

2720-12(1)

PURELL 5120-06(1)

PURELL CS4 Sanitizer Dispensers(1)

PURELL ES6 Sanitizer Dispensers(1)

 
Manufacturer Part Number

05085(1)

775402(1)

750591(1)

91590(1)

91560(1)

34700(1)

34643(1)

12977(1)

43337(1)

965712(1)

9656-06CT(1)

8805-03(1)

8704-04CT(1)

870304CT(1)

776002(1)

645402(1)

13425CT(1)

549104CT(1)

545704CT(1)

545604CT(1)

519203CT(1)

515103(1)

505402(1)

2156-08CT(1)

215604(1)

213708CT(1)

190502CT(1)

1904-02CT(1)

1903-02CT(1)

1304-03(1)

99153(1)

750593(1)

 
Country of Origin

US(30)

NL(2)

 
Color(s)

Clear(31)

White(1)

 
Packing Type

Refill(18)

Dispenser Refills(7)

Cartridge(3)

Cassette Refill(2)

Bottle(1)

Cassette(1)

 
Capacity (Volume)

1200 mL(10)

1,200 mL(5)

1000 mL(5)

700 mL(3)

1.2 L(2)

800 mL(2)

1,000 ml(2)

1100 mL(2)

1,200 ml(1)

 
Scent

Fragrance-Free(15)

Unscented(10)

Cranberry(3)

Fruity Cucumber(2)

Lemon(1)

 
Hand Sanitizers Type

Foam(18)

Gel(10)

Liquid(4)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved