Banner1 Banner1
 
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_19` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`category_name` LIKE "Back Supports") 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_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 ('BackSupport' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+BackSupport' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"BackSupport"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"BackSupport"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"BackSupport"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"BackSupport"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+BackSupport' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='BackSupport',`category_4` ='BackSupport') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'BackSupport,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('BackSupport', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

BACK SUPPORTS


Search Again >>


Refine Search

  GO
Brand

Alera(9)

ergodyne(8)

Safco(7)

Fellowes(4)

Kensington(2)

Master Caster(2)

Advantus(1)

ACE(1)

Height

2 1/8"(4)

2 3/4"(2)

11"(2)

19"(1)

9"(1)

7 1/2"(1)

19 1/2"(1)

15"(1)

6 3/4"(1)

17 1/2"(1)

3"(1)

13"(1)

2"(1)

14 1/2"(1)

12"(1)

6 1/4"(1)

13 5/8"(1)

5 3/16"(1)

5 7/8"(1)

6"(1)

16"(1)

Color(s)

Black(29)

Tan Quartz(2)

Smoke(2)

Gray(1)

Depth

3"(6)

19 1/8"(4)

3 3/4"(2)

12"(2)

2 1/2"(2)

10"(1)

2 3/4"(1)

4"(1)

16"(1)

2"(1)

4 3/4"(1)

14 1/8"(1)

15 3/4"(1)

15 3/8"(1)

3 1/8"(1)

Manufacturer Part Number

82024(1)

82025(1)

91061(1)

9311601(1)

9190701(1)

8037601(1)

9190001(1)

92061(1)

208605(1)

7152BL(1)

7153BL(1)

7154BL(1)

7151BL(1)

71491(1)

6661BL(1)

71301(1)

11286(1)

11285(1)

PC1511(1)

PC1551(1)

PC3011(1)

CGC511(1)

CGC411(1)

BR210(1)

BR317(1)

PC3051(1)

60-2804MH05(1)

11283(1)

11284(1)

11282(1)

11095(1)

11093(1)

11094(1)

BR118(1)

Country of Origin

CN(25)

TW(7)

US(2)

Width

8 1/2"(5)

7 1/2"(3)

14"(3)

15 1/2"(3)

14 1/2"(2)

16"(2)

12 3/4"(2)

29 1/2"(2)

14 7/8"(2)

17 1/2"(1)

3 3/4"(1)

17"(1)

12 1/2"(1)

18 1/8"(1)

14 3/8"(1)

14 1/8"(1)

16 1/2"(1)

15"(1)

12"(1)

Material(s)

Spandex(5)

Fabric(4)

Elastic(3)

Mesh(2)

Polyurethane; Memory Foam(2)

High-Density Foam(2)

Therasoft(2)

Cooling Gel; Memory Foam; Fabric(2)

Nylon; Polyester; Latex(1)

Smooth Surface(1)

Nylon(1)

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

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

Mesh; Memory Foam(1)

Polyurethane(1)

Memory Foam(1)

Fabric; Polyurethane Foam; Nylon; Plastic(1)

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

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

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

Weight

11 lbs.(2)

9 lbs.(1)

10 lbs.(1)

13 lbs.(1)

6 lbs.(1)

5 lbs.(1)

0.25 lbs.(1)

0.65 lbs.(1)

1.37 lbs.(1)

1.4 lbs.(1)

Cover Material(s)

Polyester(3)

Polyolefin; Nylon(2)

Fabric(2)

Cotton; Polyester(2)

Mesh Fabric(1)

Brushed Fabric Cover(1)

Mesh(1)

Soft, Breathable Fabric(1)

Polyurethane(1)

Brushed Cover(1)

Size Group

Medium(3)

X-Large(2)

Large(2)

One Size Fits All(1)

One Size(1)

Fits most chairs(1)

2X-Large(1)

Small(1)

Fits most office chairs(1)

Fits most modern chairs(1)

Washable

Yes(22)

No(3)

Yes (Hand Washable)(1)

Adjustability Features

Elastic Strap(5)

Hook and Loop Closure(5)

Detachable Suspenders(3)

Adjust Shape/Thickness(2)

Adjustable Straps(2)

Adjustable Cushions and Straps(2)

Adjustable Strap(1)

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

Tri-Tachment System Eliminates Repeated Readjustments(1)

Straps(1)

Body Heat Adjust Cushion Curvature; Adjustable Strap(1)

Straps

Yes(26)

Number of Stays

4(8)

2(1)

Unlimited(1)

Back Support Type

Chair(19)

Belt(9)

Lumbar(2)

Credenza Seat Cushion(2)

Pedestal File Seat Cushion(2)

Price Range

$0-$99.99(33)

$100-$199.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Carriage Paper Products, All Rights Reserved