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(88)

Smead(29)

Universal(24)

Avery(18)

C-Line(8)

Five Star(6)

Southworth(2)

 
Manufacturer Part Number

47696(1)

87017(1)

78513(1)

78542(1)

99656(1)

99667(1)

99801(1)

99810(1)

99811(1)

99837(1)

87700(1)

78502(1)

87701(1)

87705(1)

87706(1)

87725(1)

87726(1)

87727(1)

87850(1)

87852(1)

78511(1)

59811(1)

87854(1)

57709(1)

57557(1)

57568(1)

57701(1)

57702(1)

57703(1)

57704(1)

57705(1)

57706(1)

57711(1)

59806(1)

57713(1)

57738(1)

57755(1)

57756(1)

57757(1)

57768(1)

59626234(1)

59802(1)

87853(1)

87855(1)

57555(1)

56604(1)

20545(1)

56416(1)

56417(1)

56418(1)

56419(1)

56420(1)

56426(1)

56601(1)

56611(1)

20543(1)

56613(1)

56616(1)

56638(1)

57113(1)

57114(1)

57115(1)

57116(1)

57117(1)

20544(1)

20542(1)

87858(1)

87965(1)

87859(1)

87861(1)

87862(1)

87865(1)

87867(1)

87910(1)

87939(1)

87964(1)

87980(1)

20541(1)

87981(1)

87982(1)

88052(1)

88054(1)

89204(1)

98873(1)

98874(1)

20540(1)

57556(1)

57538(1)

47811(1)

04161(1)

34721(1)

34725(1)

38056(1)

38130(1)

38133(1)

73264(1)

73266(1)

73270(1)

04162(1)

33930(1)

10071(1)

10072(1)

50190(1)

5049526(1)

5049560(1)

5049561(1)

5049580(1)

50625-00(1)

34720(1)

32935(1)

50625-58(1)

47986(1)

47846(1)

47847(1)

47975(1)

47976(1)

47977(1)

47978(1)

47979(1)

47985(1)

47987(1)

32934(1)

47988(1)

47989(1)

47990(1)

47991(1)

47992(1)

47993(1)

32010(1)

32930(1)

50625-23(1)

50625-80(1)

57514(1)

57501(1)

57402(1)

57411(1)

57441(1)

57442(1)

57444(1)

57454(1)

57455(1)

57470(1)

57502(1)

54443(1)

57503(1)

57504(1)

57505(1)

57506(1)

57509(1)

57510(1)

57511(1)

57513(1)

57401(1)

53443(1)

51274(1)

51711(1)

51276(1)

51617(1)

51626(1)

51643(1)

51701(1)

51704(1)

51705(1)

51706(1)

51717(1)

53442(1)

51718(1)

51726(1)

51743(1)

53404(1)

53405(1)

53406(1)

53434(1)

53441(1)

57118(1)

 
Country of Origin

US(71)

CN(67)

MX(31)

IN(6)

 
Sheet Size

11 x 8 1/2(158)

8 1/2 x 11(8)

11 x 8.5(6)

8 1/2" x 11"(3)

 
Cover Material(s)

Paper(50)

Polypropylene(34)

Heavyweight Paper Stock(16)

Paper Stock(16)

Embossed Standard Paper(9)

Laminated Paper(9)

Laminated Paperboard(9)

Plastic(6)

Cardboard Paper(6)

Poly(5)

Standard Grade Paper(3)

Cover Stock(2)

Premium Cover Stock(2)

11-pt Laminated Stock(2)

Heavyweight Grain Stock(2)

Card Stock(2)

Glossy Laminated Paper Stock(1)

 
Capacity Range [Max]

1/2"(46)

20"(5)

1"(1)

 
Back Cover Color(s)

Assorted(30)

Black(20)

Red(17)

Blue(14)

Dark Blue(12)

White(10)

Green(9)

Navy(9)

Light Blue(6)

Teal(5)

Gray(5)

Yellow(4)

Purple(4)

Burgundy(3)

Hunter Green(3)

Orange(3)

Pink(2)

Royal Blue(2)

Natural(1)

Oyster(1)

Lavender(1)

Crimson(1)

Translucent/Navy Blue(1)

Black/Gold(1)

Emerald Green(1)

Copper(1)

Blue/Gold(1)

Translucent Blue(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(67)

135 Sheets(20)

40 Sheets(9)

20 Sheets(6)

100 sheets(6)

150 Sheets(5)

70 Sheets(5)

200 Sheets(4)

60 Sheets(3)

50 Sheets(3)

180 Sheets(3)

110 Sheets(2)

25 Sheets(2)

125 Sheets(1)

 
Business Card Holder

Inside Front Cover(132)

Inside Back Pocket(5)

Inside Back Cover(2)

 
Texture/Finish

Textured(17)

Leatherette Grain(16)

High Gloss(13)

Leatherette(8)

Laminated(7)

Linen(7)

Matte(5)

Metallic(4)

Smooth(4)

Opaque(2)

Honeycomb Texture(1)

 
Design

Contour Curves(4)

Marble(4)

Trend(3)

Snap Closure(2)

Embossed Gold Foil Accents(2)

Embossed Pattern(2)

Solid Colors(2)

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

Traditional(1)

 
Title View

Full-Frame Front Window(5)

Full-Frame Front Sleeve(4)

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)

Assorted(6)

Black(5)

Red(3)

White(3)

Translucent(2)

Navy(2)

Blue(2)

Black; Gray(1)

Navy Blue(1)

Royal Blue(1)

Dark Blue(1)

 
Inside Pockets

One Back, One Front(144)

Two(6)

2(4)

One Back(4)

Three Back, One Front(3)

Three Back(3)

One Back; One Front(2)

Two Front(2)

One Back, Six Center, One Front(2)

Three Back, Three Front(1)

Four(1)

4(1)

Three Inside(1)

Ten Inside(1)

 
Front Cover Color(s)

Assorted(30)

Black(18)

Red(17)

Blue(13)

Dark Blue(12)

Navy(9)

White(9)

Green(9)

Light Blue(6)

Gray(5)

Teal(5)

Yellow(4)

Purple(4)

Clear(4)

Hunter Green(3)

Burgundy(3)

Orange(3)

Translucent/Navy Blue(2)

Pink(2)

Natural(1)

Clear/Black(1)

Clear/Oyster(1)

Navy Blue(1)

Lavender(1)

Blue/Gold(1)

Crimson(1)

Emerald Green(1)

Copper(1)

Translucent Blue(1)

Black/Gold(1)

Steel Blue/Amber Orange(1)

Charcoal Gray/Lime Green(1)

Clear/Assorted(1)

Translucent/Black(1)

Royal Blue(1)

 
 
 

© 2020-2021 Desert West Office Supply, All Rights Reserved