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

Guardian(54)

3M(5)

Scott(1)

Ergotron(1)

 
Color(s)

Charcoal(35)

Black(27)

Gray(25)

Brown(16)

Midnight Blue(6)

Anthracite(4)

Black/Gray(4)

Black/Brown(4)

Steel Gray(3)

Slate(3)

Red(2)

Dark Brown(2)

Royal Blue(2)

Blue(2)

Pepper/Salt(2)

Tan(2)

Chocolate(1)

Terra Cotta(1)

Black/Yellow Border(1)

Pewter(1)

White(1)

 
Manufacturer Part Number

44020335(1)

44020350(1)

44030535(1)

34030401(1)

24031202(1)

24030500(1)

24030501DIAM(1)

24030502(1)

44030550(1)

64030520(1)

64040630(1)

74030530(1)

74040630(1)

64040620(1)

64031030(1)

64030530(1)

64031020(1)

24020302(1)

24020301DIAM(1)

WA-0035GY(1)

WA-0046GY(1)

WSCT35BK(1)

TE-0046GY(1)

TE-0046AC(1)

TE-0035AC(1)

TE-0035GY(1)

WSCT35TC(1)

ZC0023GY(1)

14030500(1)

14040600(1)

24020300(1)

11658(1)

97620060(1)

ZC0025GY(1)

ZC0310GY(1)

94030530(1)

94030535(1)

UG030514(1)

WG030504(1)

WG030514(1)

UG030504(1)

EGDSF040804(1)

EGDFB040604(1)

EGDFB040804(1)

EGDSF030604(1)

WG031004(1)

WG031014(1)

3200320BL(1)

3200320TN(1)

34826(1)

3200310TN(1)

3200310BL(1)

WG040604(1)

WG040614(1)

EGDFB031004(1)

EGDFB030504(1)

94040635(1)

94040650(1)

EG020304(1)

94040630(1)

94031050(1)

94030550(1)

94031035(1)

EG030504(1)

EG031004(1)

EGDFAN020404(1)

EGDFB020304(1)

EGDFB030404(1)

EGDFAN020304(1)

EGDDF040804(1)

EG040604(1)

EGDDF030804(1)

SPNC35PE(1)

S1R310ST(1)

DS0046CH(1)

DS0046RD(1)

DS0310CH(1)

DS0035RD(1)

DS0035CH(1)

DEMB35GY(1)

DEMB46BR(1)

DEMB46GY(1)

ECR035CH(1)

ECR035MB(1)

ET0035CH(1)

ET0035MB(1)

ET0046CH(1)

ECR310MB(1)

ECR310CH(1)

ECR046CH(1)

ECR046MB(1)

DEMB35BR(1)

CU3672GY(1)

CB0310GY(1)

CD0023DB(1)

CD0035DB(1)

CB0310BR(1)

CB0046GY(1)

CB0035GY(1)

CB0046BR(1)

CD0035YB(1)

CD0312DB(1)

CU3660BK(1)

CU3660GY(1)

CU3672BK(1)

CS-0046GY(1)

CS-0035GY(1)

CK0023BL(1)

CK0035BL(1)

ET0046MB(1)

ET0310CH(1)

NR0310BR(1)

NR0310GY(1)

OE0035BR(1)

NR0046GY(1)

NR0046CH(1)

NR0035GY(1)

NR0046BR(1)

OE0035GY(1)

OE0046BR(1)

OXH046GY(1)

S1R035ST(1)

S1R046ST(1)

OXH046BR(1)

OXH035GY(1)

OE0046GY(1)

OXH035BR(1)

NR0035CH(1)

NR0035BR(1)

FL3660BK(1)

FL3660GY(1)

FN-0035GY(1)

FL3610GY(1)

FL2436BK(1)

ET0310MB(1)

FJS736GY(1)

FN-0046GY(1)

MAFG62BK(1)

MN0046DB(1)

NR0034BR(1)

NR0034CH(1)

MN0046AC(1)

MN0035DB(1)

MASR42BK(1)

MN0035AC(1)

CB0035BR(1)

 
Country of Origin

US(80)

CA(51)

IN(5)

JP(4)

LK(4)

NL(2)

 
Width

36"(81)

48"(34)

24"(14)

35"(4)

96"(3)

45"(3)

34"(2)

72"(1)

8 ft(1)

27"(1)

 
Material(s)

Polypropylene(42)

Vinyl(18)

P.E.T. Polyester(12)

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

Rubber(8)

Nylon/Polypropylene(7)

Nylon/Olefin(6)

Microfiber/Olefin(5)

Closed Cell PVC(4)

Plastic(4)

Loop Pile Polypropylene Fibers(4)

Polypropylene/ThermoFlex Vinyl(4)

Loop Pile Polypropylene Fibers/Nylon Fibers(4)

Sponge(3)

Zedlan(2)

Olefin/Polypropylene(2)

Vinyl/Nitrile blend(2)

Olefin(2)

Polyurethane Foam(1)

HYDROKNIT*(1)

100% Rubber(1)

 
Shape

Rectangular(135)

Rectangular with Single Fan(2)

Rectangular with Double Fan(2)

Half Moon(2)

 
Length

60"(51)

72"(35)

120"(19)

36"(15)

48"(6)

70"(3)

24"(2)

240"(2)

118"(2)

59"(2)

144"(2)

96"(1)

12 ft(1)

58"(1)

115"(1)

32"(1)

 
Style

Rectangular(27)

Anti-Fatigue(4)

Single Fan(2)

Double Fan(2)

Fan Only(2)

 
Capacity (Weight)

21 lbs.(2)

13 1/4 lbs.(2)

 
Thickness

0.375"(25)

3/8"(22)

0.313"(21)

1/4"(16)

0.5"(13)

0.38"(13)

0.438"(8)

0.25"(6)

0.563"(5)

0.125"(4)

3/32"(4)

0.625"(2)

5/8"(1)

 
Backing Material

Vinyl(53)

Rubber(24)

Crumb Rubber(12)

PVC Foam Cushion(10)

Nitrile Rubber(9)

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

Vinyl/Natural Organic Resin Blend(6)

PVC Foam(4)

Premium ThermoFlex Vinyl(4)

Polypropylene Foam(4)

Sponge Foam(4)

Polyurethane Foam(1)

 
Mat Type

Wiper Mat(80)

Anti-Fatigue Mat(36)

Wiper/Scraper Mat(23)

Drain Mat(4)

Dropcloth(1)

 
Surface

Carpet(36)

Ribbed(10)

Medium Pile(8)

Vinyl-Loop Scraper(4)

Solid PVC(4)

Needle-Punched; Latex Coated Patterns(4)

Marbleized Rubber(4)

Molded Ribbed(3)

Pebble Grain Sponge(3)

Diamond-Pattern(3)

Vinyl(2)

Air Dome(2)

Continous Filament Olefin(2)

Molded Tread(2)

Ribbon Polypropylene(2)

Olefin/Ribbon Polypropylene(2)

Cleated(1)

Polyurethane Foam(1)

 
Backing Type

Textured(48)

Smooth(18)

Non-Skid(17)

Cleated(5)

 
Lip Size (W x L)

No Lip(19)

2" x 2"(2)

 
 
 

© 2018-2019 Onestop, Inc., All Rights Reserved