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

Currently Filtered by

Category

Pocket Folders

Refine Search

  GO
Brand

Oxford(97)

Smead(42)

Avery(18)

Universal(18)

C-Line(8)

Smead®(2)

Manufacturer Part Number

99812(1)

99837(1)

87017(1)

87700(1)

99811(1)

99810(1)

99656(1)

99667(1)

99801(1)

99802(1)

87701(1)

87705(1)

87850(1)

87852(1)

87853(1)

87854(1)

87800(1)

87728(1)

87706(1)

87725(1)

87726(1)

87727(1)

78542(1)

78513(1)

57705(1)

57706(1)

57709(1)

57711(1)

57704(1)

57703(1)

57557(1)

57568(1)

57701(1)

57702(1)

57713(1)

57738(1)

59806(1)

59811(1)

78502(1)

78511(1)

59802(1)

59626234(1)

57755(1)

57756(1)

57757(1)

57768(1)

87855(1)

87856(1)

56418(1)

56419(1)

56420(1)

56426(1)

56417(1)

56416(1)

88052(1)

88054(1)

88059(1)

89204(1)

56601(1)

56604(1)

57115(1)

57116(1)

57117(1)

57118(1)

57114(1)

57113(1)

56611(1)

56613(1)

56616(1)

56638(1)

87991(1)

87990(1)

87910(1)

87913(1)

87914(1)

87915(1)

87867(1)

87865(1)

87858(1)

87859(1)

87861(1)

87862(1)

87916(1)

87926(1)

87966(1)

87980(1)

87981(1)

87982(1)

87965(1)

87964(1)

87927(1)

87939(1)

87951(1)

87963(1)

57556(1)

57555(1)

ESS99656(1)

04161(1)

04162(1)

04164(1)

ESS57713(1)

ESS57513(1)

34725(1)

ESS55774(1)

ESS55776(1)

ESS57503(1)

04165(1)

10071(1)

50625-00(1)

50625-23(1)

50625-58(1)

50625-60(1)

5049580(1)

5049561(1)

10072(1)

50190(1)

5049526(1)

5049560(1)

34721(1)

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

32930(1)

32934(1)

32935(1)

33930(1)

32010(1)

47993(1)

47989(1)

47990(1)

47991(1)

47992(1)

50625-70(1)

50625-80(1)

57444(1)

57454(1)

57455(1)

57470(1)

57443(1)

57442(1)

57402(1)

57403(1)

57411(1)

57441(1)

57501(1)

57502(1)

57511(1)

57513(1)

57514(1)

57538(1)

57510(1)

57509(1)

57503(1)

57504(1)

57505(1)

57506(1)

57401(1)

55776(1)

51706(1)

51711(1)

51717(1)

51718(1)

51705(1)

51704(1)

51617(1)

51626(1)

51643(1)

51701(1)

51726(1)

51743(1)

53443(1)

54406(1)

54443(1)

55774(1)

53442(1)

53441(1)

53404(1)

53405(1)

53406(1)

53434(1)

47696(1)

Country of Origin

US(118)

CN(51)

MX(16)

Sheet Size

11 x 8 1/2(184)

8 1/2 x 11(1)

Cover Material(s)

Paper(51)

Polypropylene(38)

Paper Stock(18)

Heavyweight Paper Stock(17)

Laminated Paperboard(9)

Embossed Standard Paper(9)

Laminated Paper(8)

Cardboard Paper(6)

11 pt. Laminated Stock(4)

Premium Cover Stock(4)

11-pt. Paper Stock(4)

Colored Laminated Stock(3)

Heavyweight Grain Stock(3)

Standard Grade Paper(3)

Textured Paper(2)

Cover Stock(2)

Glossy Laminated Paper Stock(2)

11 pt. Paper Stock(2)

Capacity Range [Max]

1/2"(52)

1"(1)

Back Cover Color(s)

Black(25)

Assorted(25)

Red(20)

Blue(15)

White(12)

Dark Blue(12)

Green(11)

Navy(8)

Gray(6)

Light Blue(6)

Yellow(5)

Teal(5)

Purple(4)

Hunter Green(3)

Burgundy(3)

Orange(3)

Pink(2)

Crimson(1)

Oyster(1)

Blue Gray(1)

Lavender(1)

Emerald Green(1)

Monaco Blue(1)

Natural(1)

Royal Blue(1)

Blue/Gold(1)

Clear/Assorted(1)

Translucent/Black(1)

Translucent/Navy(1)

Translucent Blue(1)

Gray/Green(1)

Blue/Orange(1)

Burgundy/Gold(1)

Green/Gold(1)

Translucent/Navy Blue(1)

Black/Gold(1)

Copper(1)

Capacity (text)

100 Sheets(79)

135 Sheets(21)

40 Sheets(9)

100 sheets(6)

150 Sheets(5)

200 Sheets(5)

70 Sheets(5)

180 Sheets(4)

50 Sheets(4)

60 Sheets(3)

110 Sheets(3)

250 Sheets(2)

125 Sheets(2)

20 Sheets(1)

Business Card Holder

Inside Front Cover(149)

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

Honeycomb Texture(1)

Leatherette Texture(1)

Leatherette Embossed(1)

Glossy(1)

Design

Contour Curves(6)

Marble(4)

Embossed Gold Foil Accents(4)

Embossed Pattern(2)

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

School Subjects(1)

Florals; Nature; Birds; Geometric(1)

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

Pocket Leaves Color(s)

Assorted(4)

Black(3)

White(2)

Red(2)

Translucent(2)

Blue(2)

Dark Blue(1)

Navy(1)

Inside Pockets

One Back, One Front(163)

One Back(6)

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)

Assorted(24)

Black(23)

Red(19)

Blue(14)

Dark Blue(12)

White(11)

Green(11)

Navy(8)

Clear(6)

Light Blue(6)

Gray(6)

Yellow(5)

Teal(5)

Purple(4)

Orange(3)

Burgundy(3)

Hunter Green(3)

Translucent/Navy Blue(2)

Pink(2)

Lavender(1)

Monaco Blue(1)

Blue Gray(1)

Crimson(1)

Clear/Oyster(1)

Clear/Black(1)

Natural(1)

Green/Gold(1)

Gray/Green(1)

Clear/Assorted(1)

Translucent/Black(1)

Translucent Blue(1)

Blue/Orange(1)

Black/Gold(1)

Copper(1)

Burgundy/Gold(1)

Blue/Gold(1)

Emerald Green(1)

Price Range

$0-$49.99(185)

$50-$99.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved