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)

Monitors(10)

Multimedia Speakers(10)

Cable Locks(10)

Wireless Routers(9)

Docking Stations(8)

Stands & Equipment Cabinets(8)

Connector Adapters(7)

Wireless Access Points/Bridges(7)

Switches & Bridges(7)

Mounting Kits(5)

USB/Firewire Adapters(5)

WebCams(4)

Power Adapters(3)

Network Interface Cards(2)

Audio & Video Consoles/Extenders(2)

Wireless NICs & Adapters(2)

Routers & Gateways(2)

Lighting Filters(1)

Ties/Seals(1)

Video Processing/Capturing Modules(1)

Video Switchboxes(1)

Phone Add-ons(1)

Electric Switches & Dimmers(1)

Tool Kits(1)

Surge Suppressors/Protectors(1)

Cable Modems(1)

Furniture Accessories(1)

Home & Office Security(1)

Power Inverters(1)

Protective Covers(1)

Biometrics(1)

Brand

3M(91)

Tripp Lite(63)

Belkin(31)

Linksys(30)

Kantek(28)

Business Source(27)

Kensington(25)

Verbatim(25)

Logitech(22)

Bluelounge(12)

Compucessory(11)

Fellowes(11)

Viewsonic(10)

Read Right(9)

Dust-Off(7)

Falcon(6)

CHERRY(6)

Spracht(5)

Advantus(4)

Lorell(4)

ChargeTech(4)

CordAway(4)

Allsop(3)

Endust(2)

SKILCRAFT(2)

Tatco(2)

Keyspan(2)

VELCRO®(2)

Clorox(2)

Bostitch(2)

Weiman(2)

Maxell(1)

Command(1)

Master(1)

Plantronics(1)

Digital Innovations(1)

Windex®(1)

Acco(1)

Educational Insights(1)

Color

Black(230)

Matte(45)

Glossy(43)

Silver(21)

White(21)

Gray(19)

Clear(19)

Blue(16)

Gold(13)

Aqua(8)

Red(7)

Multi(5)

Dark Gray(3)

Graphite(3)

Assorted(3)

Aluminum(2)

Charcoal(2)

Obsidian Black(1)

Natural(1)

Purple(1)

Pearl Black(1)

Crystal Clear(1)

Marble White(1)

Platinum(1)

Green(1)

Black Gray(1)

Light Gray(1)

Glossy Black(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