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

Currently Filtered by

Category

Labels

Refine Search

  GO
 
Brand

Avery(264)

Smead(48)

Universal(38)

Monarch(4)

Garvey(3)

PM Company(2)

Southworth(2)

Quality Park(1)

Innovera(1)

Geographics(1)

 
Manufacturer Part Number

05204(2)

05203(2)

8461(1)

8460(1)

8425(1)

8462(1)

8463(1)

8662(1)

8663(1)

8660(1)

8465(1)

8464(1)

8366(1)

8255(1)

8168(1)

8167(1)

8165(1)

8164(1)

8195(1)

8250(1)

8665(1)

8254(1)

8253(1)

8293(1)

91201(1)

090947(1)

090944(1)

95945(1)

95940(1)

090949(1)

20014(1)

925084(1)

925075(1)

925074(1)

6209(1)

95935(1)

95930(1)

95526(1)

95523(1)

95520(1)

8163(1)

95900(1)

95905(1)

95920(1)

95915(1)

95910(1)

8667(1)

8161(1)

61531(1)

61522(1)

61521(1)

60526(1)

61532(1)

61533(1)

6465(1)

6464(1)

6460(1)

6450(1)

60525(1)

60524(1)

60505(1)

60504(1)

60503(1)

60502(1)

60506(1)

60508(1)

60523(1)

60522(1)

60521(1)

6466(1)

6467(1)

6878(1)

6876(1)

6874(1)

6873(1)

6879(1)

8066(1)

925085(1)

8160(1)

8126(1)

6871(1)

6870(1)

6575(1)

6482(1)

6481(1)

6479(1)

6576(1)

6577(1)

6582(1)

6579(1)

6578(1)

8162(1)

66004(1)

60101(1)

598342(1)

50113(1)

50110(1)

70103(1)

70104(1)

75114(1)

70114(1)

70112(1)

70109(1)

40115(1)

40114(1)

99293(1)

68318(1)

68001(1)

67918(1)

99294(1)

308383(1)

40108(1)

40103(1)

37103(1)

80001(1)

80002(1)

81102(1)

81101(1)

80206(1)

80120(1)

81105(1)

81106(1)

90108(1)

90107(1)

90102(1)

80111(1)

80109(1)

80101(1)

80011(1)

80004(1)

80003(1)

80102(1)

80104(1)

80108(1)

80107(1)

80106(1)

67450(1)

67430(1)

67082(1)

67081(1)

67080(1)

67079(1)

67083(1)

67084(1)

67088(1)

67087(1)

67086(1)

67085(1)

67078(1)

67077(1)

67071(1)

67070(1)

66006(1)

60501(1)

67072(1)

67073(1)

67076(1)

67075(1)

67074(1)

67089(1)

67090(1)

67375(1)

67374(1)

67373(1)

67372(1)

67376(1)

67377(1)

67380(1)

67379(1)

67378(1)

67371(1)

67370(1)

67094(1)

67093(1)

67092(1)

67091(1)

67095(1)

67096(1)

67170(1)

67150(1)

67097(1)

46910(1)

5979(1)

22808(1)

22807(1)

22806(1)

22805(1)

22820(1)

22822(1)

22830(1)

22828(1)

22827(1)

22825(1)

22804(1)

2181(1)

15660(1)

05868(1)

05795(1)

05793(1)

15667(1)

15695(1)

18695(1)

18661(1)

18660(1)

22836(1)

22837(1)

4157(1)

4156(1)

4155(1)

4153(1)

4221(1)

4222(1)

4227(1)

4224(1)

4223(1)

4076(1)

4065(1)

27901(1)

27900(1)

22856(1)

22845(1)

27902(1)

4013(1)

4027(1)

4022(1)

4014(1)

05791(1)

05790(1)

05422(1)

05418(1)

05410(1)

05408(1)

05424(1)

05428(1)

05444(1)

05436(1)

05434(1)

05430(1)

05248(1)

05247(1)

05062(1)

05052(1)

05051(1)

05050(1)

05200(1)

05201(1)

05215(1)

05209(1)

05202(1)

05450(1)

05453(1)

05476(1)

05473(1)

05472(1)

05471(1)

05477(1)

05496(1)

05499(1)

05498(1)

05497(1)

05470(1)

05469(1)

05462(1)

05461(1)

05459(1)

05454(1)

05463(1)

05465(1)

05468(1)

05467(1)

05466(1)

45160(1)

45366(1)

5667(1)

5666(1)

5664(1)

5663(1)

5766(1)

58160(1)

5912(1)

5866(1)

58164(1)

58163(1)

5662(1)

5661(1)

5522(1)

5520(1)

55164(1)

55163(1)

5523(1)

5524(1)

5660(1)

5630(1)

5526(1)

5935(1)

5936(1)

5972(1)

5971(1)

5970(1)

5967(1)

5974(1)

5975(1)

00755(1)

5978(1)

5976(1)

5966(1)

5964(1)

5952(1)

5948(1)

5946(1)

5940(1)

5956(1)

5960(1)

5963(1)

5962(1)

5961(1)

55160(1)

5366(1)

5162(1)

5161(1)

5160(1)

5155(1)

5163(1)

5164(1)

5168(1)

5167(1)

5166(1)

5165(1)

5126(1)

5066(1)

48464(1)

48460(1)

48266(1)

48163(1)

48467(1)

48960(1)

5029(1)

5027(1)

5026(1)

5195(1)

5230(1)

5334(1)

5332(1)

5311(1)

5294(1)

5351(1)

5352(1)

5363(1)

5360(1)

5353(1)

5293(1)

5292(1)

5263(1)

5262(1)

5261(1)

5260(1)

5264(1)

5265(1)

5278(1)

5267(1)

5266(1)

5980(1)

 
Country of Origin

MX(293)

US(60)

CN(8)

IT(3)

 
Material(s)

Paper(278)

Laminated Paper(47)

Polyester(15)

Foil(3)

Paper/Poly Laminate(1)

Foil Paper(1)

 
Shape

Rectangular(285)

Round(50)

Square(4)

Oval(3)

Circular(1)

Round;Starburst(1)

Round Scallop(1)

Burst(1)

 
Tab Cut

1/3(30)

 
Tab Style

End Tab(45)

Top Tab(30)

End Tab;Top Tab(2)

 
Sheets Per Unit

25(65)

50(51)

100(49)

250(19)

10(16)

36(14)

42(13)

500(11)

40(8)

5(7)

20(6)

8(6)

15(5)

14(4)

12(3)

150(2)

300(2)

2(1)

120(1)

31(1)

9(1)

220(1)

70(1)

32(1)

11(1)

4(1)

35(1)

29(1)

28(1)

 
Rolls Per Unit

1(45)

2(3)

10(2)

3(2)

4(2)

26(1)

16(1)

 
Label Color(s)

White(260)

Clear(28)

Assorted(20)

Neon Green(7)

Matte White(5)

Neon Orange(4)

Neon Magenta(4)

Red(4)

Gold(3)

Neon Yellow(3)

Green(3)

Neon Red(3)

Light Blue(3)

Fluorescent Red(2)

Pearl Ivory(2)

Dark Blue(2)

Yellow(2)

Teal(1)

Silver(1)

Clear; Red(1)

Gold; Silver(1)

Glossy Clear(1)

Black(1)

Pastel Blue(1)

Kraft Brown(1)

Orange(1)

 
Label Size - text

1 1/4 x 1(39)

1 x 2 5/8(31)

2 x 4(28)

3/4" dia.(20)

8 1/2 x 11(19)

2/3 x 3 7/16(16)

3 1/3 x 4(15)

1/2 x 1 3/4(12)

5 1/2 x 8 1/2(11)

1 1/3 x 4(10)

1 x 4(9)

11/16 x 3 7/16(7)

3 1/2 x 5(6)

2/3 x 1 3/4(5)

2 1/2" dia.(5)

2" dia.(5)

1 x 2 13/16(5)

1 1/4" dia.(5)

4 x 6(4)

1/4" dia.(4)

1" dia.(4)

1/2" dia.(4)

5 1/16 x 7 5/8(3)

1 x 3(3)

4 3/4 x 7 3/4(3)

2 x 2(3)

15/16 x 3 7/16(3)

5/8 x 7/8(3)

4 x 4(2)

1 15/16 x 4(2)

1 x 1/2(2)

2 15/16 x 5(2)

1 7/16 x 4(2)

1 1/4 x 2 3/8(2)

1 1/4 x 1 3/4(2)

1 1/2 x 2 1/2(2)

1 1/2" dia.(2)

7/16 x 7/8(2)

1 1/2 x 1 1/2(2)

2 x 4 1/4(2)

1 3/4" dia.(2)

7/16 x 13/16(2)

7 1/2 x 1 1/2(2)

3 7/16 x 2/3(2)

3 1/2 x 5 1/4(1)

5/8 x 13/16(1)

3/4 x 2 1/4(1)

2 x 3 3/4(1)

3 x 3 3/4(1)

3 3/4 x 4 3/4(1)

1 1/4 x 3 3/4(1)

3 1/8 x 1 5/32(1)

3 7/16 x 9/16(1)

1 1/2 x 5 1/2 or 1 1/2 x 2 3/4(1)

3 1/2 x 7/16(1)

15/16 x 3 1/2(1)

1 7/16 x 3 1/2(1)

3 x 5(1)

1 1/2 x 3/4(1)

1 1/4 x 1 1/4(1)

4 x 5 1/2 or 1 3/4 x 5 1/2(1)

1 5/8" dia.(1)

1 x 1 5/8(1)

10 1/8 x 1 5/8(1)

1 3/4 x 5 1/2(1)

3-1/3 x 4(1)

15/16 x 3-1/2(1)

9 3/4 x 1 1/4(1)

7/16 x 3 1/2(1)

15/16 x 4(1)

9/16 x 3 7/16(1)

2 1/8 x 4(1)

3 1/2 x 4 3/4(1)

2 x 3(1)

6 x 4(1)

1 x 3/4(1)

3 x 4(1)

5 x 3(1)

2 x 3 1/3(1)

1/2 x 3/4(1)

3 1/2 x 4 1/2(1)

3 1/4 x 8 3/8(1)

1 1/4 x 3 1/2(1)

2/3 x 1 3/4(1)

5/8 x 3(1)

2 x 2 5/8(1)

3/4 x 1 3/4(1)

8 1/2 x 14(1)

1 2/3" dia.(1)

3/4 x 1 1/2(1)

1 x 1 1/2(1)

1 1/2 x 2 13/16(1)

1 3/8 x 2 13/16(1)

5 x 8 1/8(1)

 
Labels Per Unit

500(54)

750(22)

1008(18)

100(17)

1000(15)

200(14)

600(14)

5000(14)

300(12)

1500(12)

250(11)

3000(10)

2000(9)

450(9)

400(8)

252(8)

150(7)

120(6)

50(6)

2500(5)

840(5)

25(4)

40(4)

7500(4)

3500(4)

15(3)

8000(3)

350(3)

1400(3)

90(3)

80(3)

72(3)

1600(2)

3300(2)

700(2)

20(2)

240(2)

800(2)

45(1)

360(1)

3,000(1)

160(1)

945(1)

248(1)

504(1)

4000(1)

15000(1)

2,500(1)

13,000(1)

1,500(1)

2,200(1)

20000(1)

42(1)

15,000(1)

3600(1)

19200(1)

5,000(1)

2100(1)

256(1)

32(1)

225(1)

60(1)

880(1)

140(1)

260(1)

220(1)

180(1)

6000(1)

8250(1)

16500(1)

2400(1)

2310(1)

1050(1)

480(1)

44(1)

768(1)

1015(1)

 
Labels Per Sheet

30(49)

10(30)

1(27)

2(20)

6(18)

24(15)

20(14)

80(13)

4(13)

14(11)

12(11)

60(10)

8(9)

7(8)

18(7)

5(6)

33(5)

28(5)

3(4)

9(4)

15(3)

32(3)

21(2)

25(2)

63(1)

36(1)

35(1)

192(1)

 
Printed Text Color(s)

Red(5)

White(5)

Blue(4)

Lavender(4)

Dark Orange(4)

Dark Green(4)

Light Orange(4)

Pink(3)

Brown(3)

Violet(3)

Assorted(3)

Light Green(3)

Gold(2)

Silver(1)

Blue; Brown; Dark Green; Dark Orange; Lavender; Light Green; Light Orange; Pink; Purple; Red(1)

N(1)

Blue; Dark Green; Dark Orange; Lavender; Light Green; Light Orange; Pink; Red; Violet(1)

Purple(1)

 
Sheet (W x L)

8 1/2 x 11(187)

4 x 6(57)

Dispenser(3)

5 1/2 x 3 5/8(1)

4 x 9(1)

4 1/4 x 10(1)

8 1/2 x 14(1)

 
Labels Per Roll

500(41)

450(3)

2500(2)

1750(2)

1000(2)

1200(2)

220(2)

250(1)

130(1)

140(1)

 
Printed Text

A-Z(3)

18(2)

Achievement(2)

0-9(2)

Assorted(2)

N(2)

0(1)

2(1)

Mc(1)

1(1)

X(1)

W(1)

3(1)

Y(1)

Z(1)

7(1)

9(1)

JAN-DEC(1)

FRAGILE Handle with Care(1)

8(1)

V(1)

5(1)

6(1)

4(1)

T(1)

F(1)

G(1)

H(1)

I(1)

E(1)

D(1)

A(1)

B(1)

C(1)

J(1)

K(1)

R(1)

S(1)

Official Seal of Excellence(1)

Q(1)

P(1)

L(1)

M(1)

O(1)

U(1)

 
Labels Across

1(65)

2(21)

3(13)

8(2)

4(2)

5(1)

 
Catalog Description

Shipping(31)

White Dissolvable Labels(3)

Boxes; Shipping(1)

Teacher & Student Organization(1)

Gifts; Homemade Goodies(1)

Printable Self-Adhesive Permanent 3/4" Round ID Labels(1)

File Folder(1)

White Durable Labels(1)

 
Design

Achievement(2)

Circular With Inner Pattern(1)

Official Seal of Excellence(1)

 
Finish

Matte(9)

Glossy(9)

TrueBlock Technology(3)

Pearl(2)

Laminated(1)

 
Adhesive

Permanent(212)

Permanent Self-Adhesive(85)

Removable(51)

Removable Self-Adhesive(7)

Self-Adhesive(6)

Pressure-Sensitive(2)

 
Border Color(s)

Assorted(12)

Red(6)

Blue(5)

Dark Green(4)

Lavender(4)

Light Orange(4)

Dark Orange(4)

Light Green(3)

Purple(3)

Pink(3)

Violet(3)

Brown(3)

Yellow(2)

Green(2)

Teal(1)

Dark Blue(1)

Dark Red(1)

Orange(1)

 
 
 

© 2018-2019 Legal Name, All Rights Reserved