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

Brother(13)

Dymo(9)

Monarch(5)

SICURIX(1)

 
Color

Black(8)

Charcoal Gray(5)

Silver(4)

White(3)

Dark Gray(2)

Gray(1)

Light Gray(1)

Navy Blue(1)

Blue Gray(1)

Purple(1)

 
Recycled

No(25)

 
Height

5.7"(3)

2.7"(2)

2.8"(2)

8"(2)

2.3"(1)

3.4"(1)

2.4"(1)

5.6"(1)

8.5"(1)

2"(1)

10"(1)

 
Depth

7"(2)

2.2"(2)

9.2"(2)

4.3"(1)

5.9"(1)

7.6"(1)

4.4"(1)

8.4"(1)

2.8"(1)

8"(1)

2.4"(1)

 
Manufacturer Part Number

AD24(1)

1756589(1)

925083(1)

925082(1)

925073(1)

925072(1)

925055(1)

2056115(1)

1868815(1)

1868814(1)

1815990(1)

1790415(1)

1768815(1)

1754488(1)

PT-70BM(1)

1733013(1)

QL820NWB(1)

QL810W(1)

QL800(1)

PT-P700(1)

PT-M95(1)

PT-H300(1)

PTH110(1)

PTD600(1)

PTD450(1)

PT-D400AD(1)

PTD210(1)

3633-0052(1)

 
Country of Origin

China(6)

United States(5)

 
Width

7.4"(2)

5"(2)

6.6"(1)

6.2"(1)

7.9"(1)

4.3"(1)

6.1"(1)

4.9"(1)

6.7"(1)

4.1"(1)

4.6"(1)

4.5"(1)

4.7"(1)

6"(1)

 
Limited Warranty

2 Year(7)

1 Year(5)

 
Weight (Approximate)

8 oz(1)

1.10 lb(1)

1.61 lb(1)

1.63 lb(1)

2.09 lb(1)

14.40 oz(1)

1.47 lb(1)

9.12 oz(1)

2.54 lb(1)

2.56 lb(1)

1.40 lb(1)

13.93 oz(1)

2.49 lb(1)

1.28 lb(1)

 
Length

10.4"(1)

3"(1)

 
Media Size

0.35" - Tape(6)

0.47" - Tape(6)

0.14" - Tape(5)

0.24" - Tape(5)

0.24"(4)

0.35"(4)

0.47"(4)

0.71" - Tape(3)

0.37"(2)

0.75"(2)

0.50"(2)

0.94" - Label(1)

0.75" - Label(1)

0.47" - Label(1)

0.35" - Label(1)

0.24" - Label(1)

0.71"(1)

0.25"(1)

0.50" x 78"(1)

0.50" x 13 ft(1)

Roll - 2.44"(1)

0.14"(1)

0.94" - Tape(1)

2.13" - Label(1)

 
Recommended Use

Label Print(3)

 
Media Type

Label(19)

Tape(15)

Die-cut Label(2)

Heat Shrink Tubing(2)

Continuous Paper(1)

 
Device Supported

Printer(1)

 
Form Factor

Handheld(7)

Desktop(4)

 
Power Source

Battery(15)

Power Adapter(10)

AC Supply(1)

 
Input Voltage

120 V AC(1)

230 V AC(1)

 
Standard Memory

6 MB(1)

 
USB

Yes(9)

 
Output Voltage

9 V DC(1)

 
Display Screen Type

LCD(10)

 
Maximum Print Resolution

180 dpi(5)

300 x 600 dpi(3)

300 dpi(2)

180 x 360 dpi(1)

230 dpi(1)

 
Battery Chemistry

Alkaline(6)

Lithium Ion (Li-Ion)(2)

Lithium Polymer (Li-Polymer)(2)

 
Platform Supported

PC(12)

Mac(6)

 
Number of Lines

2(3)

1(2)

 
Wireless LAN

Yes(2)

 
Print Color Capability

Monochrome(3)

 
Ethernet

Yes(1)

 
Number of Fonts

14(1)

3(1)

1(1)

 
Battery Size Supported

AAA(6)

AA(5)

 
Number of Batteries Supported

6(8)

4(3)

1(2)

 
Maximum Mono Print Speed

0.79 in/s(4)

1.18 in/s(1)

0.30 in/s(1)

1.6 lps(1)

1.8 lps(1)

6.93 in/s(1)

1.25 in/s(1)

1.10 in/s(1)

 
Product Type

Electronic Label Maker(17)

Pricemarker(5)

Direct Thermal Printer(3)

AC Adapter(1)

Label Printer Kit(1)

Upgrade Kit(1)

 
Packaged Quantity

1 / Each(4)

1(2)

1 Each(2)

 
Assembly Required

No(9)

 
Product Model

AD24(1)

QL820NWB(1)

XTL 500(1)

XTL 300(1)

280(1)

LM160(1)

420P(1)

5200(1)

LM360D(1)

LT-100T(1)

QL810W(1)

70BM(1)

QL800(1)

PT-P700(1)

PT-M95(1)

PT-H300(1)

PT-H110(1)

PT-D600(1)

PT-D450(1)

PT-D400AD(1)

PT-D210(1)

1155(1)

 
Product Line

P-touch(8)

LabelManager(4)

LetraTag(1)

RHINO(1)

ColorPop(1)

 
Bluetooth

Yes(1)