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

Currently Filtered by

Category

Chair Mats

Refine Search

  GO
Brand

deflecto(39)

ES Robbins(38)

Floortex(29)

Mammoth Office Products(7)

Universal(3)

Cleartex(1)

Advantus(1)

Color

Clear(1)

Recycled

No(1)

Color(s)

Clear(106)

Slightly Tinted(4)

Black(4)

Clear/Black(2)

Orange/Blue(1)

Manufacturer Part Number

1113423LR(1)

1113427ER(1)

1113423ER(1)

501124(1)

184603(1)

184612(1)

1115223ER(1)

1120023ER(1)

119923SR(1)

1213419LR(1)

118927ER(1)

118923LR(1)

118923ER(1)

184016(1)

184014(1)

141052(1)

143002(1)

141042(1)

141032(1)

132321(1)

141028(1)

143007(1)

143012(1)

162014(1)

162017(1)

162011(1)

162008(1)

143022(1)

1213420ERA(1)

1215015019ER(1)

V3648LSP(1)

V4553LHF(1)

V3648LHF(1)

R113618EV(1)

PF129225EV(1)

R112712EV(1)

V4553LSP(1)

V4660RHF(1)

56807(1)

56808(1)

56806(1)

V4660RSP(1)

V4660RMP(1)

PF1213425EV(1)

PF119225EV(1)

128920ERA(1)

129919SR(1)

128919LR(1)

128919ER(1)

1215020019ER(1)

1215219ER(1)

ECO3048EP(1)

ECO3648EP(1)

PF1113425EV(1)

PF1115225EV(1)

M121525ER(1)

M121345ER(1)

ECO3648LP(1)

132123(1)

131826(1)

CM15233(1)

CM15443F(1)

CM15113(1)

CM14443F(1)

CM14242BLK(1)

CM14243(1)

CM16233COM15(1)

CM16243COM15(1)

CM1K112PET(1)

CM1K142PET(1)

CM17743(1)

CM17443F(1)

CM17233(1)

CM14233COM(1)

CM14233(1)

CM11442FPC(1)

CM13113(1)

CM11442FBLK(1)

CM11442F(1)

CM11112(1)

CM11232(1)

CM13233(1)

CM13233COM(1)

CM14113(1)

CM14142BLK(1)

CM14003K(1)

CM13443F(1)

CM13433F(1)

CM1K232PET(1)

CM21232(1)

122775(1)

124054(1)

122371(1)

122271(1)

122073(1)

122173(1)

124154(1)

124173(1)

128371(1)

131823(1)

128173(1)

124377(1)

124375(1)

121821(1)

120321(1)

CM21442F(1)

CM2G112PET(1)

CM21242COM(1)

CM21242BLK(1)

CM21232COM(1)

CM2G142PET(1)

CMG70433646(1)

120082(1)

120123(1)

120023(1)

CMG70434860(1)

CMG70434450(1)

50221(1)

Country of Origin

US(71)

GB(36)

DE(7)

CN(3)

United Kingdom(1)

Width

45"(32)

36"(28)

46"(25)

48"(12)

35"(6)

60"(5)

53"(4)

49"(2)

27"(1)

44"(1)

66"(1)

Material

Polycarbonate(1)

Limited Warranty

Lifetime(1)

Material(s)

Vinyl(68)

Polycarbonate(20)

Phthalate-Free PVC(7)

PVC(7)

PET(5)

Recycled PET(3)

Glass(3)

Vinyl; Foam(2)

P.E.T. Polyester(1)

PVC Plastic(1)

Shape

Rectangular(108)

Square(2)

"Beaker" Shape(1)

L-Workstation(1)

Wide Lip(1)

Length

53"(37)

60"(30)

48"(25)

47"(6)

36"(4)

45"(3)

39"(2)

79"(2)

144"(1)

216"(1)

30"(1)

120"(1)

66"(1)

46"(1)

50"(1)

240"(1)

Style

Rectangular(64)

Lip(47)

Square(2)

L-Workstation(2)

Folded Rectangle(1)

Wide Lip(1)

Capacity (Weight)

200 lbs.(29)

12 lbs.(4)

16 lbs.(3)

150 lbs.(3)

1000 lbs.(3)

10 lbs.(3)

500 lbs.(2)

25.2 lbs.(2)

18 lbs.(2)

14 lbs.(2)

20 lbs.(2)

36 lbs.(1)

13 lbs.(1)

48 lbs.(1)

17 lbs.(1)

29 lbs.(1)

21 lbs.(1)

22 lbs.(1)

9 lbs.(1)

7 lbs.(1)

19 lbs.(1)

28.77 lbs.(1)

16.9 lbs.(1)

11 lbs.(1)

23 lbs.(1)

Thickness

1/8"(20)

0.09"(9)

0.075"(7)

0.11"(6)

0.087"(5)

0.05"(5)

0.145"(5)

0.095"(5)

1/4"(5)

0.085"(4)

0.173"(3)

0.25"(3)

0.065"(3)

0.07"(2)

.072"(2)

0.2"(2)

0.11 mil(1)

0.098"(1)

.085"(1)

1.7 mm(1)

0.112"(1)

0.08"(1)

Backing Material

Vinyl(74)

Polycarbonate(19)

Phthalate-Free PVC(7)

Recycled PET(3)

Glass(3)

Vinyl; Foam(2)

Mat Width

48"(1)

Mat Length

53"(1)

Mat Thickness

74.8 mil(1)

Mat Type

Chair Mat(111)

Carpet Runner(4)

Anti-Fatigue Mat; Chair Mat(2)

Surface

Hard Floor(30)

Low Pile(24)

Medium Pile(21)

Low/Medium Pile(9)

Standard Pile(9)

Plush Pile(7)

High Pile(5)

Hard Floor; All Pile Carpets(3)

Hard Floor; Low/Medium Pile(2)

Ribbed Texture(2)

Hard Floor/All Pile Carpets(2)

All Pile Carpet(1)

Backing Type

Smooth(29)

Studded(29)

Cleated(27)

Grippers(18)

Nonstudded(10)

Vinyl(4)

Product Type

Chair Mat(1)

Packaged Quantity

1 Each(1)

Assembly Required

No(1)

Product Line

UnoMat(1)

Lip Size (W x L)

No Lip(62)

25" x 12"(26)

20" x 10"(8)

19" x 10"(5)

20" x 12"(5)

25" x 10"(2)

25" x 11"(1)

12" x 25"(1)

10" x 20"(1)

20" x 18"(1)

Price Range

$0-$99.99(71)

$100-$199.99(33)

$200-$299.99(9)

$300-$399.99(2)

$400-$499.99(1)

To  GO

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

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved