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_36` 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(78)

Guardian(60)

ES Robbins(4)

Safco(1)

Ergotron(1)

Alera(1)

 
Color(s)

Charcoal(36)

Black(31)

Gray(25)

Brown(20)

Midnight Blue(6)

Red(5)

Steel Gray(3)

Red Brick(3)

Terra Cotta(3)

Slate(3)

Black/Yellow Border(2)

Black/Brown(2)

Black/Gray(2)

Royal Blue(2)

Chocolate(1)

Pewter(1)

 
Manufacturer Part Number

64030520(1)

64030530(1)

64031020(1)

44030550(1)

44030535(1)

24031202(1)

44020335(1)

44020350(1)

64031030(1)

64040620(1)

94031035(1)

94031050(1)

94031080(1)

94030580(1)

94030550(1)

64040630(1)

94030535(1)

24030502(1)

24030501DIAM(1)

ZC0310GY(1)

97620060(1)

184714(1)

ZC0025GY(1)

ZC0023GY(1)

WSCT35BK(1)

WSCT35TC(1)

184716(1)

184719(1)

24020301DIAM(1)

24020302(1)

24030500(1)

24020300(1)

14040600(1)

184721(1)

14030500(1)

94040635(1)

94040650(1)

WG030510(1)

WG030512(1)

WG030514(1)

WG030504(1)

UGMM030514(1)

PARQUET3X5(1)

UGMM030504(1)

WG031004(1)

WG031010(1)

WG040612(1)

WG040614(1)

2110BL(1)

WG040610(1)

WG040604(1)

WG031012(1)

WG031014(1)

PARQUET2X3(1)

EGDSF040804(1)

EG040604(1)

EGDDF030804(1)

EGDDF040804(1)

EG031004(1)

EG030504(1)

94040680(1)

EG020304(1)

EGDFAN020304(1)

EGDFAN020404(1)

EGDFB040604(1)

EGDFB040804(1)

EGDSF030604(1)

EGDFB031004(1)

EGDFB030504(1)

EGDFB020304(1)

EGDFB030404(1)

WA-0046GY(1)

WA-0035GY(1)

DEMB46BR(1)

DEMB46GY(1)

DS0035CH(1)

DEMB35GY(1)

DEMB35BR(1)

CU3660GY(1)

CU3672BK(1)

CU3672GY(1)

DS0035RD(1)

DS0046CH(1)

ECR046CH(1)

ECR046MB(1)

ECR310CH(1)

ECR035MB(1)

ECR035CH(1)

DS0046RD(1)

DS0310CH(1)

CU3660BK(1)

CS-0046GY(1)

CB0310BR(1)

CB0310GY(1)

CD0023DB(1)

CB0046GY(1)

CB0046BR(1)

CB0035BR(1)

CB0035GY(1)

CD0023YB(1)

CD0035DB(1)

CS-0035BR(1)

CS-0035GY(1)

CS-0046BR(1)

CK0035BL(1)

CK0023BL(1)

CD0035YB(1)

CD0312DB(1)

ECR310MB(1)

ET0035CH(1)

NR0046CH(1)

NR0046GY(1)

NR0310BR(1)

NR0046BR(1)

NR0035GY(1)

NR0035BR(1)

NR0035CH(1)

NR0310GY(1)

OXH035BR(1)

S1R046ST(1)

S1R310ST(1)

SPNC35PE(1)

S1R035ST(1)

OXH046GY(1)

OXH035GY(1)

OXH046BR(1)

NR0034CH(1)

NR0034BR(1)

ET0310MB(1)

FJS736GY(1)

FL2436BK(1)

ET0310CH(1)

ET0046MB(1)

ET0035MB(1)

ET0046CH(1)

FL2436GY(1)

FL3610GY(1)

MAFG62BK(1)

MASR42BK(1)

NR0023CH(1)

FN-0046GY(1)

FN-0035GY(1)

FL3660BK(1)

FL3660GY(1)

AE23AFM(1)

 
Country of Origin

US(85)

CA(42)

IN(6)

LK(4)

JP(4)

NL(2)

CN(1)

TW(1)

 
Width

36"(78)

48"(31)

24"(21)

35"(4)

96"(3)

45"(3)

34"(2)

20"(1)

27"(1)

72"(1)

 
Material(s)

Polypropylene(43)

Vinyl(14)

P.E.T. Polyester(12)

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

Nylon/Polypropylene(10)

Rubber(10)

Nylon/Olefin(6)

Microfiber/Olefin(5)

Closed Cell PVC(4)

Plastic(4)

Vinyl; Nitrile Rubber(4)

Loop Pile Polypropylene Fibers(4)

Olefin/Polypropylene(4)

Sponge(3)

Zedlan(2)

Vinyl/Nitrile blend(2)

Polyurethane Foam(2)

Olefin(2)

PVC(1)

Synthetic Rubber(1)

 
Shape

Rectangular(139)

Rectangular with Single Fan(2)

Rectangular with Double Fan(2)

Half Moon(2)

 
Length

60"(50)

72"(32)

36"(22)

120"(20)

48"(5)

70"(3)

24"(2)

118"(2)

144"(2)

59"(2)

96"(1)

30"(1)

115"(1)

58"(1)

32"(1)

 
Style

Rectangular(65)

Anti-Fatigue(4)

Single Fan(2)

Double Fan(2)

Fan Only(2)

 
Capacity (Weight)

21 lbs.(2)

13 1/4 lbs.(2)

250 lbs.(1)

{clear}(1)

 
Thickness

3/8"(30)

0.313"(23)

0.375"(20)

1/4"(18)

0.5"(13)

0.38"(8)

0.25"(6)

0.563"(5)

0.438"(4)

3/32"(4)

0.125"(4)

1/2"(2)

0.625"(2)

5/8"(2)

3/4"(1)

5/16"(1)

 
Backing Material

Vinyl(54)

Rubber(34)

Crumb Rubber(12)

PVC Foam Cushion(11)

Nitrile Rubber(9)

Vinyl/Natural Organic Resin Blend(6)

Sponge Foam(4)

PVC Foam(4)

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

Polypropylene Foam(4)

Polyurethane Foam(2)

PVC Sponge(1)

 
Mat Type

Wiper Mat(85)

Anti-Fatigue Mat(38)

Wiper/Scraper Mat(18)

Drain Mat(4)

 
Surface

Carpet(36)

Ribbed(11)

Marbleized Rubber(4)

Vented(4)

Solid PVC(4)

Medium Pile(4)

Vinyl-Loop Scraper(4)

Olefin/Ribbon Polypropylene(4)

Pebble Grain Sponge(3)

Molded Ribbed(3)

Diamond-Pattern(3)

Vinyl(2)

Air Dome(2)

Continous Filament Olefin(2)

Ribbon Polypropylene(2)

Molded Tread(2)

Hard Floor/All Pile Carpets(2)

Rib Emboss(1)

Polyurethane Foam(1)

 
Backing Type

Textured(50)

Smooth(19)

Non-Skid(18)

Cleated(5)

Ribbed(4)

Rubber(2)

Polyurethane Foam(1)

Vinyl(1)

 
Lip Size (W x L)

No Lip(19)

2" x 2"(2)

 
 
 

© 2017-2018 Gateway Business Products, All Rights Reserved