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

Currently Filtered by

Category

Buckets Wringers

Refine Search

  GO
 
Brand

Rubbermaid Commercial(38)

Rubbermaid Commercial HYGEN(8)

Impact(5)

Boardwalk(3)

San Jamar(1)

Unger(1)

Magnolia Brush(1)

Barnes Paper Company(1)

 
Height

36 1/2"(6)

38 3/5"(4)

36"(3)

11 1/4"(3)

19 3/4"(3)

10"(3)

8 1/2"(2)

10 1/4"(2)

27"(2)

17 2/5"(1)

16 3/4"(1)

32 1/4"(1)

11"(1)

12 1/4"(1)

16"(1)

36.97"(1)

34.41"(1)

14 1/8"(1)

12"(1)

24 7/10"(1)

38.6"(1)

16 1/5"(1)

10 1/8"(1)

14.5"(1)

25"(1)

35.1"(1)

14 1/2"(1)

11 1/2"(1)

10 1/2"(1)

21"(1)

8"(1)

13.917"(1)

27.137"(1)

13 5/8"(1)

3.4"(1)

4 1/2"(1)

38"(1)

 
Color(s)

Yellow(20)

Gray(8)

Red(6)

Green(4)

Black(4)

Blue(2)

White(2)

Steel(2)

Yellow/Black/Red(2)

Steel Gray(1)

Blue/Black/White(1)

White/Black(1)

Yellow/Silver(1)

Black/Red(1)

Yellow/Red(1)

Blue;Green;Red;Yellow(1)

Yellow/Black(1)

 
Depth

20 1/8"(3)

15 7/10"(3)

23.92"(3)

29 3/4"(2)

16"(2)

7 1/2"(2)

8"(2)

22 2/5"(2)

13"(2)

13 1/5"(1)

11 3/4"(1)

16 1/2"(1)

15 9/10"(1)

18 1/5"(1)

29"(1)

15 1/2"(1)

8 7/8"(1)

14 7/10"(1)

22.83"(1)

18 5/8"(1)

22.07"(1)

10"(1)

14 1/2"(1)

14"(1)

14 3/8"(1)

36"(1)

10.25"(1)

21"(1)

11"(1)

5 4/5"(1)

3.4"(1)

24"(1)

10 1/2"(1)

13 7/8"(1)

14.744"(1)

9 1/2"(1)

9.857"(1)

22 5/8"(1)

 
Quantity

1 each(42)

12 per case(1)

6 per case(1)

1 kit(1)

 
Diameter

12"(3)

10 1/2"(2)

18"(1)

17.75"(1)

11 1/14"(1)

14"(1)

 
Manufacturer Part Number

758088YW(1)

7578-88 BLU(1)

7588-88 BLU(1)

7588-88 GRE(1)

7590-88 YEL(1)

7588-88 RED(1)

757788YW(1)

7575-88 YEL(1)

6194 STL(1)

618688YW(1)

738000YEL(1)

748000YEL(1)

7570-88 YEL(1)

7677 YEL(1)

768000YW(1)

Q050(1)

FG758888GRN(1)

Q90088YW(1)

Q95088YW(1)

QB220(1)

KP196GN(1)

FG758088YEL(1)

FG748000YEL(1)

778000YW(1)

7777 YEL(1)

9C74 RED(1)

FG1863896(1)

FG1863898(1)

6127-88 YEL(1)

2963 RED(1)

60353(1)

WH2000(1)

1791797(1)

1791798(1)

1791800(1)

1791799(1)

7Y/2636-3Y(1)

6Y/2635-3Y(1)

CBMF6GY(1)

2635COMBOYEL(1)

KP196RD(1)

260(1)

5515(1)

1791801(1)

1791802(1)

2614 RED(1)

2614GRAY(1)

2617 GRA(1)

262888GY(1)

296300GY(1)

261400GY(1)

2064915(1)

1857391(1)

1857378(1)

1863896(1)

1863897(1)

2064907(1)

5GALLID(1)

 
Country of Origin

US(46)

CN(9)

MY(2)

CA(1)

 
Width

16.05"(5)

20 1/10"(4)

15 3/4"(3)

16 1/8"(2)

17"(2)

13"(2)

8"(2)

16 1/2"(2)

26 1/5"(2)

13 1/2"(1)

15 5/8"(1)

13 1/4"(1)

28 9/10"(1)

25 1/8"(1)

25"(1)

14 1/8"(1)

18 1/4"(1)

22 2/5"(1)

18 3/5"(1)

12.223"(1)

24"(1)

24 1/2"(1)

13.25"(1)

14"(1)

11"(1)

12"(1)

21"(1)

17 3/8"(1)

15.186"(1)

14 5/8"(1)

9 3/10"(1)

9.3"(1)

4 1/2"(1)

23 7/8"(1)

18"(1)

 
Material(s)

Plastic(43)

Plastic/Steel(5)

Polyethylene(2)

Tubular Steel;Plastic(1)

Plastic/Microfiber(1)

Paper/Plastic(1)

Structural Foam Polyethylene; Steel; Nylon(1)

Plastic/Metal(1)

Polypropylene(1)

Galvanized Steel(1)

Steel(1)

 
Suggested Use

General Mopping(16)

Accommodates 12 To 32 oz. Mopheads; General Mopping(6)

Floor Finishing(3)

Accommodates 12 To 32 oz. Mopheads;General Mopping(3)

Accommodates 16 To 24 oz. Mopheads; Heavy-Duty(2)

Soap Solution Cleaning(1)

Accommodates Up To 10-oz. Mop Heads; General Mopping(1)

Accommodates 12 to 32 oz. Mopheads; General Mopping(1)

Sanitizing(1)

All-Purpose(1)

Floor Care(1)

Accommodates 20 to 40 oz. Mop Head;General Mopping(1)

Cleaning Carts(1)

 
Capacity Range (Volume) [Max]

35 qt(17)

8.75 gal(3)

26 qt(3)

14 qt(3)

10 qt(2)

6 gal(2)

6 qt(2)

18 qt(2)

32 oz(2)

5 qt(2)

6.8 gal(1)

43 qt(1)

31 qt(1)

27 gal(1)

19 qt(1)

4 gal(1)

17 qt(1)

5 gal(1)

44 qt(1)

15 qt(1)

 
Caster/Glide/Wheel Type

Four 3" TPR Swivel Casters(7)

Four 3" Plastic Swivel Casters(5)

Four 3" Quiet Casters(2)

Four 3" Quiet Swivel Casters(2)

Yes(1)

Four 3" ball bearing casters.(1)

Four 2" Swivel Casters(1)

Four Reinforced Nylon Bearing Casters(1)

Non-Marking(1)

Four 3" Swivel Casters(1)

 
Wringer

Side-Press Wringer(16)

Down-Press Wringer(4)

Sideward Pressure(4)

Downward Pressure(2)

Pedal(2)

Strainer(2)

Twin Roller(1)

Reverse(1)

 
 
 

© 2019-2020 NBJ Form & Function Inc. , All Rights Reserved