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_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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` 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 WHERE (`category_id` IN ('124')) 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 `pinfo`.`sku` LIKE '%Cables' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Cables' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Cables' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Cables"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Cables"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Cables"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Cables"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Cables' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Cables',`category_4` ='Cables') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Cables,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Cables', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Cables

Refine Search

  GO
 
Brand

Tripp Lite(46)

Softalk(9)

Scosche(2)

Duracell(2)

Case Logic(1)

ByTech(1)

 
Color(s)

Black(2)

 
Manufacturer Part Number

N201-025-BL(1)

N201025BK(1)

N201-050-GY(1)

P502006(1)

P566-006(1)

P502050(1)

N201-014-GY(1)

N201014BL(1)

N201007BL(1)

N201007BK(1)

N201-007-GY(1)

N201010BL(1)

N201014BK(1)

N201010GY(1)

P568-006(1)

P568-010(1)

U024-006(1)

U022-010(1)

U024-010(1)

U244001R(1)

U324010(1)

U324006(1)

P586006VGA(1)

P586006HDMI(1)

P569010(1)

P569006(1)

P580006(1)

P582006(1)

P586006DVI(1)

N201005GY(1)

N201-001-BL(1)

48100(1)

42265(1)

48102(1)

48106(1)

I3M(1)

12RA(1)

42261(1)

42260(1)

PRO905(1)

CLLPCA002WT(1)

PRO907(1)

04020(1)

42215(1)

04130(1)

N002002BK(1)

N002-002-BL(1)

N002-014-BL(1)

N002-014-BK(1)

N002-014-GY(1)

N002014WH(1)

N002100GY(1)

N002-025-BL(1)

N002010WH(1)

N002-010-GY(1)

N002-007-BL(1)

N002007BK(1)

N002-007-GY(1)

N002-010-BK(1)

N002-010-BL(1)

BYMPCA107BK(1)

 
Country of Origin

CN(61)

 
Length

10 ft(2)

 
Connector/Port/Interface

Two RJ 45 Male(28)

Two 6P4C Plug(8)

Apple Lightning; USB(3)

HDMI Male; HDMI Male(2)

USB A Male; USB A Female(2)

HD15 Male; HD15 Male(2)

USB 3.0 A Male; USB 3.0 A Female(2)

Two HDMI Male(2)

USB A Male; USB B Male(1)

Mini DisplayPort to VGA(1)

6P4C Plug;Dual Jack(1)

USB A (Male); DVI-I (Female)(1)

Micro USB(1)

Mini DisplayPort to HDMI HD Cable Adapter(1)

Mini DisplayPort to DVI(1)

Micro USB; USB(1)

Apple Lightning; Micro USB; USB(1)

DisplayPort Male to DisplayPort Male(1)

DisplayPort HDMI Male to Male(1)

DVI Male; HDMI Male(1)

 
Power Source(s)

External(2)

 
For Device Type

Telephone(6)

Mac; Network;PC(4)

Mac; Network; PC(3)

Home Theater System(3)

USB 2.0 Peripherals(3)

Computers, KVM; Servers; Modems(3)

Monitor(2)

Mobile Devices(2)

USB 2.0, 3.0 Peripherals(2)

Answering Machine;Fax Machine;Modem;Telephone(2)

HDMI(2)

Monitors; Computers(2)

PC(2)

Computers, Digital Cameras, Cell Phone(1)

VGA/DVI Monitors; Projectors(1)

Telephone;Telephone Accessory(1)

Monitor; HDMI(1)

Smartphones; Tablets(1)

DVI Monitor(1)

VGA(1)

 
Connects Devices (From/To)

CAT6/CAT5e(13)

Phone to Handset(6)

Cat 6/Cat 5e(5)

Cat 5/Cat 5e(5)

Computers in Local Area Network(4)

USB Peripherals to Hub/PC/Mac(3)

Computer to Monitor(3)

HDTV Display Devices to Digital Video Sources(2)

Some Smartphones; Tablets; Computers; Monitors; TVs(2)

Monitor to Computer(2)

Peripherals to Computer(2)

Answering Machine;Fax Machine;Modem to Modular Phone Wall Outlet;Telephone(2)

Monitor to PC(1)

Computers with DisplayPort Video Out Port to an HDMI-enabled Monitor or TV(1)

Computer with Mini DisplayPort Output to an HDMI-enabled Monitor or TV(1)

100 MBps TPDDI;155 MBps ATM;Hardware in 10/100/1000 Base-T Ethernet;ISDN;Voice/Token Ring Type Applications(1)

Telephone;Telephone Accessory to Modular Phone Wall Outlet(1)

USB to Lightning or micro USB Device(1)

USB to Lightning or Micro USB Device(1)

Digital Display Devices to Digital Source Devices(1)

 
Cable Length

10 ft(13)

6 ft(11)

25 ft(9)

14 ft(7)

7 ft(7)

3 ft(2)

2 ft(2)

50 ft(2)

12 ft(2)

4"(1)

1 ft(1)

100 ft(1)

5 ft(1)

 
Cable Type

Cat5e Patch Molded(15)

CAT6 Snagless Molded(13)

Coiled Phone Cord(6)

USB 2.0(5)

DisplayPort Cable(4)

HDMI Cables(2)

USB 3.0 Extension(2)

Video Male/Male(2)

VGA Monitor(2)

Line/Extension Cord(2)

USB(2)

Display Adapter(1)

Duplex Outlet Line Extension Cord(1)

Video(1)

DisplayPort(1)

 
Jacket Color

Black(28)

Blue(12)

Gray(9)

Ivory(5)

White(3)

Ash(1)

Beige(1)

 
Adapter/Charger Type

Charging Cable(2)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved