facebook
 
 
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_name` IN ('Index Cards','Business Cards','Fine Stationery','Greeting Cards','ID Cards','Invitations','Note Cards','Postcards','RSVP Cards','Stationery Envelopes','Tent & Placement Cards','Printed Stationery','Unprinted Stationery')) 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 '%CardsandStationery' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('CardsandStationery' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+CardsandStationery' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"CardsandStationery"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"CardsandStationery"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"CardsandStationery"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"CardsandStationery"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+CardsandStationery' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='CardsandStationery',`category_4` ='CardsandStationery') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'CardsandStationery,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('CardsandStationery', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Cards And Stationery

Refine Search

  GO
 
Brand

Avery®(33)

Southworth(22)

Oxford(19)

Business Source(9)

Pacon(7)

Ashley(6)

Mead(4)

Geographics(4)

St. James®(3)

Hygloss(2)

Classic Crest(2)

C-Line(2)

Quality Park(2)

Sparco(2)

Trend(2)

Mohawk(1)

Zeus(1)

Advantus(1)

 
Color

White(53)

Ivory(14)

Multi(6)

Blue(4)

Green(3)

Cherry(3)

Canary(3)

Violet(3)

Silver(2)

Diamond White(2)

Natural White (Ivory)(2)

Multicolor(2)

Natural(1)

Avon Brilliant White(1)

Natural White(1)

Black(1)

Orange(1)

Yellow(1)

Pink(1)

 
Brightness

93(1)

 
Recycled

No(88)

Yes(30)

 
Height

3.3"(1)

 
Depth

0.9"(1)

 
Manufacturer Part Number

90350(1)

35810(1)

5136(1)

5135(1)

1726(1)

81300(1)

63525(1)

63500(1)

61100(1)

46002(1)

41(1)

40282(1)

40280(1)

40279(1)

34610(1)

5141(1)

31(1)

30BD(1)

30(1)

10022(1)

10013(1)

10002(1)

10001(1)

04736(1)

01345(1)

01338(1)

300033(1)

63074(1)

5137(1)

5142(1)

63006(1)

554C(1)

T11920(1)

01098(1)

01097(1)

R14ICF(1)

R14CF(1)

P984CK(1)

JD18IC(1)

JD18C(1)

J56410(1)

J404N-10(1)

J404I-10(1)

J404-10(1)

41SM(1)

5174(1)

404NC(1)

404IC(1)

404C(1)

403ER(1)

403E(1)

403CR(1)

403C(1)

31-224-10(1)

31-220-10(1)

14C(1)

13C(1)

10750(1)

10740(1)

63008(1)

63004(1)

90351(1)

5689(1)

8316(1)

8315(1)

5919(1)

5914(1)

5913(1)

5911(1)

5889(1)

5877(1)

5876(1)

5874(1)

5871(1)

5870(1)

5389(1)

8371(1)

5388(1)

5376(1)

5371(1)

5361(1)

5315(1)

5309(1)

5305(1)

5302(1)

3265(1)

90453(1)

90452(1)

90451(1)

90450(1)

8317(1)

8376(1)

53510(1)

65262(1)

43510(1)

48674(1)

46102(1)

44480(1)

39051(1)

71452(1)

71440(1)

70-71419-2(1)

87517(1)

87507(1)

65263BX(1)

65263(1)

65261BX(1)

8386(1)

65261(1)

65260(1)

65259BX(1)

65259(1)

65258(1)

66200(1)

97034(1)

8877(1)

8871(1)

8870(1)

8859(1)

8471(1)

8387(1)

T11921(1)

 
Country of Origin

United States(90)

China(14)

Mexico(14)

Canada(3)

Mayotte(1)

 
Width

2"(1)

8.5"(1)

 
Material

Polypropylene(6)

Cotton Fiber(4)

Polyvinyl Chloride (PVC)(1)

Plastic(1)

Linen(1)

 
Limited Warranty

90 Day(1)

 
Weight (Approximate)

1 lb(2)

24 lb(2)

30 lb(1)

 
Length

3"(1)

 
Sheet Size

8 1/2" x 11"(22)

3" x 5"(19)

4" x 6"(14)

2" x 3 1/2"(12)

3 1/2" x 2"(9)

5" x 8"(5)

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

4" Width x 6" Length(4)

3" Width x 5" Length(3)

2 1/2" x 8 1/2"(2)

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

8 1/2" x 14"(2)

5" Width x 3" Length(2)

6" Width x 4" Length(2)

8" Width x 5" Length(2)

5" x 3"(1)

2" x 3"(1)

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

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

3 1/2" x 11"(1)

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

12 1/2" Width x 9" Length(1)

 
Print Technology

Inkjet(48)

Laser(46)

 
Media Size

2.13" Width x 3.38" Length(1)

 
Binding Type

Ring(1)

 
Number of Sheets

100(3)

50(1)

 
Mailer/Envelope Length

9 1/2"(4)

5 3/4"(1)

8 3/4"(1)

 
Mailer/Envelope Width

4 1/8"(4)

4 3/8"(1)

5 3/4"(1)

 
Sheet Type

Plain(5)

 
Basis Weight

24 lb(11)

65 lb(6)

20 lb(6)

85 lb(4)

72 lb(3)

100 lb(3)

90 lb(2)

32 lb(2)

47 lb(1)

 
Media Type

Printable(1)

 
Mailer/Envelope Classification

#10(4)

#5-1/2(1)

 
Mailer/Envelope Weight

24 lb(6)

 
Surface Finish

Matte(16)

Wove(16)

Smooth(2)

Embossed(1)

Glossy(1)

Linen(1)

Parchment(1)

 
Front Lines Space

0.25" Ruled(4)

 
Front Ruling Type

Ruled(16)

Unruled(2)

 
Ruling Surface Side

Front(13)

Both Side(1)

 
Back Ruling Type

Unruled(6)

Ruled(1)

 
Product Type

Note Card(23)

Copy & Multipurpose Paper(21)

Business Card(19)

Printable Index Card(12)

Index Card(7)

Tent Card(7)

Envelope(6)

Index Card Holder(6)

Greeting Card(5)

Invitation Card(3)

Postcard(3)

Printable Multipurpose Card(2)

Notepad(2)

ID Card(1)

Name Plate Holder(1)

Printable Recognition Card(1)

Name Badge(1)

Binding Cover(1)

Parchment Paper(1)

 
Packaged Quantity

100 / Pack(31)

500 / Box(13)

100 / Box(9)

200 / Pack(6)

250 / Box(6)

5 / Pack(6)

1000 / Box(5)

300 / Pack(5)

250 / Pack(5)

500 / Ream(3)

60 / Box(3)

30 / Box(2)

50 / Box(2)

75 / Pack(2)

60 / Pack(2)

4000 / Carton(2)

400 / Box(2)

200 / Box(2)

160 / Pack(1)

1 / Pack(1)

160 / Box(1)

150 / Box(1)

50 / Each(1)

500 / Bundle(1)

2000 / Box(1)

1 Pack(1)

20 / Box(1)

750 / Pack(1)

350 / Pack(1)

50 / Pack(1)

80 / Box(1)

2500 / Box(1)

25 / Pack(1)

25 / Box(1)

 
Assembly Required

No(25)

 
Product Model

13C(1)

14C(1)

403C(1)

403CR(1)

403E(1)

403ER(1)

404C(1)

404IC(1)

404NC(1)

554C(1)

J404-10(1)

J404I-10(1)

J404N-10(1)

J56410(1)

JD18IC(1)

 
Product Line

Clean Edge(6)

Overtures(3)

Strathmore(1)

Credentials(1)

Premium(1)

 
Mailer/Envelope Type

Business(4)

Announcement(2)

 
Closure Type

Gummed(3)

Peel & Seal(2)

 
Sheet Color

White(18)

Assorted(3)

Blue(2)

Orange(2)

Green(2)

Buff(1)

Cherry(1)

Hot Pink(1)

Hot Yellow(1)

Hot Lime(1)

Hot Blue(1)

Hot Orange(1)

Pink(1)

Canary(1)