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

Currently Filtered by

Category

Spot And Stain Removers

Refine Search

  GO
 
Brand

Clorox(4)

Maintex(3)

Tide(2)

Comet(2)

Resolve(2)

Krud Kutter(2)

Amodex(2)

Scotchgard(2)

Dymon(2)

Diversey(2)

Weiman(1)

Zep Commercial(1)

Sheila Shine(1)

Betco(1)

Genuine Joe(1)

Shout(1)

 
Color

White(13)

Clear(5)

Orange(2)

Red(2)

Blue(1)

Colorless(1)

Green(1)

Yellow(1)

 
Recycled

No(27)

 
Packaged Quantity

1 Each(13)

12 / Carton(9)

6 / Carton(3)

24 / Carton(1)

9 / Carton(1)

72 / Carton(1)

4 / Carton(1)

 
Assembly Required

No(27)

 
Recommended Use

Stain Remover(19)

Grease Remover(11)

Spot Remover(6)

Soil Remover(5)

Urine Remover(5)

Odor Remover(5)

Spill Remover(4)

Rust Remover(3)

Limescale Remover(3)

Scale Remover(2)

Odor Removal(2)

Calcium Deposit Remover(2)

Food Stain(2)

Grime Remover(2)

Juice(2)

Residue(2)

Dirt Remover(2)

Mineral Deposit Remover(2)

Urine Smell(2)

Finger Mark Remover(2)

Smudge Remover(2)

Vomit(2)

Ink Remover(2)

Blood Remover(2)

Oil Remover(2)

Water Mark Remover(2)

Urine Stain(2)

Feces(2)

Stain Removal(2)

Dust Remover(2)

Red Wine(2)

Liquid Remover(1)

Mildew Remover(1)

Mold Remover(1)

Residue Remover(1)

Fingerprint Remover(1)

Streak Remover(1)

Alkaline Deposit Remover(1)

Ketchup Remover(1)

Gum Remover(1)

Adhesive Remover(1)

Food Remover(1)

Coffee Remover(1)

Hard Water Remover(1)

Concrete Remover(1)

Stucco Remover(1)

Asphalt Remover(1)

Debris Remover(1)

Graffiti Remover(1)

 
Volume Capacity

1 quart(2)

 
Cleaner Type

Aerosol(8)

Spray(7)

Liquid(6)

Powder(2)

Gel(1)

Foam Spray(1)

 
Composition

Hydrogen peroxide(4)

Bleach(3)

Degreaser(1)

Phosphoric Acid(1)

Hydrochloric Acid(1)

Surfactant(1)

Sodium Hydroxide(1)

Water(1)

Isopropyl Alcohol(1)

Fragrance(1)

Detergent(1)

C11-C15 Ethoxylated Alcohol(1)

 
Cleaner Volume

0.25 gal (32 fl oz)(7)

0.13 gal (17 fl oz)(3)

0.13 gal (16 fl oz)(3)

0.22 gal (28 fl oz)(2)

0.34 fl oz(2)

1 gal (128 fl oz)(2)

10 fl oz(1)

0.17 gal (22 fl oz)(1)

0.16 gal (20 fl oz)(1)

4 fl oz(1)

 
Quantity Per Container

24(1)

 
Cleaner Weight

21 oz (1.31 lb)(2)

18 oz (1.12 lb)(1)

4 oz (0.25 lb)(1)

 
Cleaner Form

Ready-To-Use(4)

Concentrate(2)

 
Acidic

Yes(2)

 
Manufacturer Part Number

32987CT(1)

99305(1)

32987(1)

01870CT(1)

14003CT(1)

01870(1)

99305CT(1)

305475(1)

49(1)

ZUMILDEW32CT(1)

SSCA10(1)

652463(1)

305475CT(1)

14003(1)

161532WAL(1)

31351(1)

31351CT(1)

31036CT(1)

31036(1)

104CT(1)

4251200(1)

94970590(1)

94970590CT(1)

113032WAL(1)

145132WAL(1)

10620CT(1)

10620(1)

99682(1)

104(1)

 
Country of Origin

United States(27)

Canada(2)

 
Scent

Characteristic(2)

Floral(1)

Rain Clean(1)

Country Fresh(1)

 
Container Type

Bottle(4)

 
 
 
 
 

© 2019-2020 Bayshore Office Products, Inc., All Rights Reserved