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)

Mouse & Keyboard Wrist Rests(26)

Laminating Supplies(23)

Privacy Filters(22)

Mouse Pads(20)

Binding Covers(19)

Cross-Cut/Confetti-Cut Shredders(18)

Letter Trays(14)

Binding Spines & Strips(14)

Keyboard/Mouse Platforms & Trays(12)

Storage Drawers & Accessories(12)

Binding Machines(11)

Shipping & Moving Boxes(11)

Laminating Machines(11)

Desktop File Sorters(11)

Monitor Stands/Risers(9)

Monitor Arms(9)

Air Purifier/Humidifier Filters(9)

Surge Protectors(9)

Desktop Copyholders(8)

Cubicle / Partition Organizers & Accessories(8)

Foot Rests(7)

Shredder Bags(7)

Micro-Cut Shredders(7)

Strip-Cut Shredders(6)

Wall Files, Pockets & Accessories(5)

Portable Storage Files & Bins(5)

Backrests & Seat Cushions(5)

Extension Cords(4)

Workstations/Computer Desks(4)

Desktop Organizers(4)

Air Purifiers/Cleaners/Humidifiers(3)

Power Strips(3)

Waste Containers & Accessories(3)

Dry-Erase Boards(2)

CD/DVD Jewel Cases & Inserts(2)

CD/DVD Case Inserts(2)

Desk Shelves(2)

Trash Bags & Liners(2)

Catalog Racks(2)

Shredder Oil(2)

Coat/Garment Hooks(2)

Magazine Files(2)

Utility/Service Carts(2)

Pencil Holders(2)

Paper Trimmers(2)

Copyholders(1)

Multimedia Player Cases & Bags(1)

CPU Stands(1)

Mice & Keyboard Bundles(1)

Computer Cloths/Wipes & Dusters(1)

Air Dusters(1)

Computer Dust Covers(1)

Book Stand(1)

Keyboards(1)

Phone Stands(1)

Mice(1)

Literature Organizers/Sorters(1)

Name Badge Holders(1)

Notes Holders / Dispensers(1)

Computer Stands & Pads(1)

Wall Organizer Systems(1)

Cubicle Hooks/Clips(1)

Report Covers(1)

Binder Clips(1)

Nameplates(1)

Tool Kits(1)

Paper Clip Holders(1)

Mailing & Address Labels(1)

Document/Box Files(1)

Tape Dispensers(1)

Printer/Fax Stands(1)

Storage Binders(1)

Telephone Stands & Holders(1)

Laptop Stands & Pads(1)

 
Brand

Fellowes(358)

Bankers Box(86)

Office Suites(4)

 
Color

Black(199)

White(82)

Blue(71)

Clear(45)

Silver(31)

Gray(20)

Kraft(19)

Graphite(14)

Dark Silver(13)

Platinum(13)

Dark Graphite(10)

Multicolor(10)

Green(8)

Pearl(8)

Navy(6)

Crystal Clear(5)

Metallic Silver(4)

Wood Grain(3)

Chrome(3)

Charcoal(2)

Dark Gray(2)

Sapphire(2)

Purple(2)

Black Spine(1)

Clear Cover(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

Letter(20)

A4(1)

 
Recycled

No(150)

Yes(118)

 
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