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

Currently Filtered by

Category

Back Supports

Refine Search

  GO
 
Brand

ergodyne(8)

Safco(4)

Fellowes(3)

Rubbermaid Commercial(2)

SoftSpot(2)

Kensington(2)

Master Caster(2)

Advantus(1)

 
Warranty

Manufacturer's limited lifetime warranty.(8)

Manufacturer's limited one-year warranty.(3)

 
Special Features

Deluxe Lumbar Support Cushion with Memory Foam-Memory Foam conforms to the body's natural curves, providing maximum relief.(1)

Deluxe Seat/Back Cushion with Memory Foam-Memory Foam conforms to the body's natural curves, providing maximum relief.(1)

 
Manufacturer Part Number

8248ELDCT(1)

91060(1)

92061(1)

91061(1)

82025(1)

6661BL(1)

71301(1)

7154BL(1)

7153BL(1)

7152BL(1)

7151BL(1)

82024(1)

9311601(1)

11282(1)

11095(1)

11094(1)

11093(1)

11283(1)

11284(1)

9190701(1)

8037601(1)

11286(1)

11285(1)

60-2804MH05(1)

 
Country of Origin

CN(15)

TW(6)

US(3)

 
Height

3"(2)

19"(1)

12 1/2"(1)

19.5"(1)

11"(1)

15"(1)

10 3/4"(1)

6.75"(1)

7.5"(1)

5.19"(1)

14.5"(1)

2"(1)

16"(1)

17.5"(1)

12"(1)

 
Width

8.5"(5)

7.5"(3)

14"(3)

16"(2)

13"(1)

15.5"(1)

17.5"(1)

14.5"(1)

12 7/8"(1)

12.5"(1)

15"(1)

13.5"(1)

12.75"(1)

17"(1)

12"(1)

 
Depth

2.5"(2)

2 3/4"(2)

3"(2)

3.75"(2)

12"(2)

2"(1)

10"(1)

3.13"(1)

6"(1)

2.75"(1)

14.5"(1)

 
Color(s)

Black(22)

Gray(2)

 
Material(s)

Spandex(5)

Elastic(3)

Therasoft(2)

Memory Foam; Polyurethane(2)

High-Density Foam(1)

Nylon(1)

Mesh(1)

Smooth Surface(1)

Microtex 260 Foam(1)

High-Density Memory Cell Pressure-Sensitive Foam(1)

Fabric; Nylon; Plastic; Polyurethane Foam(1)

Brushed Cover; Nylon; Plastic; Polyurethane Foam(1)

Nylon; Plastic; Polyester Fabric; Polyurethane Foam(1)

High-Density, Temperature-Sensitive Memory Cell Foam(1)

Memory Foam(1)

 
Weight

11 lbs.(1)

 
Size Group

Medium(3)

Fits Most Chairs(2)

X-Large(2)

Large(2)

One Size Fits All(1)

Small(1)

2X-Large(1)

 
Cover Material(s)

Nylon; Polyolefin(2)

Cotton; Polyester(2)

Polyester(2)

Fleece(1)

Fabric(1)

Soft, Breathable Fabric(1)

Brushed Cover(1)

Mesh(1)

 
Washable

Yes(20)

No(2)

 
Adjustability Features

Hook and Loop Closure(5)

Detachable Suspenders(3)

Elastic Strap(3)

Strap(2)

Adjust Shape; Thickness(2)

Cushion Curvature(1)

Adjustable Cushions; Straps(1)

Tri-Tachment System Eliminates Repeated Readjustments(1)

Adjustable Strap; Body Heat Adjust Cushion Curvature(1)

 
Back Support Type

Chair(14)

Belt(8)

Lumbar(2)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved