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

Currently Filtered by

Category

Storage Cabinets

Refine Search

  GO
 
Brand

Drano(6)

Zep Professional(2)

Boardwalk(2)

Liquid Plumr(2)

Dymon(2)

RID-X(2)

Misty(1)

Diversey(1)

CLR PRO(1)

DCT(1)

Rubbermaid Commercial(1)

ROTO-ROOTER(1)

 
Recycled

No(1)

 
Packaged Quantity

1 Each(1)

 
Assembly Required

No(1)

 
Application

Drain Cleaner(14)

Septic System Treatment(2)

Drains; Garbage Disposals(2)

Garbage Disposals(1)

Bathroom Sinks; Bathtub Drains; Floor Drains; Garbage Disposals; Kitchen Sinks; Shower Drains(1)

Drains(1)

 
Recommended Use

Clog Remover(1)

 
Applicable Material

Metal; Plastic; PVC(5)

Drains; Garbage Disposals(3)

Metal; PVC(2)

Drains(2)

Metal; Old Pipes; Plastic; PVC(2)

Household Septic Waste(2)

Metal(1)

Garbage Disposal Units; Soft Metals(1)

Garbage Disposals(1)

Ceramic; Glass; Metal; Plastic(1)

Acrylonitrile Butadiene Styrene (ABC); Brass; Copper; Iron; Polyvinyl Chloride (PVC); Steel(1)

 
Dirt Types

Food Debris; Grease; Hair; Oil-Based Soils; Organic Matter; Water-Based Soils(7)

Grease; Hair; Soap Scum(3)

Food Particles; Grease; Hair; Oil; Organic Matter(2)

Grease(2)

Hair; Gunk; Grease; Soap Scum(2)

Food Waste; Grease; Oils(1)

Carbohydrates; Cellulose; Grease; Oil; Proteins(1)

Mineral Deposits; Organic Matter(1)

Grease; Hair; Organic Waste; Soap Scum; Soil(1)

 
Physical Form

Liquid(11)

Gel(7)

Powder(2)

Pod(1)

 
Volume Capacity

32 oz(6)

80 oz(2)

1 gal(2)

128 oz(2)

1 qt(1)

5 L(1)

5 gal(1)

19.6 oz(1)

 
Chemical Compound

Sodium Hydroxide; Sodium Hypochlorite(3)

Sodium Hypochlorite(2)

Amylase Enzyme; Cellulose Enzyme; Subtilisin; Bacteria Spore Blend(2)

Alkaline(1)

Potassium Hydroxide; Sodium Hypochlorite(1)

Sodium Bicarbonate; Citric Acid(1)

Sodium Dodecylbenzene Sulfonate(1)

C12-18-Alkyldimethyl; Amines; N-Oxides; Sodium Hydroxide; Sodium Hypochlorite; Sodium Metasilicate(1)

 
Cleaner Volume

32 fl oz (1 quart)(1)

 
Cleaner Form

Liquid(1)

 
Country of Origin

US(21)

United States(1)

 
Packing Type

Bottle(2)

Refill(1)

 
Capacity (Volume)

9.8 oz(1)

32 oz(1)

80 oz(1)

 
Scent

Unscented(12)

Bleach(3)

Neutral(2)

Chlorine(1)

Fresh Scent(1)

Original(1)

Unscented (Bleach-Like Odor)(1)

 
Capacity (Weight)

5.3 oz(1)

9.8 oz(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved