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') 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(35)

Clorox(10)

Diversey(6)

Misty(2)

Professional LYSOL Brand(2)

Zep Commercial(2)

Scrubbing Bubbles(2)

Seventh Generation Professional(2)

Zep Professional(2)

Method(2)

The Works(2)

Franklin Cleaning Technology(2)

Easy Paks(2)

Boardwalk(1)

3M(1)

Rubbermaid Commercial(1)

Theochem Laboratories(1)

WD-40(1)

Green Works(1)

Mr. Clean(1)

 
Color

Green(1)

 
Recycled

No(1)

 
Packing Type

Bottle(28)

Angle-Neck Bottle(15)

Box(6)

Squeeze Bottle(5)

Angle-Necked Bottle(5)

Tablet(4)

Clip-On(4)

Block(3)

Packet(2)

Canister(1)

Bag(1)

Pack(1)

Spray Bottle(1)

Squirt Bottle(1)

 
Manufacturer Part Number

1038799(1)

96084(1)

98012(1)

98011EA(1)

98011(1)

96085PK(1)

96085(1)

96084PK(1)

96083EA(1)

98013(1)

96083(1)

96082EA(1)

96082(1)

92921(1)

92919CT(1)

92919(1)

92918CT(1)

98012EA(1)

98013EA(1)

90704PK(1)

44727EA(1)

1041410(1)

ZUATB32EA(1)

ZUATB32CT(1)

290088(1)

975(1)

696208PK(1)

696208(1)

44727CT(1)

98014(1)

4870108(1)

98726PK(1)

98726(1)

98016PK(1)

98015PK(1)

98015(1)

98014EA(1)

92918(1)

90704(1)

1038801(1)

31786(1)

914839(1)

5019237(1)

100925283(1)

04578(1)

31788EA(1)

31788(1)

31786EA(1)

31597EA(1)

990652EA(1)

30024PK(1)

30024CT(1)

00940CT(1)

00275(1)

00031EA(1)

00031CT(1)

ABCBX(1)

990652CT(1)

CBD539698(1)

89957PK(1)

74278CT(1)

88830PK(1)

83723(1)

83722(1)

83721(1)

80088EA(1)

79174PK(1)

74278EA(1)

39950(1)

CBD539698EA(1)

01221CT(1)

01221(1)

34764(1)

33302WKCT(1)

33302WK(1)

F270012CT(1)

F270012(1)

1041410EA(1)

 
Country of Origin

US(63)

HU(4)

MX(4)

PL(4)

CA(2)

United States(1)

 
Capacity (Volume)

24 oz(25)

32 oz(20)

24oz(9)

0.68 oz(4)

0.17 oz(2)

9 oz(1)

47.3 oz(1)

9.5 L(1)

 
Scent

Wintergreen(14)

Fresh(7)

Floral(5)

Unscented(5)

Cool Spring Breeze(5)

Slight Chlorine(4)

Ocean Fresh(4)

Atlantic Fresh(3)

Mint(3)

Pacific Breeze & Coconut(2)

Lavender Fields(2)

Emerald Cypress & Fir(2)

Country Scent(2)

Forest Rain(2)

Rainshower(2)

Tuscan Lavender & Jasmine(2)

Spearmint(2)

Lavender(2)

Original Fresh(1)

Cotton Lilac(1)

Original(1)

Citrus(1)

Floral Woody(1)

Lemon Breeze(1)

 
Dirt Types

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

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

Soils; Odors(7)

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

Toilet Rings; Toilet Stains(4)

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

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

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

Grease; Grime(2)

Odor; Soil(2)

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

Rust; Lime; Germs; Hard-Water Buildup(2)

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

Grime; Organic Matter; Soil; Stains(2)

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

Hard Water Stains; Limescale(1)

Bacteria; Uric Scale(1)

Fecal Matter; Limescale; Rust(1)

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

Odors; Stains(1)

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

Mildew; Mineral Scale, Organic Matter; Soil(1)

Rust; Uric Acid; Water-Based Soil(1)

Rust; Soil Buildup; Stains; Uric Acid; Water Deposits(1)

Food; Grease(1)

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

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

Hard Water Stains; Residue; Rust Stains(1)

 
Capacity (Weight)

1.37 oz(4)

3.5 oz(3)

1.41 oz(3)

0.5 oz(2)

1.25 oz(1)

 
Recommended Use

Mineral Deposit Remover(1)

Rust Remover(1)

Germs Remover(1)

Hard Water Remover(1)

 
Chemical Compound

Hydrochloric Acid(21)

Didecyl Dimethyl Ammonium Chloride; Dimethyl Benzyl Ammonium Chlorides; Dioctyl Dimethyl Ammonium Chloride; Glycolic Acid; N-Alkyl; Octyl Decyl Dimethyl Ammonium Chloride; Other Ingredients(4)

Sodium Hypochlorite(4)

Hydrogen Peroxide(4)

Sodium Dodecylbenzenesulfonate; Sodium Sulfate; Sodium Chloride(4)

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

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

Natural Ingredients; Plant-Derived Surfactants(2)

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

Glycerol(2)

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

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

1-bromo-3-chloro-5,5-dimethylhydantoin 51.0%, 1,3-dichloro-5,5-dimethylhydantoin 23.3%, 1,3-dichloro-5-ethyl-5-methylhydantoin 9.0%. Other ingredients: 16.7%. Available bromine 33.3%. Available chlorine 37.7%.(1)

Alcohols, C10-16, ethoxylated, sulfates, sodium salts;Benzenesulfonic acid, C10-13-alkyl derivs., sodium salts , hydrogen peroxide(1)

Hydrochloric acid(1)

Cocamidopropyl Betaine; Ethyl Alcohol; Sodium Dodecylbenzene Sulfonate; Sodium Lauryl Ether Sulfate; Sodium Xylene Sulfonate(1)

N-Alkyn; Dimethyl Benzyl Ammonium Chloride(1)

Citric acid, Caprylyl/capryl oligoglucoside(1)

Hydrochloric Acid; Hydrogen Chloride(1)

 
Cleaner Volume

0.25 gal (32 fl oz)(1)

 
Number of Tabs (Single-Use Packs)

2(2)

 
Cleaner Form

Ready-To-Use(1)

 
Product Type

Toilet Bowl Cleaner(1)

 
Packaged Quantity

1 Bottle(1)

 
Assembly Required

No(1)

 
Cleaner Type

Liquid(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved