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(149)

Mice(58)

AV Cables(30)

Cable Management(25)

Ethernet/Networking Cables(24)

USB Cables(22)

Air Dusters(20)

Glare/Radiation Filters(13)

Multimedia Speakers(13)

Computer Cloths/Wipes & Dusters(12)

LCD Monitors(10)

Wireless Routers(10)

Laptop Docking Stations(10)

Cleaning Kits(10)

Laptop Locks(8)

Wireless Access Points/Bridges(8)

Ethernet/Networking Switches & Bridges(7)

Screen Protectors(7)

USB Hubs(6)

Cleaning Wipes(6)

Connector Adapters(5)

CPU Stands(5)

Monitor Stands/Risers(4)

PC & Web Cameras(4)

Computer Locks & Kits(4)

Patch Cables(3)

Multimedia Player Power Adapters(3)

Graphic & TV Tuner Combo Cards(3)

Lens Cleaners(2)

Wireless NICs & Adapters(2)

Range Extenders(2)

Magnifying Filters(2)

Monitor Arms(2)

Ethernet/Networking Routers(2)

Ethernet/Networking Cards & Adapters(2)

Strapping & Twines(1)

3D Printer Cartridges/Filaments(1)

Wireless Signal Boosters(1)

Telephone Headsets & Accessories(1)

Cleaning Sheets(1)

Telephone Cords & Accessories(1)

Multimedia Player Holders & Clips(1)

Flash/Video Lights & IR Illuminators(1)

Power Inverters(1)

Multimedia Player Docking Stations(1)

Surge Protectors(1)

Tool Kits(1)

Computer Dust Covers(1)

Cable Modems(1)

Desktop Risers(1)

Keyboard/Mouse Platforms & Trays(1)

Trackballs(1)

Printer & Peripheral Switches(1)

Brand

3M(97)

Tripp Lite(63)

Kensington(32)

Linksys(32)

Belkin(31)

Kantek(28)

Fellowes(28)

Business Source(27)

Verbatim(27)

Logitech(22)

Compucessory(20)

Advantus(16)

Read Right(12)

Viewsonic(10)

Dust-Off(7)

Falcon(7)

CHERRY(6)

Spracht(5)

Lorell(5)

CordAway(4)

ChargeTech(4)

Allsop(3)

Windex®(2)

Bostitch(2)

VELCRO® Brand(2)

Keyspan(2)

Tatco(2)

Endust(2)

Clorox(2)

SKILCRAFT(2)

Weiman(2)

Digital Innovations(1)

Acco(1)

Master(1)

Maxell(1)

Command(1)

Plantronics(1)

Educational Insights(1)

Color

Black(259)

Glossy(44)

Matte(44)

White(22)

Silver(22)

Gray(21)

Clear(19)

Blue(17)

Gold(13)

Red(8)

Aqua(8)

Multi(6)

Crystal Clear(4)

Dark Gray(3)

Assorted(3)

Graphite(3)

Green(2)

Aluminum(2)

Charcoal(2)

Purple(1)

Light Gray(1)

Glossy Black(1)

Natural(1)

Marble White(1)

Pearl Black(1)

Black Gray(1)

Platinum(1)

Obsidian Black(1)

Brightness

250 Nit(7)

300 Nit(3)

Recycled

No(53)

Price Range

$0-$499.99(508)

$500-$999.99(2)

To  GO

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

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