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

Currently Filtered by

Category

Soap Dispensers

Refine Search

  GO
 
Brand

Boardwalk(3)

TOLCO(2)

LYSOL No-Touch(2)

Kimberly-Clark Professional*(2)

GOJO(2)

 
Height

5.41"(2)

11 3/4"(2)

12"(2)

9"(1)

9 1/4"(1)

11 20/29"(1)

9 3/10"(1)

11 7/10"(1)

 
Color(s)

White(5)

Black Pearl(2)

Black(1)

White/White(1)

Gray(1)

Brushed Chrome/Black(1)

 
Depth

4"(6)

3.66"(2)

3 1/4"(1)

6.625"(1)

18 7/10"(1)

 
Manufacturer Part Number

93205(1)

93205EA(1)

523155(1)

523195(1)

32504(1)

32499(1)

SH900SBBW(1)

SHF900SBBW(1)

8880-06(1)

8888-06(1)

8350(1)

 
Country of Origin

US(7)

CN(3)

TW(1)

 
Width

4.78"(2)

4 1/2"(2)

5 1/2"(2)

4"(1)

5 1/4"(1)

7 9/31"(1)

11 1/10"(1)

7 3/10"(1)

 
Material(s)

Plastic(8)

ABS; PP; PE; Rubber(1)

ABS; AS; Stainless Steel(1)

 
For Use With

Bulk Soaps(2)

GOJO ADX-12 Refills(2)

Bulk Foam Soap, Liquid/Lotion Soap or Sanitizer(2)

Lysol Healthy Touch Hand Soap Refill(2)

12979, 34643, 91590, 91591, 91592(1)

Boardwalk 1250 mL Refills(1)

Kleenex Alcohol Free Foam Hand Sanitizer; Kleenex Green Certified Foam Sanitizer; Kleenex Ultra* Moisturizing Foam Hand Sanitizer; Kleenex Ultra* Moisturizing Foam Hand Sanitizer; Kleenex Moisturizing Foam Hand Sanitizer; Kleenex Moisturizing Instant Hand Sanitizer; Kleenex Moisturizing Foam Hand Sanitizer; Kleenex Antibacterial Foam Skin Cleanser(1)

 
Capacity (Volume)

1250 mL(3)

8.5 oz(2)

1200 mL(2)

34 oz(1)

50 oz(1)

900 mL(1)

900 ml(1)

 
Weight

4.4 lbs(2)

6.9 lbs(1)

 
Mounting

Wall(9)

 
Dispenser Type

For Liquids(5)

Manual Foam(2)

Liquid, Manual(2)

Electronic Touchless(1)

Soap Dispenser(1)

 
Holds

LYSOL No-Touch Hand Soap Refills(2)

1200 mL Refills(1)

Refill(1)

Foam Soap(1)

Liquid/Lotion Soap or Hand Sanitizer(1)

 
 
 

© 2017-2018 Gateway Business Products, All Rights Reserved