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_2` 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 ('832')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 '%AdaptersChargers' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('AdaptersChargers' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+AdaptersChargers' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"AdaptersChargers"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"AdaptersChargers"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"AdaptersChargers"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"AdaptersChargers"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+AdaptersChargers' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='AdaptersChargers',`category_4` ='AdaptersChargers') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'AdaptersChargers,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('AdaptersChargers', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Adapters Chargers

Refine Search

GO
 
Brand

Tripp Lite(12)

Innovera(9)

Duracell(7)

LINKSYS(4)

Artistic(3)

Kensington(3)

Brother P-Touch(2)

Belkin(1)

Brother(1)

Case Logic(1)

DYMO(1)

Rayovac(1)

 
Color(s)

Black(19)

White(6)

Silver(2)

Blue(1)

 
Base Color

Black(3)

 
Manufacturer Part Number

ART59026D0(1)

B015-000(1)

33117(1)

38231(1)

39794(1)

USB3GIG(1)

WUSB6100M(1)

WUSB6300(1)

WUSB6400M(1)

PS101E(1)

B130101A2(1)

30020(1)

P13706NHDV(1)

PV200CUSB(1)

PV375(1)

PV400USB(1)

U44406NDC(1)

U44406NDGUC(1)

U44406NH4UC(1)

U44406NHGUC(1)

U44406NVC(1)

30022(1)

30018(1)

ART59026D9(1)

DMLIONPB3(1)

ART59026M(1)

F8J032TT04(1)

AD-24(1)

AD24ESAW(1)

ADE001(1)

CLTCMF(1)

DMLIONPB1(1)

DMLIONPB2(1)

40077(1)

30016(1)

DC5341(1)

DU5274(1)

PRO168(1)

PRO515(1)

30006(1)

30008(1)

30013(1)

30014(1)

30015(1)

USA19HS(1)

 
Country of Origin

CN(43)

TW(2)

 
For Use With

iPhone 8, 8 Plus, X; Samsung Galaxy S6(3)

Micro USB Devices(3)

iPad 4th Gen; iPad mini; iPhone 5(1)

Brother GL-100, PT-1000, PT-1010, PT-1010B, PT-1010NB, PT-1010R, PT-1010S, PT-1090, PT-1090BK, PT-1230PC, PT-1280, PT-1280SR, PT-128AF, PT-1290, PT-1290RS, PT-1400, PT-1500PC, PT-1600, PT-1650, PT-1750, PT-1830, PT-1830C, PT-1830SC, PT-1880, PT-1880C, PT-1880SC, PT-1880W, PT-1900, PT-1910, PT-1950, PT-1960, PT-2030, PT-2030AD, PT-2030VP, PT-2100, PT-2110, PT-2700, PT-2710, PT-2730, PT-2730VP, PT-6100, PT-7100, PT-D200, PT-D200BT, PT-D200DA, PT-D200MA, PT-D200SA, PT-E100(1)

Brother P-Touch PT-D200, PT-D200G, PT-D210, PT-H110(1)

Brother PT-E300, PT-E500, PT-E550W, PT-H300, PT-H300LI, PT-H500LI, PT-P700, PT-P750W(1)

DYMO 1000, 1000 Plus, 4500; LabelMANAGER 100, 150, 160, 200, 300, 350, 400, 450, PC II; LabelPOINT 200, 250, 300, 350; LetraTAG Plus LT100H(1)

iPad; iPhone; iPod(1)

 
Length

3 ft(6)

6 ft(3)

10 ft(3)

36"(1)

24"(1)

11"(1)

5 ft(1)

2"(1)

2.25"(1)

9 1/4"(1)

 
Connector/Port/Interface

USB(5)

Micro USB(5)

Qi Wireless Charging(3)

5-Pin Micro B Male; USB A Male(3)

Type-C Male ; USB A Male(3)

c48, 8-Pin Male; USB A Male(3)

Apple Lightning; USB(2)

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

HD15 (Female); USB-C (Female); USB-C (Male)(1)

HDMI (Female); RJ45 (Female); USB 3.0 A (Female); USB C (Female); USB C (Male)(1)

HDMI (Female); USB 3.0 A (Female); USB-C (Female); USB-C (Male)(1)

DVI-I (Female); RJ45 (Female); USB 3.0 A (Female); USB-C (Female); USB-C (Male)(1)

3.5mm (Female); HD15 (Female); RJ45 (Female)(1)

2 AC Outlets; 1.0A USB Port; 2.1A USB Port(1)

2 AC(1)

Displayport; DVI; HDMI; VGA(1)

Mini DIN-6; USB(1)

USB-C(1)

DB9; USB(1)

 
Operating System Compatibility

Chrome OS; Mac OS X 10.10 and Later; Windows 8.1, 10(1)

 
Power Source(s)

AC Wall Outlet(11)

USB Port(10)

Vehicle Outlet(6)

Lithium Ion Rechargeable Battery(4)

Wall Outlet(1)

 
Voltage

5V(4)

5 V(3)

9V(2)

120 V(2)

9 V(1)

12V(1)

110V(1)

120V(1)

 
For Device Type

Mobile Devices(16)

Laptops; Mobile Devices(8)

Label Makers(4)

Android Tablets; Android Smartphones; Power Bank(3)

Smartphones; Tablets(3)

iPhone(3)

PS/2 Devices; USB Devices(1)

Digital Signage(1)

USB Devices(1)

Desktops; Laptops(1)

 
Network Types

Ethernet; USB 3.0(1)

 
Expected Delivery

Allow several additional days for delivery(2)

 
Connects Devices (From/To)

Devices to Inductive Charge Pad(3)

Android Phone or Android Tablet to PC; Power Bank to Phone(3)

Phone to PC; PC to Tablet(3)

iPhone, iPad to PC(3)

Computer to Wi-Fi(2)

USB to DVI(2)

AC Outlet to Device(1)

Wall AC Outlet to Label Maker(1)

Device to AC Outlet(1)

USB Peripheral to Computer(1)

USB to Wi-Fi(1)

Displayport to VGA, HDMI, DVI(1)

USB to HDMI(1)

Cable to Ethernet Port; Charger to Device; Device to Monitors(1)

USB to VGA(1)

Serial Peripherals to PC/Mac Computers(1)

 
Electronic/Mechanical

Electronic(9)

 
Ports/Amps

One 1.0 Amp Port(3)

2(2)

One 2.1 Amp Port(1)

One 3350 mAh Port(1)

One 6700 mAh Port(1)

One 10050 mAh Port(1)

Two 3.1 Amp Ports(1)

One 2600 mAh Port(1)

One 1.0 Amp Port; One 2.1 Amp Port(1)

One 2.4 Amp Port; One 1.0 Amp Port(1)

One 2.4 Amp Port(1)

 
Capacity

5 W(3)

10W(1)

2.1 Amp(1)

3350 mAh(1)

6700 mAh(1)

10050 mAh(1)

2600 mAh(1)

 
Cable Length

3"(5)

18"(1)

6"(1)

 
Cable Type

Detachable USB to Micro USB Cable (Included)(3)

Detachable Micro USB (Included)(3)

Detachable Apple Lightning Cable (Included)(2)

USB-C to DVI Adapter(2)

USB-C to HDMI Adapter(2)

Hardwired Micro USB Cable (Included)(1)

Detachable Lightning Cable (Included)(1)

Device's USB Cable (Sold Separately)(1)

Detachable Micro USB Cable (Included)(1)

Detachable USB-C Cable (Included)(1)

Hardwired Apple Lightning Cable (Included); Device's Charging Cable (Sold Separately)(1)

PS/2 to USB Adapter(1)

A/V Extender(1)

Displayport to VGA/HDMI/DVI Adapter(1)

USB-C to VGA Adapter(1)

Serial to USB Adapter(1)

 
Jacket Color

White(5)

Black(2)

 
Adapter/Charger Type

Charging Cable(9)

Car Charger(6)

Wall Charger(4)

AC Adapter(4)

Portable Mobile Charger(4)

Wireless Charging Desk Mat(3)

Plug Adapter(1)

USB-C Charger(1)

 
 
 

© 2020-2021 ISEOP, All Rights Reserved