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

Diversey(9)

Tilex(5)

Seventh Generation Professional(4)

Green Works(3)

Method(3)

CLR PRO(2)

LYSOL Brand(2)

Goo Gone(2)

Clorox(2)

Simple Green(2)

Microban(2)

Professional LYSOL Brand(2)

Scrubbing Bubbles(1)

PAK-IT(1)

Arm & Hammer(1)

Dymon(1)

Franklin Cleaning Technology(1)

Kaboom(1)

Zep Commercial(1)

 
Packing Type

Bottle(14)

Spray Bottle(12)

Smart Tube Spray Bottle(6)

Trigger Spray Bottle(4)

Trigger Bottle(2)

Aerosol(2)

Water-Soluble Liquid Packet(1)

Can(1)

Refill Bottle(1)

Snap N Dose(1)

Aerosol Can(1)

 
Manufacturer Part Number

5722102020CT(1)

95026(1)

BATH-32PROEA(1)

00008(1)

00008CT(1)

01656(1)

30120(1)

30120EA(1)

04685CT(1)

04685EA(1)

95026EA(1)

33732(1)

44722CT(1)

44722EA(1)

44728CT(1)

44728EA(1)

682264(1)

11101(1)

11101CT(1)

2054A(1)

2054AEA(1)

BATH-32PRO(1)

F967022(1)

3320000105(1)

35604CT(1)

5703700071CT(1)

00263(1)

00452(1)

00452CT(1)

01100(1)

31752(1)

35600CT(1)

35600EA(1)

35604EA(1)

CBD540489(1)

35605(1)

100828354(1)

100919352(1)

101100486(1)

94995359(1)

95325322(1)

CBD539650(1)

CBD540281(1)

CBD540281EA(1)

ZUCSM32CT(1)

 
Country of Origin

US(45)

 
Capacity (Volume)

32 oz(21)

1 gal(6)

28 oz(5)

19 oz(3)

24 oz(2)

4 oz(1)

16 oz(1)

101 oz(1)

128 oz(1)

20 mL(1)

946 mL(1)

47.3 oz(1)

25 oz(1)

 
Scent

Unscented(11)

Fresh(9)

Citrus(5)

Emerald Cypress & Fir(4)

Eucalyptus Mint(3)

Fresh Clean(2)

Light Lavender(2)

Ocean(1)

Lemon(1)

Original(1)

Lavender(1)

Neutral(1)

Clean Fresh(1)

Slight(1)

 
Dirt Types

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

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

Hard Water Stains; Mildew; Mold; Soap Scum(2)

Dust;Grease;Grime(2)

Dirt;Grease;Mildew;Mineral Scale;Mold;Oil;Soap Scum(2)

Dirt; Soap Scum; Stain(2)

Dirt; Soap Scum; Stains(2)

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

Soap Scum; Hard Water Stains; Bacteria; Mold; Mildew(2)

Body Oils; Dirt; Grime; Rust; Soap Scum; Water Deposits(2)

Bacteria; Fungi; Mold; Viruses(2)

Grease; Grime(2)

Soap Scum; Hard Water Stains; Lime; Grease; Grime; Ink; Smoke Film; Crayon(1)

Grease; Grime; Soap Scum; Soil; Water Spots(1)

Mildew; Mold; Stains(1)

Mildew; Mold; Soap Scum(1)

Dirt;Grime;Soap Scum(1)

Dirt; Soap Scum; Lime; Calcium(1)

Dirt;Grime;Soap Scum;Stain(1)

Grease; Grime; Soap Scum; Soil(1)

Grime; Soap Scum(1)

Dirt; Grime; Oils; Rust; Soap Scum; Water Deposits(1)

Hard Water Deposits; Soap Scum(1)

Grease; Scuffs; Soap Scum(1)

Dirt; Grease; Mildew; Mineral Scale; Mold; Oil; Soap Scum(1)

Dust; Food Residue; Grease; Grime; Organic Matter; Scuff Marks; Smoke Residue; Soil(1)

Fungus; Grime; Mildew; Mold(1)

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

Mold; Mildew(1)

 
Chemical Compound

Urea Hydrochloride(2)

Hydroxyacetic Acid(2)

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

Quaternary Ammonium Compounds 0.8%(2)

Citric Acid(2)

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

Natural Ingredients; Plant-Derived Surfactants(2)

Alkyl Polyglucoside; Citric Acid; Corn-Based Ethanol; Glycerin(1)

Sodium hypochlorite(1)

Hydroxyacetic acid(1)

Methyl Glycine Diacetic Acid 3Na-Salt(1)

Citric Acid; Decyl Glucoside Lauryl Glucoside; Methylsocutyl Glycerol; Sodium Citrate(1)

Bac-Shield (Chitosan) (Antifungal Agent; Antimicrobial Agent)(1)

 
Number of Tabs (Single-Use Packs)

20(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved