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

Currently Filtered by

Manufacturer

SMEAD MANUFACTURING CO

Refine Search

  GO
 
Category Filter

File Folders(335)

Expandable File Folders(181)

Classification Folders(136)

Labels(122)

Hanging File Folders(87)

File Jackets/Sleeves/Wallets(54)

Pocket Folders(44)

Report Covers(41)

File Guides(38)

Envelopes/Mailers(10)

File Inserts/Tabs(8)

File Fasteners(6)

Label Holders(4)

Indexed Sorters(3)

Hanging File Frames(3)

Cables(3)

Cable Management(3)

Sheet Protectors(2)

Label Protectors(2)

Binder Pockets(1)

Index Dividers(1)

Software(1)

Media Sleeves(1)

 
Brand

Smead(1087)

 
Color

Manila(1)

 
Recycled

No(1)

 
Height

9 1/2"(424)

10"(60)

9 15/16"(18)

9 3/16"(17)

10 1/4"(8)

11 3/4"(6)

11 5/8"(5)

9 7/8"(5)

1 1/4"(3)

12"(2)

8 3/4"(2)

3/4"(2)

5"(2)

11 1/2"(2)

9"(2)

11 1/4"(2)

1/2"(2)

14 3/4"(1)

Add:10"(1)

9 1/4"(1)

6 3/8"(1)

8 5/8"(1)

9.5"(1)

14 1/2"(1)

13 5/8"(1)

14"(1)

6"(1)

 
Color(s)

Manila(174)

Redrope(74)

Assorted(57)

Blue(41)

Green(33)

Yellow(32)

Red(31)

Standard Green(30)

Gray-Green(25)

Redrope Printed(23)

Clear(15)

Kraft(15)

Orange(10)

Purple(9)

Black(9)

Navy Blue(8)

Brown(7)

Gray(7)

White(7)

Pink(7)

Gray/Green(7)

Lavender(7)

Moss(6)

Sky Blue(6)

Teal(5)

Maroon(4)

Dark Brown(4)

Goldenrod(4)

Clear Tabs; White Inserts(3)

Navy(3)

Bright Red(3)

Transparent Blue(2)

Transparent Clear(2)

Steel Gray(2)

Aqua(2)

Assorted Earth Tones(2)

Dark Blue(2)

Transparent Green(2)

Transparent Red(2)

Translucent Blue(1)

Translucent Purple(1)

Translucent Green(1)

Transparent Purple(1)

Lake Blue/Navy Blue(1)

Assorted Bright Tones(1)

Blue/Clear(1)

Assorted Brights(1)

Orange, White(1)

Opaque Clear(1)

Tan(1)

Gopher Green(1)

Black/Assorted(1)

Silver(1)

Black/Blue(1)

Blue Moon(1)

Green Tea(1)

Natural Brown(1)

 
Depth

3 3/4"(2)

5 1/16"(1)

 
Quantity

25 per box(30)

1 each(27)

5 per pack(19)

100 per box(14)

50 per box(11)

25 per set(9)

250 per pack(8)

250 per roll(7)

500 per roll(7)

10 per pack(6)

25 per pack(3)

2 per pack(3)

31 per set(2)

100 per pack(2)

160 per pack(1)

5 per set(1)

3 per pack(1)

18 per pack(1)

12 per set(1)

45 per pack(1)

500 per box(1)

120 per pack(1)

25 set(1)

 
Size

Letter(522)

Legal(264)

9 x 5 9/16(1)

12 x 5(1)

6 1/4 x 4 9/16(1)

Legal/Letter(1)

4 1/16 x 3(1)

9 x 6 Card Size(1)

3 1/2 x 1 11/16(1)

8 x 1 11/16(1)

5 5/16 x 3 5/8(1)

 
Closure

String and Button(9)

Top Flap(1)

Male/Female(1)

 
Expansion

Scored for 3/4" expansion(259)

2"(144)

1"(33)

3"(32)

1 1/4"(14)

Flat(13)

1 1/2"(12)

3 1/2"(9)

3/4"(7)

5 1/4"(5)

1 3/4"(4)

1/2"(3)

Scored for 1/2" expansion(2)

No(1)

1" - 3"(1)

3/4" each section(1)

 
Envelope/Mailer Type

Expanding Envelope(9)

Business/Trade(1)

 
Envelope Size

9 3/4" x 11 5/8"(9)

 
Opening

Open End(5)

Open Side(4)

 
 
 

© 2019-2020 Onestop, Inc., All Rights Reserved