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','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 '%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(3)

Method(2)

Mr. Clean(2)

Misty(1)

Clorox(1)

Murphy Oil Soap(1)

Easy Paks(1)

Swiffer(1)

Professional EASY-OFF(1)

 
Special Features

Value Pack-Stock up and save!(2)

SmartDoseT system for easy dosing.(1)

90 Packets per Tub(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(10)

Floors(2)

Hard Surface Floors(2)

Floor Cleaner(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; Sealed/Finished Wood; Glass; Sealed Cement/Concrete; Ceramic Tile; Terra Cotta; Quarry Tile(1)

Asphalt Tile; Ceramic; Granite; Linoleum; Marble; Quarry Tile; Rubber; Slate; Terrazzo; Vinyl Tile(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)

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

 
Dirt Types

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

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)

Black Heel Marks; Dirt; Surface Scratches; Tar(1)

Dirt; Grease; Grime; Oil(1)

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

 
Physical Form

Liquid(14)

Powder(2)

 
Chemical Compound

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

Dipropylene Glycol Monomethyl Ether(1)

Diethylene Glycol Butyl Ether; Propylene Glycol(1)

Alcohol Ethoxylates(1)

Alkaline(1)

Sodium Carbonate(1)

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

C9-11 Alcohols Ethoxylate(1)

 
Manufacturer Part Number

1033704(1)

30892(1)

01151(1)

948030(1)

95122613(1)

990653(1)

CBD540458(1)

00563(1)

00563CT(1)

02001(1)

02011(1)

02621CT(1)

02621EA(1)

31973CT(1)

77810(1)

89770CT(1)

 
Country of Origin

US(15)

CA(1)

 
Packing Type

Bottle(9)

Packet(2)

Spray Bottle(2)

Bottle of Concentrate(1)

Container(1)

Box(1)

 
Capacity (Volume)

1 gal(8)

25 oz(2)

32 oz(1)

1.4 L(1)

0.5 oz(1)

3 oz(1)

27 oz(1)

1.25 L(1)

 
Scent

Fresh(4)

Lemon(4)

Citrus(2)

Lemon Ginger(2)

Pleasant(1)

Solvent(1)

Pine Forest(1)

 
Capacity (Weight)

0.5 oz(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved