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

Currently Filtered by

Category

Glass Cleaners

Refine Search

  GO
 
Brand

Genuine Joe(10)

Windex®(7)

Zep(6)

Clorox Commercial Solutions(4)

Diversey(4)

Betco(3)

RMC(3)

Unger(3)

Spic and Span(2)

Dymon(2)

Method(2)

Spray Nine(2)

Easy-Off(2)

MISTY(1)

Rubbermaid Commercial(1)

SKILCRAFT(1)

Zep Commercial(1)

 
Color

Blue(26)

White(6)

Clear(4)

Dark Blue(4)

Light Blue(4)

Purple(3)

Green(3)

Silver(2)

Black(1)

 
Recycled

No(54)

 
Manufacturer Part Number

1001482(1)

696501CT(1)

23319CT(1)

89772(1)

89772CT(1)

12001014(1)

12001014CT(1)

12001099(1)

Q630(1)

695237(1)

695237CT(1)

696501(1)

696502(1)

58773CT(1)

696503(1)

696503CT(1)

CK053(1)

PL500(1)

PL500CT(1)

ZU1052128(1)

ZU1052128CT(1)

ZU1120128(1)

ZU1120128CT(1)

ZU112032(1)

ZU112032CT(1)

23319(1)

58773(1)

1814700(1)

02103CT(1)

1994700(1)

5350400(1)

00459(1)

00459CT(1)

3107(1)

3107CT(1)

15200049(1)

94378CT(1)

95019510(1)

95019510CT(1)

02103(1)

99669(1)

7930016005748(1)

99669CT(1)

99670(1)

99670CT(1)

99680(1)

99680CT(1)

99681(1)

99681CT(1)

38520(1)

38520CT(1)

00003(1)

00003CT(1)

ZUFGC19(1)

 
Country of Origin

United States(52)

Indonesia(1)

China(1)

 
Weight (Approximate)

12 oz(1)

 
Scent

Lemon(3)

Original(2)

Mint(2)

Grape(1)

Fresh(1)

 
Recommended Use

Grease Remover(26)

Fingerprint Remover(24)

Dirt Remover(22)

Smudge Remover(19)

Grime Remover(15)

Soil Remover(13)

Dust Remover(7)

Smoke Film Remover(6)

Film Remover(4)

Residue Remover(4)

Lipstick Remover(3)

Oil Remover(3)

Water Mark Remover(2)

Bacteria Remover(2)

Virus Remover(2)

Spot Remover(1)

Streak Remover(1)

Liquid Remover(1)

Debris Remover(1)

 
Composition

Ammonia-D(7)

Ammonia(5)

Ethanol(3)

Sodium Carbonate(3)

Aqua(2)

Potassium Citrate(2)

Colorant(2)

Fragrance(2)

Caprylyl/Capryl Glucoside(2)

Alkyl Polyglucoside(1)

Glycerin(1)

Alkaline(1)

Water(1)

Dye(1)

Surfactant(1)

 
Cleaner Volume

32 fl oz (1 quart)(18)

128 fl oz (4 quart)(13)

19 fl oz (0.6 quart)(5)

67.6 fl oz (2.1 quart)(2)

47.3 fl oz (1.5 quart)(2)

28 fl oz (0.9 quart)(2)

19.7 fl oz (0.6 quart)(2)

64.2 fl oz (2 quart)(1)

640 fl oz (20 quart)(1)

 
Cleaner Weight

19 oz (1.19 lb)(3)

 
Cleaner Form

Concentrate(10)

Ready-To-Use(6)

 
Quantity Per Container

100(1)

 
Non-Acidic

Yes(1)

 
Product Type

Glass Cleaner(46)

Surface Cleaner(3)

Glass/Surface Cleaner(2)

Window/Glass Cleaner(2)

Glass Cleaner Refill(1)

 
Packaged Quantity

1 Each(22)

12 / Carton(9)

4 / Carton(8)

6 / Carton(6)

2 / Carton(2)

1 / Each(2)

8 / Carton(1)

12 / Box(1)

3 / Carton(1)

1 / Kit(1)

5 / Carton(1)

 
Assembly Required

No(54)

 
Product Line

Professional(4)

Enviro Care(3)

SmartDose(2)

Clear Reflections(2)

HYGEN(1)

SpeedClean(1)

 
Cleaner Type

Spray(18)

Liquid(17)

Aerosol(5)

Foam Spray(4)

Tablet(2)

Cloth(1)

 
Container Type

Bottle(3)

Roll(1)

 
Cleaner Size

16" Width x 16" Length(1)