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 ('832')) 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 '%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(16)

Duracell(9)

Rayovac(7)

Verbatim(5)

Kensington(5)

Scosche(4)

Belkin(3)

Brother(2)

Leitz(2)

Case Logic(2)

Targus(1)

Brother P-Touch(1)

DYMO(1)

ByTech(1)

Canon(1)

Nomad by Palmer Hamilton(1)

Kenwood(1)

 
Color(s)

Black(44)

White(4)

Silver(3)

Red(2)

Blue(1)

 
Quantity

1 each(13)

 
Manufacturer Part Number

B015-000(1)

APM32US(1)

B120000(1)

B122-000(1)

B1261A1(1)

B125-150(1)

USBH121WT(1)

USBH121M(1)

PS76(1)

PS71BT6(1)

PS77(1)

PS80(1)

MAGPBEZ2I(1)

EZC12(1)

B1301012(1)

B130101A2(1)

98343(1)

USA19HS(1)

98357(1)

98450(1)

98608(1)

98453(1)

U244001HDMIR(1)

PV400USB(1)

B132100A(1)

B132004A2(1)

B202150(1)

P13706NHDV(1)

PV375(1)

PV200CUSB(1)

PS68BK(1)

PS102(1)

PRCA5B1(1)

5478B001AA(1)

40077(1)

DC5341(1)

DU5264(1)

DC5343(1)

CLTCMF(1)

CLPLMF(1)

F8J071BT04(1)

F8J032TT04(1)

AD-24(1)

ADE001(1)

21CPUNIUSB(1)

BAE001(1)

DU5265(1)

DU7169(1)

KMB44K(1)

39794(1)

652002(1)

653002(1)

PS101(1)

RLCB(1)

39768(1)

33974(1)

PRO168(1)

PRO158(1)

PRO515(1)

33117(1)

33497(1)

B2B052(1)

 
Country of Origin

CN(56)

TW(3)

US(2)

TH(1)

 
For Use With

Micro USB Devices(3)

Portable Electronic Devices(3)

Apple Devices Using Lightning Connector(2)

iPhone 5, 5s(2)

iPad; Smartphones; MP3 Players(2)

USB Devices(2)

Kenwood PKT23K(1)

Nomad Reload Mobile Charging Table(1)

iPhone(1)

Mobile Devices(1)

Universal(1)

BlackBerry; iPhone; iPod nano; iPod shuffle; iPod touch; Kindle Touch; Kindle Touch 3G; Nook Simple Touch; Samsung Galaxy Nexus 7(1)

Acer; Asus; Compaq; Dell; Fujitsu; Gateway; HP; IBM; Lenovo; Panasonic; Sony; Toshiba(1)

Smartphones; Tablets(1)

All standard Micro USB devices(1)

iPad; iPhone; iPod(1)

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

Brother PT-E300, PT-E500, PT-E550W, PT-H300, PT-H300LI, PT-H500LI, PT-P700, PT-P750W(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)

iPad 4th Gen; iPad mini; iPhone 5, 5s; iPod nano 7th Gen; iPod touch 5th Gen(1)

USB-Powered Devices(1)

Canon P1-DHV-G, P23-DHV, P23-DHV-G(1)

Ultrabook; Windows 8 tablet; MacBook; Apple computer(1)

iPad 4th Gen; iPad mini; iPhone 5(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)

iPhone 5(1)

iPad; iPhone(1)

 
Length

3 ft(2)

2 1/4"(2)

6"(1)

135 ft(1)

18"(1)

4 ft(1)

 
Connector/Port/Interface

USB(16)

Micro USB(6)

Micro USB; USB(4)

Apple 30-Pin(2)

Apple Lightning(2)

Displayport; VGA; HDMI; DVI(1)

RJ45; USB 1.1(1)

3.5mm; HD15; RJ45(1)

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

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

HDMI Female; USB A Male(1)

AC Outlet; USB Port(1)

DB9; USB(1)

HD15 Female; RJ45 Female(1)

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

2 AC(1)

HDMI Female/HDMI Female(1)

Apple Lightning; USB(1)

2 Amp USB(1)

Lightning(1)

Apple Lightning; Micro USB(1)

Apple Lightning to USB cable(1)

Apple 30-Pin; Micro USB(1)

USB; 7 Laptop Tips(1)

HDMI Female; RJ45 Female(1)

USB 3.0(1)

DVI-I Female; DVI-Female(1)

Mini DIN-6; USB(1)

3 HDMI Female;2 RJ45 Female(1)

 
Operating System Compatibility

Mac; Windows(6)

Mac OS X 10.4 and Later; Windows 2000 and Later(1)

Mac OS X 10.6 and Later; Windows XP, Vista, 7, 8(1)

 
Power Source(s)

AC Wall Outlet(20)

Vehicle Outlet(12)

Lithium Ion Rechargeable Battery(5)

Lithium Ion Battery(4)

Wall Outlet(4)

USB Port(3)

Rechargeable Battery(2)

Internal Lithium-ion Batteries(1)

AC Outlet; USB Port(1)

Micro USB(1)

110V AC, 12V DC(1)

USB(1)

AC Adapter(1)

AC Wall Outlet; Internal Battery(1)

CR123 Battery(1)

 
Voltage

5V(12)

3.7V(4)

120V(3)

12V(2)

9V(2)

7.2V(1)

110V(1)

120 V(1)

 
For Device Type

Mobile Devices(22)

USB Devices(10)

Label Makers(4)

Digital Signage(4)

Home Theater/AV(2)

iPad; Smartphones; MP3 Players(2)

Micro USB Devices(2)

Remote Display/Local Monitor(1)

DVI-Enabled Digital Video Components(1)

Computers(1)

Universal(1)

PS/2 Devices; USB Devices(1)

Computers; HDTVs(1)

Laptops; Mobile Devices(1)

Smartphones; Tablets(1)

Notebooks; USB Devices(1)

Battery Chargers; Cell Phones; Consumer Electronics 2.5A; Laptops; Small Electronics(1)

Calculators(1)

Two-Way Radios(1)

Nomad Reload Charging Table(1)

Tablets; Ultrabooks(1)

Cell Phones; Digital Cameras; Mobile Devices(1)

Laptops(1)

 
Expected Delivery

Allow several additional days for delivery(8)

 
Connects Devices (From/To)

Single Source to a Display(3)

Wall AC Outlet to USB(2)

Adapter to Monitor(1)

Laptop to USB, Wall AC Outlet or Car Outlet(1)

Battery Pack to Micro USB Devices(1)

USB Peripheral to Computer(1)

AC to Laptops; USB Port to Tablets(1)

Serial Peripherals to PC/Mac Computers(1)

Additional Monitor or HDTV to Computer/Laptop USB 2.0 Port(1)

Displayport to VGA, HDMI, DVI(1)

Standard Micro USB Devices to Car Outlet(1)

Connects to device using compatible USB cord(1)

Device to AC Outlet(1)

Device to DC Outlet(1)

USB-Powered Device to Charger(1)

Vehicle Outlet to Device(1)

Calculator to Wall Outlet(1)

Wall AC Outlet to Tablets; Smartphones(1)

Connects to Apple 30 Pin devices(1)

Connects to Micro USB device(1)

USB Powered Devices to Power Source(1)

Wall AC Outlet to Radios(1)

AC Outlet to Device(1)

 
Electronic/Mechanical

Electronic(31)

 
Ports/Amps

One 1.0 Amp Port(7)

One 2.4 Amp Port(3)

2(2)

One 2600 mAh Port(2)

One 2.0 Amp Port(1)

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

Two 1.0 Amp Ports(1)

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

Two 2.1 Amp Ports(1)

Two 3.1 Amp Ports(1)

One 2.1 Amp Port(1)

 
Capacity

12W(3)

2600 mAh(2)

800 mAh(2)

2.1 Amp(2)

4200 mAh(2)

2000 mAh(1)

2200 mAh(1)

12000 mAh(1)

1.5W(1)

1900mAh(1)

20W(1)

1950mAh(1)

5 Hours(1)

10W(1)

2.5W(1)

 
Cable Type

USB to Micro USB Cable (Included)(4)

Detachable Micro USB Cable (Included)(3)

Detachable Apple Lightning Cable (Included)(3)

Detachable USB Cable (Included)(2)

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

Hardwired Micro USB Cable (Included)(2)

Hardwired Apple Lightning Cable (Included)(2)

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

AC Power Cord(1)

Hardwired Cable with Lightning Tip (Included)(1)

Detachable 30-Pin Cable (Included)(1)

Detachable Lightning Cable (Included)(1)

 
Adapter/Charger Type

Portable Mobile Charger(14)

Car Charger(11)

A/V Extender(7)

AC Adapter(7)

Wall Charger(6)

Transmitter(1)

Receiver(1)

PS/2 to USB Adapter(1)

HDMI Adapter(1)

AC Outlet; 2.4A USB Port(1)

Serial to USB Adapter(1)

Power Bank(1)

Displayport to VGA, HDMI, DVI(1)

Six-Unit Charger(1)

A/C Home Charger Lightning Connector(1)

D/C Car Charger Lightning Connector(1)

Rechargeable Li-ion Battery Pack(1)

Plug Adapter(1)

Display Adapter(1)

5 Stage Charger(1)

USB to Display Port Adapter(1)

Micro USB(1)

 
 
 

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