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 ('90234')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 '%LabelMakers' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('LabelMakers' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+LabelMakers' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"LabelMakers"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"LabelMakers"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"LabelMakers"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"LabelMakers"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+LabelMakers' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='LabelMakers',`category_4` ='LabelMakers') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'LabelMakers,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('LabelMakers', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Label Makers

Refine Search
  GO
 
Brand

DYMO(22)

Brother P-Touch(18)

Brother(11)

Seiko(4)

AbilityOne(3)

 
Packaged Quantity

1(2)

 
Limited Warranty

3 Year(2)

 
Weight (Approximate)

1.08 lb(2)

 
For Use With

Brother DK-1247; DK-2246(1)

Brother DK Tapes(1)

Brother DK Tapes and Labels(1)

 
Recommended Use

Label Print(2)

 
Media Type

Label(2)

Tag(2)

 
Model Name/Number

PT-D410(2)

LetraTag 100H(2)

Rhino 4200(2)

LabelManager 360D(2)

Rhino 5200(2)

LabelWriter 550(2)

PT-D460BT(2)

LabelManager 280(1)

VC-500W(1)

LabelManager 210D Kit(1)

LabelWriter 450 Twin Turbo(1)

LabelManager 420P(1)

LabelManager 500TS(1)

LabelWriter Wi-Fi Black(1)

Rhino Industrial 4200(1)

LabelWriter 550 Turbo(1)

LabelWriter 5XL(1)

LetraTag 100T(1)

LabelManager 210D(1)

LabelManager 160(1)

Organizer Xpress Pro(1)

LetraTag 200B(1)

Smart Label Printer 620(1)

QL-820NWBC(1)

QL-820NWB(1)

QL-810WC(1)

PT-P300BTBU(1)

PT-D610BT(1)

D-610BTVP(1)

PT-D800W(1)

PT-H110(1)

PT-H300(1)

PT-H300LI(1)

PT-H500LI(1)

PT-M95(1)

PT-P300BT(1)

PT-P700(1)

QL-810W(1)

PT-P710BT(1)

PT-P750W(1)

PT-P910BT(1)

QL-1100(1)

QL-1100C(1)

QL-1110NWB(1)

QL-1110NWBC(1)

QL-600(1)

QL-800(1)

Smart Label Printer 650(1)

 
USB

Yes(2)

 
Tape Type

DK(11)

TZe Series Laminated(8)

TZe(7)

LW(6)

D1(4)

LT(4)

D1; IND(4)

Flexible Nylon; Heat Shrinkable Tube; Metalized Permanent Polyester; Permanent Polyester; Vinyl(2)

Flexible Nylon; Heat Shrinkable Tube; Permanent Polyester; Vinyl(2)

SLP(2)

TZe Series(1)

M(1)

TZ Series Laminated(1)

Brother CZ and CK Tapes Up to 50 mm (1.97") Wide by 17" Long(1)

D1; IND; LW(1)

 
Platform Supported

Mac(2)

PC(2)

 
Print Color Capability

Monochrome(2)

 
Maximum Mono Print Speed

2.76 in/s(1)

3.94 in/s(1)

 
Country of Origin

CN(45)

PH(8)

US(3)

China(2)

 
Height

5.8"(2)

 
Width

4.5"(2)

 
Depth

6.8"(2)

 
Connector/Port/Interface

USB(14)

Bluetooth; USB(6)

USB; Wi-Fi(4)

Bluetooth(4)

Wi-Fi(2)

Bluetooth; Ethernet; USB; Wi-Fi(2)

USB; LAN(2)

Bluetooth; Ethernet; USB; Wireless (802.11b/g/n)(1)

USB; Wireless (802.11 b/g/n); Wireless Direct(1)

Bluetooth; Ethernet; USB; Wireless (802.11b/g/n); Wireless Direct(1)

 
Power Source

Power Adapter(2)

 
Power Source(s)

AC Adapter (Included)(11)

(6) AA Batteries (Sold Separately); AC Power Adapter (Included)(5)

AC Adapter(4)

(4) AA Batteries (Sold Separately)(3)

AC Power Cord (Included); Li-ion Rechargeable Battery (Sold Separately)(2)

Li-ion Battery (Included)(2)

(6) AA Batteries (Sold Separately)(2)

(6) AAA Batteries (Optional, Sold Separately); AC Power Adapter (Included)(2)

(6) AA Batteries (Sold Separately); AC Adapter (Included); Rechargeable Li-ion Battery (Included)(2)

Adapter Power Cable (Included)(2)

(6) AAA Batteries (Sold Separately); AC Adapter (Sold Separately)(2)

AC Adapter (Included); Rechargeable Batteries (Included)(2)

Rechargeable Battery (Included); Charging Adapter (Included)(1)

Rechargeable Batteries (Included)(1)

AC Adapter (Included); Lithium-Ion Battery (Included)(1)

Li-ion Battery (Sold Separately)(1)

(6) AA Batteries (Sold Separately); AC Adapter (Sold Separately)(1)

AC Power Cord (Included)(1)

(6) AA Batteries (Included); AC Adapter (Included)(1)

(6) AA Batteries (Sold Separately) ;AC Power Adapter (Included)(1)

AC Power Cord(1)

AC Power Cable(1)

(6) AA Batteries (Sold Separately); AC Adapter (Included); Rechargeable Li-ion Battery (Sold Separately)(1)

(6) AA Batteries (Sold Separately); AC Adapter (Included)(1)

(4) AAA Batteries (Sold Separately)(1)

(6) AA Batteries (Included); AC Adapter (Sold Separately); Rechargeable Li-ion Battery (Sold Separately)(1)

AC Adapter (Included) or Li-ion Battery (Optional)(1)

AA Batteries(1)

 
Model

LabelWriter 450 DUO(1)

 
Display Type

LCD(10)

Graphical(8)

Graphical; Monochrome(2)

Backlight; Graphical; Monochrome(2)

Graphical; LCD(2)

Backlight; Color; Graphical(1)

Full-color Touch Screen(1)

Full Color Touch Screen(1)

 
Machine Depth

8.5"(5)

7"(3)

4.6"(3)

6.78"(2)

8.46"(2)

6"(2)

6.13"(2)

6.5"(2)

2.6"(2)

7.76"(2)

8.7"(2)

6.7"(2)

5.7"(2)

9.2"(1)

2.24"(1)

7.44"(1)

2.8"(1)

2.3"(1)

8"(1)

4.65"(1)

8.3"(1)

4.72"(1)

10.8"(1)

11.25"(1)

3.9"(1)

7 4/5"(1)

8.4"(1)

10.43"(1)

14.2"(1)

9.38"(1)

8.75"(1)

8.8"(1)

5.4"(1)

3.12"(1)

9.7"(1)

7.5"(1)

4.8"(1)

9.37"(1)

 
Machine Height

2.5"(5)

7.38"(4)

5.9"(3)

6"(3)

5.78"(2)

13.3"(2)

9.2"(2)

8.7"(2)

2.24"(2)

4.6"(2)

3.5"(2)

2.63"(2)

2.8"(2)

4.72"(1)

2.6"(1)

7.9"(1)

5.7"(1)

8.3"(1)

5.91"(1)

10.4"(1)

4.78"(1)

1.9"(1)

12.3"(1)

3.74"(1)

8.46"(1)

7 3/10"(1)

7.4"(1)

3.31"(1)

6.1"(1)

5.4"(1)

5.62"(1)

5"(1)

5.6"(1)

6.12"(1)

12.6"(1)

3.8"(1)

 
Machine Width

5"(7)

4.5"(4)

3.1"(3)

5.34"(3)

4.06"(3)

6.7"(3)

6"(2)

7.4"(2)

5.5"(2)

5.25"(2)

6.1"(2)

2.5"(2)

2.8"(2)

5.9"(2)

4.9"(1)

8.9"(1)

6.46"(1)

4"(1)

7.9"(1)

1.77"(1)

6.12"(1)

5.1"(1)

5 1/2"(1)

4.72"(1)

4.4"(1)

3.7"(1)

4.8"(1)

12.25"(1)

14.2"(1)

10.2"(1)

3.6"(1)

 
Number of Printed Lines

2(14)

5(8)

7(4)

Variable(3)

1(3)

17(2)

4(2)

Continuous(1)

8(1)

Unlimited(1)

 
Tape Size

0.25"; 0.38"; 0.5"; 0.75"(7)

0.23"; 0.35"; 0.47"; 0.7"(4)

0.25"; 0.38"; 0.5"(4)

0.14"; 0.25"; 0.38"; 0.5"; 0.75"; 1"(3)

2.5"(3)

0.5"(3)

36 mm(2)

12 mm(2)

0.14"; 0.25"; 0.38"; 0.5"; 0.75"(2)

9 mm to 12 mm(2)

0.38"(1)

0.25"; 0.38"; 0.5"; 0.75"; 1"(1)

4"(1)

50 mm(1)

0.23"; 0.47"; 0.7"; 0.94"(1)

0.14"; 0.25"; 0.38"; 0.5"; 0.75"; 0.94"(1)

0.23"; 0.35"; 0.47"; 0.7"; 0.94(1)

0.75"(1)

 
Keyboard Type

QWERTY(22)

ABC Style(5)

Qwerty(1)

 
Number of Fonts

1(8)

3(6)

14(3)

8(3)

Variable(3)

13(2)

16(2)

17(2)

33(2)

2(2)

5(2)

10(1)

Unlimited(1)

 
Number of Font Styles

7(6)

10(4)

3(4)

5(3)

13(2)

15(2)

17(2)

8(2)

6(1)

9(1)

33(1)

Unlimited(1)

1(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander