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

Currently Filtered by

Category

Mailing And Address Labels

Refine Search

  GO
 
Brand

Avery®(171)

Business Source(30)

Dymo(29)

Maco(10)

SKILCRAFT(9)

PRES-a-ply(6)

Seiko(5)

Tatco(5)

Brother(2)

Elite Image(2)

Bankers Box(1)

Simon(1)

 
Color

White(197)

Clear(40)

Neon Green(10)

Neon Magenta(9)

Neon Yellow(7)

Bright White(6)

Assorted(2)

Neon(1)

Magenta(1)

Green(1)

Yellow(1)

Blue(1)

Silver(1)

Red(1)

Translucent(1)

 
Recycled

No(248)

Yes(18)

 
Packaged Quantity

750 / Pack(14)

1000 / Box(13)

100 / Box(11)

300 / Pack(10)

500 / Box(9)

100 / Pack(9)

500 / Pack(7)

600 / Box(7)

3000 / Box(7)

250 / Pack(7)

200 / Pack(6)

150 / Pack(6)

600 / Pack(6)

220 / Pack(6)

2000 / Pack(6)

7500 / Box(5)

1500 / Pack(5)

50 / Pack(5)

200 / Box(5)

2000 / Box(4)

15000 / Carton(4)

2500 / Box(4)

5000 / Box(4)

350 / Pack(4)

25 / Pack(3)

1 Each(3)

1000 / Pack(3)

1 / Each(3)

1000 Label(3)

20 / Pack(3)

5000 / Roll(2)

450 / Pack(2)

1000 / Carton(2)

3000 / Carton(2)

1 Box(2)

1400 / Pack(2)

260 / Box(2)

130 / Pack(2)

2 Roll(2)

700 / Box(2)

3000 / Pack(2)

7500 / Pack(2)

300 / Box(2)

1500 / Box(2)

3000 / Roll(2)

800 / Pack(2)

700 / Pack(2)

1400 / Box(2)

400 / Box(2)

250 / Box(2)

10 / Pack(2)

8000 / Box(2)

60 / Pack(2)

140 / Pack(2)

700 / Each(1)

48 / Pack(1)

80 / Pack(1)

12 Roll(1)

400 / Pack(1)

5 Roll(1)

1 / Box(1)

250 / Roll(1)

500 / Roll(1)

220 / Box(1)

880 / Box(1)

3300 / Pack(1)

480 / Pack(1)

6 Roll(1)

750 / Box(1)

2500 / Pack(1)

15000 / Box(1)

2400 / Box(1)

3500 / Box(1)

2100 / Box(1)

20000 / Box(1)

15 / Pack(1)

3300 / Box(1)

120 / Pack(1)

7000 / Box(1)

6000 / Box(1)

8250 / Box(1)

2310 / Box(1)

5000 / Carton(1)

240 / Pack(1)

1200 / Box(1)

1 / Roll(1)

8000 / Pack(1)

5000 / Pack(1)

3500 / Pack(1)

 
Weight (Approximate)

4.64 oz(1)

4.80 oz(1)

12.80 oz(1)

3.20 oz(1)

6.10 oz(1)

6.60 oz(1)

 
Compatibility

Avery Quick Peel Automatic Label Peeler

(23)

Dymo LabelWriter 4XL Label Printer(3)

  • Dymo LabelWriter 450 Series
(3)

Dymo LabelWriter Label Printers:

  • 4XL
  • 450
  • 450 Duo
  • 450 Turbo
  • 450 Twin Turbo
  • Se450
(3)

Seiko SmartLabel Printers:

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

Dymo LabelWriter Printers:

  • 400 Series Printers
  • 450 Series Printers
(2)

La Poste TpMaC Franking Machine(1)

Seiko Label Printers:

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

Seiko 400 series Smart Label Printer

(1)

Banker Box Storage Boxes(1)

Laser printer(1)

Laser Printers(1)

DYMO LabelWriter Printers:

  • EL40
  • EL60
  • Dymo LabelWriter 450 Series

CoStar LabelWriter XL Printers:

  • 300
  • 310

Turbo and CoStar LabelWriter XL Plus Printers:

  • Turbo
  • 320
  • 330
  • 330 Turbo
  • 400
  • 400 Turbo
  • Twin Turbo
  • Duo
  • Seiko SLP 120
  • 240
  • Pro
  • EZ30
(1)

Dymo LabelWriters:

  • 400 series
  • 300 series (excluding models 310 & 315)
  • Dymo LabelWriter 450 Series
(1)

  • Suit Dymo & CoStar printers
  • Dymo LabelWriter 450 Series
(1)

DYMO LabelWriter Printers:

  • EL40
  • EL60
  • Dymo LabelWriter 450 Series

CoStar LabelWriter XL Printers:

  • 300
  • 310

Turbo and CoStar LabelWriter XL Plus Printers:

  • Turbo
  • 320
  • 330
  • 330 Turbo
  • 400
  • 400 Turbo
  • Twin Turbo
  • Duo
  • Seiko SLP240
  • SLP Pro
(1)

DYMO LabelWriter Printers:

  • EL40
  • EL60
  • Dymo LabelWriter 450 Series

CoStar LabelWriter XL Printers:

  • 300
  • 310

Turbo and CoStar LabelWriter XL Plus Printers:

  • Turbo
  • 320
  • 330
  • 330 Turbo
  • 400
  • 400 Turbo
  • Twin Turbo
  • Duo
(1)

Dymo LabelWriter Printers:

  • EL40
  • EL60
  • CoStar XL
  • 300
  • 310
  • Turbo XL Plus
  • CoStar XL Plus
  • Turbo
  • 320
  • 330
  • 330 Turbo
  • 400
  • 400 Turbo
  • Twin Turbo
  • DuoTurbo

Seiko Printers:

  • SLP 120
  • SLP 240
  • SLP Pro
  • SLP EZ30
  • SLP Plus
(1)

DYMO LabelWriter Label Printers:

  • 4XL
  • 450
  • 450 Duo
  • 450 Turbo
  • 450 Twin Turbo
  • Se450
(1)

Dymo LabelWriter 4XL Label Printer

(1)

Rhino Label Printers:

  • 3000
  • 5000
  • 6000
  • 6500
(1)

Brother Label Printers:

  • QL-1050
  • QL-1050N
  • QL-1060N
  • QL-1100
  • QL-1110NWB
(1)

Brother P-touch Label Printers:

  • QL-500
  • QL-550
  • QL-570
  • QL-650TD
  • QL-1050
  • QL-1060N
(1)

  • Dymo LabelWriter 4XL Label Printer
  • Zebra GX420d Printer
(1)

Dymo Labelwriter 400 Printer Series

(1)

 
Print Technology

Laser(178)

Inkjet(129)

Direct Thermal(19)

Thermal(2)

Thermal Transfer(2)

 
Package Type

Bulk(6)

 
Number of Labels per Roll

130(4)

220(3)

260(2)

5000(2)

3000(2)

80(1)

180(1)

250(1)

350(1)

700(1)

300(1)

520(1)

1000(1)

500(1)

 
Number of Labels per Sheet

30(41)

10(30)

6(22)

1(21)

2(16)

14(12)

80(11)

20(10)

4(5)

60(4)

33(4)

12(1)

5(1)

100(1)

8(1)

18(1)

25(1)

50(1)

 
Core Diameter

3"(5)

25/32"(2)

 
Print/Message

Fragile - Handle with Care(1)

Thank You(1)

 
Media Diameter

1 1/2" Diameter(3)

1" Diameter(2)

 
Total Number of Labels

500(3)

20(1)

100(1)

250(1)

300(1)

50(1)

2500(1)

 
Manufacturer Part Number

04182(1)

26108(1)

95920(1)

95930(1)

95935(1)

95940(1)

95945(1)

DK1201BX(1)

DK1247(1)

21050(1)

21050CT(1)

21051(1)

21051CT(1)

21052(1)

21052CT(1)

26107(1)

26109(1)

95910(1)

26112(1)

26113(1)

26114(1)

26115(1)

26116(1)

26117(1)

26119(1)

26120(1)

26121(1)

26122(1)

26123(1)

26124(1)

26125(1)

26131(1)

95915(1)

95905(1)

26160(1)

8462(1)

8163(1)

8164(1)

8165(1)

8167(1)

8168(1)

8195(1)

8217(1)

8250(1)

8253(1)

8254(1)

8255(1)

8257(1)

8460(1)

8461(1)

8463(1)

95900(1)

8464(1)

8465(1)

8660(1)

8662(1)

8663(1)

8665(1)

8667(1)

8986(1)

91200(1)

91201(1)

95520(1)

95522(1)

95523(1)

95526(1)

26132(1)

26161(1)

8161(1)

7530015789290(1)

0034801(1)

ML-0100(1)

ML-0200(1)

ML-0400(1)

ML-0600(1)

ML-1000(1)

ML-1000B(1)

ML3000(1)

ML-3000B(1)

ML-5000(1)

MSL0100(1)

7530-01-514-4903(1)

7530-01-514-4904(1)

7530-01-514-4911(1)

7530015789292(1)

26003(1)

7530015789294(1)

7530015789295(1)

7530016471412(1)

7530016471413(1)

11349(1)

SLP-1RLB(1)

SLP-2RL(1)

SLP-2RLE(1)

SLP-2RLH(1)

SLP-SRL(1)

10951(1)

36100(1)

36200(1)

36400(1)

26004(1)

30573(1)

98107(1)

2050770(1)

98108(1)

98110(1)

98111(1)

1734523(1)

1744907(1)

1763982(1)

2011999(1)

2026404(1)

2026405(1)

2050764(1)

2050765(1)

2050766(1)

2050768(1)

2050769(1)

2050811(1)

30327(1)

2050812(1)

2050813(1)

2050814(1)

2050816(1)

2050817(1)

2050818(1)

2050829(1)

30251(1)

30252(1)

30253(1)

30254(1)

30256(1)

30321(1)

30323(1)

8162(1)

8160(1)

04183(1)

5160(1)

30606(1)

4157(1)

45160(1)

48160(1)

48163(1)

48263(1)

48266(1)

48460(1)

48464(1)

48467(1)

48960(1)

5126(1)

5127(1)

5155(1)

5161(1)

30604(1)

5162(1)

5163(1)

5164(1)

5165(1)

5167(1)

5168(1)

5195(1)

5260(1)

5261(1)

5262(1)

5263(1)

5264(1)

AVE 5265(1)

5267(1)

37160(1)

30603(1)

5292(1)

18160(1)

5247(1)

5248(1)

11821(1)

11822(1)

11823(1)

11824(1)

15516(1)

15660(1)

15661(1)

15662(1)

15663(1)

15664(1)

15667(1)

15695(1)

18163(1)

30601(1)

18167(1)

18660(1)

18661(1)

18662(1)

18663(1)

18664(1)

18665(1)

18667(1)

2160(1)

2163(1)

27900(1)

27901(1)

27902(1)

37129(1)

5278(1)

5311(1)

8126(1)

5980(1)

5960(1)

5961(1)

5962(1)

5963(1)

5964(1)

5967(1)

5970(1)

5971(1)

5972(1)

5974(1)

5975(1)

5976(1)

5978(1)

5979(1)

6520(1)

5954(1)

6521(1)

6522(1)

6524(1)

6526(1)

6528(1)

6529(1)

6530(1)

6870(1)

6871(1)

6873(1)

6874(1)

6876(1)

6878(1)

6879(1)

5956(1)

5952(1)

5332(1)

5660(1)

5351(1)

5352(1)

5353(1)

5360(1)

5363(1)

55160(1)

55163(1)

55164(1)

5520(1)

5522(1)

5523(1)

5524(1)

5526(1)

5630(1)

5661(1)

5948(1)

5662(1)

5663(1)

5664(1)

5667(1)

58160(1)

58163(1)

58164(1)

5912(1)

5934(1)

5935(1)

5936(1)

5940(1)

5944(1)

5946(1)

36600(1)

 
Country of Origin

United States(139)

Mexico(124)

China(2)

Vietnam(1)

Belgium(1)

 
Material

Paper(35)

Polyester(11)

Plastic(2)

Polypropylene(1)

Polyvinyl Chloride (PVC)(1)

 
Height

3.3"(1)

 
Width

9.3"(1)

 
Depth

0.1"(1)

 
Sheet Size

1"(2)

 
Shape

Rectangle(242)

Circle(4)

Square(1)

 
Number of Sheets

100(10)

250(6)

10(2)

25(2)

500(2)

 
Adhesive Type

Permanent(181)

Removable(5)

 
 
 

© 2020-2021 Browns Office Centre, All Rights Reserved