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

Currently Filtered by

Category

Classification Folders

Refine Search

  GO
 
Brand

Smead(124)

Pendaflex(28)

ACCO(19)

 
Special Features

2/5 Cut Right of Center Position Self Tabs on Cover(12)

Embedded Fasteners(8)

With Twin-Prong Fasteners(2)

Bottom Tab(2)

With 5 1/2" High Pockets on Both Sides(1)

Bonded Fasteners(1)

With Prepunched Slits for Twin-Prong Fasteners (sold separately)(1)

Side Tab(1)

1/3 Cut Assorted Position Metal Tabs on Cover-Flat metal tab.(1)

 
Divider Color

Natural Brown(131)

Manila(30)

 
Divider Material

17-pt Kraft(86)

20-pt Kraft(19)

18-pt Manila(16)

20-pt Fiberboard(14)

11-pt Kraft(12)

14-pt Manila(2)

11-pt Manila(2)

Polypropylene(1)

 
Cover Color

Red(25)

Green(21)

Gray-Green(20)

Blue(18)

Yellow(14)

Bright Red(11)

Dark Blue(11)

Manila(8)

Earth Red(6)

Leaf Green(5)

Sky Blue(4)

Light Green(4)

Pale Green(3)

Light Blue(2)

Mist Gray(2)

Dark Gray(1)

Executive Red(1)

Scarlet(1)

 
Total Number of Dividers

2(87)

1(40)

3(25)

 
Cover Material

25-pt Pressboard(76)

23-pt Pressboard(48)

14-pt Stock(10)

11-pt Manila(9)

20-pt PressGuard(8)

18-pt Manila(6)

11-pt Stock(4)

15-pt Pressboard(2)

23-pt Linen Stock(2)

Polypropylene(1)

 
Folder Material

23-pt Pressboard Cover; 17-pt Kraft Divider(2)

25-pt Pressboard Exterior; 20-pt Pressboard Interior(2)

 
Manufacturer Part Number

19035(1)

19075(1)

19076(1)

19079(1)

19034(1)

19033(1)

19023(1)

19030(1)

19031(1)

19081(1)

19082(1)

19094(1)

19095(1)

19096(1)

19097(1)

19093(1)

19092(1)

19083(1)

19084(1)

19091(1)

19022(1)

19000(1)

14096(1)

14097(1)

14098(1)

14099(1)

14095(1)

14094(1)

14091(1)

14092(1)

14093(1)

14575(1)

15003(1)

18734(1)

18775(1)

18776(1)

18733(1)

18732(1)

18700(1)

18730(1)

18731(1)

19098(1)

19099(1)

29855(1)

29860(1)

34220(1)

35511(1)

29820(1)

29810(1)

29785(1)

29789(1)

29800(1)

35521(1)

35600(1)

68025(1)

68027(1)

68030(1)

78208(1)

68021(1)

65115(1)

35605(1)

35650(1)

65105(1)

29784(1)

29783(1)

26785(1)

26789(1)

26800(1)

26810(1)

26784(1)

26783(1)

19230(1)

26710(1)

26781(1)

26820(1)

26825(1)

26865(1)

29710(1)

29781(1)

26860(1)

26855(1)

26835(1)

26836(1)

26837(1)

14084(1)

14083(1)

1257Y(1)

17173(1)

17178(1)

2157G(1)

1257SC(1)

1257R(1)

1257G(1)

1257GR(1)

1257LB(1)

2157R(1)

2257BL(1)

23314(1)

23324(1)

59225(1)

59251(1)

23224(1)

2257R(1)

2257G(1)

2257GR(1)

2257LB(1)

1257BL(1)

1157R(1)

15046(1)

15048(1)

15056(1)

15663(1)

15044(1)

15038(1)

15026(1)

15034(1)

15036(1)

15669(1)

16024(1)

16046(1)

16056(1)

1157G(1)

16044(1)

16038(1)

16026(1)

16034(1)

16036(1)

59253(1)

59254(1)

14030(1)

14031(1)

14032(1)

14033(1)

14024(1)

14023(1)

14004(1)

14010(1)

14011(1)

14034(1)

14045(1)

14076(1)

14079(1)

14081(1)

14082(1)

14075(1)

14064(1)

14061(1)

14062(1)

14063(1)

14003(1)

14002(1)

13702(1)

13703(1)

13704(1)

13723(1)

13701(1)

13700(1)

59352(1)

FP213(1)

FP313(1)

13724(1)

13730(1)

13776(1)

14000(1)

14001(1)

13775(1)

13734(1)

13731(1)

13732(1)

13733(1)

15024(1)

 
Country of Origin

US(131)

MX(39)

CN(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved