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

Laminating Supplies(25)

Privacy Filters(22)

Cross-Cut/Confetti-Cut Shredders(17)

Mouse & Keyboard Wrist Rests(17)

Binding Covers(16)

Letter Trays(14)

Mouse Pads(12)

Storage Drawers & Accessories(12)

Shipping & Moving Boxes(11)

Binding Machines(11)

Keyboard/Mouse Platforms & Trays(11)

Surge Protectors(9)

Laminating Machines(9)

Desktop File Sorters(8)

Binding Spines & Strips(8)

Monitor Stands/Risers(8)

Monitor Arms(8)

Magazine Files(7)

Portable Storage Files & Bins(7)

Shredder Bags(7)

Micro-Cut Shredders(7)

Air Purifier/Humidifier Filters(6)

Desktop Copyholders(5)

Foot Rests(5)

Wall Files, Pockets & Accessories(5)

Cubicle / Partition Organizers & Accessories(5)

Backrests & Seat Cushions(4)

Strip-Cut Shredders(4)

Extension Cords(4)

Workstations/Computer Desks(4)

Air Purifiers/Cleaners/Humidifiers(3)

Waste Containers & Accessories(3)

Power Strips(3)

CD/DVD Case Inserts(2)

LCD Monitor/Plasma Mounts(2)

Desktop Organizers(2)

Shredder Oil(2)

CD/DVD Jewel Cases & Inserts(2)

Trash Bags & Liners(2)

Catalog Racks(2)

Coat/Garment Hooks(2)

Desk Shelves(2)

Computer Dust Covers(1)

Mice & Keyboard Bundles(1)

CPU Stands(1)

Mice(1)

Computer Cloths/Wipes & Dusters(1)

Keyboards(1)

Air Dusters(1)

Document/Box Files(1)

Tool Kits(1)

Book Stand(1)

Storage Binders(1)

Literature Organizers/Sorters(1)

Utility/Service Carts(1)

Name Badge Holders(1)

Report Covers(1)

Copyholders(1)

Phone Stands(1)

Laptop Stands & Pads(1)

Printer/Fax Stands(1)

Mailing & Address Labels(1)

Brand

Fellowes(299)

Bankers Box(94)

R-Kive(1)

Color

Black(176)

White(81)

Blue(75)

Clear(45)

Silver(21)

Kraft(20)

Gray(17)

Dark Silver(11)

Platinum(10)

Green(10)

Graphite(9)

Pearl(7)

Crystal Clear(5)

Metallic Silver(4)

Dark Graphite(3)

Sapphire(2)

Dark Gray(2)

Chrome(2)

Charcoal(2)

Navy(2)

Multicolor(2)

Wood Grain(2)

Purple(2)

Red(2)

Black Spine(1)

Light Gray(1)

Clear Cover(1)

Yellow(1)

Orange(1)

Black Hook(1)

Assorted(1)

Light Amber(1)

Opaque(1)

Metallic Gray(1)

Size

Letter(13)

A4(1)

Recycled

No(129)

Yes(113)

Price Range

$0-$499.99(366)

$500-$999.99(17)

$1000-$1499.99(3)

$1500-$1999.99(5)

$2000-$2499.99(2)

$3500-$3999.99(1)

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