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(23)

Privacy Filters(22)

Cross-Cut/Confetti-Cut Shredders(18)

Mouse Pads(16)

Mouse & Keyboard Wrist Rests(16)

Binding Covers(14)

Letter Trays(13)

Storage Drawers & Accessories(12)

Keyboard/Mouse Platforms & Trays(11)

Shipping & Moving Boxes(11)

Binding Machines(10)

Laminating Machines(10)

Surge Protectors(9)

Monitor Arms(9)

Air Purifier/Humidifier Filters(9)

Binding Spines & Strips(9)

Desktop File Sorters(9)

Desktop Copyholders(7)

Micro-Cut Shredders(7)

Shredder Bags(7)

Monitor Stands/Risers(7)

Foot Rests(6)

Backrests & Seat Cushions(5)

Portable Storage Files & Bins(5)

Wall Files, Pockets & Accessories(5)

Cubicle / Partition Organizers & Accessories(5)

Strip-Cut Shredders(5)

Workstations/Computer Desks(4)

Extension Cords(4)

Desktop Organizers(3)

Power Strips(3)

Waste Containers & Accessories(3)

Air Purifiers/Cleaners/Humidifiers(3)

Desk Shelves(2)

Desks(2)

CD/DVD Jewel Cases & Inserts(2)

CD/DVD Case Inserts(2)

Dry-Erase Boards(2)

Magazine Files(2)

Coat/Garment Hooks(2)

Shredder Oil(2)

Trash Bags & Liners(2)

Catalog Racks(2)

Paper Trimmers(2)

Binding Systems Covers(2)

Keyboards(1)

Mice(1)

Tool Kits(1)

Storage Binders(1)

Mice & Keyboard Bundles(1)

Utility/Service Carts(1)

Air Dusters(1)

Towels & Wipes(1)

Computer Cloths/Wipes & Dusters(1)

Computer Dust Covers(1)

Literature Organizers/Sorters(1)

CPU Stands(1)

LCD Monitor/Plasma Mounts(1)

Laptop Stands & Pads(1)

Book Stand(1)

Document/Box Files(1)

Printer/Fax Stands(1)

Phone Stands(1)

Name Badge Holders(1)

Mailing & Address Labels(1)

Shredders(1)

Multimedia Player Cases & Bags(1)

Copyholders(1)

Report Covers(1)

Brand

Fellowes(316)

Bankers Box(84)

Office Suites(3)

Color

Black(183)

White(81)

Blue(69)

Clear(42)

Silver(23)

Gray(20)

Kraft(20)

Platinum(12)

Dark Silver(12)

Graphite(10)

Pearl(8)

Green(8)

Multicolor(5)

Crystal Clear(5)

Metallic Silver(4)

Wood Grain(3)

Dark Graphite(3)

Sapphire(2)

Navy(2)

Charcoal(2)

Dark Gray(2)

Chrome(2)

Black Spine(1)

Clear Cover(1)

Red(1)

Black Hook(1)

Opaque(1)

Light Amber(1)

Metallic Gray(1)

Size

Letter(13)

A4(1)

Recycled

No(134)

Yes(109)

Price Range

$0-$499.99(373)

$500-$999.99(19)

$1000-$1499.99(3)

$1500-$1999.99(5)

$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