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

Smead(31)

Universal(24)

Avery(18)

C-Line(8)

Five Star(7)

 
Manufacturer Part Number

99801(1)

99810(1)

99811(1)

99837(1)

99667(1)

99656(1)

78502(1)

78511(1)

78513(1)

78542(1)

87017(1)

87700(1)

87727(1)

87800(1)

87850(1)

87852(1)

87726(1)

87725(1)

87701(1)

87705(1)

87706(1)

59811(1)

59806(1)

57702(1)

57703(1)

57704(1)

57705(1)

57701(1)

57568(1)

57555(1)

57556(1)

57557(1)

57706(1)

57709(1)

57757(1)

57768(1)

59626234(1)

59802(1)

57756(1)

57755(1)

57711(1)

57713(1)

57738(1)

87853(1)

87854(1)

56419(1)

56420(1)

56426(1)

56601(1)

56418(1)

56417(1)

20544(1)

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

20543(1)

20542(1)

87865(1)

87867(1)

87910(1)

87913(1)

87862(1)

87861(1)

87855(1)

87858(1)

87859(1)

87916(1)

87939(1)

88054(1)

89204(1)

20540(1)

20541(1)

88052(1)

87982(1)

87965(1)

87980(1)

87981(1)

57538(1)

57514(1)

38133(1)

73264(1)

73266(1)

73270(1)

38130(1)

38056(1)

34720(1)

34721(1)

34725(1)

73272(1)

04161(1)

5049560(1)

5049561(1)

5049580(1)

50625-00(1)

5049526(1)

50190(1)

04162(1)

10071(1)

10072(1)

33930(1)

32935(1)

47977(1)

47978(1)

47979(1)

47985(1)

47976(1)

47975(1)

47811(1)

47846(1)

47847(1)

47986(1)

47987(1)

47993(1)

32010(1)

32930(1)

32934(1)

47992(1)

47991(1)

47988(1)

47989(1)

47990(1)

50625-23(1)

50625-58(1)

57442(1)

57444(1)

57454(1)

57455(1)

57441(1)

57411(1)

54443(1)

57401(1)

57402(1)

57470(1)

57501(1)

57509(1)

57510(1)

57511(1)

57513(1)

57506(1)

57505(1)

57502(1)

57503(1)

57504(1)

53443(1)

53442(1)

51643(1)

51701(1)

51704(1)

51705(1)

51626(1)

51617(1)

50625-80(1)

51274(1)

51276(1)

51706(1)

51711(1)

53405(1)

53406(1)

53434(1)

53441(1)

53404(1)

51743(1)

51717(1)

51718(1)

51726(1)

47696(1)

 
Country of Origin

US(73)

CN(66)

MX(31)

IN(6)

 
Sheet Size

11 x 8 1/2(166)

8 1/2 x 11(7)

8 1/2" x 11"(3)

 
Cover Material(s)

Paper(50)

Polypropylene(34)

Paper Stock(16)

Heavyweight Paper Stock(16)

Laminated Paperboard(9)

Embossed Standard Paper(9)

Laminated Paper(9)

Plastic(6)

Poly(6)

Cardboard Paper(6)

Standard Grade Paper(3)

Premium Cover Stock(2)

11-pt. Paper Stock(2)

Heavyweight Grain Stock(2)

Cover Stock(2)

Glossy Laminated Paper Stock(1)

Colored Laminated Stock(1)

11-pt Laminated Stock(1)

 
Capacity Range [Max]

1/2"(46)

20"(6)

1"(1)

 
Back Cover Color(s)

Assorted(32)

Black(20)

Red(18)

Blue(13)

Dark Blue(12)

White(10)

Green(9)

Navy(8)

Light Blue(6)

Gray(5)

Teal(5)

Purple(4)

Yellow(4)

Orange(3)

Hunter Green(3)

Burgundy(3)

Pink(2)

Royal Blue(2)

Oyster(1)

Crimson(1)

Lavender(1)

Natural(1)

Navy Blue(1)

Steel Blue/Amber Orange(1)

Clear/Assorted(1)

Translucent/Black(1)

Translucent/Navy(1)

Translucent Blue(1)

Charcoal Gray/Lime Green(1)

Translucent/Navy Blue(1)

Copper(1)

Blue/Gold(1)

Black/Gold(1)

Emerald Green(1)

 
Capacity (text)

100 Sheets(68)

135 Sheets(20)

40 Sheets(9)

20 Sheets(7)

100 sheets(6)

150 Sheets(5)

70 Sheets(5)

50 Sheets(4)

200 Sheets(4)

60 Sheets(3)

180 Sheets(3)

110 Sheets(2)

125 Sheets(1)

 
Business Card Holder

Inside Front Cover(131)

Inside Back Pocket(5)

Inside Back Cover(2)

 
Texture/Finish

Textured(19)

Leatherette Grain(16)

High Gloss(13)

Leatherette(8)

Linen(7)

Laminated(7)

Matte(6)

Smooth(4)

Metallic(4)

Opaque(2)

Glossy(1)

Honeycomb Texture(1)

 
Design

Contour Curves(4)

Marble(4)

Trend(3)

Solid Colors(2)

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

Embossed Pattern(2)

Traditional(2)

Snap Closure(2)

Embossed Gold Foil Accents(2)

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

Red(3)

White(3)

Translucent(2)

Blue(2)

Black; Gray(2)

Dark Blue(1)

Royal Blue(1)

Navy Blue(1)

Navy(1)

 
Inside Pockets

One Back, One Front(144)

Two(6)

2(4)

One Back(4)

Three Back(3)

Three Back, One Front(3)

One Back; One Front(2)

One Back, Six Center, One Front(2)

4(2)

Two Front(2)

Ten Inside(1)

Three Inside(1)

Four(1)

Three Back, Three Front(1)

 
Front Cover Color(s)

Assorted(32)

Red(18)

Black(18)

Blue(12)

Dark Blue(12)

White(9)

Green(9)

Navy(8)

Light Blue(6)

Teal(5)

Gray(5)

Purple(4)

Clear(4)

Yellow(4)

Orange(3)

Hunter Green(3)

Burgundy(3)

Translucent/Navy Blue(2)

Pink(2)

Lavender(1)

Royal Blue(1)

Navy Blue(1)

Clear/Oyster(1)

Clear/Black(1)

Natural(1)

Blue/Gold(1)

Clear/Assorted(1)

Translucent/Black(1)

Translucent Blue(1)

Charcoal Gray/Lime Green(1)

Steel Blue/Amber Orange(1)

Emerald Green(1)

Copper(1)

Black/Gold(1)

Crimson(1)

 
 
 

© 2019-2020 Horizon Business Products, All Rights Reserved