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 ('805')) 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

Alera(9)

ergodyne(8)

Safco Mayline(6)

Fellowes(5)

Allegro(4)

Rubbermaid Commercial(3)

Kensington(3)

Master Caster(2)

Advantus(1)

Safco(1)

ACE(1)

Curad(1)

DMI(1)

 
Height

2 1/8"(4)

13"(2)

12 1/2"(2)

15"(2)

3"(2)

11"(2)

2 3/4"(2)

9"(1)

7 1/2"(1)

10 3/4"(1)

10"(1)

19"(1)

6 3/4"(1)

19 1/2"(1)

17 1/2"(1)

16"(1)

13 5/8"(1)

14 1/2"(1)

6 1/4"(1)

5 3/16"(1)

5 7/8"(1)

2"(1)

13 3/4"(1)

12"(1)

 
Color(s)

Black(38)

Gray(2)

Tan Quartz(2)

Smoke(2)

Beige(1)

 
Depth

3"(5)

2 3/4"(4)

19 1/8"(4)

12"(2)

2 1/2"(2)

3 3/4"(2)

14 1/2"(1)

48"(1)

10"(1)

1 1/2"(1)

4"(1)

2"(1)

15 3/4"(1)

14 1/8"(1)

4 3/4"(1)

3 7/8"(1)

5"(1)

3 1/8"(1)

15 3/8"(1)

6"(1)

 
Manufacturer Part Number

82025(1)

91061(1)

92061(1)

ORT22000D(1)

82024(1)

82021(1)

8037601(1)

9190001(1)

9190701(1)

9311601(1)

208605(1)

8248ELDCT(1)

7151BL(1)

7152BL(1)

7153BL(1)

7154BL(1)

71491(1)

71301(1)

91060(1)

91060CT(1)

6661BL(1)

8036501(1)

11286(1)

PC3011(1)

PC3051(1)

717601(1)

717602(1)

PC1551(1)

PC1511(1)

BR210(1)

BR317(1)

CGC411(1)

CGC511(1)

717603(1)

717604(1)

11282(1)

11283(1)

11284(1)

11285(1)

11095(1)

11094(1)

60-2804MH05(1)

55573010200(1)

11093(1)

BR118(1)

 
Country of Origin

CN(32)

TW(9)

US(4)

 
Width

8 1/2"(5)

14"(4)

13"(3)

7 1/2"(3)

14 1/2"(2)

16"(2)

12 3/4"(2)

29 1/2"(2)

15 1/2"(2)

14 7/8"(2)

17"(1)

17 1/2"(1)

33"(1)

3 3/4"(1)

12 7/8"(1)

12 1/2"(1)

17 3/4"(1)

14 1/8"(1)

14 3/8"(1)

16 1/2"(1)

18 1/8"(1)

12"(1)

15"(1)

13 1/2"(1)

 
Material(s)

Nylon(5)

Spandex(5)

Elastic(4)

Fabric(4)

Mesh(3)

Microtex 260 Foam(2)

Polyurethane; Memory Foam(2)

High-Density Foam(2)

Therasoft(2)

Cooling Gel; Memory Foam; Fabric(2)

Smooth Surface(1)

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

Nylon; Polyester; Latex(1)

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

Brushed Fabric; Polyurethane Foam; Gel Pack; Nylon(1)

Memory Foam(1)

Mesh; Memory Foam(1)

Polyurethane(1)

Polyester; Cotton; Foam(1)

Fabric; Polyurethane Foam; Nylon; Plastic(1)

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

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

Eggshell Foam(1)

 
Weight

11 lbs.(1)

 
Cover Material(s)

Polyester(3)

Fabric(3)

Cotton; Polyester(2)

Fleece(2)

Polyolefin; Nylon(2)

Mesh Fabric(1)

Stretch Lycra(1)

Elastic(1)

Brushed Cover(1)

Mesh(1)

Polyester/Cotton(1)

Soft, Breathable Fabric(1)

Brushed Fabric Cover(1)

Polyurethane(1)

 
Size Group

Medium(4)

Large(3)

X-Large(3)

One Size(2)

Small(2)

One Size Fits All(1)

Fits most chairs(1)

2X-Large(1)

Fits most office chairs(1)

Fits most modern chairs(1)

 
Washable

Yes(28)

No(3)

Yes (Hand Washable)(1)

 
Expected Delivery

Allow several additional days for delivery(1)

 
Adjustability Features

Detachable Suspenders(7)

Hook and Loop Closure(5)

Elastic Strap(5)

Adjust Shape/Thickness(2)

Straps(2)

Adjustable Cushions and Straps(2)

Adjustable Straps(2)

Adjustable Strap(1)

Cushion Curvature(1)

Tri-Tachment System Eliminates Repeated Readjustments(1)

Body Heat Adjust Cushion Curvature; Adjustable Strap(1)

Durable Elastic Compression Straps; Grip Tape Strapping; Adjustable and Removable Suspenders(1)

 
Straps

Yes(35)

 
Number of Stays

4(12)

2(1)

Unlimited(1)

6(1)

 
Back Support Type

Chair(24)

Belt(13)

Lumbar(3)

Credenza Seat Cushion(2)

Pedestal File Seat Cushion(2)

Compression(1)

 
 
 

© 2018-2019 BonTay Business Products, Inc., All Rights Reserved