facebook
 
 
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_name` IN ('Changing Table Accessories','Changing Tables','Toilet Bowl Deodorizers','Plungers','Urinal Screens & Deodorizers','Hand Dryers','Touchless Valves & Faucets')) 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 '%RestroomSupplies' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('RestroomSupplies' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+RestroomSupplies' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"RestroomSupplies"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"RestroomSupplies"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"RestroomSupplies"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"RestroomSupplies"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+RestroomSupplies' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='RestroomSupplies',`category_4` ='RestroomSupplies') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'RestroomSupplies,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('RestroomSupplies', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Restroom Supplies

Refine Search

  GO
 
Brand

Genuine Joe(25)

Impact Products(9)

ActiveAire(6)

ECR4KIDS(1)

Z-Mat(1)

 
Color

Blue(14)

Yellow(5)

Black(4)

White(3)

Pink(3)

Green(2)

Purple(2)

Citrus(2)

Red(2)

Dark Blue(2)

Orange(1)

 
Recycled

No(40)

 
Height

0.4"(8)

0.5"(3)

0.2"(3)

19"(1)

8"(1)

18"(1)

11.8"(1)

12"(1)

8.5"(1)

 
Depth

9"(4)

7.9"(2)

4"(1)

6"(1)

 
Diameter

7"(4)

8"(2)

 
Manufacturer Part Number

ELR-18004(1)

48275(1)

85157(1)

85157CT(1)

48260(1)

48261(1)

48265(1)

48270(1)

48271(1)

1170(1)

85156(1)

1451DZ94(1)

1451DZ94CT(1)

15255(1)

25130288(1)

9205(1)

9205CT(1)

9587(1)

9594(1)

85156CT(1)

85155CT(1)

58330(1)

58335(1)

58330CT(1)

58331(1)

58332(1)

58332CT(1)

58333(1)

58333CT(1)

58334(1)

58334CT(1)

58335CT(1)

85155(1)

58336(1)

58336CT(1)

85130(1)

85130CT(1)

85137(1)

85137CT(1)

85154(1)

85154CT(1)

9594CT(1)

 
Country of Origin

United States(34)

Mexico(6)

China(2)

 
Width

7"(4)

8.8"(3)

7.9"(3)

17.5"(2)

35.5"(1)

8"(1)

20.4"(1)

7.5"(1)

12.1"(1)

35.6"(1)

 
Material

Vinyl(3)

Virgin Vinyl(2)

Polyethylene(2)

Plastic(1)

Felt(1)

Paper(1)

 
Limited Warranty

2 Year(1)

 
Weight (Approximate)

1 lb(2)

3.50 oz(2)

4 lb(1)

 
Length

0.5"(4)

20.4"(2)

23"(2)

25"(2)

8"(1)

8.7"(1)

12.1"(1)

17.6"(1)

 
Maximum Load Capacity

100 lb(1)

 
Certifications & Standards

VOC Compliant(5)

VOC(4)

 
Backing Type

Poly(1)

 
Replacement

Lasts up to 30 Day(15)

Lasts up to 45 Day(4)

Lasts up to 6 Week(3)

Lasts up to 30(1)

 
Product Type

Urinal Screen(25)

Deodorant Block(6)

Plunger(4)

Urinal Mat(3)

Baby Changing Station(1)

Restroom Mat(1)

Changing Table(1)

Changing Table Liner(1)

 
Packaged Quantity

12 / Box(8)

12 / Carton(7)

1 Each(6)

72 / Carton(6)

6 / Carton(4)

12 / Dozen(4)

36 / Carton(4)

144 / Carton(2)

500 / Carton(1)

 
Assembly Required

No(41)

 
Product Line

Eclipse(8)

 
Color/Finish

Gray(1)

 
Fragrance

Cherry(5)

Spice(2)

Green Apple(2)

Bubblegum(2)

Citrus Grove(2)

Cucumber Melon(2)

Lavender Fields(2)

Ocean Breeze(2)

Coastal Breeze(2)

Sunscape(2)

Citrus(2)

Camphor Cherry(2)

Apple Green(1)

Apple(1)

Fresh Blast(1)

Camphor(1)