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

Privacy Filters(149)

Mice(58)

AV Cables(30)

Cable Management(26)

Ethernet/Networking Cables(24)

USB Cables(22)

Air Dusters(19)

Multimedia Speakers(13)

Glare/Radiation Filters(13)

Computer Cloths/Wipes & Dusters(12)

LCD Monitors(10)

Cleaning Kits(10)

Laptop Docking Stations(10)

Wireless Routers(10)

Laptop Locks(8)

Wireless Access Points/Bridges(8)

Screen Protectors(7)

Ethernet/Networking Switches & Bridges(7)

USB Hubs(6)

Cleaning Wipes(6)

CPU Stands(5)

Connector Adapters(5)

PC & Web Cameras(5)

Monitor Stands/Risers(4)

Computer Locks & Kits(4)

Multimedia Player Power Adapters(3)

Graphic & TV Tuner Combo Cards(3)

Patch Cables(3)

Ethernet/Networking Cards & Adapters(2)

Cable Modems(2)

Ethernet/Networking Routers(2)

Lens Cleaners(2)

Range Extenders(2)

Monitor Arms(2)

Magnifying Filters(2)

Desktop Risers(2)

Wireless NICs & Adapters(2)

Tool Kits(1)

Telephone Cords & Accessories(1)

Telephone Headsets & Accessories(1)

Wireless Signal Boosters(1)

Strapping & Twines(1)

3D Printer Cartridges/Filaments(1)

Cleaning Sheets(1)

Printer & Peripheral Switches(1)

Surge Protectors(1)

Multimedia Player Docking Stations(1)

Keyboard/Mouse Platforms & Trays(1)

Trackballs(1)

Power Inverters(1)

Desktops(1)

Multimedia Player Holders & Clips(1)

Communications(1)

Flash/Video Lights & IR Illuminators(1)

Computer Dust Covers(1)

Brand

3M(97)

Tripp Lite(63)

Linksys(33)

Kensington(32)

Belkin(31)

Kantek(28)

Fellowes(28)

Business Source(27)

Verbatim(27)

Logitech(23)

Compucessory(20)

Read Right(12)

Bluelounge(12)

Viewsonic(10)

Falcon(7)

Dust-Off(6)

CHERRY(6)

Lorell(6)

Advantus(5)

Spracht(5)

CordAway(4)

ChargeTech(4)

Allsop(3)

Weiman(2)

Tatco(2)

Bostitch(2)

Clorox(2)

VELCRO®(2)

Keyspan(2)

OneScreen(2)

Windex®(2)

SKILCRAFT(2)

Endust(2)

Maxell(1)

Educational Insights(1)

Acco(1)

Plantronics(1)

Digital Innovations(1)

Command(1)

Master(1)

Color

Black(261)

Glossy(44)

Matte(44)

White(23)

Silver(22)

Gray(21)

Clear(19)

Blue(17)

Gold(13)

Aqua(8)

Red(8)

Multi(6)

Crystal Clear(4)

Graphite(4)

Assorted(3)

Dark Gray(3)

Aluminum(2)

Green(2)

Charcoal(2)

Natural(1)

Purple(1)

Obsidian Black(1)

Marble White(1)

Pearl Black(1)

Ruby Red(1)

Platinum(1)

Black Gray(1)

Light Gray(1)

Glossy Black(1)

Brightness

250 Nit(7)

300 Nit(3)

Recycled

No(52)

Price Range

$0-$499.99(513)

$500-$999.99(2)

$1000-$1499.99(1)

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