Banner1 Banner1
 
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(56)

Laminating Supplies(24)

Mouse Pads(23)

Mouse & Keyboard Wrist Rests(23)

Privacy Filters(22)

Cross-Cut/Confetti-Cut Shredders(18)

Binding Covers(17)

Binding Spines & Strips(14)

Letter Trays(14)

Keyboard/Mouse Platforms & Trays(12)

Storage Drawers & Accessories(12)

Binding Machines(11)

Laminating Machines(11)

Shipping & Moving Boxes(11)

Desktop File Sorters(11)

Cubicle / Partition Organizers & Accessories(9)

Monitor Arms(9)

Surge Protectors(9)

Air Purifier/Humidifier Filters(9)

Desktop Copyholders(8)

Monitor Stands/Risers(8)

Micro-Cut Shredders(7)

Foot Rests(7)

Shredder Bags(7)

Strip-Cut Shredders(6)

Wall Files, Pockets & Accessories(5)

Backrests & Seat Cushions(5)

Portable Storage Files & Bins(5)

Desktop Organizers(4)

Extension Cords(4)

Workstations/Computer Desks(4)

Power Strips(3)

Air Purifiers/Cleaners/Humidifiers(3)

Waste Containers & Accessories(3)

Trash Bags & Liners(2)

CD/DVD Case Inserts(2)

Desk Shelves(2)

Nameplates(2)

Dry-Erase Boards(2)

CD/DVD Jewel Cases & Inserts(2)

Paper Trimmers(2)

Pencil Holders(2)

Shredder Oil(2)

Catalog Racks(2)

Magazine Files(2)

Desks(2)

Utility/Service Carts(2)

Coat/Garment Hooks(2)

Binding Systems Covers(2)

Laminator Supplies(1)

Book Stand(1)

CPU Stands(1)

Mouse Pads & Wrist Rests(1)

Desktop File Folder Sorters(1)

Media Sleeves(1)

Name Badge Holders(1)

Mice(1)

Keyboards(1)

Computer Cloths/Wipes & Dusters(1)

Towels & Wipes(1)

Air Dusters(1)

Computer Dust Covers(1)

Binding Spines(1)

Mice & Keyboard Bundles(1)

Document/Box Files(1)

Mailing & Address Labels(1)

Multimedia Player Cases & Bags(1)

Copyholders(1)

Storage Binders(1)

Tool Kits(1)

Shredders(1)

Literature Organizers/Sorters(1)

Notes Holders / Dispensers(1)

Cubicle Hooks/Clips(1)

Wall Organizer Systems(1)

Monitor Filters(1)

Desktop Stands(1)

Telephone Stands & Holders(1)

LCD Monitor/Plasma Mounts(1)

Laptop Stands & Pads(1)

Phone Stands(1)

Report Covers(1)

Literature Sorters(1)

Printer/Fax Stands(1)

Tape Dispensers(1)

Paper Clip Holders(1)

Binder Clips(1)

 
Brand

Fellowes(373)

Bankers Box(85)

Office Suites(6)

 
Color

Black(201)

White(81)

Blue(71)

Clear(45)

Silver(31)

Kraft(20)

Gray(20)

Graphite(14)

Dark Silver(13)

Platinum(13)

Dark Graphite(11)

Multicolor(10)

Pearl(8)

Green(8)

Navy(6)

Crystal Clear(5)

Metallic Silver(4)

Chrome(3)

Wood Grain(3)

Clear Cover(2)

Charcoal(2)

Dark Gray(2)

Sapphire(2)

Purple(2)

Black Spine(1)

Dark Graphite Hook(1)

Opaque(1)

Black Hook(1)

Red(1)

Light Amber(1)

Dove Gray(1)

Metallic Gray(1)

Transparent(1)

Light Gray(1)

 
Size

11 x 8 1/2(1)

11 1/4 x 8 3/4(1)

16" x 10 ft(1)

 
Size

Letter(20)

A4(1)

 
Recycled

No(153)

Yes(119)

 
Sheet Size

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

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

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

 
 
 

© 2018-2019 Penn Office Products, Inc., All Rights Reserved