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','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(20)

Duracell(6)

LINKSYS(4)

Artistic(3)

Belkin(3)

Kensington(3)

Brother P-Touch(2)

Brother(1)

Case Logic(1)

DYMO(1)

Kenwood(1)

Rayovac(1)

 
Color(s)

Black(20)

White(4)

Silver(2)

Blue(1)

 
Quantity

1 each(4)

 
Base Color

Black(3)

 
Manufacturer Part Number

ART59026D0(1)

B132100A(1)

B015-000(1)

B120000(1)

B122-000(1)

B125-150(1)

B1261A1(1)

B1301012(1)

B130101A2(1)

B132004A2(1)

B202150(1)

WUSB6400M(1)

P13706NHDV(1)

PV200CUSB(1)

PV375(1)

PV400USB(1)

U44406NDC(1)

U44406NDGUC(1)

U44406NH4UC(1)

U44406NHGUC(1)

U44406NVC(1)

PS101E(1)

WUSB6300(1)

ART59026D9(1)

DMLIONPB2(1)

ART59026M(1)

B2B052(1)

F8J032TT04(1)

F8J032TT04WH(1)

AD-24(1)

AD24ESAW(1)

ADE001(1)

CLTCMF(1)

DMLIONPB1(1)

DMLIONPB3(1)

WUSB6100M(1)

40077(1)

DC5341(1)

PRO168(1)

PRO515(1)

33117(1)

38231(1)

39794(1)

KMB44K(1)

USB3GIG(1)

USA19HS(1)

 
Country of Origin

CN(39)

TW(5)

US(2)

 
For Use With

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

Micro USB Devices(3)

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

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)

Kenwood PKT23K(1)

 
Length

3 ft(4)

36"(1)

24"(1)

11"(1)

5 ft(1)

2.25"(1)

9 1/4"(1)

135 ft(1)

 
Connector/Port/Interface

Micro USB(5)

USB(4)

Qi Wireless Charging(3)

Apple Lightning; USB(3)

RJ45; USB 1.1(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)

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

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

2 AC(1)

Displayport; DVI; HDMI; VGA(1)

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

3.5mm; HD15; RJ45(1)

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

USB 3.0(1)

HD15 Female; RJ45 Female(1)

3 HDMI Female;2 RJ45 Female(1)

HDMI Female; RJ45 Female(1)

HDMI Female/HDMI Female(1)

DVI-I Female; DVI-Female(1)

Mini DIN-6; USB(1)

USB-C(1)

DB9; USB(1)

 
Operating System Compatibility

Mac; Windows(3)

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

 
Power Source(s)

AC Wall Outlet(18)

Vehicle Outlet(6)

Lithium Ion Rechargeable Battery(4)

USB Port(2)

Wall Outlet(1)

 
Voltage

5V(5)

5 V(3)

9V(2)

120 V(2)

9 V(1)

12V(1)

110V(1)

120V(1)

 
For Device Type

Mobile Devices(17)

Laptops; Mobile Devices(8)

Label Makers(4)

Digital Signage(4)

Home Theater/AV(2)

USB Devices(2)

Two-Way Radios(1)

PS/2 Devices; USB Devices(1)

DVI-Enabled Digital Video Components(1)

Remote Display/Local Monitor(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)

Single Source to a Display(3)

AC Outlet to Device(2)

USB Peripheral to Computer(2)

Computer to Wi-Fi(2)

USB to DVI(2)

Wall AC Outlet to Label Maker(1)

Device to AC Outlet(1)

Wall AC Outlet to Radios(1)

USB to Wi-Fi(1)

Adapter to Monitor(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(13)

 
Ports/Amps

One 1.0 Amp Port(3)

One 2.1 Amp Port(2)

2(2)

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

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 Apple Lightning Cable (Included)(3)

Detachable Micro USB (Included)(3)

USB-C to HDMI Adapter(2)

USB-C to DVI Adapter(2)

A/V Extender(1)

USB-C to VGA Adapter(1)

Displayport to VGA/HDMI/DVI Adapter(1)

Receiver(1)

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

PS/2 to USB Adapter(1)

USB to Display Port Adapter(1)

Detachable USB-C Cable (Included)(1)

Detachable Micro USB Cable (Included)(1)

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

Hardwired Micro USB Cable (Included)(1)

Serial to USB Adapter(1)

 
Jacket Color

White(5)

Black(4)

 
Adapter/Charger Type

A/V Extender(6)

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)

Six-Unit Charger(1)

Transmitter(1)

 
 
 

© 2020-2021 BonTay, Inc., All Rights Reserved

Powered by SITS Erp