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

Top Tab Colored Folders(83)

Pressboard Classification Folders(83)

Top Tab Fastener Folders(78)

Expanding Pockets(64)

Top Tab Manila Folders(58)

End Tab Accessories(53)

File Jackets/Sleeves/Wallets(43)

Report Covers(43)

File Folders(41)

Color Hanging Folders(39)

Wallets(36)

End Tab Fastener Folders(35)

Expanding Files(30)

End Tab Classification Folders(25)

End Tab Folders(24)

End Tab Pockets(23)

Portfolios(22)

Manila Jackets(20)

Labels(17)

Pocket Folders(16)

Top Tab Pressboard Folders(16)

Interior Folders(16)

Multipurpose Labels(16)

Color Jackets(15)

Hanging Pockets(15)

Poly Envelopes(14)

Green Hanging Folders(14)

Classification Folders (Paper Stock)(14)

Filing Labels & Systems(14)

Pocket Portfolios/Folders(12)

Pressboard Guides(12)

Hanging Accessories(12)

Classification Folders(11)

Hanging Box Bottom Folders(10)

Vinyl/Plastic Pockets & Sleeves(10)

Top Tab Accessories(10)

Hanging File Folders(9)

Top Tab Poly Folders(8)

Poly Jackets(8)

Manila Guides(8)

Out Guides(8)

File Guides(8)

Paper Fasteners(5)

Poly Expanding Files(5)

Boards(4)

End Tab Jackets(3)

Sorters(3)

Hanging Folder Frames(2)

Desktop File Sorters(2)

Hanging Classification Folders(2)

End Tab Pressboard Folders(2)

Pad Folios(2)

Binding Index Dividers(1)

Copier/Laser/Inkjet Index Dividers(1)

Tabletop Sorters/Racks(1)

Hanging File Systems(1)

Hanging File Frames(1)

File Fasteners(1)

Poly Classification Folders(1)

File Inserts/Tabs(1)

Media Storage Cases/Drawers/Wallets(1)

Document/Box Files(1)

Expandable File Folders(1)

 
Brand

Smead(1137)

 
Color

Manila(162)

Green(152)

Blue(133)

Red(126)

Yellow(100)

Redrope(79)

Gray(71)

Black(40)

Purple(34)

Dark Blue(28)

Standard Green(25)

Pink(22)

Orange(22)

Clear(20)

Lavender(17)

Bright Red(17)

White(15)

Moss(14)

Kraft(12)

Teal(10)

Assorted(9)

Navy(8)

Brown(8)

Aqua(8)

Goldenrod(6)

Sky Blue(6)

Dark Brown(6)

Navy Blue(5)

Maroon(5)

Dark Green(5)

Light Green(5)

Light Orange(4)

Dark Orange(4)

Light Blue(3)

Light Brown(2)

Camel(2)

Monaco Blue(2)

Oyster(2)

Violet(2)

Lake Blue(2)

Steel Gray(2)

Dark Pink(1)

Cool Gray(1)

Green Tea(1)

Blue Moon(1)

Lime(1)

Natural Brown(1)

Smoke(1)

Turquoise(1)

Bright Purple(1)

Bright Green(1)

Bright Blue(1)

Dark Gray(1)

Gold(1)

Crystal Clear(1)

Bright Pink(1)

 
Size

Legal(20)

Letter(20)

Small Format(2)

X-Ray(1)

 
Size

Letter(620)

Legal(232)

Ledger(3)

Statement(1)

Letter/Legal(1)

Tabloid(1)

 
Recycled

Yes(770)

No(210)

 
Sheet Size

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

8 1/2" Width x 14" Length(227)

11 x 8 1/2(16)

11" Width x 17" Length(4)

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

10" Width x 12" Length(2)

3" Width x 5" Length(2)

3 1/4" Width x 9 1/4" Length(1)

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

1 1/4" Width x 3 1/2" Length(1)

11 x 17(1)

8 1/2 x 14(1)

14 3/8" Width x 9" Length(1)

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

6" Width x 4" Length(1)

12 3/8" Width x 10" Length(1)

11 3/4" Width x 9 1/2" Length(1)

3 1/2" Width x 2" Length(1)

 
 
 

© 2019-2020 Swaim Office Products, All Rights Reserved