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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`manufacturer_id` = "1700290") 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 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

Manufacturer

Currently Filtered by

Manufacturer

Smead

Refine Search

  GO
Category

Pressboard Classification Folders(82)

Top Tab Colored Folders(75)

Top Tab Fastener Folders(69)

Expanding Pockets(57)

End Tab Accessories(56)

Top Tab Manila Folders(52)

Color Hanging Folders(33)

End Tab Fastener Folders(33)

Report Covers(32)

End Tab Classification Folders(31)

Wallets(27)

Expanding Files(25)

End Tab Pockets(25)

End Tab Folders(23)

Manila Jackets(17)

Color Jackets(16)

Portfolios(16)

Top Tab Pressboard Folders(16)

Interior Folders(16)

Filing Labels & Systems(14)

Green Hanging Folders(14)

Classification Folders (Paper Stock)(14)

Multipurpose Labels(13)

Hanging Accessories(12)

Pressboard Guides(12)

Poly Envelopes(11)

Top Tab Accessories(11)

Hanging Pockets(11)

Hanging Box Bottom Folders(11)

Pocket Portfolios/Folders(10)

Vinyl/Plastic Pockets & Sleeves(9)

Poly Jackets(7)

Out Guides(7)

Top Tab Poly Folders(6)

Poly Expanding Files(5)

Manila Guides(4)

Paper Fasteners(4)

End Tab Jackets(3)

Sorters(3)

Pad Folios(2)

Hanging Classification Folders(2)

Hanging Folder Frames(2)

Dry-Erase Boards(2)

Bulletin Boards(2)

End Tab Pressboard Folders(2)

Desktop File Sorters(2)

Binding Index Dividers(1)

Copier/Laser/Inkjet Index Dividers(1)

Tabletop Sorters/Racks(1)

Catalog Stands & Frames(1)

Document/Box Files(1)

Poly Classification Folders(1)

Media Storage Cases/Drawers/Wallets(1)

Brand

Smead(898)

Justick(5)

Color

Manila(153)

Green(139)

Blue(124)

Red(113)

Yellow(96)

Redrope(71)

Gray(69)

Black(30)

Dark Blue(29)

Purple(29)

Standard Green(22)

Pink(21)

Orange(20)

Clear(17)

Lavender(17)

Bright Red(17)

Moss(11)

Kraft(10)

White(9)

Brown(8)

Aqua(8)

Assorted(7)

Teal(7)

Dark Green(6)

Navy(6)

Dark Brown(6)

Goldenrod(6)

Light Green(5)

Sky Blue(5)

Maroon(5)

Navy Blue(5)

Dark Orange(4)

Light Orange(4)

Violet(3)

Light Blue(3)

Light Brown(2)

Monaco Blue(2)

Steel Gray(2)

Lime(1)

Smoke(1)

Cool Gray(1)

Dark Gray(1)

Lake Blue(1)

Camel(1)

Dark Pink(1)

Natural Brown(1)

Size

Letter(560)

Legal(220)

Ledger(2)

Statement(1)

Recycled

Yes(716)

No(186)

Price Range

$0-$99.99(874)

$100-$199.99(25)

$200-$299.99(2)

$300-$399.99(2)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2019-2020 Granite Office, LLC, All Rights Reserved