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 CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` 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(138)

Mice(58)

AV Cables(26)

Cable Management(23)

USB Cables(19)

Air Dusters(17)

Ethernet/Networking Cables(17)

Computer Cloths/Wipes & Dusters(14)

Glare/Radiation Filters(13)

LCD Monitors(11)

Multimedia Speakers(10)

Laptop Locks(10)

Laptop Docking Stations(10)

Wireless Routers(10)

Wireless Access Points/Bridges(9)

Cleaning Kits(8)

Ethernet/Networking Switches & Bridges(7)

Computer Locks & Kits(6)

USB Hubs(6)

Screen Protectors(6)

CPU Stands(5)

Graphic & TV Tuner Combo Cards(5)

Connector Adapters(4)

PC & Web Cameras(4)

3D Printer Cartridges/Filaments(4)

Monitor Stands/Risers(4)

Range Extenders(3)

Patch Cables(3)

Multimedia Player Power Adapters(3)

Cleaning Wipes(3)

Lens Cleaners(2)

Wireless NICs & Adapters(2)

Ethernet/Networking Routers(2)

Magnifying Filters(2)

Ethernet/Networking Cards & Adapters(2)

Monitor Arms(2)

Telephone Headsets & Accessories(1)

Strapping & Twines(1)

Locks(1)

Cleaning Sheets(1)

Electronic Cleaners/Anti-Static Sprays(1)

Telephone Cords & Accessories(1)

Surge Protectors(1)

Lamps(1)

Trackballs(1)

Multimedia Player Holders & Clips(1)

Computer Dust Covers(1)

Flash/Video Lights & IR Illuminators(1)

Mounting Putty(1)

Keyboard/Mouse Platforms & Trays(1)

Tool Kits(1)

Cable Modems(1)

Contemporary - Laminate(1)

Desktop Risers(1)

Printer & Peripheral Switches(1)

Brand

3M(93)

Tripp Lite(50)

Kensington(36)

Linksys(33)

Belkin(32)

Fellowes(30)

Verbatim(29)

Business Source(29)

Kantek(28)

Logitech(26)

Advantus(16)

Viewsonic(11)

Falcon(10)

Compucessory(10)

Read Right(7)

CHERRY(5)

CordAway(4)

Spracht(4)

Lorell(4)

Allsop(3)

Dust-Off(3)

Master(2)

Tatco(2)

Keyspan(2)

Bostitch(2)

VELCRO® Brand(2)

Samsung(1)

Weiman(1)

Digital Innovations(1)

Leitz(1)

Educational Insights(1)

ChargeTech(1)

Bush(1)

Bush Business Furniture(1)

Acco(1)

Maxell(1)

Plantronics(1)

Endust(1)

Command(1)

Martin Yale(1)

Color

Black(249)

Matte(59)

Silver(25)

White(21)

Gray(20)

Glossy(18)

Clear(18)

Blue(13)

Aqua(9)

Gold(9)

Multi(8)

Red(7)

Crystal Clear(4)

Assorted(3)

Graphite(3)

Green(2)

Dark Gray(2)

Aluminum(2)

Glossy Black(1)

Purple(1)

Natural(1)

Light Gray(1)

Pearl Black(1)

Black Gray(1)

Platinum(1)

Obsidian Black(1)

Brightness

250 Nit(8)

300 Nit(3)

Recycled

No(48)

Yes(1)

Price Range

$0-$99.99(342)

$100-$199.99(101)

$200-$299.99(36)

$300-$399.99(9)

$400-$499.99(2)

To  GO

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

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