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

Belkin(12)

Softalk(8)

Duracell(6)

Scosche(4)

Innovera(3)

Case Logic(3)

ByTech(1)

Kensington(1)

 
Color(s)

Black(5)

 
Manufacturer Part Number

P502006(1)

P502050(1)

P456-006(1)

P314006(1)

P311006(1)

P312006(1)

P510006(1)

P510-010(1)

P568-003-FL(1)

P568-006(1)

P568003(1)

P566-010(1)

P560-006(1)

P566-006(1)

P14206NMICRO(1)

N820-03M(1)

N201010BL(1)

N201010GY(1)

N201-007-GY(1)

N201007BL(1)

N201005GY(1)

N201007BK(1)

N201014BK(1)

N201014BL(1)

N316-02M(1)

N820-01M(1)

N201-050-GY(1)

N201-025-BL(1)

N201-014-GY(1)

N201025BK(1)

P568-006-FL(1)

P568-010(1)

U322010(1)

U322015(1)

U244001R(1)

U209-000-R(1)

U026016(1)

U042025(1)

U324006(1)

U324010(1)

UR022006(1)

UR030006(1)

UR020006(1)

U326006(1)

U326001BK(1)

U326003(1)

U024-010(1)

U024-006(1)

P569010(1)

P570003MICRO(1)

P569006(1)

P569003(1)

P568-025(1)

P568-050(1)

P580006(1)

P582006(1)

U022-010(1)

U022015(1)

P774-006(1)

P586006VGA(1)

P586006DVI(1)

P586006HDMI(1)

N201005BL(1)

N201001GY(1)

PRO907(1)

30500(1)

PRO905(1)

PRO711(1)

DU1339(1)

PRO428(1)

30501(1)

30503(1)

42260(1)

42261(1)

42215(1)

04130(1)

39202(1)

04020(1)

DU1311(1)

CLMFCBL(1)

A3X12607YLWM(1)

F3H98110(1)

A3L98003BLK(1)

A3L79125M(1)

A3L79103BLUS(1)

A3L79103S(1)

F3H982-06(1)

F3H98210(1)

CLCBLIPHBLK(1)

CLLPCA002WT(1)

BYMPCA107BK(1)

F8V3311B15(1)

F8V3311B06(1)

F8V3311B12(1)

42265(1)

48100(1)

N002-025-BK(1)

N002-025-BL(1)

N002014WH(1)

N002-014-GY(1)

N002-014-BK(1)

N002-014-BL(1)

N002-025-GY(1)

N002025WH(1)

N201-001-BK(1)

N201-001-BL(1)

N002100GY(1)

N002100BL(1)

N002-050-BK(1)

N002-050-GY(1)

N002010WH(1)

N002-010-GY(1)

I3FLED(1)

N002002BK(1)

12WTA(1)

12RA(1)

48102(1)

12A(1)

N002-002-BL(1)

N002002GY(1)

N002-010-BK(1)

N002-010-BL(1)

N002007WH(1)

N002-007-GY(1)

N002007BK(1)

N002-007-BL(1)

A3L79103BLKS(1)

 
Country of Origin

CN(126)

US(1)

 
For Use With

Apple Lightning Devices(1)

 
Length

10 ft(2)

6 ft(2)

 
Connector/Port/Interface

Two RJ 45 Male(48)

Two HDMI Male(9)

Two 6P4C Plug(7)

Apple Lightning; USB(6)

HDMI Male; HDMI Male(4)

USB 3.0 A Male; USB 3.0 Micro-B Male(3)

USB A Male; USB A Female(3)

USB A Male; USB B Male(3)

Two LC(2)

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

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

USB 2.0(2)

DVI Male; HDMI Male(2)

HD15 Male; HD15 Male(2)

Two HDDB15 Male(2)

Micro USB(2)

USB to Apple Lightning(1)

Apple 30-Pin; USB(1)

Mini DisplayPort to HDMI HD Cable Adapter(1)

HD15 (Male); Mini DIN-6(1)

USB A (Male); DB9 (Male)(1)

Mini DisplayPort to VGA(1)

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

Reversible USB A Male; USB B Male(1)

Reversible USB A Male; USB Mini-B 5-Pin Male(1)

Reversible USB A Male; Reversible USB A Male(1)

HDDB15 Male; HDDB15 Female(1)

Micro USB; USB(1)

Mini DisplayPort to DVI(1)

DisplayPort Male to DisplayPort Male(1)

3.5 mm Male; Two RCA Male(1)

DB 25 Male;DB 9 Female(1)

3.5 mm Male; 3.5 mm Male(1)

3.5 mm Male; 3.5 mm Female(1)

6P4C Plug;Dual Jack(1)

Micro HDMI Male; HDMI Female(1)

Two 3.5mm Jacks(1)

HD15 Male; HD15 Female(1)

Micro HDMI Male; HDMI Male(1)

Two SC/LC(1)

3.5 mm Male to Male(1)

DVI Male(1)

HD15 Female; HD15 Male(1)

DisplayPort HDMI Male to Male(1)

 
Power Source(s)

External(5)

 
For Device Type

Home Theater System(11)

Mac; Network; PC(9)

Telephone(6)

USB 2.0, 3.0 Peripherals(6)

HDMI(6)

Mac;Network;PC(5)

Mobile Devices(5)

Computers, KVM; Servers; Modems(4)

Mac; Network;PC(4)

Computers, Digital Cameras, Cell Phone(4)

PC(4)

USB 2.0 Peripherals(3)

Network(3)

Monitor(3)

USB 1.1, 2.0 Peripherals(2)

Monitors; Computers(2)

VGA Computer Monitor(2)

17" or Larger Computer Monitor(2)

Monitor; HDMI(1)

USB to Micro B(1)

VGA(1)

Digital Camera;Modem;PDA(1)

USB Devices(1)

Computer(1)

Printer, Computer(1)

VGA/DVI Monitors; Projectors(1)

Smartphones, Headphones, iPod, iPad(1)

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

iPhone; iPod; Other 3.5mm Devices(1)

3.5mm Devices(1)

Mac(1)

Telephone;Telephone Accessory(1)

Smartphones; Tablets(1)

Serial Peripherals(1)

PC, Notebook, MP3, iPad, iPod, Computer(1)

Stereo Amplifiers, Tape Decks, Speakers(1)

DVI Monitor(1)

 
Expected Delivery

Allow several additional days for delivery(3)

 
Connects Devices (From/To)

CAT6/CAT5e(16)

Hardware in 10 Base-T and 100 Base-T Networks(10)

Cat 5/Cat 5e(9)

Cat 6/Cat 5e(9)

HDTV Display Devices to Digital Video Sources(6)

Phone to Handset(6)

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

Computers in Local Area Network(5)

Digital Display Devices to Digital Video Sources(3)

USB Peripherals to Hub/PC/Mac(3)

Computer to Monitor(3)

USB to Lightning USB Device(3)

Monitor to PC(3)

Peripherals to Computer(3)

USB 2.0 Devices(2)

Monitor to Computer(2)

Digital Display Devices to Digital Source Devices(2)

Monitors to Computer(2)

Computers; Digital Cameras; Cell Phone(1)

Hardware in 100 Base-T and Gigabit Ethernet Networks(1)

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

Computer to devices(1)

USB Peripheral to Computer(1)

USB A (Male) to DB9 (Male) Devices(1)

USB 2.0 Device Cables(1)

Computer to Printer or Other Devices(1)

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

DB25M to DB9F(1)

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

USB to Lightning or micro USB Device(1)

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

Device to Vehicle Auxiliary Jack(1)

Headphones to Smartphones(1)

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

PC to Monitor(1)

Apple Devices to Computer(1)

Mini Stereo Output Jack to Stereo RCA Input(1)

Stereo to Speakers(1)

Smartphone to Headphone(1)

Monitor to Mac/PC(1)

 
Cable Length

6 ft(26)

10 ft(22)

25 ft(15)

3 ft(14)

7 ft(8)

14 ft(7)

50 ft(5)

1 ft(4)

5 ft(4)

12 ft(3)

2 ft(3)

15 ft(3)

100 ft(2)

3 1/2 ft(2)

4"(1)

16 ft(1)

6"(1)

4 ft(1)

 
Cable Type

Cat5e Patch Molded(24)

CAT6 Snagless Molded(16)

Video(9)

USB 2.0(7)

Coiled Phone Cord(6)

HDMI Cables(5)

USB(4)

USB 3.0 Device(4)

Monitor(3)

Cat5e Patch Snagless Molded(3)

Audio Cables(3)

Fiber Optic Patch Cable(3)

CAT6 Patch(3)

VGA Monitor(2)

DisplayPort Cable(2)

VGA Monitor Extension Cable(2)

Mini DisplayPort Cable(2)

USB 3.0 Extension(2)

Video Male/Male(2)

USB 2.0 Gold Cable(1)

USB 2.0 Cable A to A(1)

USB 2.0 Extension(1)

USB 2.0 Reversible A Male to B Male Device(1)

USB 2.0 Device(1)

Reversible USB 2.0 A to Mini B Device(1)

USB/Serial(1)

USB 3.0 Device Cable to Micro B M/M(1)

Display Adapter(1)

Null Modem Gold Cable(1)

Audio(1)

Extension(1)

Cat5e Crossover Patch(1)

Cat6 UTP Patch(1)

Auxiliary Audio(1)

Line/Extension Cord(1)

Mini DisplayPort(1)

MICRO HDMI Male to HDMI Female(1)

Duplex Outlet Line Extension Cord(1)

PS/2(1)

 
Jacket Color

Black(66)

Blue(20)

Gray(17)

White(7)

Ivory(4)

Beige(2)

Aqua(2)

Orange(1)

Ash(1)

Yellow(1)

 
Adapter/Charger Type

Charging Cable(5)

 
 
 

© 2018-2019 BonTay Business Products, Inc., All Rights Reserved