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','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 '%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(23)

Scott(5)

Dial Professional(3)

Rubbermaid Commercial(2)

Dial(1)

Georgia Pacific Professional(1)

 
Special Features

For Use with Dial Professional Duo Manual Dispenser(2)

Value Pack-Stock up and save!(2)

For PURELL 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)

For ES6 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 PURELL Dispenser 2720-12(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

PURELL 2720-12(3)

ES6 Sanitizer Dispensers(2)

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

PURELL 2120-06(2)

PURELL 9621-12(2)

PURELL ADX-7 Dispensers(1)

Rubbermaid Commercial AutoFoam Dispenser RCP-RG750127(1)

KLEENEX Hand Sanitizer Dispensers(1)

Kimberly-Clark Professional* 92144, 92145(1)

Kimberly-Clark Professional* 32499, 32504, 32508, 11329, 92147, 92148(1)

Scott 92144, 92145(1)

Georgia Pacific Professional 53590(1)

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

PURELL ADX-7 dispensers(1)

Dial Professional Duo Manual Dispenser(1)

PURELL Hand Sanitizer ES8 Dispenser(1)

ES8 Sanitizer Dispensers(1)

Dial Duo Manual Dispensers(1)

2720-12(1)

PURELL 5120-06(1)

5110-01; 5121-01; 5124-01(1)

ES4 Sanitizer Dispensers(1)

2120-06(1)

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

PURELL 1320-04, 1328-05(1)

Dial Professional Duo Touch-Free Dispenser(1)

RCP-RG750127; RCP-750411(1)

 
Manufacturer Part Number

01203(1)

965712(1)

775402(1)

776002(1)

870304CT(1)

8704-04CT(1)

8805-03(1)

9656-06CT(1)

43337(1)

645302(1)

12977(1)

34643(1)

34700(1)

91560(1)

91590(1)

750591(1)

645402(1)

549104CT(1)

05085(1)

213708CT(1)

13425CT(1)

99153(1)

1304-03(1)

1903-02CT(1)

1904-02CT(1)

190502CT(1)

215604(1)

545704CT(1)

2156-08CT(1)

505402(1)

515103(1)

519203CT(1)

5384-02(1)

545604CT(1)

750593(1)

 
Country of Origin

US(33)

NL(2)

 
Color(s)

Clear(34)

White(1)

 
Packing Type

Refill(19)

Dispenser Refills(8)

Cartridge(3)

Cassette Refill(2)

Flip-Top Bottle(1)

Bottle(1)

Cassette(1)

 
Capacity (Volume)

1200 mL(9)

1,200 mL(8)

1000 mL(5)

700 mL(3)

1.2 L(2)

800 mL(2)

1,000 ml(2)

1100 mL(2)

2 oz(1)

1,200 ml(1)

 
Scent

Fragrance-Free(16)

Unscented(9)

Cranberry(3)

Fruity Cucumber(2)

Light Citrus(1)

Fragrance Free(1)

Clean Scent(1)

Lemon(1)

 
Hand Sanitizers Type

Foam(20)

Gel(11)

Liquid(4)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved