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

Currently Filtered by

Category

Toilet Bowl Cleaners

Refine Search

  GO
 
Brand

LYSOL Brand(20)

Clorox(5)

Diversey(5)

Scrubbing Bubbles(3)

Misty(2)

Method(2)

Professional LYSOL Brand(2)

Seventh Generation(2)

Zep(2)

Betco(1)

Boardwalk(1)

Maxim(1)

3M(1)

Seventh Generation Professional(1)

Theochem Laboratories(1)

 
Application

Toilet & Urinal Cleaner(19)

Bowl Cleaner(16)

Toilet Bowl(3)

Automatic Toilet Bowl Cleaner(3)

Toilets(3)

Toilet Bowls; Urinals(2)

Toilets; Urinals(1)

Bathroom Fixtures; Bathtubs; Countertops; Sinks; Toilet Bowls; Urinals; Tiles(1)

Toilets; Fixtures(1)

 
Applicable Material

Ceramics; Enamel; Metal(7)

Ceramics; Enamel; Fiberglass; Metal; Plastic; Vinyl(7)

Toilets; Urinals(6)

Bidets; Porcelain Surfaces; Toilets; Urinals(5)

Bidets; Toilets; Urinals(4)

Toilets, Urinals(3)

Ceramics; Enamel; Porcelain(2)

Porcelain(2)

Toilets,Urinals(2)

Ceramic Tile(2)

Hard, Non-Porous Surfaces(2)

Hard Surfaces; Toilets; Urinals(1)

Ceramic; Fiberglass; Metal; Plastic; Vinyl(1)

Ceramic; Fiberglass; Grout; Metal; Plastic(1)

Porcelain; Metal(1)

Non-Porous Surfaces(1)

 
Dirt Types

Grime; Mildew; Mineral Scale; Mold; Organic Matter; Soil; Stains(9)

Bacteria; Fungus; Germs; Grime; Lime; Mildew; Mineral Scale; Mold; Organic Matter; Rust; Soil; Stains(4)

Soils; Odors(3)

Grime; Lime; Mineral Scale; Organic Matter; Rust; Soil; Stains(3)

Bacteria; Limescale; Rust; Soap Scum; Toilet Bowl Rings; Viruses(3)

Bacteria; Grime; Mildew; Mineral Scale; Mold; Organic Matter; Rust; Soil; Stains(2)

Hard Water Stains; Limescale; Rust Stains(2)

Rust(2)

Grime; Mildew; Mineral Scale, Mold; Organic Matter; Soil(2)

Grime; Mildew; Mineral Scale; Mold; Organic Matter; Rust; Soil; Stains(2)

Odor; Soil(2)

Bacteria; Germs; Grime; Mildew; Mineral Scale; Mold; Organic Matter; Rust; Soil; Stains; Viruses(2)

Grease; Grime(2)

Rust; Scale; Stains(2)

Mineral Deposits; Rust; Scale; Soils(1)

Scale; Rust; Algae; Calcium Deposits(1)

Bacteria; Dust; Fungus; Germs; Grime; Mildew; Mold; Organic Matter; Viruses; Water-Based Soil(1)

Bacteria; Viruses; Toilet Bowl Rings; Soap Scum; Limescale; Rust(1)

Bacteria; Fungus; Germs; Grime; Mildew; Mold; Organic Matter; Soil; Stains(1)

Bacteria; Soil; Fungus; Germs; Grime; Mildew; Mold; Organic Matter; Stains(1)

Rust stains; Lime Scale; Uric Acid; Other Mineral Deposits; Pseudomonas Aeruginosa; Staphylococcus Aureus; Salmonella Choleraesuis(1)

Mineral Scale; Soil(1)

 
Physical Form

Liquid(36)

Gel(6)

Solid(5)

Solid Gel(2)

 
Volume Capacity

24 oz(20)

32 oz(14)

24oz(4)

9 oz(1)

47.3 oz(1)

 
Chemical Compound

Hydrochloric Acid(16)

Hydrogen Peroxide(4)

Sodium Hypochlorite(4)

Sodium C14-16 Olefin Sulfonate; Sodium Dodecylbenzenesulfonate(3)

1-bromo-3-chloro-5,5-dimethylhydantoin 51.0%(2)

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

C16-18 and C18-unsatd., ethoxylated, Glycerin(2)

Alkyl (C14 50%, C12 40%, C16 10%) Dimethyl Benzyl Ammonium Chloride(2)

Water; Lactic Acid; Octyl/Decyl Glucoside; Xanthan Gum; Sodium Benzoate; Fragrance(2)

Amines; Tallow Alkyl; Ethoxylated, Dodecyldimethylamine Oxide(2)

N-Alkyn; Dimethyl Benzyl Ammonium Chloride(1)

Oxalic Acid(1)

Natural Ingredients; Plant-Derived Surfactants(1)

Sodium Hypochlorite; Water; Sodium Hydroxide; Sodium Silicate; Alkyl Dimethyl Amine Oxide; Sodium Laureth Sulfate; Sodium Ethylhexyl Sulfate; Alkyl Dimethyl Betaines; Fragrances(1)

 
Country of Origin

US(42)

MX(5)

CA(2)

 
Packing Type

Bottle(2)

 
Capacity (Volume)

24 oz(1)

32 oz(1)

 
Scent

Atlantic Fresh(6)

Clean Scent(4)

Unscented(4)

Mint(4)

Wintergreen(3)

Ocean Fresh(3)

Rainshower(3)

Fresh(3)

Spearmint(2)

Floral(2)

Ocean Fresh Scent(2)

Forest Rain Scent(2)

Fresh Mint(2)

Citrus(1)

Minty(1)

Lemon Breeze(1)

Lavender Fields(1)

Mint-Wintergreen(1)

Emerald Cypress & Fir(1)

Cotton Lilac(1)

 
Capacity (Weight)

1.41 oz(3)

3.5 oz(2)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved