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 ('60024')) 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(60)

Avery(18)

Smead(10)

Five Star(3)

C-Line(1)

 
Special Features

Heavy-Duty Opaque Polypropylene(2)

With Assorted Color Pockets(1)

Durable Glossy Laminated Paper Stock-Die-cut business card holder on inside front cover.(1)

Durable Glossy Laminated Paper Stock(1)

 
Assortment

Light Blue; Green; Orange; Red; Yellow(2)

Green; Red; Purple; Yellow(1)

Blue; Green; Pink; Red; Yellow(1)

Blue; Dark Blue; Gray; Green; Red; Yellow(1)

Dark Blue; Green; Orange; Red; Yellow(1)

Lime; Purple; Teal; White(1)

Blue; Green; Orange; Purple; Red; Yellow(1)

Bright Orange;Blue Teal;Lime;Pink; Royal Purple; Yellow(1)

Black; Cobalt Blue; Green; Red; Royal Purple; White(1)

Black; Dark Blue; Green; Light Blue; Red(1)

 
Capacity (text)

100 Sheets(46)

135 Sheets(11)

40 Sheets(9)

70 Sheets(5)

200 Sheets(4)

150 Sheets(3)

20 Sheets(2)

110 Sheets(1)

50 Sheets(1)

 
Manufacturer Part Number

57556(1)

57555(1)

57538(1)

57513(1)

57557(1)

57568(1)

57705(1)

57703(1)

57702(1)

57701(1)

57511(1)

57510(1)

57501(1)

57470(1)

57455(1)

57454(1)

57502(1)

57503(1)

57509(1)

57506(1)

57505(1)

57504(1)

57709(1)

57711(1)

87855(1)

87854(1)

87852(1)

87850(1)

87859(1)

87861(1)

88052(1)

87867(1)

87865(1)

87862(1)

99811(1)

99801(1)

57756(1)

57755(1)

57738(1)

57713(1)

57757(1)

59802(1)

99656(1)

78511(1)

59811(1)

57443(1)

57441(1)

47991(1)

47990(1)

47989(1)

47988(1)

47992(1)

47993(1)

73270(1)

38058(1)

38056(1)

32010(1)

47987(1)

47986(1)

47975(1)

47847(1)

47846(1)

47811(1)

47976(1)

47977(1)

47985(1)

47979(1)

47978(1)

04161(1)

04162(1)

51726(1)

51718(1)

51717(1)

51711(1)

51743(1)

53441(1)

57402(1)

54443(1)

54406(1)

53443(1)

51706(1)

51704(1)

5049580(1)

5049561(1)

5049560(1)

5049526(1)

50625-00(1)

50625-23(1)

51701(1)

50625-80(1)

50625-70(1)

47696(1)

 
Country of Origin

US(40)

CN(34)

MX(18)

 
Sheet Size

11 x 8 1/2(89)

8 1/2 x 11(3)

 
Capacity Range [Max]

1/2"(35)

20"(1)

 
Cover Material(s)

Paper(23)

Paper Stock(15)

Polypropylene(13)

Heavyweight Paper Stock(10)

Embossed Standard Paper(9)

Laminated Paperboard(8)

Laminated Paper(6)

Standard Grade Paper(2)

Premium Cover Stock(2)

Glossy Laminated Paper Stock(2)

Heavyweight Grain Stock(1)

Poly(1)

 
Inside Pockets

One Back, One Front(83)

Three Back(2)

Four(2)

Three Back, One Front(1)

One Back, Six Center, One Front(1)

One Back; One Front(1)

4(1)

Three Back, Three Front(1)

 
Back Cover Color(s)

Assorted(10)

Red(9)

Blue(7)

Green(7)

Dark Blue(7)

Black(6)

Yellow(5)

Navy(5)

White(4)

Light Blue(4)

Teal(4)

Burgundy(3)

Gray(3)

Orange(2)

Hunter Green(2)

Purple(2)

Pink(1)

Crimson(1)

Lavender(1)

Royal Blue(1)

Clear/Assorted(1)

Translucent/Navy(1)

Translucent Blue(1)

Translucent/Black(1)

Translucent/Navy Blue(1)

Blue/Gold(1)

Black/Gold(1)

Copper(1)

 
Front Cover Color(s)

Assorted(10)

Red(8)

Green(7)

Dark Blue(7)

Blue(6)

Black(6)

Yellow(5)

Navy(5)

Teal(4)

White(4)

Light Blue(4)

Burgundy(3)

Gray(3)

Clear(3)

Orange(2)

Hunter Green(2)

Translucent/Navy Blue(2)

Purple(2)

Lavender(1)

Pink(1)

Black/Gold(1)

Translucent/Black(1)

Translucent Blue(1)

Clear/Assorted(1)

Blue/Gold(1)

Copper(1)

Crimson(1)

 
Design

Contour Curves(4)

Embossed Gold Foil Accents(2)

Trend(2)

Traditional(1)

 
Business Card Holder

Inside Front Cover(80)

Inside Back Cover(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved