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

Mice(62)

AV Cables(30)

Cable Management(25)

Ethernet/Networking Cables(24)

USB Cables(22)

Air Dusters(20)

Computer Cloths/Wipes & Dusters(14)

Multimedia Speakers(14)

Glare/Radiation Filters(13)

LCD Monitors(10)

Wireless Routers(10)

Laptop Docking Stations(10)

Cleaning Kits(10)

Laptop Locks(9)

Wireless Access Points/Bridges(9)

Screen Protectors(7)

Ethernet/Networking Switches & Bridges(7)

Cleaning Wipes(6)

USB Hubs(6)

Connector Adapters(5)

CPU Stands(5)

PC & Web Cameras(4)

Monitor Stands/Risers(4)

3D Printer Cartridges/Filaments(4)

Computer Locks & Kits(4)

Patch Cables(3)

Multimedia Player Power Adapters(3)

Graphic & TV Tuner Combo Cards(3)

Lens Cleaners(2)

Cable Modems(2)

Wireless NICs & Adapters(2)

Monitor Arms(2)

Magnifying Filters(2)

Ethernet/Networking Routers(2)

Ethernet/Networking Cards & Adapters(2)

Range Extenders(2)

Electronic Cleaners/Anti-Static Sprays(1)

Telephone Headsets & Accessories(1)

Wireless Signal Boosters(1)

Cleaning Sheets(1)

Telephone Cords & Accessories(1)

Strapping & Twines(1)

Locks(1)

Keyboard/Mouse Platforms & Trays(1)

Power Inverters(1)

Flash/Video Lights & IR Illuminators(1)

Multimedia Player Docking Stations(1)

Surge Protectors(1)

Panels/Partitions(1)

Tool Kits(1)

Computer Dust Covers(1)

Desktop Risers(1)

Mounting Putty(1)

Trackballs(1)

Multimedia Player Holders & Clips(1)

Printer & Peripheral Switches(1)

Brand

3M(100)

Tripp Lite(63)

Linksys(34)

Kensington(33)

Belkin(31)

Fellowes(30)

Verbatim(30)

Kantek(28)

Business Source(27)

Logitech(23)

Compucessory(22)

Advantus(16)

Read Right(12)

Viewsonic(10)

CHERRY(7)

Falcon(7)

Dust-Off(7)

Lorell(6)

Spracht(5)

CordAway(4)

ChargeTech(4)

Allsop(3)

Keyspan(2)

Windex®(2)

Clorox(2)

Tatco(2)

VELCRO® Brand(2)

SKILCRAFT(2)

Bostitch(2)

Master(2)

Endust(2)

Weiman(2)

HON(1)

Digital Innovations(1)

Samsung(1)

Maxell(1)

Command(1)

Educational Insights(1)

Plantronics(1)

Acco(1)

Color

Black(264)

Matte(44)

Glossy(44)

White(24)

Silver(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(57)

Price Range

$0-$499.99(528)

$500-$999.99(2)

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