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

Currently Filtered by

Category

Folder Frames And Sorters

Refine Search

  GO
 
Brand

Pendaflex(6)

Smead(4)

Business Source(3)

C-Line(2)

HON(2)

MMF(2)

OIC(2)

LEE(1)

SKILCRAFT(1)

 
Color

Gray(5)

Stainless Steel(4)

Silver(3)

Black(3)

Blue(1)

White(1)

 
Recycled

No(14)

Yes(9)

 
Height

7"(2)

2.50"(1)

10"(1)

11.75"(1)

9.8"(1)

9.3"(1)

 
Depth

11.4"(2)

1.50"(2)

23.5"(1)

11"(1)

16"(1)

 
Manufacturer Part Number

26(1)

98620(1)

89235(1)

64855(1)

64850(1)

AFF24(1)

50995(1)

44116(1)

40652(1)

11017(1)

11015(1)

91997(1)

36(1)

7520-00-286-1726(1)

2062TBK(1)

2061TBK(1)

14112(1)

919492(1)

919491(1)

30540(1)

30526(1)

60529(1)

89237(1)

 
Country of Origin

China(14)

United States(7)

Mexico(2)

 
Width

2.5"(2)

25.50"(1)

42"(1)

7"(1)

12.1"(1)

15.1"(1)

11.75"(1)

10"(1)

12.5"(1)

13"(1)

 
Material

Steel(7)

Metal(4)

Plastic(3)

Stainless Steel(1)

Aluminum(1)

 
Limited Warranty

1 Year(3)

Lifetime(3)

 
Weight (Approximate)

1.12 lb(1)

1.75 lb(1)

0.80 oz(1)

15.04 oz(1)

2.01 lb(1)

1.26 lb(1)

 
Length

24"(1)

 
Sheet Size

8 1/2" Width x 11" Length(1)

8 1/2" Width x 14" Length(1)

 
Media Size Supported

Letter(1)

Legal(1)

 
Exterior Material

Steel(2)

 
Tab Style

Printed(4)

 
Case Style

Bin(2)

 
Placement

Desktop(2)

 
Divider Width

8.5"(3)

 
Divider Length

11"(3)

 
Tab Title

A-Z(5)

0-31(1)

1-2000(1)

January-December(1)

Sunday-Saturday(1)

1-31(1)

 
Total Number of Tabs

20(3)

10(1)

 
Tab Material

Mylar(2)

Metal(1)

Vinyl(1)

 
Strength

Heavy Duty(2)

 
Mount Type

Drawer(1)

 
Total Number of Dividers

31(1)

10(1)

20(1)

 
Product Type

File Frame(9)

File Sorter(7)

File Rail(2)

Storage Case(2)

Drawer Organizer(1)

Desktop File Organizer(1)

Card Rack(1)

 
Packaged Quantity

1 Each(15)

6 Box(2)

2 Box(2)

4 / Pack(1)

2 / Pack(1)

6 / Box(1)

 
Assembly Required

No(11)

Yes(3)

 
Product Model

2061(1)

2062(1)

 
Product Line

Steelmaster(2)

 
Compartment Width

9.50"(1)

 
Divider Color

Blue(4)

Red(1)

Multicolor(1)

 
Divider Material

Pressboard(1)

 
Tab Color

Multicolor(2)

 
Item Capacity

12(1)