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

Currently Filtered by

Manufacturer

Fellowes

Refine Search

  GO
 
Category

Storage Boxes & Containers(72)

Laminating Supplies(38)

Mouse Pads(29)

Mouse & Keyboard Wrist Rests(28)

Cross-Cut/Confetti-Cut Shredders(26)

Binding Covers(26)

Binding Spines & Strips(26)

Privacy Filters(24)

Letter Trays(15)

Keyboard/Mouse Platforms & Trays(14)

Storage Drawers & Accessories(14)

Binding Machines(13)

Desktop File Sorters(13)

Shipping & Moving Boxes(13)

Laminating Machines(13)

Surge Protectors(11)

Monitor Stands/Risers(10)

Cubicle / Partition Organizers & Accessories(10)

Air Purifier/Humidifier Filters(10)

Desktop Copyholders(9)

Literature Organizers/Sorters(8)

Foot Rests(7)

Shredder Bags(7)

Monitor Arms(7)

Magazine Files(7)

Desktop Organizers(7)

Laptop Stands & Pads(7)

Micro-Cut Shredders(6)

Wall Files, Pockets & Accessories(6)

Strip-Cut Shredders(6)

Extension Cords(5)

Multimedia Player Cases & Bags(5)

CD/DVD Case Inserts(5)

Backrests & Seat Cushions(5)

Paper Trimmers(4)

Mice(4)

Waste Containers & Accessories(3)

Coat/Garment Hooks(3)

Power Strips(3)

Portable Storage Files & Bins(3)

Utility/Service Carts(3)

Keyboards(3)

Air Purifiers/Cleaners/Humidifiers(3)

Air Dusters(3)

Nameplates(2)

Dry-Erase Boards(2)

Workstations/Computer Desks(2)

Desk Shelves(2)

CD/DVD Jewel Cases & Inserts(2)

Trash Bags & Liners(2)

Tabletop Sorters/Racks(2)

Shredder Oil(2)

Pencil Holders(2)

Catalog Racks(2)

Document/Box Files(2)

Report Covers(2)

Desktop Risers(2)

Computer Stands & Pads(2)

Top Tab Accessories(1)

Top Tab Colored Folders(1)

Media Storage Cases/Drawers/Wallets(1)

Multimedia Player Holders & Clips(1)

Mobile File Carts & Cabinets(1)

Mice & Keyboard Bundles(1)

Binder Clips(1)

Computer Cloths/Wipes & Dusters(1)

Phone Cleaners(1)

Computer Dust Covers(1)

Notes Holders / Dispensers(1)

Cubicle Hooks/Clips(1)

Book Stand(1)

Back Supports(1)

CPU Stands(1)

Paper Trimmer Replacement Blades(1)

LCD Monitor/Plasma Mounts(1)

Cutting Mats(1)

Paper Clip Holders(1)

Printer/Fax Stands(1)

Tape Dispensers(1)

Phone Stands(1)

Copyholders(1)

Tool Kits(1)

Storage Binders(1)

Wall Organizer Systems(1)

Name Badge Holders(1)

Cleaning Wipes(1)

Telephone Stands & Holders(1)

 
Brand

Fellowes(465)

Bankers Box(117)

Office Suites(9)

 
Color

Black(215)

White(111)

Blue(89)

Clear(61)

Silver(41)

Gray(27)

Kraft(27)

Graphite(17)

Platinum(13)

Multicolor(11)

Green(11)

Dark Graphite(11)

Pearl(9)

Navy(8)

Purple(5)

Crystal Clear(5)

Dove Gray(5)

Wood Grain(5)

Charcoal(4)

Metallic Silver(4)

Chrome(3)

Red(3)

Sapphire(3)

Medium Oak(2)

Clear Cover(2)

Orange(2)

Slate Gray(1)

Black Spine(1)

Dark Graphite Hook(1)

Assorted(1)

Light Amber(1)

Yellow(1)

Black Hook(1)

Opaque(1)

Translucent(1)

Metallic Gray(1)

Transparent(1)

Light Gray(1)

 
Size

Letter(30)

 
Recycled

No(205)

Yes(154)

 
Sheet Size

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

8 3/4" Width x 11 1/4" Length(6)

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

8 3/4" Width x 11" Length(1)

 
 
 

© 2017-2018 Jiorle's Office Supplies, All Rights Reserved