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_12` 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_name` IN ('Electronic Label Makers','Manual Label Makers','Pricing Guns')) 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 '%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

Brother(13)

Dymo(12)

Monarch(5)

SICURIX(1)

 
Color

Black(9)

Silver(5)

Charcoal Gray(5)

White(3)

Dark Gray(2)

Gray(2)

Yellow(1)

Light Gray(1)

Blue Gray(1)

Navy Blue(1)

 
Recycled

No(28)

 
Packaged Quantity

1 / Each(4)

1 Each(2)

1(2)

 
Assembly Required

No(9)

 
Limited Warranty

2 Year(7)

1 Year(5)

 
Weight (Approximate)

2.49 lb(2)

2.56 lb(1)

2.54 lb(1)

1.40 lb(1)

15 oz(1)

13.93 oz(1)

9.12 oz(1)

1.47 lb(1)

1.61 lb(1)

1.10 lb(1)

1.63 lb(1)

2.09 lb(1)

14.40 oz(1)

8 oz(1)

 
Compatibility

Magicolor Printers:

  • Single-sided Enduro
  • Enduro Duo
(1)

RHINO 5200 Label Printer

(1)

Brother Label Printers:

  • GL-100
  • PT-1000
  • PT-1010
  • PT-1010B
  • PT-1010R
  • PT-1010S
  • PT-1090
  • PT-1230PC
  • PT-1280
  • PT-1290
  • PT-1400
  • PT-1500PC
  • PT-1600
  • PT-1650
  • PT-1750
  • PT-1830
  • PT-1830SC
  • PT-1880
  • PT-1900
  • PT-1910
  • PT-1950
  • PT-1960
  • PT-2100
  • PT-2110
  • PT-2700
  • PT-2710
  • PT-7100
(1)

 
Recommended Use

Label Print(3)

 
Media Type

Label(20)

Tape(19)

Heat Shrink Tubing(3)

Die-cut Label(2)

Continuous Paper(1)

 
Form Factor

Handheld(8)

Desktop(4)

 
Device Supported

Printer(1)

 
Input Voltage

230 V AC(1)

120 V AC(1)

 
USB

Yes(10)

 
Output Voltage

9 V DC(1)

 
Display Screen Type

LCD(10)

 
Maximum Print Resolution

180 dpi(5)

300 dpi(3)

300 x 600 dpi(3)

230 dpi(1)

180 x 360 dpi(1)

 
Wireless LAN

Yes(2)

 
Platform Supported

PC(13)

Mac(6)

 
Print Color Capability

Monochrome(3)

 
Ethernet

Yes(1)

 
Battery Size Supported

AA(7)

AAA(5)

 
Number of Batteries Supported

6(9)

4(3)

1(2)

 
Maximum Mono Print Speed

0.79 in/s(4)

1.25 in/s(2)

1.10 in/s(1)

6.93 in/s(1)

1.6 lps(1)

1.18 in/s(1)

0.30 in/s(1)

1.8 lps(1)

 
Bluetooth

Yes(1)

 
Number of Display Lines

3(1)

 
Battery Included

Yes(6)

No(6)

 
Print Method

Thermal Transfer(11)

Direct Thermal(2)

 
Maximum Print Width

2.28"(1)

2.30"(1)

 
Manufacturer Part Number

1815990(1)

1868813(1)

1801611(1)

1790415(1)

1756589(1)

1768815(1)

1868814(1)

1868815(1)

925083(1)

3633-0052(1)

925082(1)

925073(1)

925055(1)

925072(1)

1754488(1)

1738345(1)

PTD600(1)

PTH110(1)

PTD450(1)

PT-D400AD(1)

PT-70BM(1)

PTD210(1)

PT-H300(1)

PT-M95(1)

12966(1)

1733013(1)

QL820NWB(1)

QL810W(1)

PT-P700(1)

QL800(1)

AD24(1)

 
Country of Origin

China(6)

United States(5)

 
Height

5.7"(3)

2.7"(3)

8"(2)

2.8"(2)

2.5"(1)

2"(1)

3.8"(1)

8.5"(1)

2.4"(1)

3.4"(1)

2.3"(1)

5.6"(1)

 
Width

4.7"(2)

7.4"(2)

5"(2)

4.1"(1)

6"(1)

4.6"(1)

4.5"(1)

6.2"(1)

6.7"(1)

6.3"(1)

4.3"(1)

6.1"(1)

4.9"(1)

6.6"(1)

7.9"(1)

 
Depth

2.2"(2)

8.4"(2)

7"(2)

9.2"(2)

6.4"(1)

8"(1)

2.4"(1)

2.8"(1)

4.4"(1)

5.9"(1)

7.6"(1)

4.3"(1)

 
Length

10.4"(2)

 
Power Source

Battery(17)

Power Adapter(12)

 
Standard Memory

6 MB(1)

 
Number of Lines

2(3)

1(2)

 
Number of Fonts

1(1)

3(1)

14(1)

 
 
 

© 2019-2020 Arnold's Office Supply, Inc., All Rights Reserved