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

Currently Filtered by

Category

Pocket Folders

Refine Search

  GO
 
Brand

Oxford(95)

Smead(41)

Universal(18)

Avery(18)

C-Line(5)

Southworth(3)

GBC(1)

 
Manufacturer Part Number

87701(1)

87705(1)

87706(1)

87725(1)

87700(1)

87017(1)

99802(1)

99810(1)

99811(1)

99837(1)

87726(1)

87727(1)

87854(1)

87855(1)

87856(1)

87858(1)

87853(1)

87852(1)

87728(1)

87800(1)

87850(1)

99801(1)

99667(1)

57713(1)

57738(1)

57755(1)

57756(1)

57711(1)

57709(1)

57703(1)

57704(1)

57705(1)

57706(1)

57757(1)

57768(1)

78511(1)

78513(1)

78542(1)

99656(1)

78502(1)

59811(1)

59626234(1)

59802(1)

59806(1)

87859(1)

87861(1)

56419(1)

56420(1)

56426(1)

56601(1)

56418(1)

56417(1)

98873(1)

98874(1)

98875(1)

56416(1)

56604(1)

56611(1)

57115(1)

57116(1)

57117(1)

57118(1)

57114(1)

57113(1)

56613(1)

56616(1)

56638(1)

89204(1)

88059(1)

87915(1)

87916(1)

87926(1)

87927(1)

87914(1)

87913(1)

87862(1)

87865(1)

87867(1)

87939(1)

87963(1)

87982(1)

87990(1)

88052(1)

88054(1)

87981(1)

87980(1)

87964(1)

87965(1)

87966(1)

57702(1)

57701(1)

5049526(1)

5049560(1)

5049561(1)

5049580(1)

50190(1)

10072(1)

04161(1)

04162(1)

04165(1)

10071(1)

50625-00(1)

50625-23(1)

51626(1)

51643(1)

51701(1)

51704(1)

51617(1)

50625-80(1)

50625-58(1)

50625-60(1)

50625-70(1)

55516(1)

33930(1)

47978(1)

47979(1)

47985(1)

47986(1)

47977(1)

47976(1)

47811(1)

47846(1)

47847(1)

47975(1)

47987(1)

47988(1)

32010(1)

32930(1)

32934(1)

32935(1)

47993(1)

47992(1)

47989(1)

47990(1)

47991(1)

51705(1)

51706(1)

57502(1)

57503(1)

57504(1)

57505(1)

57501(1)

57470(1)

57443(1)

57444(1)

57454(1)

57455(1)

57506(1)

57509(1)

57555(1)

57556(1)

57557(1)

57568(1)

57538(1)

57514(1)

57510(1)

57511(1)

57513(1)

57442(1)

57441(1)

53404(1)

53405(1)

53406(1)

53434(1)

51743(1)

51726(1)

51711(1)

51717(1)

51718(1)

53441(1)

53442(1)

57401(1)

57402(1)

57403(1)

57411(1)

55776(1)

55774(1)

53443(1)

54406(1)

54443(1)

47696(1)

 
Country of Origin

US(114)

CN(51)

MX(16)

 
Sheet Size

11 x 8 1/2(178)

8 1/2 x 11(3)

 
Cover Material(s)

Paper(51)

Polypropylene(34)

Heavyweight Paper Stock(18)

Paper Stock(17)

Laminated Paperboard(9)

Embossed Standard Paper(9)

Laminated Paper(8)

Cardboard Paper(6)

11 pt. Laminated Stock(4)

11-pt. Paper Stock(4)

Colored Laminated Stock(3)

Card Stock(3)

Heavyweight Grain Stock(3)

Premium Cover Stock(3)

Standard Grade Paper(3)

Glossy Laminated Paper Stock(2)

Cover Stock(2)

Textured Paper(2)

 
Capacity Range [Max]

1/2"(50)

1"(1)

 
Back Cover Color(s)

Black(26)

Assorted(23)

Red(20)

Blue(15)

Dark Blue(12)

Green(11)

White(10)

Navy(9)

Gray(6)

Light Blue(6)

Teal(5)

Yellow(5)

Purple(4)

Burgundy(4)

Orange(3)

Hunter Green(3)

Pink(2)

Gray Metallic(1)

Crimson(1)

Royal Blue(1)

Oyster(1)

Monaco Blue(1)

Natural(1)

Lavender(1)

Black/Gold(1)

Translucent/Black(1)

Translucent/Navy(1)

Translucent Blue(1)

Clear/Assorted(1)

Translucent/Navy Blue(1)

Copper(1)

Burgundy/Gold(1)

Blue/Gold(1)

Emerald Green(1)

 
Capacity (text)

100 Sheets(75)

135 Sheets(21)

40 Sheets(9)

100 sheets(6)

70 Sheets(5)

150 Sheets(5)

200 Sheets(5)

180 Sheets(4)

50 Sheets(4)

25 Sheets(3)

110 Sheets(3)

250 Sheets(2)

125 Sheets(2)

60 Sheets(1)

20 Sheets(1)

 
Business Card Holder

Inside Front Cover(148)

Inside Back Cover(2)

 
Texture/Finish

Textured(22)

Leatherette Grain(16)

High Gloss(13)

Leatherette(8)

Linen(7)

Laminated(6)

Metallic(4)

Smooth(3)

Opaque(2)

Satin Finish(1)

Glossy(1)

Honeycomb Texture(1)

Leatherette Texture(1)

Leatherette Embossed(1)

Ribbed(1)

 
Design

Contour Curves(6)

Marble(4)

Embossed Gold Foil Accents(3)

Snap-Closure Security Pocket (9 x 5)(2)

Embossed Pattern(2)

 
Title View

Full-Frame Front Sleeve(5)

Full-Frame Front Window(5)

Square-Cut Front Window(2)

Full Frame Front and Back Window(1)

 
Media Holder(s)

CD/DVD Slot - Inside Back Cover(4)

 
Pocket Leaves Color(s)

Black(4)

Assorted(4)

White(2)

Red(2)

Blue(2)

Translucent(2)

Navy(2)

Dark Blue(1)

Gray Metallic(1)

 
Inside Pockets

One Back, One Front(157)

One Back(9)

Three Back, One Front(5)

Three Back(3)

One Back; One Front(2)

One Back, Six Center, One Front(2)

Ten Inside(1)

Three Inside(1)

Three Back, Three Front(1)

 
Front Cover Color(s)

Black(24)

Assorted(23)

Red(19)

Blue(14)

Dark Blue(12)

Green(11)

White(9)

Navy(9)

Light Blue(6)

Gray(6)

Teal(5)

Clear(5)

Yellow(5)

Purple(4)

Burgundy(4)

Orange(3)

Hunter Green(3)

Pink(2)

Translucent/Navy Blue(2)

Natural(1)

Lavender(1)

Gray Metallic(1)

Monaco Blue(1)

Clear/Oyster(1)

Clear/Black(1)

Blue/Gold(1)

Clear/Assorted(1)

Translucent/Black(1)

Translucent Blue(1)

Black/Gold(1)

Burgundy/Gold(1)

Emerald Green(1)

Copper(1)

Crimson(1)

 
 
 

© 2018-2019 BonTay Business Products, Inc., All Rights Reserved