SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 ('743')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=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 ('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

Identity Group(11)

Headline Sign(7)

Universal(1)

Quartet(1)

Schoolgirl Style(1)

Height

2"(10)

1 3/4"(4)

1 1/2"(2)

1"(1)

2.5"(1)

12"(1)

3"(1)

2.88"(1)

Width

8"(16)

9"(10)

3"(6)

10"(4)

13.1"(2)

6"(2)

9 1/2"(2)

Base Color

Silver(4)

Gold(4)

Gray(3)

Black(2)

Black/Dark Gray(1)

White(1)

Charcoal(1)

Country of Origin

US(19)

CN(2)

For Use With

Classroom Desks(1)

Base Material

Metal(2)

Aluminum(2)

Plastic(1)

Plastic/Steel(1)

Paper(1)

Mounting

Wall(3)

Very High Bond Tape(1)

Cubicle Panels; Metal Surfaces(1)

Desk; Door; Wall(1)

Lettering

Assorted(12)

White(1)

Corner/Edge Style

Square Corner(14)

Radius Edge(4)

Square Edge(2)

Rounded Corner(1)

Name Plate Color

Assorted(4)

Gray(2)

Black(2)

Charcoal(1)

White(1)

Name Plate Material

ABS Plastic(11)

Plastic(4)

Steel(1)

Paper(1)

Nameplates Type

Sign(7)

Changeable(5)

Desk Nameplate(4)

Nameplate(3)

Cubicle(1)

Special Features

Magnetic Fastener(2)

Safety Pin Fastener(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved