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

Currently Filtered by

Category

Floor Mats

Refine Search

  GO
 
Brand

Crown(71)

Guardian(47)

ES Robbins(4)

Ergotron(1)

 
Color(s)

Charcoal(35)

Black(27)

Gray(19)

Brown(18)

Midnight Blue(6)

Slate(3)

Terra Cotta(3)

Steel Gray(3)

Royal Blue(2)

Red(2)

Black/Brown(2)

Black/Gray(2)

Black/Yellow Border(1)

 
Manufacturer Part Number

CB0035BR(1)

24020300(1)

64030530(1)

64030520(1)

44030550(1)

44030535(1)

44020350(1)

44020335(1)

24031202(1)

24030502(1)

24030501DIAM(1)

24030500(1)

24020302(1)

24020301DIAM(1)

14040600(1)

64031030(1)

14030500(1)

184721(1)

184719(1)

184716(1)

184714(1)

97620060(1)

ZC0310GY(1)

ZC0025GY(1)

ZC0023GY(1)

WSCT35TC(1)

WSCT35BK(1)

WA-0046GY(1)

WA-0035GY(1)

64031020(1)

64040620(1)

S1R046ST(1)

EGDFB020304(1)

WG040604(1)

WG031014(1)

WG031004(1)

WG030514(1)

WG030504(1)

EGDSF040804(1)

EGDSF030604(1)

EGDFB040804(1)

EGDFB040604(1)

EGDFB031004(1)

EGDFB030504(1)

EGDFB030404(1)

EGDFAN020404(1)

64040630(1)

EGDFAN020304(1)

EGDDF040804(1)

EGDDF030804(1)

EG040604(1)

EG031004(1)

EG030504(1)

EG020304(1)

94040650(1)

94040635(1)

94031050(1)

94031035(1)

94030550(1)

94030535(1)

S1R310ST(1)

S1R035ST(1)

CB0035GY(1)

CU3660BK(1)

ECR046MB(1)

ECR046CH(1)

ECR035MB(1)

ECR035CH(1)

DS0310CH(1)

DS0046RD(1)

DS0046CH(1)

DS0035RD(1)

DS0035CH(1)

CU3672GY(1)

CU3672BK(1)

CU3660GY(1)

CS-0046GY(1)

ECR310MB(1)

CS-0046BR(1)

CS-0035GY(1)

CS-0035BR(1)

CK0035BL(1)

CK0023BL(1)

CD0312DB(1)

CD0035YB(1)

CD0035DB(1)

CD0023DB(1)

CB0310GY(1)

CB0310BR(1)

CB0046GY(1)

CB0046BR(1)

ECR310CH(1)

ET0035CH(1)

OXH046GY(1)

NR0034BR(1)

OXH046BR(1)

OXH035GY(1)

OXH035BR(1)

NR0310GY(1)

NR0310BR(1)

NR0046GY(1)

NR0046CH(1)

NR0046BR(1)

NR0035GY(1)

NR0035CH(1)

NR0035BR(1)

NR0034CH(1)

NR0023CH(1)

ET0035MB(1)

MASR42BK(1)

MAFG62BK(1)

FN-0046GY(1)

FN-0035GY(1)

FL3660GY(1)

FL3660BK(1)

FL3610GY(1)

FL2436GY(1)

FJS736GY(1)

ET0310MB(1)

ET0310CH(1)

ET0046MB(1)

ET0046CH(1)

WG040614(1)

 
Country of Origin

US(74)

CA(41)

LK(4)

IN(4)

 
Width

36"(66)

48"(26)

24"(17)

35"(4)

45"(3)

96"(3)

34"(2)

27"(1)

72"(1)

 
Material(s)

Polypropylene(34)

Recycled Bottles for Carpet; Recycled Tires for Rubber Backing(12)

P.E.T. Polyester(12)

Vinyl(9)

Rubber(8)

Nylon/Polypropylene(7)

Nylon/Olefin(6)

Microfiber/Olefin(5)

Loop Pile Polypropylene Fibers(4)

Olefin/Polypropylene(4)

Vinyl; Nitrile Rubber(4)

Closed Cell PVC(4)

Plastic(4)

Sponge(3)

Vinyl/Nitrile blend(2)

Zedlan(2)

Olefin(2)

Polyurethane Foam(1)

 
Shape

Rectangular(117)

Rectangular with Double Fan(2)

Half Moon(2)

Rectangular with Single Fan(2)

 
Length

60"(41)

72"(27)

36"(18)

120"(17)

48"(5)

70"(3)

144"(2)

59"(2)

118"(2)

24"(2)

32"(1)

58"(1)

115"(1)

96"(1)

 
Style

Rectangular(27)

Anti-Fatigue(4)

Double Fan(2)

Fan Only(2)

Single Fan(2)

 
Capacity (Weight)

13 1/4 lbs.(2)

21 lbs.(2)

 
Thickness

3/8"(26)

0.313"(22)

0.375"(19)

0.5"(13)

1/4"(12)

0.25"(6)

0.38"(5)

0.563"(4)

3/32"(4)

0.438"(4)

0.125"(4)

0.625"(2)

5/16"(1)

5/8"(1)

 
Backing Material

Vinyl(53)

Rubber(20)

Crumb Rubber(12)

PVC Foam Cushion(10)

Nitrile Rubber(9)

Vinyl/Natural Organic Resin Blend(6)

Sponge Foam(4)

D.O.P.-Free PVC/Thermoflex Vinyl(4)

PVC Foam(4)

Polyurethane Foam(1)

 
Mat Type

Wiper Mat(67)

Anti-Fatigue Mat(34)

Wiper/Scraper Mat(18)

Drain Mat(4)

 
Surface

Carpet(34)

Ribbed(11)

Olefin/Ribbon Polypropylene(4)

Marbleized Rubber(4)

Medium Pile(4)

Vented(4)

Solid PVC(4)

Diamond-Pattern(3)

Pebble Grain Sponge(3)

Molded Ribbed(3)

Ribbon Polypropylene(2)

Continous Filament Olefin(2)

Molded Tread(2)

Air Dome(2)

Vinyl(2)

Polyurethane Foam(1)

 
Backing Type

Textured(45)

Non-Skid(18)

Smooth(8)

Cleated(5)

Ribbed(4)

 
Lip Size (W x L)

No Lip(18)

 
 
 

© 2019-2020 gemlaser, Inc., All Rights Reserved