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_name` IN ('Ethernet/Networking Cables','AV Cables','Cable Management','Connector Adapters','KVM Switches','Miscellaneous Cables','Parallel Cables','Patch Cables','USB Cables','USB Hubs','Connector Cables')) 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 '%CablesHubsConnectorsandSwitches' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('CablesHubsConnectorsandSwitches' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+CablesHubsConnectorsandSwitches' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"CablesHubsConnectorsandSwitches"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"CablesHubsConnectorsandSwitches"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"CablesHubsConnectorsandSwitches"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"CablesHubsConnectorsandSwitches"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+CablesHubsConnectorsandSwitches' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='CablesHubsConnectorsandSwitches',`category_4` ='CablesHubsConnectorsandSwitches') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'CablesHubsConnectorsandSwitches,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('CablesHubsConnectorsandSwitches', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Cables Hubs Connectors And Switches

Refine Search

  GO
 
Brand

CordAway(5)

Belkin(4)

Compucessory(2)

Softalk(2)

Tatco(1)

 
Color

Gray(6)

Black(6)

Almond(1)

Clear(1)

Natural(1)

 
Packaged Quantity

1(11)

6(1)

1000(1)

 
Limited Warranty

Lifetime(5)

 
Weight (Approximate)

2.88 oz(2)

1 lb(2)

1.60 oz(1)

 
Package Type

Retail(2)

 
Device Supported

Monitor(1)

 
Connector on First End

1 x Type A Male USB(2)

1 x RJ-11 Male Phone(2)

1 x RJ-45 Male IEEE 802.3 Network(1)

1 x 15-pin HD-15 Male(1)

1 x Type A Male USB 1.1 USB(1)

 
Connector on Second End

1 x Type B Male USB(2)

1 x RJ-11 Female Phone(2)

1 x RJ-45 Male IEEE 802.3 Network(1)

1 x 15-pin HD-15 Female(1)

1 x Type A Female USB 1.1 USB(1)

 
Cable Characteristic

Extension Cable(2)

Patch Cable(1)

 
Manufacturer Part Number

A3L791-03-S(1)

F3H981-10(1)

F3U130-16(1)

F8B023(1)

11150(1)

11151(1)

00201(1)

00203(1)

00204(1)

00205(1)

00209(1)

21001(1)

21002(1)

22200(1)

 
Country of Origin

China(8)

United States(6)

 
Material

Plastic(2)

Nylon(1)

 
Height

1.1"(3)

0.6"(2)

1.5"(1)

 
Width

0.5"(2)

0.9"(1)

0.2"(1)

 
Depth

1"(1)

 
Length

1.6"(2)

48"(1)

8"(1)

 
Cable Length

10 ft(2)

3 ft(1)

16 ft(1)

6 ft(1)

 
Cable Type

USB(3)

Category 5e(1)

 
Adapter Type

RJ-11(2)

 
 
 

© 2019-2020 Edwards Office System, All Rights Reserved