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

Currently Filtered by

Category

Scouring Pads Sticks

Refine Search
  GO
Brand

Scotch-Brite PROFESSIONAL(18)

GMT(11)

Boardwalk(10)

Scotch-Brite(10)

3M(6)

S.O.S.(5)

AbilityOne(5)

AmerCareRoyal(4)

Kurly Kate(3)

Pumie(2)

Brillo(2)

Big Boss II(1)

Disco(1)

GEN(1)

Color(s)

Steel Gray(15)

Green(14)

Gray(7)

Blue(7)

Steel(4)

Dark Blue(3)

White(3)

Black(3)

Brown(3)

Blue/White(2)

Silver(2)

Charcoal;Pink(2)

Maroon(2)

Yellow/Green(2)

Stainless Steel(1)

Green/Yellow(1)

Dark Gray(1)

Yellow(1)

Charcoal(1)

Gold(1)

Light Gray|D3D3D3(1)

Copper(1)

Purple(1)

Red/Black(1)

Country of Origin

US(32)

MX(18)

CN(16)

CA(10)

DE(2)

ES(1)

Material(s)

Steel Wool(16)

Stainless Steel(10)

Synthetic Fiber(7)

Resin; Fiber; Mineral(4)

Nylon(4)

Resin; Fiber; Mineral(3)

Fiber(3)

Nylon/Polyester Blend(3)

Pumice(2)

Aluminum Oxide(2)

Fiber; Mineral; Resin(2)

Synthetic Fiber; Urethane; Plastic(1)

Plastic; Cellulose(1)

Glass Foam(1)

Cellulose; Synthetic Fiber(1)

Rayon(1)

Fiber; Mineral; Plastic; Resin(1)

Melamine; Urethane(1)

Synthetic Fiber;Abrasives;Resin(1)

Fiberglass(1)

Brass(1)

Stone-Like(1)

Polyester and Nylon Fibers(1)

Resin; Fiber; Mineral(1)

Non-Woven Nylon/Polyester Fiber(1)

Resin; Mineral; Fiber(1)

Polymeric Foam/Urethane(1)

Copper Coated Metal(1)

Fabric backing, Resin, Mineral(1)

Coiled Synthetic Fiber(1)

For Use With

MMM6472(5)

Scotch-Brite 65012(1)

Scotch-Brite 481-7-RSC(1)

3M MCO 08004(1)

3M MCO 05241(1)

Scotch-Brite MCO 223(1)

Size (W x L)

6" x 9"(12)

4" x 4"(3)

10" x 4 5/8"(2)

3.8" x 6"(2)

2 1/2" x 2 3/4"(2)

4" x 5 1/2"(2)

4 5/8" x 10"(2)

9" x 6"(2)

10" x 4.63"(2)

2 1/2" x 9 1/2"(2)

4.4" x 2.6"(1)

3" x 6"(1)

5" x 5"(1)

3 1/2" x 3 1/2"(1)

4" x 8"(1)

6.75 x 1.25(1)

1 1/4 in x 5 in(1)

3 1/2 in x 5 1/2 in(1)

4" x 6" x 3"(1)

4" x 6"(1)

1 3/4" W x 4"Diameter(1)

6" x 9 1/4"(1)

4.45" x 3.85"(1)

50 gram(1)

3 1/2" x 5"(1)

8" x 4"(1)

2.5" x 2.75"(1)

3.5" x 5"(1)

4.63" x 10"(1)

3 1/2" x 4" x 8"(1)

4" x 5 1/4"(1)

2.8" x 4.5" x 1.2"(1)

2.8 in x 4.5 in(1)

2.9" x 2.2"(1)

5.75" x 5"(1)

5 1/2" x 3 9/10"(1)

3" x 4 1/2"(1)

Scouring Pads/Sticks Type

Pad(68)

Stainless Steel Scrubber(3)

Brick(3)

Stick(2)

Dishwand(1)

Screen(1)

Metal/Brass Scrubber(1)

Special Features

For use with Utility Pad Holder (sold separately).(3)

Medium Size(2)

#1 Medium(2)

#2 Medium Coarse(2)

Large Size(2)

Delicate Clean-Safely cleans ceramic tile, glass, some fiberglass and other delicate surfaces.(1)

#4 Extra Coarse(1)

Copper Coated Metal Three Pack(1)

#3 Medium(1)

Stainless Steel Three Pack(1)

3 Pack(1)

#000 Extra Fine(1)

12 boxes per carton.(1)

#3 Coarse(1)

#0000 Super Fine(1)

#00 Very Fine(1)

#0 Fine(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved

Powered by SITS Erp