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)

Diversey(2)

Method(2)

Mr. Clean(2)

Misty(1)

Clorox(1)

Murphy Oil Soap(1)

Swiffer(1)

MOP & GLO(1)

Professional EASY-OFF(1)

 
Special Features

Value Pack-Stock up and save!(2)

SmartDoseT system for easy dosing.(1)

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

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

 
Application

Floor Cleaner/Degreaser(9)

Floor Cleaner(2)

Hard Surface Floors(2)

Floors(1)

Multi-Purpose Neutral 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(5)

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)

Wood; No-Wax Floors; Marble Floors; Tile Floors(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)

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)

Tile; Vinyl; Sealed Hardwood; Marble; Linoleum; Sealed Ceramic; No-Wax Floors(1)

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

 
Dirt Types

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

Grease; Grime(2)

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

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

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

Dirt; Grease; Grime; Oil(1)

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

Dust; Food Residue; Soils(1)

 
Physical Form

Liquid(14)

Powder(1)

 
Chemical Compound

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

Dipropylene Glycol Monomethyl Ether(1)

Diethylene Glycol Butyl Ether; Propylene Glycol(1)

Alkaline(1)

Sodium Carbonate(1)

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

Modified Acrylic Polymer(1)

C9-11 Alcohols Ethoxylate(1)

 
Manufacturer Part Number

1033704(1)

30892(1)

01151(1)

948030(1)

95122613(1)

00563(1)

00563CT(1)

02001(1)

02011(1)

02621CT(1)

02621EA(1)

31973CT(1)

77810(1)

89333(1)

89770CT(1)

 
Country of Origin

US(14)

CA(1)

 
Packing Type

Bottle(9)

Spray Bottle(2)

Bottle of Concentrate(1)

Container(1)

Packet(1)

Box(1)

 
Capacity (Volume)

1 gal(7)

32 oz(2)

25 oz(2)

1.4 L(1)

3 oz(1)

27 oz(1)

1.25 L(1)

 
Scent

Lemon(4)

Fresh(4)

Lemon Ginger(2)

Pleasant(1)

Solvent(1)

Citrus(1)

Fresh Citrus(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved