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

Currently Filtered by

Category

Stain Removers

Refine Search

  GO
 
Brand

OxiClean(8)

SPRAY ‘n WASH(4)

Clorox 2(3)

Tide Professional(2)

Shout(2)

 
Application

Laundry Pretreatment(17)

Stain Remover(2)

 
Applicable Material

Fabric(12)

Carpet; Ceramics; Fabric; Fiberglass; Finished/Sealed Wood; Glass; Laminates; Metal; Plastic; Upholstery; Vinyl(4)

Bed Linens; Clothing; Washable Fabrics(2)

Clothing; Fabric(1)

 
Dirt Types

Food Stains; Grass Stains; Grease; Oil-Based Soil; Organic Matter; Water-Based Soil(9)

Food Stains; Grass Stains; Grease; Ink; Oil-Based Soil; Organic Matter; Water-Based Soil(6)

Dirt; Chocolate; Coffee; Stains(1)

Dirt; Grass; Stains; Wine(1)

Beverages; Body Soils; Cosmetics; Food; Greasy Food; Household/Office Stains (Ink; Shoe Polish); Oils; Outdoor Soils(1)

Beverages; Body Soils; Cosmetics; Food; Greasy Food; Household & Office Stains (Ink; Shoe Polish); Oils; Outdoor Soils; Set-In Stains(1)

 
Physical Form

Liquid(11)

Powder(8)

 
Volume Capacity

22 oz(4)

12 oz(2)

33 oz(1)

32 oz(1)

60 oz(1)

 
Chemical Compound

Sodium Percarbonate(1)

Water; Hydrogen Peroxide; Myristamine Oxide; Alkylbenzene Sulfonic Acid; Fragrance; Disodium Distyrylbiphenyl Disulfonate; Dipropylene Glycol; Isopropyl Myristate; Colorant; Sodium Hydroxide(1)

Hydrogen Peroxide(1)

Acrylic Copolymer; Citric Acid; Dodecanol; Ethoxylated Alcohol; Polyacrylate Polymer; Proxel GXL; Sodium Borate; Sodium Hydroxide; Subtilisin(1)

Ethoxylated Alcohol(1)

 
Country of Origin

US(19)

 
Packing Type

Bottle(2)

 
Capacity (Volume)

33 oz(1)

60 oz(1)

 
Scent

Unscented(10)

Regular(4)

Neutral(3)

Original(1)

Scented(1)

 
Capacity (Weight)

7.22 lbs(2)

1.5 lbs(2)

30 lbs(1)

49.2 oz(1)

7.6 oz(1)

1 oz(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved