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

Duracell(5)

Belkin(4)

Kenwood(1)

Kensington(1)

Verbatim(1)

VXi(1)

DYMO(1)

Brother P-Touch(1)

Brother(1)

ByTech(1)

Canon(1)

 
Color(s)

Black(19)

White(2)

Silver(1)

Black/Blue(1)

Blue(1)

 
Quantity

1 each(10)

 
Manufacturer Part Number

B1301012(1)

B130101A2(1)

B132004A2(1)

B1261A1(1)

B126-1A0(1)

B120000(1)

B122-000(1)

P13706NHDV(1)

PV375(1)

98343(1)

203017(1)

USA19HS(1)

U44406NHGUC(1)

PV400USB(1)

U244001HDMIR(1)

B015-000(1)

KMB44K(1)

ADE001(1)

21CPUNIUSB(1)

AD-24(1)

F8J071BT04BK(1)

F8J032TT04(1)

F8J071BT04(1)

5478B001AA(1)

40077(1)

PRO168(1)

33117(1)

PRO158(1)

DU7169(1)

DC5341(1)

DU5264(1)

B2B052(1)

 
Country of Origin

CN(27)

US(2)

TW(2)

TH(1)

 
For Use With

USB Devices(2)

Micro USB Devices(2)

iPhone 5, 5s(1)

Kenwood PKT23K(1)

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

Chromebook; Laptop; MacBook; Smartphone; Tablet(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)

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

iPad mini; iPad with Retina display (4th generation); iPhone 5; iPod nano (7G; iPod touch (5G)(1)

iPad 4th Gen; iPad mini; iPhone 5, 5s; iPod nano 7th Gen; iPod touch 5th Gen(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 PT-E300, PT-E500, PT-E550W, PT-H300, PT-H300LI, PT-H500LI, PT-P700, PT-P750W(1)

USB-Powered Devices(1)

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

 
Length

3 ft(2)

2 1/4"(2)

4 ft(2)

3"(1)

6"(1)

18"(1)

135 ft(1)

 
Connector/Port/Interface

USB(6)

Micro USB(2)

2 AC(1)

Displayport; VGA; HDMI; DVI(1)

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

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

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

Micro USB; USB(1)

DB9; USB(1)

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

HDMI Female; USB A Male(1)

3 HDMI Female;2 RJ45 Female(1)

Mini DIN-6; USB(1)

Apple Lightning(1)

Apple Lightning to USB cable(1)

DVI-I Female; DVI-Female(1)

HDMI Female/HDMI Female(1)

USB 3.0(1)

HDMI; RJ45(1)

HD15 Female; RJ45 Female(1)

 
Operating System Compatibility

Mac; Windows(5)

Linux; Mac; Windows(1)

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

Android; Mac(1)

 
Power Source(s)

AC Wall Outlet(13)

Vehicle Outlet(8)

USB Port(2)

Wall Outlet(2)

Lithium Ion Battery(1)

USB(1)

Lithium Ion Rechargeable Battery(1)

 
Voltage

120V(2)

9V(2)

20 V(1)

3.7V(1)

110V(1)

12V(1)

5V(1)

 
For Device Type

Mobile Devices(8)

Digital Signage(3)

USB Devices(3)

Label Makers(3)

Laptops; Mobile Devices(1)

Remote Display/Local Monitor(1)

Computers; HDTVs(1)

Computers(1)

Headsets(1)

HDMI Splitter Local Units(1)

Computers; Phones; Tablets(1)

DVI-Enabled Digital Video Components(1)

Micro USB Devices(1)

Calculators(1)

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

Two-Way Radios(1)

Tablets; Ultrabooks(1)

PS/2 Devices; USB Devices(1)

Home Theater/AV(1)

 
Expected Delivery

Allow several additional days for delivery(3)

 
Connects Devices (From/To)

Single Source to a Display(2)

Vehicle Outlet to Device(2)

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

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

Serial Peripherals to PC/Mac Computers(1)

PC to V150 Wireless Headset(1)

Displayport to VGA, HDMI, DVI(1)

Adapter to Monitor(1)

USB-Powered Device to Charger(1)

Calculator to Wall Outlet(1)

Wall AC Outlet to Radios(1)

AC Outlet to Device(1)

 
Electronic/Mechanical

Electronic(15)

 
Ports/Amps

Two 2.1 Amp Ports(2)

4(1)

Two 1.0 Amp Ports(1)

2(1)

One 1.0 Amp Port(1)

One 2600 mAh Port(1)

One 2.1 Amp Port(1)

Two 3.1 Amp Ports(1)

 
Capacity

10W(2)

12000 mAh(1)

20W(1)

2600 mAh(1)

 
Cable Type

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

Detachable Apple Lightning Cable (Included)(2)

USB C Male(1)

Detachable USB Cable(1)

USB to Micro USB Cable (Included)(1)

Detachable Micro USB Cable (Included)(1)

Hardwired Micro USB Cable (Included)(1)

Hardwired Apple Lightning Cable (Included)(1)

Detachable Lightning Cable (Included)(1)

 
Adapter/Charger Type

Car Charger(8)

A/V Extender(6)

AC Adapter(4)

Portable Mobile Charger(2)

Wall Charger(2)

HDMI Adapter(1)

USB-C to HDMI Adapter(1)

Serial to USB Adapter(1)

RJ9 for V150(1)

Displayport to VGA, HDMI, DVI(1)

PS/2 to USB Adapter(1)

Plug Adapter(1)

Six-Unit Charger(1)

USB to Display Port Adapter(1)

Transmitter(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved