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

Currently Filtered by

Category

Floor Cleaners

Refine Search

  GO
 
Brand

Spic and Span(3)

Mr. Clean(2)

Method(2)

Diversey(2)

Professional EASY-OFF(1)

Swiffer(1)

Murphy Oil Soap(1)

Misty(1)

 
Special Features

Value Pack-Stock up and save!(2)

Single-Dose Packets-Single-dose concentrated packets each make 4 gallons of cleaning product.(1)

Concentrated Formula-1 gallon bottle of concentrate makes 170 gallons of cleaning product.(1)

SmartDoseT system for easy dosing.(1)

 
Application

Floor Cleaner/Degreaser(8)

Hard Surface Floors(2)

Multi-Purpose Neutral Cleaner(1)

Floors(1)

Floor Cleaner(1)

 
Applicable Material

Vinyl Composition Tile (VCT); Solid Vinyl Tile (SVT); Linoleum; Sheet Vinyl; Laminates; Glass; Sealed Cement/Concrete; Ceramic Tile; Terra Cotta; Terrazzo; Quarry Tile(4)

Hard Floors; Laminate; Stone; Tile; Wood(2)

Vinyl Composition Tile (VCT); Solid Vinyl Tile (SVT); Linoleum; Sheet Vinyl; Laminates; Glass; Sealed Cement/Concrete; Ceramic Tile; Terra Cotta; Terrazzo; Quarry Tile; Polished/Sealed Stone(2)

Floors, Walls, Glazed Porcelain, Plastic Surfaces, other Hard, Nonporous Surfaces(1)

Cement/Concrete; Ceramic Tile; Finished/Sealed Wood; Glass; Laminates; Linoleum; Quarry Tile; Sheet Vinyl; Solid Vinyl Tile (SVT); Terra Cotta; Terrazzo; Vinyl Composition Tile (VCT)(1)

Vinyl Composition Tile (VCT); Solid Vinyl Tile (SVT); Linoleum; Sheet Vinyl; Laminates; Glass; Sealed Cement/Concrete; Ceramic Tile; Terra Cotta; Terrazzo; Quarry Tile; Polished/Sealed/Engineered Stone; Metal(1)

Wood; No-Wax Floors; Marble Floors; Tile Floors(1)

 
Dirt Types

Dust; Food Residue; Grease; Grime; Scuff Marks; Soil; Spills(5)

Grease; Grime(2)

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

Dirt; Grease; Grime; Oil(1)

Dust; Food Residue; Grease; Grime; Oil-Based Soil; Organic Matter; Scuff Marks; Water-Based Soil(1)

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

 
Physical Form

Liquid(12)

Powder(1)

 
Chemical Compound

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

Water; Propylene Glycol Butyl Ether; Hexyloxyethanol; Lauramine Oxide; Polyethyleneimine Modified(1)

C9-11 Alcohols Ethoxylate(1)

Sodium Carbonate(1)

Alkaline(1)

Diethylene Glycol Butyl Ether; Propylene Glycol(1)

Dipropylene Glycol Monomethyl Ether(1)

 
Manufacturer Part Number

02621EA(1)

02621CT(1)

31973CT(1)

77810(1)

89770CT(1)

02011(1)

02001(1)

948030(1)

01151(1)

95122613(1)

00563(1)

00563CT(1)

1033704(1)

 
Country of Origin

US(12)

CA(1)

 
Packing Type

Bottle(8)

Spray Bottle(2)

Box(1)

Packet(1)

Container(1)

 
Capacity (Volume)

1 gal(6)

25 oz(2)

1.25 L(1)

27 oz(1)

3 oz(1)

32 oz(1)

1.4 L(1)

 
Scent

Lemon(4)

Fresh(4)

Lemon Ginger(2)

Citrus(1)

Solvent(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved