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

Mice(62)

AV Cables(30)

Cable Management(25)

Ethernet/Networking Cables(24)

Air Dusters(23)

USB Cables(22)

Multimedia Speakers(14)

Glare/Radiation Filters(13)

Computer Cloths/Wipes & Dusters(13)

LCD Monitors(10)

Wireless Routers(10)

Laptop Locks(10)

Laptop Docking Stations(10)

Cleaning Kits(10)

Wireless Access Points/Bridges(9)

Screen Protectors(7)

Ethernet/Networking Switches & Bridges(7)

Cleaning Wipes(6)

USB Hubs(6)

Connector Adapters(5)

Computer Locks & Kits(5)

CPU Stands(5)

PC & Web Cameras(4)

Monitor Stands/Risers(4)

3D Printer Cartridges/Filaments(4)

Multimedia Player Power Adapters(3)

Graphic & TV Tuner Combo Cards(3)

Patch Cables(3)

Monitor Arms(2)

Cable Modems(2)

Lens Cleaners(2)

Magnifying Filters(2)

Ethernet/Networking Cards & Adapters(2)

Range Extenders(2)

Ethernet/Networking Routers(2)

Wireless NICs & Adapters(2)

Strapping & Twines(1)

Electronic Cleaners/Anti-Static Sprays(1)

Wireless Signal Boosters(1)

Telephone Headsets & Accessories(1)

Cleaning Sheets(1)

Telephone Cords & Accessories(1)

Locks(1)

Keyboard/Mouse Platforms & Trays(1)

Flash/Video Lights & IR Illuminators(1)

Tool Kits(1)

Power Inverters(1)

Multimedia Player Docking Stations(1)

Surge Protectors(1)

Computer Dust Covers(1)

Multimedia Player Holders & Clips(1)

Panels/Partitions(1)

Desktop Risers(1)

Mounting Putty(1)

Trackballs(1)

Adapters/Chargers(1)

Printer & Peripheral Switches(1)

Brand

3M(101)

Tripp Lite(63)

Kensington(36)

Linksys(34)

Belkin(31)

Fellowes(30)

Verbatim(30)

Kantek(28)

Business Source(27)

Logitech(23)

Compucessory(22)

Advantus(16)

Read Right(12)

Viewsonic(10)

Falcon(10)

Dust-Off(7)

CHERRY(7)

Lorell(5)

Spracht(5)

CordAway(4)

ChargeTech(4)

Allsop(3)

Endust(2)

Keyspan(2)

Tatco(2)

Windex®(2)

VELCRO® Brand(2)

Master(2)

Clorox(2)

Weiman(2)

Bostitch(2)

Digital Innovations(1)

HON(1)

Educational Insights(1)

Maxell(1)

Active Office(1)

Command(1)

Acco(1)

Plantronics(1)

SKILCRAFT(1)

Samsung(1)

Color

Black(272)

Glossy(61)

Matte(51)

Silver(24)

White(23)

Gray(22)

Clear(19)

Blue(18)

Gold(13)

Aqua(9)

Red(8)

Multi(6)

Crystal Clear(4)

Dark Gray(3)

Graphite(3)

Assorted(3)

Green(2)

Aluminum(2)

Charcoal(2)

Natural(1)

Light Gray(1)

Glossy Black(1)

Purple(1)

Obsidian Black(1)

Black Gray(1)

Platinum(1)

Pearl Black(1)

Ash(1)

Marble White(1)

Brightness

250 Nit(7)

300 Nit(3)

Recycled

No(59)

Price Range

$0-$499.99(533)

$500-$999.99(2)

$14500-$14999.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