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') 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(145)

Mice(63)

AV Cables(26)

Cable Management(25)

Air Dusters(23)

USB Cables(19)

Ethernet/Networking Cables(17)

Computer Cloths/Wipes & Dusters(14)

Multimedia Speakers(14)

Glare/Radiation Filters(13)

Wireless Access Points/Bridges(11)

Laptop Locks(10)

LCD Monitors(10)

Wireless Routers(10)

Laptop Docking Stations(9)

Cleaning Kits(8)

Ethernet/Networking Switches & Bridges(7)

USB Hubs(6)

Screen Protectors(6)

Graphic & TV Tuner Combo Cards(5)

Computer Locks & Kits(5)

CPU Stands(5)

Cleaning Wipes(5)

PC & Web Cameras(4)

Monitor Stands/Risers(4)

Connector Adapters(4)

3D Printer Cartridges/Filaments(4)

Range Extenders(3)

Multimedia Player Power Adapters(3)

Patch Cables(3)

Lens Cleaners(2)

Cable Modems(2)

Wireless NICs & Adapters(2)

Monitor Arms(2)

Workstations/Computer Desks(2)

Ethernet/Networking Cards & Adapters(2)

Magnifying Filters(2)

Ethernet/Networking Routers(2)

USB/Jump Drives(1)

Telephone Cords & Accessories(1)

Strapping & Twines(1)

Wireless Signal Boosters(1)

Telephone Headsets & Accessories(1)

Cleaning Sheets(1)

Electronic Cleaners/Anti-Static Sprays(1)

Locks(1)

Desktop Risers(1)

Flash/Video Lights & IR Illuminators(1)

Tool Kits(1)

Communications(1)

Desktops(1)

Keyboard Drawers/Platforms(1)

Computer Dust Covers(1)

Multimedia Player Holders & Clips(1)

Keyboard/Mouse Platforms & Trays(1)

Panels/Partitions(1)

Mounting Putty(1)

Trackballs(1)

Surge Protectors(1)

Printer & Peripheral Switches(1)

Brand

3M(93)

Tripp Lite(51)

Linksys(36)

Kensington(35)

Belkin(31)

Verbatim(31)

Fellowes(30)

Kantek(28)

Business Source(27)

Logitech(24)

Compucessory(24)

Advantus(16)

Read Right(12)

Falcon(10)

Viewsonic(10)

Lorell(8)

Dust-Off(7)

CHERRY(6)

Spracht(5)

CordAway(4)

Allsop(3)

OneScreen(2)

Keyspan(2)

Tatco(2)

Windex®(2)

VELCRO® Brand(2)

Bostitch(2)

Master(2)

Weiman(1)

HON(1)

Digital Innovations(1)

Bush(1)

Martin Yale(1)

Maxell(1)

Educational Insights(1)

Acco(1)

Command(1)

Endust(1)

ChargeTech(1)

Plantronics(1)

SKILCRAFT(1)

Samsung(1)

Color

Black(259)

Glossy(53)

Matte(49)

Silver(24)

Gray(23)

White(21)

Clear(18)

Blue(15)

Gold(9)

Aqua(9)

Red(8)

Multi(6)

Crystal Clear(4)

Graphite(3)

Assorted(3)

Dark Gray(3)

Green(2)

Aluminum(2)

Natural(1)

Ash(1)

Glossy Black(1)

Obsidian Black(1)

Purple(1)

Pearl Black(1)

Platinum(1)

Light Gray(1)

Black Gray(1)

Marble White(1)

Brightness

250 Nit(7)

300 Nit(3)

Recycled

No(59)

Price Range

$0-$499.99(518)

$1000-$1499.99(1)

To  GO

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

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