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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CASE WHEN ds.type='hot deals' THEN `ds`.`expiration_date` >= CURDATE() else CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` END 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 (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>computer>computers)+(>accessory>accessory)' IN BOOLEAN MODE) OR (`category_name` LIKE 'computer accessories') OR (`pinfo`.`manufacturer_prefix` LIKE '%computer accessories%' OR `pinfo`.`manufacturer_name` LIKE '%computer accessories%' OR `pinfo`.`sku` LIKE '%computer accessories%' OR `pinfo`.`desc_long` LIKE '%computer accessories%' OR `pinfo`.`desc_title` LIKE '%computer accessories%' OR `pinfo`.`keywords` LIKE '%computer accessories%') ) 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_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 ('computer +accessory' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+computer +accessory' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"computer accessory"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"computer accessory"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"computer accessory"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"computer accessory"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+computer +accessory' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='accessory',`category_4` ='accessory') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'accessory,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('accessory', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Computer Accessories

Refine Search

  GO
Category

Screens & Filters(145)

Connector Cables(79)

Pointing Devices(53)

Cleaning Kits(44)

Cable Management(26)

Multimedia Speakers(10)

Monitors(10)

Cable Locks(10)

Wireless Routers(9)

Stands & Equipment Cabinets(8)

Docking Stations(8)

Connector Adapters(7)

Wireless Access Points/Bridges(7)

Switches & Bridges(7)

USB/Firewire Adapters(5)

Mounting Kits(5)

WebCams(4)

Power Adapters(3)

Routers & Gateways(2)

Wireless NICs & Adapters(2)

Network Interface Cards(2)

Audio & Video Consoles/Extenders(2)

Video Processing/Capturing Modules(1)

Ties/Seals(1)

Video Switchboxes(1)

Phone Add-ons(1)

Home & Office Security(1)

Lighting Filters(1)

Power Inverters(1)

Surge Suppressors/Protectors(1)

Tool Kits(1)

Protective Covers(1)

Cable Modems(1)

Furniture Accessories(1)

Biometrics(1)

Electric Switches & Dimmers(1)

Brand

3M(91)

Tripp Lite(63)

Belkin(31)

Linksys(30)

Kantek(28)

Business Source(27)

Verbatim(25)

Kensington(25)

Logitech(22)

Bluelounge(12)

Fellowes(11)

Compucessory(11)

Viewsonic(10)

Read Right(9)

Dust-Off(7)

CHERRY(6)

Falcon(6)

Spracht(5)

Advantus(4)

CordAway(4)

Lorell(4)

ChargeTech(4)

Allsop(3)

SKILCRAFT(2)

Keyspan(2)

Endust(2)

VELCRO®(2)

Weiman(2)

Tatco(2)

Bostitch(2)

Clorox(2)

Digital Innovations(1)

Educational Insights(1)

Maxell(1)

Master(1)

Command(1)

Acco(1)

Plantronics(1)

Windex®(1)

Color

Black(230)

Matte(45)

Glossy(43)

White(21)

Silver(21)

Gray(19)

Clear(19)

Blue(16)

Gold(13)

Aqua(8)

Red(7)

Multi(5)

Dark Gray(3)

Assorted(3)

Graphite(3)

Charcoal(2)

Aluminum(2)

Natural(1)

Light Gray(1)

Purple(1)

Glossy Black(1)

Obsidian Black(1)

Black Gray(1)

Crystal Clear(1)

Pearl Black(1)

Green(1)

Platinum(1)

Marble White(1)

Brightness

250 Nit(7)

300 Nit(3)

Recycled

No(46)

Price Range

$0-$499.99(460)

$500-$999.99(2)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CleanAir Granite Office

© 2020-2021 Granite Office, LLC, All Rights Reserved