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 ('40000')) 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(1)

LINKSYS(1)

DYMO(1)

Brother(1)

Brother P-Touch(1)

 
Warranty

Manufacturer's limited three-year warranty.(1)

Manufacturer's limited one-year warranty.(1)

 
For Use With

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)

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)

 
Connects Devices (From/To)

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

USB to Wi-Fi(1)

 
Manufacturer Part Number

U44406NHGUC(1)

USB3GIG(1)

40077(1)

ADE001(1)

AD-24(1)

 
Country of Origin

CN(5)

 
Quantity

1 each(2)

 
OEM/Compatible

OEM(4)

 
Connector/Port/Interface

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

 
Base Color

Black(1)

 
Cable Length

3"(1)

 
Voltage

9V(2)

12V(1)

 
Power Source(s)

AC Wall Outlet(3)

 
Cable Type

USB-C to HDMI Adapter(1)

 
For Device Type

Label Makers(3)

Laptops; Mobile Devices(1)

 
Network Types

Ethernet; USB 3.0(1)

 
Adapter/Charger Type

AC Adapter(3)

 
Jacket Color

White(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved