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

Currently Filtered by

Category

Floor Mats

Refine Search

  GO
Brand

Crown(135)

Guardian(63)

ES Robbins(13)

3M(12)

Boardwalk(5)

WizKid(2)

Safco(1)

Rubbermaid Commercial(1)

Ergotron(1)

Anchor Brand(1)

ergodyne(1)

Alera(1)

Color(s)

Charcoal(47)

Black(46)

Gray(32)

Brown(27)

Black/Yellow(7)

Midnight Blue(6)

Red(5)

Terra Cotta(5)

Dark Brown(5)

Walnut(4)

Slate(3)

Black/Brown(3)

White(3)

Steel Gray(3)

Red Brick(3)

Brown/Caramel(3)

Slate Gray(2)

Tan(2)

Blue(2)

Horizon Blue(2)

Clear(2)

Black/White(2)

Chestnut Brown(2)

Marlin Blue(2)

Castellan Red(2)

Black/Gray(2)

Anthracite(2)

Royal Blue(2)

Gray/White(2)

Black/Yellow Border(2)

Mocha(1)

Chocolate(1)

Granite(1)

Pewter(1)

Evergreen(1)

Black/Black(1)

Green/Black(1)

French Gray(1)

Medium Gray(1)

Natural Tan(1)

Manufacturer Part Number

184722(1)

184721(1)

14030500(1)

14040600(1)

24020301DIAM(1)

24020300(1)

184719(1)

184717(1)

184543(1)

110033(1)

184545(1)

184552(1)

184716(1)

184714(1)

24020302(1)

24030500(1)

64030520(1)

44030550(1)

64030530(1)

64031020(1)

64040620(1)

64031030(1)

44030535(1)

44020350(1)

24030502(1)

24030501DIAM(1)

24031202(1)

34030401(1)

44020335(1)

110030(1)

110024(1)

WBZ312KD(1)

WBZ035YD(1)

WBZ312YD(1)

WC3125SG(1)

WCRPLPAD(1)

WC3125SW(1)

WBZ035KD(1)

WBZ023YD(1)

WA-0035GY(1)

WA-0035BR(1)

WA-0046BR(1)

WA-0046GY(1)

WBZ023KD(1)

WCRPLPDW(1)

WS4E24YE(1)

ZC0025GY(1)

ZC0023GY(1)

ZC0310GY(1)

18385(1)

110021(1)

97620060(1)

WSTF35TC(1)

WSTF35BK(1)

WS4E40YE(1)

WS4E26YE(1)

WS4E64YE(1)

WSCT35BK(1)

WSCT35TC(1)

64040630(1)

94030530(1)

WG040604(1)

WG031014(1)

WG040610(1)

WG040612(1)

3200310BL(1)

WG040614(1)

WG031012(1)

WG031010(1)

WG030510(1)

WG030504(1)

WG030512(1)

WG030514(1)

WG031004(1)

3200310TN(1)

3200320BL(1)

625046GY(1)

625046BR(1)

1982726(1)

2110BL(1)

C20001BR4(1)

C20001BL4(1)

625035GY(1)

625035BR(1)

34838(1)

3200320TN(1)

34839(1)

34840(1)

34843(1)

UGMM030514(1)

UGMM030504(1)

94040650(1)

94040635(1)

94040680(1)

EG020304(1)

EG031004(1)

EG030504(1)

94040630(1)

94031080(1)

94030550(1)

94030535(1)

94030580(1)

94031035(1)

94031050(1)

EG040604(1)

EGDDF030804(1)

EGDFB040804(1)

EGDFB040604(1)

EGDSF030604(1)

EGDSF040804(1)

PARQUET3X5(1)

PARQUET2X3(1)

EGDFB031004(1)

EGDFB030504(1)

EGDFAN020304(1)

EGDDF040804(1)

EGDFAN020404(1)

EGDFB020304(1)

EGDFB030404(1)

TE-0046GY(1)

TE-0046AC(1)

DS0046RD(1)

DS0046CH(1)

DS0310CH(1)

DXHC35BC(1)

DXMU32BC(1)

DXHC46BC(1)

DS0035RD(1)

DS0035CH(1)

DEMB35BR(1)

CU3672GY(1)

DEMB35GY(1)

DEMB46BR(1)

DEMB46GY(1)

ECR035CH(1)

ECR035MB(1)

ET0310CH(1)

ET0046MB(1)

ET0310MB(1)

FJS736GY(1)

FL2436GY(1)

FL2436BK(1)

ET0046CH(1)

ET0035MB(1)

ECR046MB(1)

ECR046CH(1)

ECR310CH(1)

ECR310MB(1)

ET0035CH(1)

CU3672BK(1)

CU3660SF(1)

CB0046BR(1)

CB0035GY(1)

CB0046GY(1)

CB0310BR(1)

CD0023DB(1)

CB0310GY(1)

CB0035BR(1)

UMGW(1)

CMBW(1)

AB-GDN-5(1)

CMGW(1)

UMBB(1)

UMBW(1)

CD0023YB(1)

CD0035DB(1)

CS-0046GY(1)

CS-0046BR(1)

CU2436BK(1)

CU3660BK(1)

CU3660SB(1)

CU3660GY(1)

CS-0035GY(1)

CS-0035BR(1)

CD0312DB(1)

CD0035YB(1)

CK0023BL(1)

CK0035BL(1)

CS0023BR(1)

FL3610GY(1)

FL3660BK(1)

OXH035BR(1)

OE0046BR(1)

OXH035GY(1)

OXH046BR(1)

S1R035ST(1)

OXH046GY(1)

NR0310GY(1)

NR0310BR(1)

NR0035GY(1)

NR0035CH(1)

NR0046BR(1)

NR0046CH(1)

NR0046GY(1)

S1R046ST(1)

S1R310ST(1)

SSR310DB(1)

SSR310CH(1)

TD0035BK(1)

TD0046BK(1)

TE-0035GY(1)

TE-0035AC(1)

SSR046MG(1)

SSR046DB(1)

SSR023CH(1)

SPNC35PE(1)

SSR035CH(1)

SSR035DB(1)

SSR046CH(1)

NR0035BR(1)

NR0034GN(1)

GS0035CH(1)

GS0034WA(1)

GS0035CR(1)

GS0035MB(1)

GS0046CH(1)

GS0035WA(1)

GS0034CH(1)

GS0023CH(1)

FN-0035BR(1)

FL3660GY(1)

FN-0035GY(1)

FN-0046BR(1)

FN-0046GY(1)

GS0046CR(1)

GS0046EG(1)

MN0046AC(1)

MN0035DB(1)

MN0046DB(1)

NR0023CH(1)

NR0034CH(1)

NR0034BR(1)

MN0035AC(1)

MASR42BK(1)

GS0046WA(1)

GS0046MB(1)

GS0310CH(1)

GS0310WA(1)

MAFG62BK(1)

AE23AFM(1)

Country of Origin

US(134)

CA(71)

IN(10)

JP(7)

LK(6)

VN(4)

CN(3)

TW(2)

NL(2)

MY(1)

Width

36"(117)

48"(49)

24"(30)

34"(6)

35"(6)

45"(5)

96"(3)

40"(3)

27"(3)

17 1/2"(3)

31 1/2"(2)

16"(2)

22 7/8"(2)

30"(2)

20"(1)

72"(1)

43 3/4"(1)

35 1/2"(1)

3'(1)

4'(1)

28"(1)

Material(s)

Polypropylene(58)

Vinyl(30)

Rubber(24)

Olefin(18)

P.E.T. Polyester(12)

Nylon/Polypropylene(12)

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

PVC(7)

Vinyl; Nitrile Rubber(6)

Nylon/Olefin(6)

Olefin/Polypropylene(5)

Microfiber/Olefin(5)

Plastic(4)

Plastic Film(4)

Closed Cell PVC(4)

Loop Pile Polypropylene Fibers(4)

Polypropylene/ThermoFlex Vinyl(4)

Vinyl/Nitrile Rubber Compound(3)

Sponge(3)

Polyethylene(2)

Zedlan(2)

Vinyl/Nitrile blend(2)

Polyurethane Foam(2)

Acrylic(2)

Synthetic Fiber(2)

Spiffy Vinyl(2)

Woven Fibers(1)

Loop Pile Polypropylene Fibers/Nylon Fibers(1)

NBR Foam(1)

Synthetic Rubber(1)

100% Rubber(1)

Shape

Rectangular(225)

Triangle(3)

Rectangular with Single Fan(2)

Half Moon(2)

Commode(2)

U-Shaped(2)

Rectangular with Double Fan(2)

Square(1)

Length

60"(72)

72"(50)

36"(29)

120"(29)

48"(9)

2400"(4)

24"(4)

58"(3)

70"(3)

240"(3)

20"(3)

22"(3)

25"(2)

40"(2)

25 1/2"(2)

28"(2)

68"(2)

59"(2)

118"(2)

144"(2)

119"(2)

96"(1)

30"(1)

64"(1)

124"(1)

5'(1)

66 3/4"(1)

6'(1)

115"(1)

59 1/2"(1)

32"(1)

Style

Rectangular(71)

Anti-Fatigue(7)

Wedge(7)

Single Fan(2)

Fan Only(2)

Vinyl Lip, Rectangular Wiper(2)

Double Fan(2)

Rectangular Bath(1)

Disposable(1)

Capacity (Weight)

1 liter(5)

21 lbs.(2)

13 1/4 lbs.(2)

250 lbs.(1)

6.12 lbs.(1)

Thickness

3/8"(38)

0.38"(34)

0.375"(29)

0.313"(28)

1/4"(24)

0.5"(15)

0.25"(8)

5/8"(8)

3/32"(7)

0.125"(6)

0.438"(5)

0.563"(5)

0.17"(5)

0.41"(4)

7/8"(4)

2.2 mm(4)

0.625"(2)

1/2"(2)

3/4"(1)

5/16"(1)

1 1/2"(1)

0.875"(1)

0.88"(1)

1"(1)

Backing Material

Vinyl(90)

Rubber(50)

Crumb Rubber(12)

PVC Foam Cushion(11)

Nitrile Rubber(9)

SBR Rubber(8)

Sponge Foam(7)

Vinyl/Natural Organic Resin Blend(6)

Zedlan Foam(6)

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

Premium ThermoFlex Vinyl(4)

Removable Adhesive(4)

PVC Foam(4)

Polypropylene Foam(4)

PVC(3)

Synthetic Rubber(2)

Polyurethane Foam(2)

Polyethylene(2)

PVC Sponge(1)

Plastic(1)

Mat Type

Wiper Mat(132)

Anti-Fatigue Mat(57)

Wiper/Scraper Mat(26)

Drain Mat(10)

Commode Mat(4)

Disposable Protector Mat(4)

Urinal Mat(3)

Pad Refills(2)

Bath(1)

Kneeling Mat(1)

Surface

Carpet(38)

Olefin(14)

Ribbed(12)

Rubber(9)

Polypropylene(8)

Z-Web(8)

Vented(6)

Deck Plate PVC(6)

Medium Pile(5)

Olefin/Ribbon Polypropylene(5)

Marbleized Rubber(5)

Smooth(4)

Vinyl Coiled Loop(4)

Solid PVC(4)

Continous Filament Olefin(4)

Drainage Holes(4)

Vinyl-Loop Scraper(4)

Ribbon Polypropylene(4)

Needle-Punched; Latex Coated Patterns(4)

Molded Ribbed(3)

Pebble Grain Sponge(3)

Raised Dome(3)

Diamond-Pattern(3)

Hard Floor/All Pile Carpets(2)

Diamond-Pattern Vinyl-Loop Scraper(2)

Vinyl(2)

Fiber(2)

Air Dome(2)

Spiffy Vinyl(2)

Polyethylene(2)

Molded Tread(2)

Woven Fibers(1)

Textured Vinyl(1)

Polyurethane Foam(1)

Rib Emboss(1)

Diamond-Pattern Vinyl-Loop(1)

Cleated(1)

Backing Type

Textured(53)

Non-Skid(39)

Smooth(25)

Ribbed(6)

Sponge(6)

Cleated(5)

Slip-Resistant(5)

Waffle Pattern(3)

Non-Slip Grip(2)

Rubber(2)

Unbacked(1)

Polyurethane Foam(1)

Suction-Cup(1)

Vinyl(1)

Lip Size (W x L)

No Lip(23)

2" x 2"(2)

16" x 1"(1)

48" x 1"(1)

36" x 1"(1)

16" x 28"(1)

Price Range

$0-$499.99(237)

$500-$999.99(3)

To  GO

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

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