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

Currently Filtered by

Category

Label Printers

Refine Search

  GO
 
Brand

Dymo(11)

SICURIX(9)

Brother(5)

Badgy(1)

Sanford(1)

Seiko(1)

 
Color

Black(1)

Silver(1)

 
Recycled

No(28)

 
Assembly Required

No(26)

 
Limited Warranty

2 Year(5)

1 Year(1)

3 Year(1)

 
Weight (Approximate)

12.13 lb(2)

5.29 lb(1)

3.26 lb(1)

3.79 lb(1)

3.81 lb(1)

1.45 lb(1)

5 lb(1)

1.20 lb(1)

1.08 lb(1)

9.70 lb(1)

8.10 lb(1)

10 lb(1)

12 lb(1)

 
Recommended Use

Label Print(16)

Card Print(10)

 
Media Type

Label(13)

Card(8)

PVC Card(6)

Name Badge Label(4)

Address Label(4)

Business Card(3)

Shipping Label(3)

Adhesive Backed Card(3)

Tag(3)

File Folder Label(3)

PET Card(2)

Multipurpose Label(2)

Receipt(2)

Die-cut Label(2)

ID Card(2)

Roll Paper(2)

Tape(2)

Postage Label(1)

Large Address Label(1)

D1 Tape(1)

Thermal Paper(1)

Continuous Label(1)

Sticker(1)

Continuous Roll(1)

Super Narrow Non-laminated Tape(1)

Tamper Evident Tape(1)

Fabric Tape(1)

Flexible Tape(1)

Laminated Tape(1)

Adhesive Tape(1)

PVC Composite(1)

Laminated PVC(1)

Glossy Paper(1)

 
Form Factor

Desktop(18)

Portable(1)

Handheld(1)

 
Input Voltage

220 V AC(2)

110 V AC(2)

24 V DC(1)

6.3 V AC(1)

 
Media Handling

Feeder 40 Card(1)

Output Hopper 40 Card(1)

1 x Feeder 100 Card(1)

1 x Output Hopper 100 Card(1)

 
USB

Yes(19)

 
Display Screen Type

LCD(1)

 
Maximum Print Resolution

300 dpi(12)

180 dpi(2)

300 x 300 dpi(2)

600 x 300 dpi(2)

313 dpi(1)

203 dpi(1)

 
Wireless LAN

Yes(6)

No(1)

 
Platform Supported

PC(25)

Mac(19)

Handheld(3)

SPARC(2)

iOS(1)

Android(1)

 
Print Color Capability

Color(11)

Monochrome(11)

 
Ethernet Technology

Fast Ethernet(1)

 
Ethernet

Yes(6)

 
Battery Size Supported

AA(4)

 
Number of Batteries Supported

6(2)

4(1)

 
Maximum Mono Print Speed

4.33 in/s(2)

0.8 Second(2)

1.2 lps(2)

499.8 Second(2)

7 Second(2)

4.3 Second(2)

11 Second(1)

1.18 in/s(1)

0.30 in/s(1)

51 lpm(1)

1 Second(1)

3.20 in/s(1)

0.9 Second(1)

2.76 in/s(1)

4.2 Second(1)

 
Bluetooth

Yes(2)

 
Battery Included

Yes(1)

No(1)

 
Maximum Color Print Speed

18 Second(3)

35 Second(2)

99.6 Second(2)

38 Second(1)

 
Print Method

Thermal Transfer(1)

Direct Thermal(1)

 
Media Thickness

19.69 mil(1)

30 mil(1)

37 mil(1)

 
Media Load Type

Auto Feed(3)

Manual Feed(1)

 
Maximum Print Width

4"(2)

0.94"(1)

2"(1)

2.20"(1)

4.16"(1)

1"(1)

2.28"(1)

 
Printing Capability

Single Sided(7)

Double Sided(2)

 
Manufacturer Part Number

B22U0000RS(1)

1982171(1)

535500-002(1)

535500-001(1)

38310(1)

38000(1)

36490001K1(1)

3649-0001(1)

36333021(1)

36333001(1)

SLP620(1)

21455(1)

2002150(1)

1981698(1)

PTD800W(1)

1768960(1)

1757660(1)

1755120(1)

1752267(1)

1752266(1)

1756693(1)

1752264(1)

1738976(1)

VC-500W(1)

QL-1110NWB(1)

QL-1100(1)

PT-P750W(1)

535504-001(1)

 
Country of Origin

China(16)

United Kingdom(4)

South Korea(2)

France(1)

Belgium(1)

 
Height

5.3"(3)

5.9"(2)

9.2"(2)

8.7"(2)

6.5"(1)

5.7"(1)

3.8"(1)

6.4"(1)

8.4"(1)

1.6"(1)

3.1"(1)

5.8"(1)

9.1"(1)

12"(1)

8.8"(1)

 
Width

6.7"(4)

7"(2)

8.1"(2)

7.6"(1)

4.6"(1)

4.4"(1)

6.1"(1)

5.5"(1)

6"(1)

2.5"(1)

8.3"(1)

4.5"(1)

8.4"(1)

11"(1)

6.9"(1)

 
Depth

8.7"(2)

15.4"(2)

17.8"(2)

10.7"(1)

2.7"(1)

19"(1)

10.6"(1)

6.8"(1)

7.5"(1)

5.5"(1)

7.6"(1)

7.3"(1)

11.4"(1)

8.5"(1)

2.5"(1)

4.6"(1)

21.2"(1)

 
Power Source

Battery(2)

Power Adapter(1)

 
Standard Memory

128 MB(2)

16 MB(1)

No(1)

6 MB(1)

 
 
 

© 2020-2021 LOP Office Supply, All Rights Reserved