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_1` LIKE 'Office Supplies') AND (`category_2` LIKE 'Labels & Labeling Systems') AND `pinfo`.`country`='US' 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®(132)

Business Source(36)

Smead(30)

Maco(17)

Tabbies(17)

Sparco(12)

SKILCRAFT(10)

Monarch(10)

Advantus(8)

Seiko(6)

PRES-a-ply(6)

Tatco(5)

Dymo(2)

Elite Image(2)

Simon(1)

Paxar(1)

Carson-Dellosa(1)

Bankers Box(1)

Pacon(1)

Rubbermaid Commercial(1)

Sealed Air(1)

 
Color

White(200)

Clear(32)

Red(10)

Yellow(8)

Bright White(6)

Pink(4)

Brown(4)

Black(4)

Blue(4)

Gold(3)

Assorted(3)

Purple(3)

Green(3)

Orange(2)

Gray(2)

Fluorescent Red(2)

Turquoise(1)

Dark Blue(1)

Fluorescent Red Orange(1)

Translucent(1)

Light Green(1)

Light Orange(1)

Multicolor(1)

Dark Orange(1)

Dark Green(1)

Lavender(1)

Light Blue(1)

 
Recycled

No(287)

Yes(12)

 
Packaged Quantity

500 / Roll(19)

250 / Roll(14)

250 / Pack(13)

750 / Pack(12)

1000 / Box(11)

100 / Pack(10)

600 / Box(9)

100 / Box(9)

3000 / Box(8)

500 / Pack(8)

2000 / Pack(7)

500 / Box(6)

40 / Pack(6)

150 / Pack(5)

200 / Pack(5)

1 Box(5)

200 / Box(5)

5000 / Box(5)

1500 / Pack(4)

2000 / Box(4)

252 / Pack(4)

1 Roll(4)

80 / Pack(4)

300 / Pack(4)

600 / Pack(4)

1500 / Box(3)

2500 / Box(3)

15000 / Carton(3)

1 / Each(3)

1 Each(3)

350 / Pack(3)

2 / Box(3)

7500 / Box(3)

1000 / Pack(3)

120 / Pack(3)

1000 / Carton(2)

300 / Box(2)

800 / Pack(2)

3000 / Pack(2)

220 / Pack(2)

3 / Pack(2)

3000 / Roll(2)

3500 / Pack(2)

5000 / Roll(2)

4000 / Carton(2)

1400 / Pack(2)

36 / Box(2)

1400 / Box(2)

400 / Box(2)

12000 / Carton(2)

7500 / Pack(2)

7600 / Carton(2)

48 / Pack(1)

3300 / Pack(1)

700 / Pack(1)

400 / Pack(1)

250 / Carton(1)

2500 / Pack(1)

14 / Set(1)

45 / Pack(1)

100 / Roll(1)

175 / Roll(1)

1 / Kit(1)

1 / Box(1)

48 / Box(1)

160 / Pack(1)

2 / Pack(1)

1 / Roll(1)

72 / Box(1)

240 / Pack(1)

4 / Box(1)

72 / Pack(1)

6000 / Box(1)

8000 / Box(1)

8250 / Box(1)

630 / Box(1)

96 / Pack(1)

90 / Pack(1)

504 / Pack(1)

1050 / Pack(1)

60 / Pack(1)

10 / Pack(1)

256 / Pack(1)

32 / Pack(1)

3300 / Box(1)

2100 / Box(1)

25 / Pack(1)

150 / Box(1)

480 / Pack(1)

225 / Pack(1)

8000 / Pack(1)

3000 / Carton(1)

825 / Pack(1)

50 / Box(1)

750 / Box(1)

2400 / Box(1)

700 / Box(1)

3500 / Box(1)

20000 / Box(1)

5000 / Pack(1)

 
Assembly Required

No(1)

 
Limited Warranty

90 Day(8)

 
Weight (Approximate)

4.35 oz(10)

4.37 oz(10)

65 lb(2)

4.10 oz(2)

1.34 oz(1)

9.50 lb(1)

3.05 lb(1)

2.99 lb(1)

6.10 oz(1)

6.60 oz(1)

3.70 oz(1)

 
Compatibility

Avery Quick Peel Automatic Label Peeler

(23)

Industrial Direct Thermal Printers:

  • Zebra
  • Intermec
  • Brady
  • Sato
  • Datamax
(6)

Monarch 1131 Labeler(4)

Seiko SmartLabel Printers:

  • EZ30
  • SLP100
  • SLP120
  • SLP200
  • SLP220
  • SLP240
  • SLP410
  • SLP420
  • SLP430
  • SLP440
  • SLP450

Dymo LabelWriter Printers:

  • 400 Series Printers
  • 450 Series Printers
(3)

Dymo LabelWriter 4XL Label Printer(2)

Avery Quick Peel Automatic Peeler

(2)

Rubbermaid Glutton Recycling Stations:

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

Rubbermaid Untouchable Recycling Tops:

  • 2690
  • 2691
(1)

Seiko Label Printers:

  • 450 Series
  • 440 Series
  • 430 Series
  • 420 Series
  • 200 Series
(1)

Dymo Labelwriter 400 Printer Series

(1)

Monarch Easy-Load Pricemarker

(1)

Seiko 400 series Smart Label Printer

(1)

Monarch 1105/1110 Pricemarker Labelers

(1)

Laser printer(1)

Laser Printers(1)

Banker Box Storage Boxes(1)

Monarch 1115 Pricemarker Labeler

(1)

Monarch 1131 Pricemarker Labeler

(1)

Monarch model 1136 Pricemarker Labelers

(1)

 
Print Technology

Laser(167)

Inkjet(126)

Direct Thermal(17)

Thermal Transfer(3)

 
Mailer/Envelope Length

10"(1)

 
Mailer/Envelope Type

Bubble(1)

 
Mailer/Envelope Width

5"(1)

 
Package Type

Bulk(1)

 
Number of Labels per Roll

500(16)

250(11)

2500(6)

3000(2)

220(2)

5000(2)

260(2)

1750(1)

1063(1)

100(1)

1000(1)

130(1)

3(1)

 
Number of Labels per Sheet

30(31)

10(20)

20(16)

6(14)

80(12)

4(11)

14(10)

2(10)

1(5)

60(4)

33(4)

12(4)

8(3)

9(3)

3(2)

25(2)

50(1)

15(1)

40(1)

32(1)

5(1)

 
Flag/Note Size

1.50" Width x 0.88" Length(1)

 
Core Diameter

3"(5)

25/32"(3)

 
Print/Message

Number(22)

Year(2)

VARIABLES(1)

RESEARCH(1)

PURPOSE(1)

RESULTS(1)

Minor(1)

Thank You(1)

Fragile - Handle with Care(1)

Attention Office Staff: Co-Pay(1)

Collect at Time of Visit(1)

PROCEDURE(1)

PROBLEM(1)

ABSTRACT(1)

APPLICATIONS(1)

7 SUN 7(1)

6 SAT 6(1)

4 THUR 4(1)

CONCLUSION(1)

DATA(1)

MATERIALS(1)

INTRODUCTION(1)

HYPOTHESIS(1)

GRAPH(1)

2 TUES 2(1)

 
Media Diameter

2" Diameter(3)

1 1/2" Diameter(2)

2 1/2" Diameter(2)

1" Diameter(2)

 
Total Number of Labels

12000(2)

72(2)

40(2)

7600(2)

4000(2)

48(1)

300(1)

1500(1)

120(1)

3000(1)

36(1)

 
Manufacturer Part Number

ML-3000B(1)

ML3000(1)

ML-1000B(1)

ML-5000(1)

ML-7850(1)

925030(1)

MSL0100(1)

MS-2448(1)

ML-1000(1)

ML-0600(1)

M83402(1)

M83401(1)

M83400(1)

M83403(1)

ML-0100(1)

ML-0400(1)

ML-0200(1)

925036(1)

925074(1)

7530-01-554-9538(1)

7530-01-514-4911(1)

7530-01-514-4904(1)

7530015789290(1)

7530015789292(1)

7530016471412(1)

7530015789295(1)

7530015789294(1)

7530-01-514-4903(1)

925551(1)

925085(1)

925084(1)

925075(1)

925205A(1)

925207A(1)

925210A(1)

925209A(1)

42-451(1)

0034801(1)

26117(1)

26116(1)

26115(1)

26119(1)

26120(1)

26123(1)

26122(1)

26121(1)

26114(1)

26113(1)

26102(1)

26101(1)

21052CT(1)

26107(1)

26108(1)

26112(1)

26109(1)

26124(1)

26125(1)

98111(1)

98110(1)

98108(1)

150045(1)

2026404(1)

26004(1)

26003(1)

2026405(1)

98107(1)

98106(1)

26137(1)

26132(1)

26131(1)

26151(1)

26160(1)

98105(1)

26161(1)

7530016471413(1)

3764(1)

99593(1)

99592(1)

99591(1)

99594(1)

99595(1)

02940(1)

01730(1)

00488(1)

99590(1)

74993(1)

74988(1)

68320(1)

68319(1)

74989(1)

74990(1)

74992(1)

74991(1)

03550(1)

06420(1)

59534(1)

59533(1)

59531(1)

10951(1)

36100(1)

36600(1)

36400(1)

36200(1)

58094(1)

58092(1)

40562(1)

40561(1)

40560(1)

40566(1)

40570(1)

58091(1)

58090(1)

68318(1)

68314(1)

67372(1)

67371(1)

67370(1)

67373(1)

67374(1)

67377(1)

67376(1)

67375(1)

SLP-SRL(1)

SLP-MRL(1)

11349(1)

39091(1)

1792975(1)

SLP-1RLB(1)

SLP-2RL(1)

SLP-2RLH(1)

SLP-2RLE(1)

67378(1)

67379(1)

67430(1)

67429(1)

67428(1)

67918(1)

67919(1)

68001(1)

67920(1)

67427(1)

67426(1)

67421(1)

67420(1)

67380(1)

67422(1)

67423(1)

67425(1)

67424(1)

21052(1)

21051CT(1)

5196(1)

5195(1)

5168(1)

5260(1)

5261(1)

5332(1)

5267(1)

5262(1)

5167(1)

5165(1)

5160(1)

5155(1)

5126(1)

5161(1)

5162(1)

5164(1)

5163(1)

5351(1)

5352(1)

5663(1)

5662(1)

5661(1)

5664(1)

5667(1)

5735(1)

5697(1)

5692(1)

5660(1)

5630(1)

5363(1)

5360(1)

5353(1)

5366(1)

55160(1)

55164(1)

55163(1)

4135(1)

4134(1)

18163(1)

18160(1)

16154CT(1)

18167(1)

18660(1)

22822(1)

22820(1)

18667(1)

16154(1)

15667(1)

S8048(1)

S1224(1)

S1014(1)

S6424(1)

15661(1)

15664(1)

15663(1)

22825(1)

22827(1)

30606(1)

37160(1)

30604(1)

4130(1)

4131(1)

4133(1)

4132(1)

30603(1)

30601(1)

22830(1)

22829(1)

22828(1)

22831(1)

22845(1)

37129(1)

22856(1)

5912(1)

5960(1)

8253(1)

8250(1)

8195(1)

8254(1)

8366(1)

8462(1)

8461(1)

8460(1)

8167(1)

8162(1)

74435(1)

74434(1)

74433(1)

74436(1)

8066(1)

8161(1)

8160(1)

8463(1)

8464(1)

75511(1)

75510(1)

75444(1)

75512(1)

75513(1)

21051(1)

21050CT(1)

21050(1)

75442(1)

75441(1)

8662(1)

8660(1)

8465(1)

8663(1)

8667(1)

75440(1)

8692(1)

74432(1)

74431(1)

60518(1)

60517(1)

60506(1)

60527(1)

61501(1)

61504(1)

61503(1)

61502(1)

60505(1)

60504(1)

5963(1)

5962(1)

5961(1)

5967(1)

60501(1)

60503(1)

60502(1)

61505(1)

61506(1)

6521(1)

6520(1)

6467(1)

6522(1)

6570(1)

6878(1)

6572(1)

6465(1)

6464(1)

61522(1)

61521(1)

61507(1)

61531(1)

61532(1)

6460(1)

61533(1)

5247(1)

 
Country of Origin

United States(300)

 
Material

Paper(14)

Polyester(14)

Polyester Film(8)

Tyvek(7)

Plastic(2)

Poly(1)

Kraft(1)

Cardboard(1)

Polyvinyl Chloride (PVC)(1)

 
Height

9.3"(1)

 
Width

3.3"(1)

 
Sheet Size

6" x 4"(3)

7" x 4 1/4"(1)

6 13/16" x 4 3/4"(1)

1"(1)

 
Shape

Rectangle(197)

Circle(10)

Oval(4)

Square(4)

Round(3)

 
Number of Sheets

100(10)

25(7)

250(6)

50(4)

500(2)

10(1)

 
Closure Type

Self-sealing(1)

 
Adhesive Type

Permanent(142)

Removable(24)

Self-adhesive(1)

 
 
 

© 2019-2020 Dawkins Office Supply, All Rights Reserved