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(10)

ergodyne(9)

Safco(5)

Fellowes(4)

Allegro(4)

SoftSpot(2)

Kensington(2)

Master Caster(2)

Advantus(1)

Rubbermaid Commercial(1)

ACE(1)

Curad(1)

 
Height

2.13"(4)

3"(2)

11"(2)

2.75"(2)

12.5"(1)

9"(1)

10"(1)

19"(1)

13"(1)

6.75"(1)

15"(1)

7.5"(1)

19.5"(1)

2"(1)

12"(1)

6.34"(1)

6.25"(1)

14.5"(1)

13.63"(1)

16"(1)

5.88"(1)

5.19"(1)

17.5"(1)

 
Color(s)

Black(36)

Tan Quartz(2)

Smoke(2)

Beige(1)

Gray(1)

 
Depth

3"(5)

19.13"(4)

2.5"(2)

3.75"(2)

12"(2)

2.75"(2)

48"(1)

10"(1)

4"(1)

14.5"(1)

2"(1)

3.46"(1)

4.75"(1)

14.13"(1)

15.75"(1)

3.13"(1)

15.38"(1)

6"(1)

 
Size

5 x 3 1/8(1)

 
Manufacturer Part Number

9311601(1)

82024(1)

82025(1)

91061(1)

9190701(1)

9190001(1)

11286(1)

11383(1)

8037601(1)

92061(1)

ORT22000D(1)

7151BL(1)

7152BL(1)

7153BL(1)

7154BL(1)

71491(1)

71301(1)

208605(1)

91060CT(1)

6661BL(1)

11285(1)

11284(1)

PC1511(1)

PC1551(1)

PC3011(1)

PC3051(1)

CGC511(1)

CGC411(1)

BR210(1)

BR317(1)

BR318(1)

717601(1)

717602(1)

11095(1)

11282(1)

11283(1)

11094(1)

11093(1)

717603(1)

717604(1)

60-2804MH05(1)

BR118(1)

 
Country of Origin

CN(31)

TW(9)

US(3)

 
Width

8.5"(5)

7.5"(3)

14"(3)

16"(2)

15.5"(2)

14.5"(2)

29.5"(2)

12.75"(2)

13.5"(2)

14.88"(2)

12.5"(1)

17.5"(1)

3.75"(1)

33"(1)

17"(1)

13"(1)

15"(1)

14.38"(1)

14.13"(1)

16.5"(1)

18.13"(1)

12"(1)

 
Material(s)

Spandex(6)

Nylon(5)

Elastic(4)

Fabric(4)

High-Density Foam(2)

Therasoft(2)

Mesh(2)

Memory Foam; Polyurethane(2)

Cooling Gel; Fabric; Memory Foam(2)

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

Latex; Nylon; Polyester(1)

Microtex 260 Foam(1)

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

Smooth Surface(1)

Fabric; Nylon; Plastic; Polyurethane Foam(1)

Mesh; Memory Foam(1)

Polyurethane(1)

Fabric; Memory Foam(1)

Memory Foam(1)

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

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

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

 
Weight

11 lbs.(1)

 
Cover Material(s)

Polyester(4)

Nylon; Polyolefin(2)

Cotton; Polyester(2)

Fabric(2)

Elastic(1)

Fleece(1)

Mesh Fabric(1)

Brushed Fabric Cover(1)

Mesh(1)

Soft, Breathable Fabric(1)

Polyurethane(1)

Brushed Cover(1)

 
Size Group

Medium(5)

One Size Fits All(3)

Fits Most Chairs(3)

X-Large(3)

Large(3)

Small(2)

2X-Large(1)

 
Power Source(s)

Battery(1)

 
Washable

Yes(27)

No(3)

 
Display Type(s)

LCD(1)

 
Number of Display Digits

10(1)

 
Percent Key(s)

No(1)

 
Adjustability Features

Detachable Suspenders(8)

Elastic Strap(6)

Hook and Loop Closure(5)

Strap(4)

Adjust Shape; Thickness(2)

Adjustable Cushions; Straps(2)

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

Tri-Tachment System Eliminates Repeated Readjustments(1)

Adjustable Strap; Body Heat Adjust Cushion Curvature(1)

 
Display Notation

Numeric(1)

 
Grand Total Key

No(1)

 
+/- Switch Key

No(1)

 
Time/Date

No(1)

 
Double Zero Key

No(1)

 
Tax Calculation

No(1)

 
Percent Add-On/Discount

No(1)

 
Backspace Key

No(1)

 
Item Count Function

No(1)

 
Markup/Down Key

No(1)

 
Decimal Function

No(1)

 
Loan Calculation

Yes(1)

 
Square Root Key

No(1)

 
Fraction/Decimal Conversions

No(1)

 
Trig/Log Functions

No(1)

 
Amortization

Yes(1)

 
Complex Number Calculations

No(1)

 
Interest Rate Conversion

No(1)

 
Bond Calculations

Yes(1)

 
Time-Value-of-Money

Yes(1)

 
Probability (Random Number)

No(1)

 
Simultaneous Equations

No(1)

 
Variable Regression

Yes(1)

 
Hyperbolic Functions

No(1)

 
Base Number Calculations

No(1)

 
Logical (Boolean) Operations

No(1)

 
Date Calculations

Yes(1)

 
Hypothesis Testing

No(1)

 
Linear Regression

Yes(1)

 
Metric Conversion

No(1)

 
Polar-Rectangular Conversion

No(1)

 
Confidence Interval Calculating

No(1)

 
Matrices

No(1)

 
Replacement Batteries

3V Lithium(1)

 
Display Characters x Display Lines

10 x 1(1)

 
Case

Synthetic Leather Pouch(1)

 
Variable Statistics

Two(1)

 
Cash Flow Calculations

Yes(1)

 
Entry Logic

RPN(1)

 
Straps

Yes(32)

 
Programming Steps

99 with Subroutines(1)

 
Number of Stays

4(12)

2(1)

Unlimited(1)

6(1)

 
Memory

20 Registers(1)

 
Cost/Sell/Margin

No(1)

 
Currency Exchange Function

No(1)

 
Fraction Calculations

No(1)

 
Depreciation Calculations

Yes(1)

 
Equation Editor

No(1)

 
Back Support Type

Chair(20)

Belt(14)

Lumbar(3)

Pedestal File Seat Cushion(2)

Credenza Seat Cushion(2)

Compression(1)

 
 
 

© 2019-2020 Office Solutions & Innovations, Inc., All Rights Reserved