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

Manufacturer

Currently Filtered by

Manufacturer

Fellowes

Refine Search

  GO
Category

Storage Boxes & Containers(55)

Laminating Supplies(25)

Privacy Filters(22)

Mouse & Keyboard Wrist Rests(19)

Cross-Cut/Confetti-Cut Shredders(17)

Binding Covers(16)

Letter Trays(13)

Mouse Pads(13)

Storage Drawers & Accessories(12)

Shipping & Moving Boxes(11)

Binding Machines(11)

Keyboard/Mouse Platforms & Trays(11)

Laminating Machines(10)

Air Purifier/Humidifier Filters(9)

Monitor Arms(9)

Surge Protectors(9)

Binding Spines & Strips(9)

Desktop File Sorters(9)

Monitor Stands/Risers(8)

Micro-Cut Shredders(7)

Shredder Bags(7)

Desktop Copyholders(7)

Foot Rests(6)

Cubicle / Partition Organizers & Accessories(5)

Backrests & Seat Cushions(5)

Strip-Cut Shredders(5)

Wall Files, Pockets & Accessories(5)

Portable Storage Files & Bins(5)

Workstations/Computer Desks(4)

Extension Cords(4)

Power Strips(3)

Waste Containers & Accessories(3)

Desktop Organizers(3)

Air Purifiers/Cleaners/Humidifiers(3)

Desk Shelves(2)

CD/DVD Case Inserts(2)

CD/DVD Jewel Cases & Inserts(2)

LCD Monitor/Plasma Mounts(2)

Dry-Erase Boards(2)

Shredder Oil(2)

Catalog Racks(2)

Trash Bags & Liners(2)

Coat/Garment Hooks(2)

Magazine Files(2)

Paper Trimmers(2)

Mice(1)

Storage Binders(1)

Keyboards(1)

Utility/Service Carts(1)

Computer Cloths/Wipes & Dusters(1)

Air Dusters(1)

Computer Dust Covers(1)

Computer Stands & Pads(1)

Literature Organizers/Sorters(1)

Mice & Keyboard Bundles(1)

Multimedia Player Cases & Bags(1)

Mailing & Address Labels(1)

Printer/Fax Stands(1)

Report Covers(1)

Document/Box Files(1)

Book Stand(1)

Laptop Stands & Pads(1)

CPU Stands(1)

Copyholders(1)

Name Badge Holders(1)

Phone Stands(1)

Tool Kits(1)

Brand

Fellowes(319)

Bankers Box(89)

R-Kive(1)

Color

Black(183)

White(86)

Blue(72)

Clear(45)

Silver(23)

Gray(20)

Kraft(20)

Platinum(12)

Dark Silver(12)

Graphite(10)

Green(9)

Pearl(8)

Multicolor(5)

Crystal Clear(5)

Metallic Silver(4)

Wood Grain(3)

Dark Graphite(3)

Navy(2)

Sapphire(2)

Chrome(2)

Charcoal(2)

Dark Gray(2)

Clear Cover(1)

Black Spine(1)

Black Hook(1)

Opaque(1)

Metallic Gray(1)

Light Gray(1)

Red(1)

Light Amber(1)

Size

Letter(13)

A4(1)

Recycled

No(135)

Yes(113)

Price Range

$0-$499.99(380)

$500-$999.99(18)

$1000-$1499.99(2)

$1500-$1999.99(6)

$2000-$2499.99(2)

$3000-$3499.99(1)

To  GO

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

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