0

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_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','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 '%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(96)

Smead(42)

Universal(24)

Avery(18)

C-Line(8)

Southworth(5)

Five Star(1)

Mead(1)

 
Color

Assorted(1)

 
Recycled

No(1)

 
Height

12 1/2"(1)

 
Manufacturer Part Number

47696(1)

87852(1)

87700(1)

87701(1)

87705(1)

87706(1)

87725(1)

87726(1)

87727(1)

87800(1)

87850(1)

87853(1)

99837(1)

87854(1)

87855(1)

87856(1)

87858(1)

87859(1)

87861(1)

87862(1)

87865(1)

87867(1)

87017(1)

99811(1)

87913(1)

59626234(1)

57706(1)

57709(1)

57711(1)

57713(1)

57738(1)

57755(1)

57756(1)

57757(1)

57768(1)

59802(1)

99810(1)

59806(1)

59811(1)

78502(1)

78511(1)

78513(1)

78542(1)

99656(1)

99667(1)

99801(1)

99802(1)

87910(1)

87914(1)

57704(1)

56601(1)

20543(1)

20544(1)

20545(1)

56416(1)

56417(1)

56418(1)

56419(1)

56420(1)

56426(1)

56604(1)

20541(1)

56611(1)

56613(1)

56616(1)

56638(1)

57113(1)

57114(1)

57115(1)

57116(1)

57117(1)

20542(1)

20540(1)

87915(1)

87981(1)

87916(1)

87926(1)

87927(1)

87939(1)

87963(1)

87964(1)

87965(1)

87966(1)

87980(1)

87982(1)

98875(1)

87990(1)

87991(1)

88052(1)

88054(1)

88059(1)

89204(1)

98870(1)

98872(1)

98873(1)

98874(1)

57705(1)

57703(1)

47811(1)

5049560(1)

38058(1)

04161(1)

04162(1)

04164(1)

04165(1)

10071(1)

10072(1)

50190(1)

5049526(1)

5049561(1)

34725(1)

5049580(1)

50625-00(1)

50625-23(1)

50625-58(1)

50625-60(1)

50625-70(1)

50625-80(1)

51617(1)

51626(1)

38056(1)

34721(1)

51701(1)

47987(1)

47846(1)

47847(1)

47975(1)

47976(1)

47977(1)

47978(1)

47979(1)

47985(1)

47986(1)

47988(1)

34720(1)

47989(1)

47990(1)

47991(1)

47992(1)

47993(1)

32010(1)

32930(1)

32934(1)

32935(1)

33930(1)

51643(1)

51704(1)

57702(1)

57509(1)

57454(1)

57455(1)

57470(1)

57501(1)

57502(1)

57503(1)

57504(1)

57505(1)

57506(1)

57510(1)

57443(1)

57511(1)

57513(1)

57514(1)

57538(1)

57555(1)

57556(1)

57557(1)

57568(1)

57701(1)

57444(1)

57442(1)

51705(1)

53434(1)

51706(1)

51711(1)

51717(1)

51718(1)

51726(1)

51743(1)

53404(1)

53405(1)

53406(1)

53441(1)

57441(1)

53442(1)

53443(1)

54406(1)

54443(1)

55774(1)

55776(1)

57401(1)

57402(1)

57403(1)

57411(1)

57118(1)

 
Country of Origin

US(88)

CN(55)

MX(31)

VN(14)

IN(6)

China(1)

 
Width

9 1/2"(1)

 
Sheet Size

11 x 8.5(113)

11 x 8 1/2(72)

8 1/2 x 11(6)

8 1/2" x 11"(3)

 
Cover Material(s)

Paper(51)

Polypropylene(36)

Paper Stock(18)

Heavyweight Paper Stock(17)

Embossed Standard Paper(9)

Laminated Paper(9)

Laminated Paperboard(9)

Plastic(6)

Cardboard Paper(6)

Card Stock(5)

11-pt. Paper Stock(4)

Premium Cover Stock(4)

Colored Laminated Stock(3)

11 pt. Laminated Stock(3)

Heavyweight Grain Stock(3)

Standard Grade Paper(3)

Textured Paper(2)

Glossy Laminated Paper Stock(2)

Cover Stock(2)

11-pt Laminated Stock(1)

 
Capacity Range [Max]

0.5"(39)

1/2"(12)

1"(1)

 
Total Number of Pockets

4(1)

 
Pocket Location

Internal(1)

 
Back Cover Color(s)

Black(28)

Assorted(26)

Red(21)

Blue(15)

Dark Blue(12)

Green(11)

White(10)

Navy(9)

Light Blue(6)

Gray(6)

Yellow(5)

Teal(5)

Purple(4)

Burgundy(3)

Orange(3)

Hunter Green(3)

Royal Blue(2)

Pink(2)

Gray Metallic(2)

Translucent/Navy Blue(1)

Monaco Blue(1)

Natural(1)

Oyster(1)

Lavender(1)

Blue Gray(1)

Crimson(1)

Green/Gold(1)

Emerald Green(1)

Copper(1)

Burgundy/Gold(1)

Translucent Blue(1)

Blue/Gold(1)

Black/Gold(1)

Steel Blue/Amber Orange(1)

Charcoal Gray/Lime Green(1)

Clear/Assorted(1)

Translucent/Black(1)

Translucent/Navy(1)

Navy Blue(1)

 
Capacity (text)

100 Sheets(92)

135 Sheets(21)

40 Sheets(9)

50 Sheets(6)

100 sheets(6)

150 Sheets(5)

70 Sheets(5)

200 Sheets(5)

60 Sheets(3)

110 Sheets(3)

180 Sheets(3)

25 Sheets(3)

80 Sheets(2)

125 Sheets(2)

250 Sheets(2)

20 Sheets(1)

 
Business Card Holder

Inside Front Cover(154)

Inside Back Pocket(5)

Inside Back Cover(2)

 
Texture/Finish

Textured(22)

Leatherette Grain(16)

High Gloss(13)

Leatherette(8)

Laminated(7)

Linen(7)

Metallic(4)

Smooth(3)

Opaque(2)

Satin Finish(2)

Leatherette Texture(1)

Leatherette Embossed(1)

Honeycomb Texture(1)

Glossy(1)

 
Design

Contour Curves(6)

Embossed Gold Foil Accents(4)

Marble(4)

Embossed Pattern(2)

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

Trend(1)

 
Title View

Full-Frame Front Window(5)

Full-Frame Front Sleeve(5)

Square-Cut Front Window(2)

Full Frame Front and Back Window(1)

 
Media Holder(s)

CD/DVD Slot - Inside Back Cover(11)

 
Pocket Leaves Color(s)

Assorted(6)

Black(6)

Red(3)

White(3)

Translucent(2)

Navy(2)

Blue(2)

Gray Metallic(2)

Navy Blue(1)

Royal Blue(1)

Dark Blue(1)

 
Product Type

Pocket Folder(1)

 
Packaged Quantity

6 / Pack(1)

 
Inside Pockets

One Back, One Front(163)

One Back(9)

Two(6)

Three Back, One Front(5)

Three Back(3)

One Back; One Front(2)

One Back, Six Center, One Front(2)

Three Back, Three Front(1)

Four(1)

Three Inside(1)

Ten Inside(1)

 
Front Cover Color(s)

Black(26)

Assorted(26)

Red(20)

Blue(14)

Dark Blue(12)

Green(11)

White(9)

Navy(9)

Light Blue(6)

Gray(6)

Teal(5)

Yellow(5)

Clear(5)

Purple(4)

Hunter Green(3)

Burgundy(3)

Orange(3)

Pink(2)

Gray Metallic(2)

Translucent/Navy Blue(2)

Translucent Blue(1)

Natural(1)

Navy Blue(1)

Translucent/Black(1)

Blue Gray(1)

Monaco Blue(1)

Lavender(1)

Clear/Oyster(1)

Clear/Black(1)

Clear/Assorted(1)

Burgundy/Gold(1)

Charcoal Gray/Lime Green(1)

Steel Blue/Amber Orange(1)

Black/Gold(1)

Crimson(1)

Blue/Gold(1)

Emerald Green(1)

Green/Gold(1)

Copper(1)

Royal Blue(1)

 
 
 

© 2020-2021 Service Office Supplies, All Rights Reserved