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_27` 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(20)

Duracell(10)

LINKSYS(4)

Artistic(3)

Kensington(3)

Belkin(3)

Brother P-Touch(2)

Scosche(2)

Rayovac(1)

DYMO(1)

Brother(1)

Case Logic(1)

Canon(1)

Kenwood(1)

 
Color(s)

Black(25)

White(5)

Silver(2)

Blue(1)

 
Quantity

1 each(15)

 
Base Color

Black(3)

 
Manufacturer Part Number

B125-150(1)

B122-000(1)

B1261A1(1)

B1301012(1)

B130101A2(1)

B120000(1)

B015-000(1)

WUSB6400M(1)

WUSB6300(1)

PS101E(1)

USBH121M(1)

USBH121WT(1)

B132004A2(1)

B132100A(1)

U44406NH4UC(1)

U44406NDGUC(1)

U44406NHGUC(1)

U44406NVC(1)

USA19HS(1)

U44406NDC(1)

PV400USB(1)

B202150(1)

P13706NHDV(1)

PV200CUSB(1)

PV375(1)

WUSB6100M(1)

USB3GIG(1)

CLTCMF(1)

ADE001(1)

5478B001AA(1)

DMLIONPB1(1)

DMLIONPB2(1)

AD24ESAW(1)

AD-24(1)

ART59026M(1)

ART59026D9(1)

B2B052(1)

F8J032TT04(1)

F8J032TT04WH(1)

DMLIONPB3(1)

40077(1)

33117(1)

PRO515(1)

38231(1)

39794(1)

KMB44K(1)

PRO173(1)

PRO168(1)

DC5341(1)

DC5343(1)

DU5264(1)

PRO158(1)

ART59026D0(1)

 
Country of Origin

CN(43)

TW(5)

CA(3)

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)

iPhone 6, 6s Plus, 7, 7 Plus, 8, 8 Plus, X, XS, XS MAX, XR; iPad mini; iPad Pro Air 2(1)

iPad; iPhone; iPod(1)

Kenwood PKT23K(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)

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)

 
Length

3 ft(4)

2.25"(1)

9 1/4"(1)

135 ft(1)

2"(1)

5 ft(1)

24"(1)

11"(1)

36"(1)

 
Connector/Port/Interface

USB(8)

Micro USB(6)

Qi Wireless Charging(3)

Apple Lightning; USB(3)

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

2 AC(1)

Displayport; DVI; HDMI; VGA(1)

RJ45; USB 1.1(1)

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

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

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

3.5mm; HD15; RJ45(1)

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

HD15 Female; RJ45 Female(1)

Mini DIN-6; USB(1)

USB-C(1)

Apple Lightning(1)

USB 3.0(1)

DVI-I Female; DVI-Female(1)

HDMI Female/HDMI Female(1)

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

3 HDMI Female;2 RJ45 Female(1)

HDMI Female; RJ45 Female(1)

3.5mm Female; HD15 Male; RJ45 Female(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(21)

Vehicle Outlet(7)

Lithium Ion Rechargeable Battery(4)

Wall Outlet(4)

USB Port(2)

 
Voltage

5V(5)

120V(3)

5 V(3)

9V(2)

110V(1)

9 V(1)

12V(1)

 
For Device Type

Mobile Devices(23)

Laptops; Mobile Devices(8)

Label Makers(4)

Digital Signage(4)

Home Theater/AV(2)

USB Devices(2)

Remote Display/Local Monitor(1)

Desktops; Laptops(1)

PS/2 Devices; USB Devices(1)

Calculators(1)

Two-Way Radios(1)

DVI-Enabled Digital Video Components(1)

 
Network Types

Ethernet; USB 3.0(1)

 
Expected Delivery

Allow several additional days for delivery(3)

 
Connects Devices (From/To)

Devices to Inductive Charge Pad(3)

Single Source to a Display(3)

USB to DVI(2)

Wall AC Outlet to USB(2)

USB Peripheral to Computer(2)

Computer to Wi-Fi(2)

AC Outlet to Device(2)

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)

Displayport to VGA, HDMI, DVI(1)

Wall AC Outlet to Label Maker(1)

USB to Wi-Fi(1)

Calculator to Wall Outlet(1)

Device to AC Outlet(1)

Adapter to Monitor(1)

Wall AC Outlet to Radios(1)

 
Electronic/Mechanical

Electronic(16)

 
Ports/Amps

One 1.0 Amp Port(4)

2(2)

One 2.1 Amp Port(2)

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

One 2.4 Amp Port(1)

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

Two 3.1 Amp Ports(1)

One 3350 mAh Port(1)

One 6700 mAh Port(1)

One 10050 mAh Port(1)

One 2600 mAh Port(1)

 
Capacity

5 W(3)

12W(2)

10W(2)

2600 mAh(1)

10050 mAh(1)

3350 mAh(1)

2.1 Amp(1)

6700 mAh(1)

 
Cable Length

3"(5)

6"(1)

18"(1)

 
Cable Type

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

Detachable Micro USB (Included)(3)

Detachable Apple Lightning Cable (Included)(3)

USB-C to HDMI Adapter(2)

USB-C to DVI Adapter(2)

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

Hardwired Micro USB Cable (Included)(2)

Receiver(1)

Displayport to VGA/HDMI/DVI Adapter(1)

USB-C to VGA Adapter(1)

Serial to USB Adapter(1)

A/V Extender(1)

Detachable USB-C Cable (Included)(1)

Hardwired Apple Lightning Cable (Included)(1)

USB to Display Port Adapter(1)

Detachable Lightning Cable (Included)(1)

Detachable Micro USB Cable (Included)(1)

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

PS/2 to USB Adapter(1)

 
Jacket Color

White(5)

Black(4)

 
Adapter/Charger Type

AC Adapter(7)

Car Charger(7)

Wall Charger(7)

A/V Extender(6)

Portable Mobile Charger(4)

Wireless Charging Desk Mat(3)

Transmitter(1)

Plug Adapter(1)

USB-C Charger(1)

Six-Unit Charger(1)

 
 
 

© 2019-2020 Hi Tech Office Products, All Rights Reserved

Powered by SITS Erp