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

Currently Filtered by


Pendaflex

Refine Search

  GO
 
Category Filter

File Folders(181)

Hanging File Folders(129)

File Jackets/Sleeves/Wallets(127)

Classification Folders(50)

Pressboard Classification Folders(27)

File Guides(20)

File Inserts/Tabs(17)

Envelopes/Mailers(13)

Expandable File Folders(12)

Top Tab Manila Folders(10)

Expanding Pockets(10)

Indexed Sorters(9)

File Boxes(7)

Top Tab Fastener Folders(6)

Top Tab Colored Folders(4)

Document/Box Files(4)

Hanging File Folder Racks(4)

Storage Drawers & Accessories(4)

Hanging File Frames(4)

Expanding Files(4)

Portable Storage Files & Bins(3)

End Tab Folders(3)

Sheet Protectors(3)

Wallets(3)

Top Tab Poly Folders(2)

Magazine Files(2)

Manila Jackets(2)

End Tab Fastener Folders(2)

Poly Envelopes(2)

File Fasteners(1)

Color Jackets(1)

Hanging Folder Frames(1)

Copier/Laser/Inkjet Index Dividers(1)

Clips/Clamps(1)

Sorters(1)

Binder Pockets(1)

Top Tab Pressboard Folders(1)

End Tab Pockets(1)

Green Hanging Folders(1)

Hanging Pockets(1)

File Rails/Frames(1)

 
Brand

Pendaflex(673)

Pendaflex SureHook(3)

 
Color

Manila(17)

Blue(14)

Red(12)

Yellow(8)

Green(8)

Light Green(8)

Brown(7)

White(5)

Black(4)

Bright Red(3)

Dark Green(3)

Assorted(2)

Redrope(2)

Purple(2)

Magenta(2)

Orange(2)

Clear(2)

Standard Green(2)

Gray(2)

Stainless Steel(2)

Dark Blue(1)

Light Blue(1)

Multi(1)

Putty(1)

Black Marble(1)

Sky Blue(1)

Burgundy(1)

Lime(1)

Ice(1)

Red Fiber(1)

 
Recycled

Yes(84)

No(12)

 
Height

9.5"(56)

10"(23)

9 1/2"(14)

2"(10)

10.25"(8)

3"(8)

11"(6)

12"(5)

9"(5)

11.38"(3)

2 1/2"(3)

10.63"(3)

11 3/4"(2)

4 1/2"(2)

9.06"(2)

9.63"(2)

12 1/2"(2)

1 1/2"(2)

1/2"(2)

11.13"(2)

11.75"(2)

9 3/4"(2)

11 5/8"(2)

10.5"(1)

9.69"(1)

5"(1)

3.9"(1)

11.5"(1)

9.6"(1)

13 5/8"(1)

4.6"(1)

9 7/8"(1)

4.8"(1)

9.25"(1)

12 1/4"(1)

11.88"(1)

10 7/8"(1)

1 5/8"(1)

10.3"(1)

6.4"(1)

10 3/8"(1)

21/32"(1)

10.88"(1)

10.9"(1)

14"(1)

9 3/8"(1)

5 1/4"(1)

12.5"(1)

14 3/4"(1)

23.25"(1)

21"(1)

10 1/4"(1)

 
Color(s)

Red Fiber(37)

Redrope(29)

Manila(24)

Assorted(21)

Blue(18)

Brown(13)

Black(13)

Clear(10)

Red(9)

Green(8)

Yellow(5)

Violet(4)

Pink(3)

Orange(3)

Granite(3)

Dark Blue(3)

Bright Green(2)

Natural(2)

White(2)

Smoke(2)

Brown/White(1)

Lemon(1)

Limeade(1)

Grape(1)

Strawberry(1)

Blueberry(1)

Charcoal(1)

Assorted Prints(1)

Scarlet(1)

Assorted Tab Color(1)

Steel Gray(1)

Randomly Assorted(1)

Blue/Ice(1)

Blue/Silver(1)

Black/Orange(1)

Navy Blue(1)

Aqua(1)

Black/Silver(1)

Gray(1)

 
Depth

6"(4)

12.9"(3)

14"(2)

6.5"(2)

2.3"(1)

11"(1)

9"(1)

10"(1)

11 5/8"(1)

9.5"(1)

6.25"(1)

10.63"(1)

10.3"(1)

10 1/4"(1)

10.25"(1)

9.3"(1)

15.9"(1)

 
Size

Letter(113)

Legal(58)

Tabloid(1)

Letter/Legal(1)

 
Closure

Snap(7)

Zipper(5)

Hinged Lid(3)

Clasp(1)

Open Top(1)

Lift-Off Lid(1)

Latch-Lock Lid(1)

String & Button(1)

 
Expansion

1"(12)

2"(12)

1/2"(7)

3/4"(6)

1 3/4"(5)

1 1/2"(2)

2 1/2"(1)

0.13"(1)

1.5"(1)

Flat(1)

3 1/2"(1)

0.75"(1)

 
Envelope/Mailer Type

Specialty(1)

 
Envelope Size

Check(1)

 
Opening

Open Side(13)

 
 
 

© 2020-2021 NBJ Form & Function Inc. , All Rights Reserved