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

Currently Filtered by


Smead

Refine Search

  GO
 
Category Filter

File Folders(329)

File Jackets/Sleeves/Wallets(231)

Classification Folders(141)

Labels(101)

Hanging File Folders(66)

Report Covers(42)

Pocket Folders(36)

File Guides(34)

Pressboard Classification Folders(15)

Envelopes/Mailers(13)

Top Tab Fastener Folders(12)

Top Tab Colored Folders(12)

Pocket Portfolios/Folders(10)

Expanding Pockets(9)

File Inserts/Tabs(8)

Boards(7)

Manila Jackets(7)

File Fasteners(6)

Color Jackets(6)

Label Holders(5)

Expanding Files(5)

Poly Expanding Files(4)

Hanging Accessories(4)

Wallets(4)

Expandable File Folders(4)

Hanging File Frames(4)

End Tab Classification Folders(4)

End Tab Pockets(3)

Indexed Sorters(3)

Vinyl/Plastic Pockets & Sleeves(3)

Pressboard Guides(3)

Color Hanging Folders(3)

Portfolios(2)

Hanging Box Bottom Folders(2)

Top Tab Manila Folders(2)

End Tab Fastener Folders(2)

Hanging Pockets(2)

Pad Folios(2)

Label Protectors(2)

Binding Index Dividers(1)

Hanging File Systems(1)

Poly Jackets(1)

Binder Pockets(1)

Index Dividers(1)

Sorters(1)

End Tab Accessories(1)

Manila Guides(1)

End Tab Folders(1)

Top Tab Pressboard Folders(1)

Interior Folders(1)

Hanging Folder Frames(1)

Top Tab Accessories(1)

Desktop File Sorters(1)

Media Storage Cases/Drawers/Wallets(1)

Media Sleeves(1)

Document/Box Files(1)

 
Brand

Smead(1165)

 
Color

Blue(25)

Red(18)

Yellow(17)

Green(15)

Manila(14)

Black(13)

Redrope(8)

Dark Blue(7)

Aqua(6)

Purple(6)

Pink(6)

Gray(6)

Goldenrod(5)

Moss(4)

White(4)

Lavender(2)

Clear(2)

Orange(2)

Steel Gray(2)

Assorted(1)

Navy(1)

Maroon(1)

Dark Pink(1)

Cool Gray(1)

Bright Red(1)

Light Green(1)

Kraft(1)

Monaco Blue(1)

 
Recycled

Yes(99)

No(36)

 
Height

9.5"(145)

10"(69)

9 1/2"(36)

11 1/2"(10)

10.25"(6)

9.88"(5)

11.75"(4)

11 3/4"(4)

1.25"(3)

8 3/4"(2)

11.25"(2)

5"(2)

12"(2)

0.5"(2)

9 1/4"(2)

14"(2)

9"(1)

14 3/4"(1)

10 7/8"(1)

11.5"(1)

9 3/8"(1)

9 3/4"(1)

6"(1)

14.5"(1)

11 7/8"(1)

9.3"(1)

12 1/4"(1)

9.25"(1)

4"(1)

8.5"(1)

13.63"(1)

11.3"(1)

10 1/4"(1)

 
Color(s)

Redrope(94)

Manila(43)

Assorted(20)

Clear(15)

Blue(10)

Red(7)

Navy Blue(6)

Yellow(6)

Green(6)

Black(4)

Redrope/Red(4)

Redrope/Dark Brown(4)

Redrope/Blue(4)

Brown(4)

White/Clear(3)

Kraft(3)

Redrope/Green(2)

Redrope/Yellow(2)

White(2)

Transparent Red(2)

Transparent Blue(2)

Transparent Green(2)

Purple(2)

Navy(2)

Translucent Green(1)

Gray/Assorted Bright Color Pockets(1)

Translucent Purple(1)

Transparent Purple(1)

Lake Blue/Navy Blue(1)

Silver(1)

Translucent Blue(1)

Green Tea(1)

Opaque Clear(1)

Orange, White(1)

Assorted Earth Tones(1)

Gray(1)

Aqua(1)

Gray/Green(1)

Gray-Green(1)

Assorted Brights(1)

Navy/White(1)

Black/Blue(1)

Black/Red(1)

Monaco Blue/White(1)

Blue Moon(1)

Black/Multicolor(1)

Blue/Black(1)

Teal(1)

Vibrant Orange/White(1)

 
Depth

1 1/8"(1)

5 1/16"(1)

 
Size

Letter(149)

Legal(80)

Small Format(3)

Variety Pack(1)

Letter/Legal(1)

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

9 x 5 9/16(1)

4 1/16 x 3(1)

X-Ray(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 & Button(10)

Fold Flap(3)

Top Flap(1)

 
Expansion

2"(13)

1.25"(12)

0.5"(10)

Scored for 3/4" expansion(5)

1"(4)

1.5"(4)

Flat(2)

0.75"(2)

3/4"(1)

No(1)

 
Envelope/Mailer Type

Catalog/Booklet(1)

 
Opening

Open End(7)

Open Side(6)

 
 
 

© 2019-2020 Dependable Office Supply, All Rights Reserved