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') 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(27)

Brother P-Touch(13)

Brother(7)

Seiko(4)

Casio(1)

 
Manufacturer Part Number

PTD210(1)

1801611(1)

1752266(1)

1752267(1)

1754488(1)

1755120(1)

1755749(1)

1756589(1)

1757660(1)

1768815(1)

1768960(1)

1790415(1)

1815990(1)

1752264(1)

1868814(1)

1868815(1)

1981698(1)

1982171(1)

2002150(1)

2056115(1)

21455(1)

SLP620(1)

SLP620FP(1)

SLP650(1)

1752265(1)

1738976(1)

PTD400AD(1)

PTP750W(1)

PTD400VP(1)

PTD450(1)

PTD600(1)

PTD600VP(1)

PTD800W(1)

PTH300(1)

PTH300LI(1)

PTH500LI(1)

PTP700(1)

PTP710BT(1)

QL1100(1)

1738345(1)

QL1110NWB(1)

QL-500(1)

QL800(1)

QL810W(1)

QL820NWB(1)

VC500W(1)

KL-60L(1)

101105(1)

12966(1)

1540-00(1)

1733013(1)

SLP650FP(1)

 
Country of Origin

CN(51)

PH(1)

 
For Use With

Brother CK-1000; Brother CZ-1001; Brother CZ-1002; Brother CZ-1003; Brother CZ-1004; Brother CZ-1005(1)

 
Operating System Compatibility

Mac OS X 10.5 and Later; Windows XP, Vista, 7, 8(8)

Mac; Windows(5)

Mac OS X 10.10.5-10.12; Windows Server 2008, Vista, 7, 8, 8.1, Server 2012, 10(2)

Windows 7, 8, 10(2)

Mac OS X 10.10 and Later; Windows 7(2)

Linux; Mac OS X 10.5 and Later; Windows XP, Vista, 7, 8, 10(2)

Windows Vista, 7, 8, 8.1, 10(2)

Android; iOS(1)

Mac OS X 10.7.5 and Later; Windows Server 2008, Vista, 7, 8, Server 2012(1)

Mac OS X 10.11.x-10.13.x; Windows 7, 8, 8.1, 10(1)

Android 4.4 and Later; iOS 7-11; Mac OS X 10.11.x-10.13.x; Windows Server 2008, 7, 8, 8.1, Server 2012, 10, Server 2016(1)

Mac OS X 10.1-10.6.x; Windows XP, Vista, 7(1)

Mac OS X 10.10.5-10.12; Windows Vista, 7, 8, 8.1, 10(1)

Mac OS X 10.11 and Later; Windows 7, 8, 8.1, 10(1)

Mac OS X 10.2.8 and Later; Windows 2000, XP, Vista(1)

Mac OS X 10.8 and Later; Windows 7(1)

 
Power Source(s)

AC Adapter (Included)(8)

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

Adapter Power Cable (Included)(4)

AC Adapter(4)

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

Rechargeable Lithium Polymer Battery or AC Adapter(2)

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

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

6 AA Batteries (Sold Separately)(2)

4 AA Batteries (Sold Separately)(2)

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

Rechargeable Battery (Included); USB Cable (Included)(1)

Rechargeable Batteries (Included)(1)

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

Lithium-Ion Battery (Sold Separately)(1)

Manual(1)

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

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

AC Power Cord (Included)(1)

USB Power Adapter (Included)(1)

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

Lithium-Ion Battery (Included)(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)

6 AAA Batteries (Sold Separately)(1)

 
Tape Type

TZE(12)

LW(7)

DK(6)

D1(5)

LT(3)

D1; IND(3)

XTL(2)

SLP(2)

Brother CZ and CK tapes up to 50mm (1.97") wide by 17" long(1)

Standard Laminated(1)

Metal/Vinyl/Tapes(1)

Embossing(1)

TZe Series(1)

D1; IND; LW(1)

Flexible Nylon; Heat Shrinkable Tube; Metallized Permanent Polyester; Permanent Polyester; Vinyl(1)

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

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

D1; LW(1)

 
Model

PT-D210(1)

LabelManager 160(1)

LabelWriter 450(1)

LabelWriter 450 Turbo(1)

LabelWriter 450 Twin Turbo(1)

LabelWriter 450 DUO(1)

LabelManager 360D(1)

LabelWriter 4XL(1)

Desktop Mailing Solution(1)

LabelManager PnP(1)

LabelManager 280(1)

LabelManager 210D(1)

LabelWriter Wi-Fi White(1)

MobileLabeler(1)

LabelWriter Wi-Fi Black(1)

COLORPOP!(1)

LetraTag 100H(1)

Smart Label Printer 620(1)

Smart Label Printer 620 Food Prep Printing Kit(1)

Smart Label Printer 650(1)

LabelManager 210D Kit(1)

LetraTag 100T(1)

PT-D400AD(1)

PT-P700(1)

PT-D400VP(1)

PT-D450(1)

PT-D600(1)

PT-D600VP(1)

PT-D800W(1)

PT-H300(1)

PT-H300LI(1)

PT-H500LI(1)

PTP710BT(1)

Organizer Xpress Pro(1)

PT-P750W(1)

QL-1100(1)

QL-1110NWB(1)

QL-500(1)

QL-800(1)

QL-810W(1)

QL-820NWB(1)

VC-500W(1)

Smart Label Printer 650 Food Prep Printing Kit(1)

 
Machine Depth

6"(3)

7.4"(3)

7"(3)

8.7"(2)

6.78"(2)

8"(2)

7.8"(2)

6.5"(2)

6.77"(2)

7.63"(2)

2.6"(2)

8.5"(2)

9 1/5"(1)

2.56"(1)

4 4/5"(1)

7 1/2"(1)

5 3/4"(1)

3 1/2"(1)

2.3"(1)

8 23/50"(1)

4.65"(1)

5 3/10"(1)

2 6/25"(1)

3 1/8"(1)

11 1/4"(1)

8 3/4"(1)

8.4"(1)

9 7/10"(1)

2.8"(1)

8 3/10"(1)

8.3"(1)

3 7/8"(1)

4 1/2"(1)

4.6"(1)

9 3/8"(1)

9.38"(1)

7.76"(1)

 
Machine Height

5.5"(4)

6"(3)

5.9"(3)

3.38"(2)

4.78"(2)

2.5"(2)

2.88"(2)

14 3/8"(2)

5.78"(2)

2.63"(2)

3 1/2"(2)

5.83"(2)

8 1/10"(1)

2 1/2"(1)

10.43"(1)

8.3"(1)

7.9"(1)

2 6/25"(1)

1.9"(1)

5 3/5"(1)

8 23/50"(1)

2.75"(1)

7.3"(1)

7.4"(1)

2 3/5"(1)

2.6"(1)

4 1/2"(1)

1 1/16"(1)

3.8"(1)

7 7/8"(1)

5 5/8"(1)

5"(1)

5.6"(1)

6 1/8"(1)

2.78"(1)

5.7"(1)

 
Machine Width

5"(8)

3.1"(3)

6.7"(3)

7.5"(3)

4.48"(2)

4.5"(2)

16 1/8"(2)

4 3/50"(2)

5.5"(2)

6.1"(2)

8"(2)

5.25"(2)

5 3/4"(1)

8.5"(1)

6.3"(1)

8 3/10"(1)

12 1/4"(1)

4"(1)

7.9"(1)

2 1/10"(1)

4 9/10"(1)

4.4"(1)

6 1/8"(1)

7.3"(1)

2.8"(1)

4 4/5"(1)

6"(1)

3 1/10"(1)

11 3/8"(1)

6 5/8"(1)

6.25"(1)

 
Display Characters x Display Lines

13 x 2(4)

13 x 1(3)

15 x 3(2)

15 x 1(1)

15 x 4(1)

4 x 1(1)

14 x 2(1)

 
Number of Printed Lines

2(9)

5(7)

1(5)

7(4)

4(4)

Variable(3)

Unlimited(2)

17(1)

11(1)

24(1)

 
Display Type

Graphical(13)

LCD(9)

Full Color Touch Screen(1)

Graphical; LCD(1)

 
Keyboard Type

QWERTY(20)

ABC Style(4)

Qwerty(1)

 
Connectivity

USB(18)

USB; Wi-Fi(3)

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

PC connectivity and DYMO ID software for importing Microsoft Excel or database files for printing entire label batches.(2)

Wi-Fi(2)

USB 2.0(2)

Wireless(1)

USB; Wireless(1)

Bluetooth(1)

 
Maximum Resolution (Dpi)

180 Dpi(9)

180 dpi(4)

300 dpi(4)

600 x 300 Dpi(4)

600 x 300 dpi(4)

300 x 600 dpi(3)

300 x 300 dpi(2)

300 Dpi(2)

180 dpi (Max 180x360 dpi)(1)

313 dpi(1)

203 Dpi(1)

203 dpi(1)

 
Number of Font Styles

10(9)

7(5)

3(4)

8(3)

1(2)

15(2)

Unlimited(2)

6(1)

5(1)

 
Number of Fonts

1(12)

14(9)

Variable(4)

3(4)

8(3)

Unlimited(2)

33(1)

2(1)

 
Number of Font Sizes

6(6)

14(3)

Scalable(3)

7(3)

3(2)

25(2)

1(2)

5(2)

4(2)

Unlimited(2)

16 (8 to 72)(2)

8(1)

 
Maximum Tape/Label Width

0.5"(7)

0.75"(6)

2.3"(5)

2.25"(4)

1"(4)

2 2/5"(3)

2.31"(2)

1(2)

4.09"(2)

2"(2)

1/2"(2)

4.16"(1)

12mm(1)

0.38"(1)

24mm(1)

3/4"(1)

36mm(1)

2.4"(1)

 
Memory

9 Labels(6)

50 Labels(6)

100 Labels(2)

30 Labels(1)

Up to 99 Labels(1)

No(1)

99 Labels(1)

255 Labels(1)

128 MB(1)

63 Characters(1)

15 Labels(1)

 
Tape Size

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

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

1/4"; 3/8"; 1/2"(3)

1/4"; 3/8"; 1/2"; 3/4"(3)

0.25"; 0.38"; 0.5"(3)

1"; 2"; 2.5"(2)

0.5"(2)

2 1/2"(2)

0.75"(2)

4 3/4"(1)

2"(1)

1"(1)

3/8"; 1/4"; 1/2"; 3/4"(1)

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

3mm, 6mm, 9mm, 12mm(1)

3/8"(1)

0.38"(1)

6mm-12mm(1)

50 mm(1)

2.5"(1)

9/64"; 1/4"; 3/8"; 1/2"; 3/4"; 1"(1)

9/64"; 1/4"; 3/8"; 1/2"; 3/4"; 15/16"(1)

9/64"; 3/8"; 1/4"; 1/2"; 3/4"; 1"(1)

36mm(1)

1/2"(1)

 
Printing Speed

0.5"/Second(7)

20 mm/second(6)

30 mm/second(5)

71 Labels/Minute(4)

69 Labels/Minute(2)

0.6"/Second(2)

110 Standard Address Labels/Minute(2)

71 four-line address labels per minute(2)

100 mm/second(1)

2.76"/Second(1)

70 mm/second(1)

71 Standard Address Labels/Minute(1)

28 mm/second(1)

23 mm/second(1)

0.4"/Second(1)

50 Labels/Minute(1)

53 Labels/Minute(1)

60 mm/second(1)

51 Labels/Minute(1)

20 mm/s(1)

7.5 mm/second(1)

93 Standard Address Labels/Minute(1)

3.94"/Second(1)

 
Print Area

2 lines(1)

17 Lines(1)

4 Lines(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved