Banner1 Banner1
 
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)

Brother(5)

Seiko(4)

SICURIX(3)

Badgy(1)

Sanford(1)

 
Color

Black(1)

Silver(1)

 
Recycled

No(23)

 
Assembly Required

No(21)

 
Limited Warranty

2 Year(6)

3 Year(4)

1 Year(2)

 
Weight (Approximate)

1.08 lb(4)

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)

 
Recommended Use

Label Print(19)

Card Print(4)

 
Media Type

Label(16)

Tag(6)

Address Label(5)

Name Badge Label(5)

Shipping Label(4)

File Folder Label(4)

Card(3)

Business Card(3)

Multipurpose Label(3)

Tape(2)

Receipt(2)

Die-cut Label(2)

Roll Paper(2)

PVC Card(2)

Large Address Label(1)

Thermal Paper(1)

Postage Label(1)

Name Badge Tag(1)

D1 Tape(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)

PET Card(1)

PVC Composite(1)

Laminated PVC(1)

ID Card(1)

 
Form Factor

Desktop(13)

Portable(1)

Handheld(1)

 
Input Voltage

24 V DC(1)

110 V AC(1)

220 V AC(1)

6.3 V AC(1)

12.6 V AC(1)

 
Media Handling

Feeder 40 Card(1)

Output Hopper 40 Card(1)

 
USB

Yes(16)

 
Maximum Print Resolution

300 dpi(8)

180 dpi(2)

300 x 300 dpi(2)

600 x 300 dpi(2)

203 dpi(2)

313 dpi(1)

 
Wireless LAN

Yes(6)

No(1)

 
Platform Supported

PC(22)

Mac(20)

Handheld(3)

iOS(1)

Android(1)

 
Print Color Capability

Monochrome(14)

Color(5)

 
Ethernet

Yes(1)

 
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)

2.76 in/s(2)

3.94 in/s(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)

7 Second(1)

 
Bluetooth

Yes(2)

 
Battery Included

Yes(1)

No(1)

 
Maximum Color Print Speed

38 Second(1)

35 Second(1)

 
Print Method

Thermal Transfer(1)

Direct Thermal(1)

 
Media Thickness

19.69 mil(1)

30 mil(1)

 
Maximum Print Width

2.28"(2)

4"(2)

0.94"(1)

2"(1)

2.20"(1)

4.16"(1)

1"(1)

 
Printing Capability

Single Sided(3)

 
Manufacturer Part Number

B22U0000RS(1)

1768960(1)

38000(1)

36490001K1(1)

SLP650-FP(1)

SLP650(1)

SLP620-FP(1)

SLP620(1)

21455(1)

2002150(1)

1982171(1)

1981698(1)

1757660(1)

PTD800W(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)

38310(1)

 
Country of Origin

China(14)

South Korea(2)

France(1)

Belgium(1)

United Kingdom(1)

 
Height

5.8"(4)

5.3"(3)

5.9"(2)

6.5"(1)

5.7"(1)

3.8"(1)

6.4"(1)

8.4"(1)

1.6"(1)

3.1"(1)

12"(1)

 
Width

4.5"(4)

6.7"(2)

7"(2)

7.6"(1)

4.6"(1)

4.4"(1)

6.1"(1)

5.5"(1)

6"(1)

2.5"(1)

8.3"(1)

11"(1)

 
Depth

6.8"(4)

8.7"(2)

10.7"(1)

7.6"(1)

4.6"(1)

2.5"(1)

8.5"(1)

11.4"(1)

7.3"(1)

7.5"(1)

5.5"(1)

2.7"(1)

19"(1)

 
Power Source

Battery(2)

Power Adapter(1)

 
Standard Memory

16 MB(1)

No(1)

6 MB(1)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved