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(27)

Clorox(12)

Diversey(7)

Misty(2)

Franklin Cleaning Technology(2)

The Works(2)

Method(2)

Professional LYSOL Brand(2)

Seventh Generation Professional(2)

Scrubbing Bubbles(2)

Boardwalk(1)

3M(1)

Theochem Laboratories(1)

WD-40(1)

Zep Commercial(1)

Zep Professional(1)

 
Packing Type

Bottle(27)

Angle-Neck Bottle(15)

Tablet(6)

Squeeze Bottle(6)

Box(4)

Angle-Necked Bottle(3)

Block(3)

Canister(1)

Spray Bottle(1)

 
Manufacturer Part Number

1038799(1)

98013(1)

92918CT(1)

92919(1)

92919CT(1)

96084(1)

96084PK(1)

96085(1)

96085PK(1)

96307(1)

96308(1)

98011(1)

98011EA(1)

98012(1)

98012EA(1)

98013EA(1)

83723(1)

98014(1)

98014EA(1)

98015(1)

98015PK(1)

98016PK(1)

98726(1)

98726PK(1)

44727CT(1)

44727EA(1)

696208(1)

696208PK(1)

975(1)

290088(1)

ZUATB32CT(1)

92918(1)

83722(1)

1038801(1)

04578(1)

ABCBX(1)

00031CT(1)

00031EA(1)

00275(1)

00940CT(1)

30024CT(1)

30024PK(1)

30176(1)

30176CT(1)

31786(1)

31786EA(1)

31788(1)

31788EA(1)

04560(1)

100925283(1)

83721(1)

5019237(1)

94476081(1)

CBD539698(1)

CBD539698EA(1)

F270012(1)

F270012CT(1)

33302WK(1)

33302WKCT(1)

34764(1)

01221(1)

01221CT(1)

74278CT(1)

74278EA(1)

75055CT(1)

1041410(1)

 
Country of Origin

US(57)

MX(4)

HU(3)

CA(2)

 
Capacity (Volume)

24 oz(26)

32 oz(20)

24oz(5)

0.68 oz(4)

9 oz(1)

47.3 oz(1)

 
Scent

Wintergreen(10)

Fresh(6)

Slight Chlorine(5)

Unscented(5)

Floral(5)

Cool Spring Breeze(4)

Lavender Fields(3)

Emerald Cypress & Fir(2)

Country Scent(2)

Ocean Fresh(2)

Atlantic Fresh(2)

Spearmint(2)

Mint(2)

Pacific Breeze & Coconut(2)

Tuscan Lavender & Jasmine(2)

Rain Clean(2)

Rainshower(2)

Citrus(1)

Cotton Lilac(1)

Lemon Breeze(1)

Minty(1)

Original(1)

 
Dirt Types

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

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

Soils; Odors(7)

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

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

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; Mildew; Mineral Scale; Mold; Organic Matter; Rust; Soil; Stains(2)

Mineral Scale; Organic Matter; Stains(2)

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

Grease; Grime(2)

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

Grime; Organic Matter; Soil; Stains(2)

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

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

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

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

Bacteria; Dust; Fungus; Germs; Grime; Mildew; Mold; Organic Matter; Viruses; Water-Based Soil(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)

Hard Water Stains; Limescale(1)

Fecal Matter; Limescale; Rust(1)

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

Odors; Stains(1)

 
Capacity (Weight)

3.5 oz(3)

1.41 oz(3)

2.47 oz(2)

1.25 oz(1)

 
Chemical Compound

Hydrochloric Acid(20)

Sodium Hypochlorite(5)

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

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

Hydrogen Peroxide(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)

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

Natural Ingredients; Plant-Derived Surfactants(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)

N-Alkyn; Dimethyl Benzyl Ammonium Chloride(1)

Oxalic Acid(1)

Hydrochloric acid(1)

 
Number of Tabs (Single-Use Packs)

2(2)

1(1)

12(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved