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

Currently Filtered by

Category

Nameplates

Refine Search

  GO
 
Brand

Xstamper(86)

Trend(12)

Ashley(8)

Carson-Dellosa(8)

Advantus(2)

Quartet(1)

Fellowes(1)

Carson-Dellosa Publishing(1)

Lorell(1)

 
Color

Black(21)

Multicolor(16)

Assorted(12)

Gold(11)

Silver(10)

Brown(7)

Almond(7)

Gray(6)

Gold Frame(4)

Silver Frame(4)

White(3)

Black Holder(2)

Black Lettering(2)

Gray Frame(2)

Clear(1)

Clear Frame(1)

Black Frame(1)

Black Plastic(1)

Bronze(1)

Brown Frame(1)

Gold Badge(1)

Dark Graphite(1)

Almond Frame(1)

Silver Badge(1)

 
Recycled

No(92)

Yes(2)

 
Packaged Quantity

1 Each(90)

36 / Pack(14)

1 Pack(6)

10 / Pack(3)

32 / Pack(2)

106 / Pack(1)

1 / Pack(1)

40 / Pack(1)

 
Assembly Required

No(23)

 
Limited Warranty

3 Year(1)

 
Weight (Approximate)

1.44 oz(20)

1.50 lb(2)

3.84 oz(1)

 
Skill Learning

Classroom(3)

Letter Recognition(2)

Mathematics(1)

Creativity(1)

 
Theme/Subject

Learning(6)

 
Mount Type

Magnetic(8)

Self-adhesive(1)

 
Printed Design/Pattern/Texture

Logo(9)

Dotted(3)

Chevron(3)

Colorful Spotlights(1)

White Stars(1)

Colorful Sea Creatures(1)

White Bubbles(1)

Colorful Owls(1)

BlockStars(1)

Parade of Elephant(1)

Zebra(1)

Sparkle(1)

Apple(1)

Frogs(1)

Boho Bird(1)

Gel Star(1)

 
Holding Height

2"(20)

8"(4)

4"(4)

6"(4)

 
Holding Width

10"(10)

8"(10)

4"(8)

6"(4)

 
Manufacturer Part Number

K24(1)

K25(1)

K23(1)

K22(1)

K20(1)

K21(1)

K26(1)

K27(1)

K36(1)

K37(1)

K35(1)

K32(1)

K30(1)

K31(1)

K02(1)

K01(1)

J51(1)

J60(1)

J50(1)

J43(1)

J41(1)

J42(1)

J61(1)

J62(1)

J67(1)

J68(1)

J66(1)

J65(1)

J63(1)

K40(1)

K41(1)

W31(1)

W32(1)

W30(1)

W26(1)

K89(1)

K95(1)

W35(1)

W36(1)

W52(1)

W53(1)

W51(1)

W50(1)

W37(1)

K86(1)

K83(1)

K53(1)

K54(1)

K51(1)

K50(1)

K44(1)

K45(1)

K60(1)

K61(1)

K81(1)

K82(1)

K80(1)

K66(1)

K65(1)

J33(1)

G73(1)

80669(1)

9003(1)

75906(1)

150036(1)

122034(1)

122127(1)

69013(1)

69026(1)

69243(1)

69254(1)

69217(1)

69076(1)

69040(1)

122029(1)

122013(1)

10118(1)

10132(1)

10116(1)

10082(1)

10079(1)

10080(1)

10133(1)

75334(1)

122010(1)

122012(1)

122007(1)

122006(1)

75390(1)

69401(1)

69402(1)

G52(1)

G53(1)

G51(1)

G50(1)

G42(1)

G43(1)

G60(1)

G61(1)

G71(1)

G72(1)

G70(1)

G63(1)

G62(1)

G41(1)

G40(1)

G02(1)

G30(1)

G01(1)

79411(1)

69948(1)

69954(1)

G31(1)

G32(1)

G37(1)

G38(1)

G36(1)

G35(1)

G33(1)

10077(1)

 
Country of Origin

United States(106)

China(11)

CN(1)

US(1)

 
Material

Plastic(56)

Aluminum(23)

Walnut Wood(5)

Aluminum Frame(5)

Foam(3)

Brass Plate(3)

Wood(2)

Plastic Plate(2)

Acrylic(2)

Acrylic Base(2)

Metal(2)

Plastic Cover(1)

Steel(1)

Aluminum Base(1)

 
Height

2"(39)

3"(14)

2.88"(8)

2.9"(4)

2.87"(2)

3.75"(2)

0.6"(2)

2.25"(2)

0.31"(2)

2.5"(2)

9"(1)

2.7"(1)

4"(1)

 
Width

8"(19)

10"(16)

9.50"(10)

1.5"(9)

9.5"(4)

13"(4)

1"(3)

2.88"(2)

2.5"(2)

18"(2)

9"(2)

0.8"(1)

13.1"(1)

8.8"(1)

9 1/2"(1)

0.9"(1)

 
Depth

0.6"(2)

0.8"(1)

 
Shape

Rectangular(56)

Square(12)

30 x Rectangle(3)

Rectangle(3)

36 x Rectangle(2)

7 x Spanish Accent Mark(1)

13 x Numbers(1)

19 x Punctuation Marks(1)

40 x Owl(1)

10 x Rectangle(1)

Alphabet(1)

36 x Star(1)

66 x Uppercase Letters(1)

 
Length

9.50"(2)

7"(1)

 
Base Material

Plastic/Steel(1)

 
Placement

Desktop(33)

Wall(20)

Door(19)

Wall Mountable(17)

Countertop(12)

Door-mountable(1)

Cubicle-mountable(1)

 
Grade

Pre-K-High School(1)

 
Base Color

Black/Dark Gray(1)

 
Theme

Monkeys(1)

 
Mounting

Desk; Door; Wall(1)

 
Lettering

White(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved