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

Currently Filtered by

Category

Folders

Refine Search

  GO
 
Brand

Smead(9)

C-Line(8)

Carson-Dellosa(3)

Ashley(2)

Sparco(2)

Tatco(2)

Avery®(1)

Business Source(1)

CLI(1)

Pacon(1)

 
Color

Clear(7)

Blue(5)

Multi-colored(3)

Black(3)

Red(3)

Off White(2)

Yellow(2)

White(2)

Assorted(1)

Manila(1)

Green(1)

Pink(1)

Lime(1)

Purple(1)

 
Recycled

No(27)

Yes(1)

 
Height

11 3/4"(4)

1"(2)

4.3"(1)

4.8"(1)

9"(1)

18.5"(1)

11.3"(1)

10"(1)

 
Depth

2.5"(1)

1"(1)

6.5"(1)

12"(1)

 
Manufacturer Part Number

10400(1)

20060(1)

52006(1)

99820(1)

99819(1)

89614(1)

89206(1)

87723(1)

87722(1)

68185(1)

68180(1)

68164(1)

68153(1)

68123(1)

29130(1)

10403(1)

70058(1)

41922(1)

40620(1)

33936(1)

33935(1)

33934(1)

33933(1)

33931(1)

136006(1)

136003(1)

136002(1)

16518(1)

72260(1)

52012(1)

 
Country of Origin

China(23)

Denmark(4)

Taiwan(2)

United States(1)

 
Width

9.4"(5)

9 1/2"(3)

12.5"(1)

19"(1)

12"(1)

14.5"(1)

6"(1)

10 1/2"(1)

11 3/4"(1)

6.5"(1)

9.5"(1)

 
Material

Polypropylene(9)

Poly(6)

Plastic(4)

Vinyl(2)

Polyester(1)

 
Limited Warranty

1 Year(2)

 
Weight (Approximate)

0.11 oz(1)

0.18 oz(1)

0.26 oz(1)

0.44 oz(1)

 
Shape

Rectangular(6)

Rectangle(1)

 
Sheet Size

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

9" Width x 12" Length(1)

5" Width x 8" Length(1)

 
Sheet Capacity

50(2)

 
Tab Cut

1/3(2)

Straight(1)

 
Thickness

100 mil(5)

 
Placement

Wall Mount(1)

 
Total Number of Pockets

8(2)

6(1)

24(1)

1(1)

 
Pocket Location

Inside Back(1)

 
Number of Plys

1(1)

 
Number of Holes Punched

3(6)

 
Number of Dividers

12(1)

 
Supported Binder Type

Ring Binder(6)

 
Media Type Capacity

20 Sheet(1)

 
Product Type

Folder Pocket(10)

Organizer Folder(7)

Dry Erase Pocket(4)

Nameplate Sleeve(2)

Vinyl File Pocket(2)

Organizer Pocket(2)

File Insert(1)

Storage Folder(1)

File Pocket(1)

 
Packaged Quantity

25 / Box(6)

1 Each(5)

6 / Pack(4)

100 / Box(4)

25(2)

50 / Box(2)

15 / Box(1)

10 / Set(1)

5 / Pack(1)

1 / Each(1)

3 / Pack(1)

12 / Set(1)

30 / Set(1)

 
Assembly Required

No(7)

 
Product Model

CLI-33931(1)

CLI-33933(1)

CLI-33934(1)

CLI-33935(1)

CLI-33936(1)

 
Product Line

Organized Up(2)

Stick-N-Store(1)

 
Frame Color

Assorted(2)

Red(1)

Orange(1)

Yellow(1)

Green(1)

Blue(1)

 
Fastener Type

Spiral(1)

 
Folder Thickness

14 pt.(1)

 
Tab Position

Assorted Position(1)

 
Expansion Size

1/2"(1)