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

Laminating Supplies(31)

Mouse Pads(27)

Mouse & Keyboard Wrist Rests(24)

Privacy Filters(23)

Binding Spines & Strips(23)

Binding Covers(21)

Cross-Cut/Confetti-Cut Shredders(20)

Letter Trays(15)

Storage Drawers & Accessories(14)

Laminating Machines(13)

Keyboard/Mouse Platforms & Trays(12)

Shipping & Moving Boxes(12)

Binding Machines(11)

Desktop File Sorters(11)

Monitor Arms(11)

Cubicle / Partition Organizers & Accessories(10)

Surge Protectors(10)

Air Purifier/Humidifier Filters(9)

Desktop Copyholders(9)

Monitor Stands/Risers(8)

Foot Rests(7)

Micro-Cut Shredders(7)

Portable Storage Files & Bins(7)

Magazine Files(7)

Shredder Bags(7)

Strip-Cut Shredders(6)

Backrests & Seat Cushions(6)

Wall Files, Pockets & Accessories(5)

Desktop Organizers(5)

Literature Organizers/Sorters(5)

Extension Cords(4)

Workstations/Computer Desks(4)

Paper Trimmers(3)

Air Purifiers/Cleaners/Humidifiers(3)

Waste Containers & Accessories(3)

CD/DVD Case Inserts(3)

Coat/Garment Hooks(3)

Power Strips(3)

CD/DVD Jewel Cases & Inserts(2)

Desk Shelves(2)

Air Dusters(2)

Nameplates(2)

Dry-Erase Boards(2)

Trash Bags & Liners(2)

Pencil Holders(2)

Shredder Oil(2)

Utility/Service Carts(2)

Report Covers(2)

Catalog Racks(2)

Desks(2)

Computer Cloths/Wipes & Dusters(1)

Towels & Wipes(1)

CPU Stands(1)

Storage Binders(1)

Mobile File Carts & Cabinets(1)

Computer Dust Covers(1)

Keyboards(1)

Document/Box Files(1)

Mailing & Address Labels(1)

Book Stand(1)

Mobile Device Accessories(1)

Mice & Keyboard Bundles(1)

Mice(1)

Copyholders(1)

Laminator Supplies(1)

Telephone Stands & Holders(1)

Printer/Fax Stands(1)

Binding Systems Covers(1)

Notes Holders / Dispensers(1)

Wall Organizer Systems(1)

Binder Clips(1)

Tape Dispensers(1)

Paper Clip Holders(1)

Phone Stands(1)

Cubicle Hooks/Clips(1)

Laptop Stands & Pads(1)

LCD Monitor/Plasma Mounts(1)

Name Badge Holders(1)

Tool Kits(1)

Multimedia Player Cases & Bags(1)

 
Brand

Fellowes(415)

Bankers Box(101)

Office Suites(6)

 
Color

Black(224)

White(92)

Blue(83)

Clear(55)

Silver(35)

Kraft(24)

Gray(21)

Graphite(14)

Platinum(13)

Dark Silver(13)

Green(11)

Dark Graphite(11)

Multicolor(10)

Pearl(9)

Navy(7)

Crystal Clear(5)

Purple(4)

Metallic Silver(4)

Wood Grain(3)

Chrome(3)

Dove Gray(3)

Dark Gray(2)

Medium Oak(2)

Charcoal(2)

Red(2)

Sapphire(2)

Clear Cover(2)

Black Spine(1)

Light Gray(1)

Dark Graphite Hook(1)

Slate Gray(1)

Yellow(1)

Orange(1)

Dark Blue(1)

Black Hook(1)

Assorted(1)

Light Amber(1)

Transparent(1)

Opaque(1)

Metallic Gray(1)

 
Size

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

16" x 10 ft(1)

 
Size

Letter(27)

A4(1)

 
Recycled

No(186)

Yes(138)

 
Sheet Size

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

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

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

 
 
 

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