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') 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(184)

File Jackets/Sleeves/Wallets(130)

Hanging File Folders(129)

Classification Folders(51)

Pressboard Classification Folders(25)

File Guides(20)

File Inserts/Tabs(17)

Envelopes/Mailers(14)

Expandable File Folders(11)

Top Tab Manila Folders(10)

Expanding Pockets(10)

Indexed Sorters(9)

Top Tab Fastener Folders(7)

File Boxes(7)

Hanging File Frames(4)

Top Tab Colored Folders(4)

Expanding Files(4)

Storage Drawers & Accessories(4)

Document/Box Files(4)

Hanging File Folder Racks(4)

End Tab Folders(3)

Wallets(3)

Portable Storage Files & Bins(3)

Sheet Protectors(3)

Magazine Files(2)

End Tab Fastener Folders(2)

Poly Envelopes(2)

Top Tab Poly Folders(2)

Manila Jackets(2)

Classification Folders (Paper Stock)(2)

File Fasteners(1)

Hanging Folder Frames(1)

Color Jackets(1)

Copier/Laser/Inkjet Index Dividers(1)

File Rails/Frames(1)

Clips/Clamps(1)

Green Hanging Folders(1)

Hanging Pockets(1)

End Tab Pockets(1)

Out Guides(1)

Binder Pockets(1)

Top Tab Pressboard Folders(1)

Sorters(1)

 
Brand

Pendaflex(682)

Pendaflex SureHook(3)

 
Color

Manila(18)

Blue(14)

Red(12)

Green(8)

Light Green(8)

Yellow(8)

Brown(7)

White(5)

Black(4)

Bright Red(3)

Dark Green(3)

Redrope(2)

Magenta(2)

Orange(2)

Purple(2)

Stainless Steel(2)

Standard Green(2)

Gray(2)

Assorted(2)

Clear(2)

Lime(1)

Ice(1)

Red Fiber(1)

Burgundy(1)

Sky Blue(1)

Light Blue(1)

Putty(1)

Black Marble(1)

Dark Blue(1)

Multi(1)

 
Recycled

Yes(84)

No(14)

 
Height

9.5"(54)

10"(23)

9 1/2"(17)

2"(10)

3"(8)

10.25"(8)

11"(6)

9"(5)

12"(5)

11.38"(3)

2 1/2"(3)

12 1/2"(3)

10.63"(3)

1 1/2"(2)

11.13"(2)

1/2"(2)

9.63"(2)

11 3/4"(2)

9 3/8"(2)

9.06"(2)

11 5/8"(2)

4 1/2"(2)

9 3/4"(2)

11.75"(2)

5"(1)

9.6"(1)

13.63"(1)

5 1/4"(1)

11.5"(1)

9 7/8"(1)

4.6"(1)

10 1/4"(1)

3.9"(1)

9.25"(1)

10.5"(1)

4.8"(1)

9.69"(1)

11.88"(1)

12 1/4"(1)

14 3/4"(1)

10 3/8"(1)

10.9"(1)

10.88"(1)

10 7/8"(1)

14.50"(1)

6.4"(1)

21/32"(1)

10.3"(1)

14"(1)

21"(1)

23 1/4"(1)

1 5/8"(1)

 
Color(s)

Red Fiber(38)

Redrope(30)

Manila(24)

Assorted(20)

Blue(18)

Black(13)

Brown(13)

Clear(10)

Red(9)

Green(8)

Yellow(5)

Violet(4)

Dark Blue(3)

Orange(3)

Pink(3)

Granite(3)

Bright Green(2)

Smoke(2)

Natural(2)

White(2)

Charcoal(1)

Blueberry(1)

Assorted Prints(1)

Limeade(1)

Tangerine(1)

Lemon(1)

Assorted Tab Color(1)

Grape(1)

Strawberry(1)

Gray(1)

Black/Silver(1)

Navy Blue(1)

Black/Orange(1)

Steel Gray(1)

Scarlet(1)

Blue/Ice(1)

Blue/Silver(1)

Aqua(1)

Randomly Assorted(1)

 
Depth

6"(4)

12.9"(3)

14"(2)

6.5"(2)

2.3"(1)

9"(1)

15.9"(1)

11"(1)

9 1/2"(1)

10"(1)

10 5/8"(1)

9.3"(1)

6.25"(1)

8.50"(1)

10.25"(1)

10.3"(1)

10 1/4"(1)

11 5/8"(1)

 
Size

Letter(115)

Legal(58)

Letter/Legal(1)

Tabloid(1)

 
Closure

Snap(8)

Zipper(5)

Hinged Lid(3)

String & Button(1)

Latch-Lock Lid(1)

Open Top(1)

Lift-Off Lid(1)

Clasp(1)

 
Expansion

2"(12)

1"(12)

1/2"(7)

3/4"(6)

1 3/4"(5)

1 1/2"(2)

0.75"(1)

3 1/2"(1)

1.5"(1)

0.13"(1)

2 1/2"(1)

Flat(1)

 
Envelope/Mailer Type

Specialty(1)

 
Envelope Size

Check(1)

 
Opening

Open Side(14)

 
 
 

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