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(226)

Smead(45)

Universal(34)

Monarch(4)

Garvey(3)

PM Company(2)

Southworth(2)

Quality Park(1)

Innovera(1)

Geographics(1)

 
Manufacturer Part Number

05204(2)

91201(1)

8667(1)

95520(1)

8665(1)

95523(1)

95905(1)

95900(1)

95526(1)

8663(1)

8465(1)

8460(1)

8425(1)

8366(1)

8461(1)

8462(1)

95910(1)

8464(1)

8463(1)

8662(1)

95920(1)

925084(1)

925075(1)

925074(1)

925085(1)

05203(1)

66006(1)

66004(1)

46910(1)

6209(1)

20014(1)

95935(1)

95930(1)

8293(1)

95940(1)

95945(1)

090949(1)

090947(1)

090944(1)

95915(1)

8254(1)

6466(1)

6465(1)

6464(1)

6467(1)

6481(1)

6576(1)

6575(1)

6482(1)

6460(1)

6450(1)

60526(1)

60525(1)

60524(1)

61521(1)

61522(1)

61533(1)

61532(1)

61531(1)

6577(1)

6578(1)

8165(1)

8164(1)

8162(1)

8168(1)

8195(1)

67070(1)

8253(1)

8250(1)

8161(1)

8126(1)

6871(1)

6582(1)

6579(1)

6873(1)

6874(1)

6879(1)

6878(1)

6876(1)

8255(1)

67071(1)

598342(1)

50113(1)

50110(1)

60101(1)

70103(1)

70112(1)

70109(1)

70104(1)

40115(1)

40114(1)

99293(1)

67450(1)

67430(1)

99294(1)

308383(1)

40108(1)

40103(1)

37103(1)

70114(1)

70116(1)

81102(1)

81101(1)

80206(1)

81105(1)

81106(1)

90108(1)

90107(1)

90102(1)

80120(1)

80111(1)

80002(1)

80001(1)

75114(1)

80003(1)

80004(1)

80108(1)

80106(1)

80011(1)

67380(1)

67379(1)

67084(1)

67083(1)

67082(1)

67085(1)

67086(1)

67089(1)

67088(1)

67087(1)

67081(1)

67080(1)

67074(1)

67073(1)

67072(1)

67075(1)

67076(1)

67079(1)

67078(1)

67077(1)

67090(1)

67091(1)

67373(1)

67372(1)

67371(1)

67374(1)

67375(1)

67378(1)

67377(1)

67376(1)

67370(1)

67170(1)

67094(1)

67093(1)

67092(1)

67095(1)

67096(1)

67150(1)

67097(1)

60523(1)

60521(1)

22805(1)

22804(1)

2181(1)

22806(1)

22807(1)

22822(1)

22820(1)

22808(1)

18695(1)

18661(1)

05795(1)

05793(1)

05791(1)

05868(1)

15660(1)

18660(1)

15695(1)

15667(1)

22825(1)

22827(1)

4027(1)

4022(1)

4014(1)

4065(1)

4076(1)

4156(1)

4155(1)

4153(1)

4013(1)

27902(1)

22836(1)

22830(1)

22828(1)

22837(1)

22845(1)

27901(1)

27900(1)

22856(1)

05790(1)

05499(1)

05424(1)

05422(1)

05410(1)

05428(1)

05430(1)

05450(1)

05444(1)

05436(1)

05408(1)

05247(1)

00757(1)

00756(1)

00755(1)

05050(1)

05051(1)

05215(1)

05062(1)

05052(1)

05453(1)

05454(1)

05473(1)

05472(1)

05471(1)

05476(1)

05477(1)

05498(1)

05497(1)

05496(1)

05470(1)

05469(1)

05462(1)

05461(1)

05459(1)

05463(1)

05465(1)

05468(1)

05467(1)

05466(1)

4157(1)

4221(1)

5948(1)

5946(1)

5940(1)

5952(1)

5956(1)

5966(1)

5964(1)

5962(1)

5936(1)

5935(1)

5666(1)

5664(1)

5663(1)

5667(1)

5766(1)

5912(1)

58164(1)

58160(1)

5967(1)

5970(1)

60507(1)

60506(1)

60505(1)

60508(1)

60511(1)

00754(1)

60513(1)

60512(1)

60504(1)

60503(1)

5974(1)

5972(1)

5971(1)

5975(1)

5976(1)

60502(1)

60501(1)

5980(1)

5662(1)

5661(1)

5029(1)

5026(1)

48960(1)

5066(1)

5155(1)

5230(1)

5195(1)

5162(1)

48467(1)

48464(1)

4224(1)

4223(1)

4222(1)

4227(1)

45160(1)

48460(1)

48163(1)

45366(1)

5262(1)

5265(1)

55163(1)

55160(1)

5360(1)

55164(1)

5520(1)

5524(1)

5523(1)

5522(1)

5353(1)

5352(1)

5293(1)

5292(1)

5278(1)

5311(1)

5332(1)

5351(1)

5334(1)

60522(1)

 
Country of Origin

MX(251)

US(57)

CN(8)

IT(3)

 
Material(s)

Paper(237)

Laminated Paper(45)

Polyester(13)

Foil(3)

Foil Paper(1)

 
Shape

Rectangular(242)

Round(45)

Square(4)

Oval(3)

Circular(1)

Round;Starburst(1)

Round Scallop(1)

Burst(1)

 
Tab Cut

01/02/2017(9)

1/3(9)

 
Tab Style

End Tab(43)

Top Tab(18)

End Tab;Top Tab(2)

 
Sheets Per Unit

25(49)

50(46)

100(36)

250(16)

500(15)

10(14)

42(13)

36(9)

40(8)

20(6)

5(6)

8(5)

14(4)

15(3)

300(2)

150(2)

12(2)

220(1)

31(1)

120(1)

2(1)

70(1)

11(1)

4(1)

29(1)

35(1)

 
Rolls Per Unit

1(44)

2(3)

10(2)

3(2)

4(2)

26(1)

16(1)

 
Label Color(s)

White(223)

Clear(23)

Assorted(16)

Neon Green(7)

Matte White(5)

Neon Magenta(4)

Neon Orange(4)

Neon Red(3)

Light Blue(3)

Neon Yellow(3)

Gold(3)

Green(3)

Red(3)

Yellow(2)

Fluorescent Red(2)

Dark Blue(2)

Pearl Ivory(2)

Gold; Silver(1)

Silver(1)

Clear; Red(1)

Orange(1)

Black(1)

Kraft Brown(1)

Pastel Blue(1)

Glossy Clear(1)

 
Label Size - text

1 1/4 x 1(39)

2 x 4(21)

1 x 2 5/8(20)

8 1/2 x 11(19)

3/4" dia.(18)

3 1/3 x 4(13)

2/3 x 3 7/16(10)

1 1/3 x 4(10)

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

1/2 x 1 3/4(9)

2" dia.(5)

3 1/2 x 5(5)

1 1/4" dia.(5)

1 x 2 13/16(5)

1 x 4(5)

2/3 x 1 3/4(5)

4 x 6(4)

1/4" dia.(4)

1/2" dia.(4)

5/8 x 7/8(3)

2 x 2(3)

1" dia.(3)

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

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

2 1/2" dia.(3)

1 x 3(3)

4 x 4(2)

1 3/4" dia.(2)

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

3 7/16 x 2/3(2)

8 1/2 x 14(2)

1 1/2" dia.(2)

7/16 x 13/16(2)

2 15/16 x 5(2)

2 x 4 1/4(2)

7/16 x 7/8(2)

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

15/16 x 3 7/16(2)

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

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

1 7/16 x 4(2)

1 15/16 x 4(2)

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

11/16 x 3 7/16(2)

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

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

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

1 1/32 x 3 1/2(1)

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

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

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

3/4 x 1 1/2(1)

5/8 x 13/16(1)

1 x 3/4(1)

1 x 1 5/8(1)

15/16 x 3 1/2(1)

3 1/2 x 7/16(1)

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

2 15/16 x 4(1)

3 1/2 x 4 1/2(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 x 3 3/4(1)

1 x 1/2(1)

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

3 x 5(1)

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

2 x 2 5/8(1)

1 2/3" dia.(1)

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

2 x 3(1)

2 x 3 1/3(1)

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

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

5 x 7 1/2(1)

7/16 x 3 1/2(1)

2 1/8 x 4(1)

9/16 x 3 7/16(1)

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

3-1/3 x 4(1)

6 x 4(1)

5/8 x 3(1)

15/16 x 4(1)

5 x 8 1/8(1)

1 5/8" dia.(1)

2/3 x 1 3/4(1)

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

3 x 4(1)

5 x 3(1)

3/4 x 1 3/4(1)

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

2 x 3 3/4(1)

 
Labels Per Unit

500(54)

1008(17)

100(15)

5000(14)

1000(14)

600(13)

200(13)

750(12)

300(11)

1500(9)

3000(8)

250(8)

450(7)

400(6)

120(6)

50(6)

25(5)

840(5)

2000(5)

150(5)

40(4)

2500(4)

3500(4)

350(3)

15(3)

1400(3)

7500(3)

90(3)

80(3)

252(3)

8000(2)

3300(2)

700(2)

240(2)

72(2)

20(2)

1600(2)

20000(1)

248(1)

4000(1)

160(1)

945(1)

15000(1)

3600(1)

19200(1)

13,000(1)

42(1)

1,500(1)

15,000(1)

2,500(1)

5,000(1)

2,200(1)

3,000(1)

60(1)

800(1)

180(1)

225(1)

44(1)

768(1)

1050(1)

504(1)

1015(1)

32(1)

256(1)

2310(1)

8250(1)

16500(1)

6000(1)

880(1)

140(1)

260(1)

220(1)

2100(1)

 
Labels Per Sheet

30(31)

1(29)

10(23)

2(19)

6(16)

24(14)

4(13)

14(11)

20(10)

60(10)

12(10)

8(9)

80(8)

18(6)

33(5)

28(5)

5(5)

3(4)

32(3)

9(3)

7(3)

21(2)

15(2)

25(1)

63(1)

35(1)

192(1)

 
Printed Text Color(s)

Red(5)

Dark Orange(4)

Blue(4)

Lavender(4)

Light Orange(4)

Dark Green(4)

Brown(3)

White(3)

Pink(3)

Violet(3)

Light Green(3)

Assorted(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(147)

4 x 6(49)

8 1/2 x 14(3)

Dispenser(3)

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

4 1/4 x 10(1)

4 x 9(1)

 
Labels Per Roll

500(40)

450(3)

2500(2)

1750(2)

1000(2)

1200(2)

220(2)

250(1)

130(1)

140(1)

 
Printed Text

A-Z(3)

Achievement(2)

Assorted(2)

0-9(2)

N(2)

0(1)

2(1)

Mc(1)

1(1)

X(1)

W(1)

3(1)

Y(1)

Z(1)

6(1)

9(1)

JAN-DEC(1)

FRAGILE Handle with Care(1)

8(1)

7(1)

5(1)

V(1)

4(1)

S(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)

Official Seal of Excellence(1)

T(1)

Q(1)

P(1)

L(1)

M(1)

O(1)

U(1)

 
Labels Across

1(71)

2(23)

3(11)

4(2)

 
Catalog Description

Shipping(22)

White Dissolvable Labels(3)

Teacher & Student Organization(1)

Boxes; Shipping(1)

Gifts; Homemade Goodies(1)

File Folder(1)

 
Design

Achievement(2)

Circular With Inner Pattern(1)

Official Seal of Excellence(1)

 
Finish

Matte(8)

Glossy(8)

Laminated(4)

TrueBlock Technology(3)

Pearl(2)

 
Adhesive

Permanent(173)

Permanent Self-Adhesive(79)

Removable(48)

Removable Self-Adhesive(7)

Self-Adhesive(6)

Pressure-Sensitive(2)

 
Border Color(s)

Assorted(11)

Blue(5)

Red(5)

Lavender(4)

Dark Green(4)

Dark Orange(4)

Light Orange(4)

Brown(3)

Pink(3)

Violet(3)

Light Green(3)

Purple(3)

Yellow(1)

 
 
 

© 2018-2019 Gateway Business Products, All Rights Reserved