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_id` IN ('341')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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(303)

Smead(96)

Universal(35)

PRES-a-ply(19)

Tabbies(14)

Garvey(4)

MACO(4)

Monarch(4)

Brother P-Touch(2)

Geographics(2)

Innovera(2)

Southworth(2)

Iconex(1)

Headline Sign(1)

 
Manufacturer Part Number

05050(1)

95945(1)

ML0100(1)

IJ300T(1)

6209(1)

94180303(1)

45204(1)

20014(1)

090951(1)

090949(1)

090947(1)

090944(1)

PTP300BTBU(1)

PTP300BT(1)

95940(1)

ML-1000B(1)

95935(1)

95930(1)

95920(1)

95915(1)

95910(1)

95905(1)

95900(1)

95526(1)

95523(1)

95520(1)

91201(1)

8667(1)

ML-0200(1)

ML-3000(1)

8663(1)

67079(1)

67091(1)

67090(1)

67089(1)

67088(1)

67087(1)

67086(1)

67085(1)

67084(1)

67083(1)

67082(1)

67081(1)

67080(1)

67078(1)

925074(1)

67077(1)

67076(1)

67075(1)

67074(1)

67073(1)

67072(1)

67071(1)

67070(1)

66006(1)

66004(1)

925085(1)

925084(1)

925075(1)

8665(1)

8662(1)

67093(1)

6526(1)

6870(1)

6582(1)

6579(1)

6578(1)

6577(1)

6576(1)

6575(1)

6572(1)

6570(1)

6530(1)

6529(1)

6528(1)

6524(1)

6873(1)

6522(1)

6521(1)

6520(1)

6482(1)

6481(1)

6479(1)

6467(1)

6466(1)

6465(1)

6464(1)

6460(1)

6450(1)

6871(1)

6874(1)

8660(1)

8250(1)

8465(1)

8464(1)

8463(1)

8462(1)

8461(1)

8460(1)

8425(1)

8366(1)

8293(1)

8255(1)

8254(1)

8253(1)

8195(1)

6876(1)

8168(1)

8167(1)

8165(1)

8164(1)

8163(1)

8162(1)

8161(1)

8160(1)

8126(1)

8066(1)

75366(1)

6879(1)

6878(1)

67092(1)

67094(1)

61532(1)

40560(1)

40108(1)

40103(1)

37103(1)

308383(1)

68815(1)

68809(1)

68807(1)

68805(1)

68801(1)

40570(1)

40562(1)

40561(1)

14541(1)

40115(1)

01730(1)

01510(1)

01350(1)

00488(1)

99294(1)

99293(1)

68321(1)

68320(1)

68318(1)

68315(1)

68001(1)

67921(1)

40114(1)

50110(1)

67915(1)

80106(1)

90108(1)

90107(1)

90102(1)

81105(1)

81102(1)

81101(1)

80206(1)

80120(1)

80111(1)

80109(1)

80108(1)

80107(1)

80104(1)

50113(1)

80102(1)

80101(1)

80011(1)

80004(1)

80003(1)

80002(1)

80001(1)

75114(1)

70112(1)

70104(1)

70103(1)

60101(1)

598342(1)

67920(1)

67450(1)

67095(1)

67170(1)

67185(1)

67183(1)

67182(1)

67181(1)

67180(1)

67179(1)

67178(1)

67176(1)

67175(1)

67173(1)

67172(1)

67171(1)

67164(1)

67187(1)

67163(1)

67161(1)

67160(1)

67159(1)

67158(1)

67157(1)

67155(1)

67154(1)

67153(1)

67152(1)

67150(1)

67097(1)

67096(1)

67186(1)

67188(1)

67430(1)

67378(1)

67429(1)

67428(1)

67427(1)

67426(1)

67425(1)

67424(1)

67423(1)

67422(1)

67421(1)

67420(1)

67380(1)

67379(1)

67377(1)

67189(1)

67376(1)

67375(1)

67374(1)

67373(1)

67372(1)

67371(1)

67370(1)

67195(1)

67194(1)

67193(1)

67192(1)

67191(1)

67190(1)

61533(1)

61531(1)

05051(1)

27900(1)

30609(1)

30608(1)

30607(1)

30606(1)

30605(1)

30604(1)

30603(1)

30602(1)

30601(1)

30600(1)

30583(1)

30400(1)

22877(1)

30617(1)

22856(1)

22845(1)

22837(1)

22835(1)

22830(1)

22828(1)

22827(1)

22825(1)

22822(1)

22820(1)

22808(1)

22807(1)

30610(1)

30620(1)

22805(1)

4221(1)

48266(1)

48263(1)

48163(1)

45366(1)

45160(1)

4332(1)

4331(1)

4330(1)

4227(1)

4224(1)

4223(1)

4222(1)

4157(1)

30632(1)

4156(1)

4155(1)

4153(1)

4150(1)

4076(1)

4065(1)

4027(1)

4022(1)

4014(1)

4013(1)

30721(1)

30720(1)

30641(1)

22806(1)

22804(1)

48464(1)

05408(1)

05454(1)

05453(1)

05450(1)

05444(1)

05436(1)

05434(1)

05430(1)

05428(1)

05424(1)

05422(1)

05418(1)

05410(1)

05289(1)

05461(1)

05288(1)

05248(1)

05247(1)

05215(1)

05209(1)

05204(1)

05203(1)

05202(1)

05201(1)

05200(1)

05062(1)

05052(1)

05459(1)

05462(1)

22801(1)

05499(1)

2181(1)

18660(1)

18163(1)

15695(1)

15667(1)

15660(1)

05868(1)

05796(1)

05795(1)

05793(1)

05791(1)

05790(1)

05498(1)

05463(1)

05497(1)

05496(1)

05477(1)

05476(1)

05473(1)

05472(1)

05471(1)

05470(1)

05469(1)

05468(1)

05467(1)

05466(1)

05465(1)

48460(1)

48467(1)

61530(1)

5979(1)

60522(1)

60521(1)

60519(1)

60518(1)

60517(1)

60506(1)

60505(1)

60504(1)

60503(1)

60502(1)

60501(1)

5980(1)

5978(1)

60524(1)

5976(1)

5975(1)

5974(1)

5972(1)

5971(1)

5970(1)

5967(1)

5966(1)

5963(1)

5962(1)

5961(1)

5960(1)

60523(1)

60525(1)

5912(1)

61511(1)

61529(1)

61528(1)

61527(1)

61526(1)

61525(1)

61523(1)

61522(1)

61521(1)

61520(1)

61515(1)

61514(1)

61513(1)

61503(1)

60526(1)

61502(1)

61501(1)

60539(1)

60538(1)

60537(1)

60536(1)

60535(1)

60534(1)

60531(1)

60530(1)

60529(1)

60528(1)

60527(1)

5952(1)

5866(1)

48960(1)

5167(1)

5278(1)

5267(1)

5266(1)

5265(1)

5264(1)

5263(1)

5262(1)

5261(1)

5260(1)

5230(1)

5195(1)

5168(1)

5166(1)

5293(1)

5165(1)

5164(1)

5163(1)

5162(1)

5161(1)

5160(1)

5155(1)

5127(1)

5126(1)

5066(1)

5029(1)

5027(1)

5026(1)

5292(1)

5294(1)

58164(1)

5524(1)

58163(1)

58160(1)

5766(1)

5667(1)

5666(1)

5664(1)

5663(1)

5662(1)

5661(1)

5660(1)

5630(1)

5526(1)

5523(1)

5311(1)

5522(1)

5520(1)

55164(1)

55163(1)

55160(1)

5407(1)

5366(1)

5363(1)

5360(1)

5353(1)

5352(1)

5351(1)

5332(1)

4459(1)

 
Country of Origin

MX(280)

US(187)

CN(13)

DE(5)

IT(4)

 
Material(s)

Paper(319)

Laminated Paper(108)

Polyester(38)

Tyvek(5)

Foil(4)

Foil/Paper(1)

Paper/Poly Laminate(1)

 
Shape

Rectangular(419)

Round(55)

Square(8)

Oval(3)

Burst(1)

Round Burst(1)

 
For Use With

Select DYMO, Seiko, Zebra, Pitney Bowes label printers(4)

Garvey 22-6, 22-7, 22-8(2)

Garvey 22-66, 22-77, 22-88(2)

Monarch 1131(2)

Monarch 1136(2)

Southworth CT1R, CT3R, CT5R, CTP1V, CTP1W, CTP2V, CTP2W, 98866, 98867, 98868, 98869, PF8, PF18, PF6(2)

Pitney Bowes 5675, DM3;Touchmatic 5705, 5640, 4150, 5830(1)

Pitney Bowes Personal Post Office E700(1)

Select DYMO, Seiko, Zebra, Pitney Bowes label printers.(1)

Neopost Friden 9000, 9020, 9030;Pitney Bowes 5500, 5675, 5700, 5800, 5830, 6200, 6900, 8700, E600, E700(1)

Pitney Bowes DM100i, DM200L, E700, E707, K700, Mailstation, P700(1)

Neopost IJ35, IJ40, IJ45, IJ50, IJ60, IJ65, IJ70, IJ75, IJ80, IJ85, IJ90, IJ110, IJ15K, SM75, SM85, SM95(1)

Pitney Bowes Models 5675, DM3; Touchmatic Models 5705, 5640, 4150, 5830(1)

 
Tab Cut

1/3-Cut(31)

 
Tab Style

End Tab(60)

End Tab; Top Tab(32)

Top Tab(31)

End Tab;Top Tab(3)

 
Sheets Per Unit

25(78)

100(54)

50(53)

10(48)

8(25)

250(23)

20(17)

36(14)

42(13)

15(11)

40(9)

500(8)

12(8)

5(7)

14(4)

1(3)

4(2)

300(2)

150(2)

11(1)

125(1)

9(1)

120(1)

220(1)

3(1)

32(1)

60(1)

30(1)

70(1)

28(1)

35(1)

29(1)

31(1)

 
Rolls Per Unit

1(67)

2(4)

3(3)

4(2)

10(2)

16(1)

26(1)

 
Label Color(s)

White(321)

Clear(27)

Assorted(18)

Light Blue(7)

Yellow(7)

Neon Green(6)

Fluorescent Red(6)

Red(6)

Dark Blue(5)

Matte White(4)

Pink(4)

Silver(4)

Gold(4)

Orange(4)

Green(4)

Neon Orange(4)

Neon Yellow(3)

Glossy White(3)

Glossy Clear(3)

Black(3)

Neon Red(3)

Purple(3)

Dark Green(2)

Brown(2)

Gray(2)

Lavender(2)

Light Brown(2)

Dark Brown(2)

Red/White(2)

Neon Magenta(2)

Dark Blue/White(2)

Orange/White(1)

Red/Clear(1)

Green/White(1)

Yellow/White(1)

Blue(1)

Teal(1)

Kraft Brown(1)

Pearl Ivory(1)

Light Green(1)

Pastel Blue(1)

Gray/White(1)

Metallic Silver(1)

Dark Green/White(1)

Light Blue/White(1)

Light Green/White(1)

Lavender/White(1)

White/Yellow(1)

Pink/White(1)

Dark Brown/White(1)

White/Green(1)

 
Label Size - text

1 x 2.63(40)

1 x 1.25(39)

2 x 4(34)

1 x 1.63(20)

0.66 x 3.44(20)

0.75" dia.(20)

8.5 x 11(20)

3.33 x 4(16)

0.5 x 1.75(14)

1.5 x 1.5(12)

1.33 x 4(12)

1.16 x 3.63(11)

5.5 x 8.5(10)

1 x 4(10)

0.75 x 1.5(8)

3.5 x 5(8)

1.25" dia.(7)

0.66 x 1.75(7)

0.5 x 1(7)

0.69 x 3.44(7)

2" dia.(6)

2 x 3.75(5)

4 x 6(5)

0.25" dia.(5)

9.63 x 2(5)

1 x 2.81(5)

2 x 2(5)

1.25 x 2.75(4)

0.5" dia.(4)

0.44 x 0.81(4)

2.5" dia.(4)

1" dia.(4)

1 x 3(4)

0.94 x 3.5(3)

0.94 x 3.44(3)

4.75 x 7.75(3)

1.44 x 4(3)

2 x 2.63(3)

0.63 x 0.88(3)

1 x 1 5/8(3)

0.75 x 2(3)

1.25 x 1.75(3)

1.75" dia.(2)

3.5 x 5.25(2)

1.5 x 7.5(2)

1 x 2.5(2)

4 x 4(2)

0.44 x 0.88(2)

2 x 4.25(2)

1.5" dia.(2)

0.88 x 1.5(2)

1.66" dia.(2)

1.25 x 2.38(2)

0.56 x 3.44(2)

2.94 x 5(2)

1.5 x 2.5(2)

0.44 x 3.5(2)

5.06 x 7.63(2)

3 x 5(2)

1 x 1.5(1)

2 x 3(1)

4 x 5.5; 1.75 x 5.5(1)

2 x 3.33(1)

1.75 x 5(1)

3 x 4(1)

1.16 x 3.13(1)

1.63 x 10.13(1)

1 x 0.75(1)

1 x 0.5(1)

3.75 x 4.75(1)

1.5 x 0.75(1)

0.5 x 0.75(1)

2.5 x 4(1)

1.78 x 6(1)

1.75 x 3.25(1)

1 x 5.5(1)

1.5 x 2.75(1)

2.75 x 1.5; 5.5 x 1.5(1)

1.25 x 3.75(1)

1.63" dia.(1)

3 x 3.75(1)

0.88 x 2.63(1)

2.13 x 4(1)

1.13 x 3.5(1)

1.5 x 2.81(1)

1.38 x 2.81(1)

0.94 x 4(1)

1.94 x 4(1)

9.75 x 1.25(1)

3.25 x 7.75(1)

3.5 x 4.75(1)

1.63 x 3.63(1)

0.75 x 2.25(1)

2 x 3.5(1)

5 x 7(1)

8 x 8(1)

7 x 10(1)

0.75 x 1.75(1)

1.25 x 3.5(1)

3.25 x 8.38(1)

0.63 x 3(1)

5 x 8.13(1)

5.25 x 6; 0.88 x 6(1)

 
Operating System Compatibility

Android; iOS(2)

 
Labels Per Unit

500(57)

100(52)

250(29)

750(24)

1,008(18)

5,000(17)

1,500(17)

600(17)

300(16)

1,000(15)

3,000(14)

200(12)

2,000(11)

450(9)

400(9)

150(8)

252(8)

2,500(8)

240(6)

120(6)

50(6)

48(5)

15(5)

3,500(5)

840(5)

40(5)

320(4)

6(4)

7,500(4)

1,400(4)

25(4)

672(4)

64(4)

112(4)

3,300(3)

480(3)

350(3)

80(3)

8,000(3)

700(2)

225(2)

20(2)

160(2)

60(2)

1,600(2)

15,000(2)

260(2)

800(2)

1,800(1)

4,000(1)

175(1)

2,875(1)

825(1)

30(1)

945(1)

45(1)

2,200(1)

13,000(1)

54(1)

360(1)

19,200(1)

3,600(1)

72(1)

180(1)

2,310(1)

20,000(1)

768(1)

32(1)

256(1)

90(1)

16(1)

5(1)

44(1)

864(1)

1,015(1)

2,400(1)

504(1)

140(1)

220(1)

1,050(1)

10(1)

6,000(1)

8,250(1)

2,100(1)

248(1)

 
Power Source(s)

6 AAA Batteries (Optional, Sold Separately); AC Power Adapter (Included)(2)

 
Tape Type

TZe Series Laminated(2)

 
Labels Per Sheet

30(63)

10(59)

1(28)

4(22)

2(21)

6(18)

24(18)

14(17)

5(17)

20(15)

8(14)

80(14)

12(13)

60(12)

7(8)

18(8)

33(6)

15(5)

28(5)

32(4)

84(4)

40(4)

3(4)

25(4)

9(3)

250(2)

36(1)

216(1)

35(1)

192(1)

21(1)

63(1)

23(1)

 
Printed Text Color(s)

White(43)

Black(8)

Red(6)

Light Orange(4)

Dark Orange(4)

Dark Green(4)

Blue(4)

Lavender(4)

Gold(3)

Brown(3)

Assorted(3)

Violet(3)

Pink(3)

Light Green(3)

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

White/Yellow(1)

Purple(1)

Light Green/White(1)

Lavender/White(1)

Dark Blue/White(1)

Pink/White(1)

Dark Brown/White(1)

Gray/White(1)

Orange/White(1)

Light Blue/White(1)

Dark Green/White(1)

Red/White(1)

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

Silver(1)

 
Sheet (W x L)

8.5 x 11(251)

4 x 6(59)

5.5 x 3.63(2)

6 x 4(1)

4.25 x 10(1)

5 x 7(1)

8 x 8(1)

3.5 x 5(1)

7 x 10(1)

3.5 x 5.25(1)

8.5 X 11(1)

 
Labels Per Roll

500(47)

250(14)

450(3)

1,000(3)

130(2)

220(2)

1,200(2)

2,500(2)

1,750(2)

140(1)

100(1)

175(1)

 
Printed Text

A-Z(3)

9(2)

15(2)

V(2)

0-9(2)

X(2)

Y(2)

Achievement(2)

21(2)

20(2)

1(2)

0(2)

T(2)

2(2)

3(2)

4(2)

5(2)

6(2)

7(2)

8(2)

U(2)

W(2)

S(2)

H(2)

J(2)

K(2)

R(2)

L(2)

F(2)

E(2)

C(2)

B(2)

A(2)

M(2)

Assorted(2)

O(2)

P(2)

Q(2)

I(2)

FRAGILE Handle with Care(1)

CONFIDENTIAL For Authorized Personnel Only(1)

18(1)

JAN-DEC(1)

ALLERGIC TO: PENICILLN, CODEINE, SULFA(1)

PAST DUE Please remit TODAY!(1)

NO KNOWN ALLERGIES(1)

ALLERGIES/DRUG REACTIONS NO KNOWN ALLERGIES(1)

1 to 23; Patient Sign-In/Registro del paciente(1)

ALLERGIES:(1)

ALLERGIC:(1)

ALLERGIC TO:(1)

Official Seal of Excellence(1)

F; S(1)

M; Z(1)

B; O(1)

D(1)

G(1)

N(1)

Z(1)

Mc(1)

A; N(1)

C; P(1)

L; Y(1)

D; Q(1)

Assorted Designs(1)

G; T(1)

H; U(1)

I; V(1)

J; W(1)

Paper, Plastic, Glass, Aluminum(1)

 
Model

PT-P300BT(1)

PT-P300BTBU(1)

 
Labels Across

1(107)

2(32)

3(26)

4(10)

6(4)

5(3)

8(2)

 
Machine Depth

4.6"(2)

 
Machine Height

4.6"(2)

 
Machine Width

2 1/2"(2)

 
Design

Achievement(2)

Official Seal of Excellence(1)

Assorted Embossed(1)

Recycled Symbol(1)

 
Number of Printed Lines

2(2)

 
Connectivity

Bluetooth(2)

 
Maximum Resolution (Dpi)

180 dpi(2)

 
Maximum Tape/Label Width

12 mm(2)

 
Finish

Matte(27)

Gloss(14)

TrueBlock Technology(3)

Pearl(1)

 
Adhesive

Permanent Self-Adhesive(386)

Removable Self-Adhesive(67)

Self-Adhesive(31)

Pressure-Sensitive Self-Adhesive(1)

 
Border Color(s)

Assorted(13)

Red(10)

Pink(7)

Lavender(7)

Dark Green(7)

Purple(6)

Yellow(6)

Blue(6)

Light Green(5)

Brown(5)

Orange(5)

Dark Blue(4)

Dark Orange(4)

Light Orange(4)

Violet(3)

Green(3)

Light Blue(3)

Gray(3)

Dark Brown(3)

Light Brown(2)

Black(2)

Dark Red(1)

Silver(1)

Gold(1)

Teal(1)

 
Memory

30 Labels(2)

 
Tape Size

9 mm - 12 mm(2)

 
Printing Speed

20 mm/second(2)

 
Print Area

2 Lines(2)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved