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

Currently Filtered by

Category

Bathroom Cleaners

Refine Search

  GO
 
Brand

Tilex(4)

Clorox(2)

Green Works(2)

Method(2)

Seventh Generation Professional(2)

Scrubbing Bubbles(2)

Simple Green(2)

Kaboom(1)

Diversey(1)

LYSOL Brand(1)

 
Special Features

Value Pack-Stock up and save!(1)

 
Application

Tub/Tile/Shower/Grout Cleaner(8)

Bathroom Sinks; Countertops; Fixtures; Tubs; Tile(2)

Disinfectant/Cleaner(2)

Bathroom Cleaner(2)

Bathtubs; Sinks; Countertops(1)

Bathtubs; Floors; Showers; Urinals; Walls(1)

Bathroom Cleaning and Disinfection(1)

Bathrooms(1)

Sinks; Tiles; Tubs(1)

 
Applicable Material

Ceramic; Cement; Fiberglass; Glass; Grout; Laminates; Metal; Plastic; Vinyl(5)

Ceramic; Fiberglass; Grout; Laminates; Plastic; Polished Metal; Sealed Stone; Vinyl(3)

Ceramics; Enamel; Fiberglass; Laminates; Metal; Plastic; Sealed/Engineered Stone; Vinyl(2)

Ceramics; Enamel; Fiberglass; Finished/Sealed Wood; Laminates; Metal; Plastic; Sealed/Engineered Stone; Vinyl(2)

Ceramic; Plastic; Stainless Steel; Tile; Vinyl(2)

Ceramic; Chrome; Fiberglass; Vinyl(1)

Ceramic Tile; Chrome; Fiberglass; Porcelain; Quarry Tile; Stainless Steel(1)

Hard, Non-Porous Surfaces(1)

Counters; Porcelain(1)

Porcelain; Caulking; Counters; Faucets(1)

 
Dirt Types

Bacteria; Dust; Fungus; Germs; Grime; Mildew; Mold; Soap Scum; Soil(4)

Bacteria; Dust; Fungus; Germs; Grease; Grime; Mildew; Mineral Scale; Mold; Rust; Soap Scum; Soil(3)

Grease; Grime(2)

Mildew; Mold; Stains(2)

Dust;Grease;Grime(2)

Soap Scum; Hard Water Stains; Lime; Grease; Grime(1)

Fungus; Grime; Mildew; Mold(1)

Hard Water Deposits; Soap Scum(1)

Soap Scum; Mold; Mildew; Viruses; Bacteria(1)

Dirt; Soap Scum; Stains(1)

Dirt; Soap Scum; Stain(1)

 
Physical Form

Liquid(15)

Foam(2)

Spray(2)

 
Chemical Compound

D-Glucopyranose; Oligomers; Decyl Octyl Glycosides(2)

Didecyl Dimethyl Ammonium Chloride; Dioctyl Dimethyl Ammonium Chloride; Octyl Decyl Dimethyl Ammonium Chloride(1)

Natural Ingredients; Plant-Derived Surfactants(1)

 
Manufacturer Part Number

5703700071CT(1)

00008(1)

11101(1)

682264(1)

308469(1)

44728CT(1)

44722CT(1)

95026(1)

00008CT(1)

95325322(1)

00263(1)

35605(1)

35604CT(1)

35600EA(1)

35600CT(1)

01100(1)

00452CT(1)

00452(1)

11101CT(1)

 
Country of Origin

US(19)

 
Packing Type

Smart Tube Spray Bottle(5)

Bottle(5)

Spray Bottle(4)

Can(1)

Refill Bottle(1)

Aerosol(1)

Trigger Spray Bottle(1)

Aerosol Can(1)

 
Capacity (Volume)

32 oz(7)

1 gal(3)

19 oz(2)

24 oz(2)

28 oz(2)

16 oz(1)

128 oz(1)

25 oz(1)

 
Scent

Unscented(10)

Fresh(3)

Eucalyptus Mint(2)

Emerald Cypress & Fir(2)

Fresh Citrus(1)

Clean Fresh(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved