Total:$0.00

My Cart 0
 

 
 
 
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_3` 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_1` LIKE 'Office Supplies') AND (`category_2` LIKE 'Labels & Labeling Systems') AND `pinfo`.`is_recycled` LIKE 'Y' 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 '%LabelsandLabelingSystems' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('LabelsandLabelingSystems' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+LabelsandLabelingSystems' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"LabelsandLabelingSystems"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"LabelsandLabelingSystems"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"LabelsandLabelingSystems"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"LabelsandLabelingSystems"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+LabelsandLabelingSystems' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='LabelsandLabelingSystems',`category_4` ='LabelsandLabelingSystems') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'LabelsandLabelingSystems,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('LabelsandLabelingSystems', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Labels And Labeling Systems

Refine Search

  GO
 
Brand

Avery(13)

Maco(5)

Casio(5)

Simon(1)

Chartpak(1)

Rubbermaid(1)

 
Color

White(20)

Clear(3)

Kraft(2)

Kraft Brown(1)

 
Recycled

Yes(26)

 
Packaged Quantity

2 / Pack(5)

3000 / Box(2)

100 / Box(2)

600 / Box(2)

200 / Box(1)

1000 / Box(1)

1400 / Pack(1)

1 Each(1)

1 / Box(1)

7500 / Box(1)

1400 / Box(1)

525 / Pack(1)

300 / Pack(1)

160 / Pack(1)

400 / Box(1)

180 / Pack(1)

80 / Pack(1)

8000 / Box(1)

 
Limited Warranty

1 Year(1)

 
Compatibility

Casio Label Printer:

  • CW-L300
  • KL-100
  • KL-430
  • KL-60
  • KL-7000
  • KL-7200
  • KL-750
  • KL-780
  • KL-8100
  • KL-C500
  • KLP1000
(2)

Rubbermaid Glutton Recycling Stations:

  • 1792374
  • 1792372
  • 1792339
  • 1792340
  • 1792373
  • 1792371

Rubbermaid Untouchable Recycling Tops:

  • 2690
  • 2691
(1)

Printers:

  • KL60SR
  • KL100
  • KL780
  • KL1500
  • KL2000
  • KL7200
  • KL8000
  • KL8100
  • KL8200
  • KLC500
  • KLP1000
(1)

Label Printers:

  • KL60SR
  • KL100
  • KL780
  • KL1500
  • KL2000
  • KL7200
  • KL8000
  • KL8100
  • KL8200
  • KLC500
  • KLP1000
(1)

Label Printers:

  • KL100
  • KL750
  • KL1500
  • KL2000
  • KL7200
  • KL8000
  • KL8100
  • KL8200
(1)

 
Print Technology

Laser(20)

Inkjet(20)

Dye Sublimation(2)

Direct Thermal(1)

 
Number of Labels per Roll

80(1)

 
Number of Labels per Sheet

30(5)

8(3)

14(2)

6(2)

1(1)

10(1)

2(1)

100(1)

12(1)

21(1)

9(1)

 
Media Diameter

2 1/2" Diameter(1)

 
Total Number of Labels

525(1)

 
Manufacturer Part Number

XR9X2S(1)

MSL0100(1)

XR9WE2S(1)

XR-18X2S(1)

XR-18WE2S(1)

MSL0200(1)

MSL0600(1)

1792975(1)

11349(1)

RL-FF30R(1)

MSL3000(1)

MSL1000(1)

XR-12WE2S(1)

48960(1)

45395(1)

48160(1)

42395(1)

22855(1)

22846(1)

48163(1)

48395(1)

48467(1)

48464(1)

48462(1)

48460(1)

22808(1)

 
Country of Origin

Mexico(13)

United States(8)

China(5)

 
Material

Paper(9)

Wood(1)

 
Shape

Rectangle(18)

Oval(1)

Square(1)

Circle(1)

 
Adhesive Type

Permanent(15)

Permanent/Water Based(2)

Removable(1)

 
 
 

© 2018-2019 Liberty Tonerserv, LLC, All Rights Reserved