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

Laminating Supplies(31)

Mouse & Keyboard Wrist Rests(27)

Privacy Filters(24)

Mouse Pads(24)

Binding Covers(22)

Cross-Cut/Confetti-Cut Shredders(22)

Binding Spines & Strips(22)

Letter Trays(15)

Storage Drawers & Accessories(14)

Laminating Machines(12)

Keyboard/Mouse Platforms & Trays(12)

Shipping & Moving Boxes(12)

Binding Machines(11)

Desktop File Sorters(11)

Monitor Arms(10)

Cubicle / Partition Organizers & Accessories(9)

Monitor Stands/Risers(9)

Surge Protectors(9)

Desktop Copyholders(9)

Air Purifier/Humidifier Filters(9)

Foot Rests(7)

Micro-Cut Shredders(7)

Magazine Files(7)

Shredder Bags(7)

Portable Storage Files & Bins(7)

Backrests & Seat Cushions(6)

Strip-Cut Shredders(6)

Wall Files, Pockets & Accessories(5)

Desktop Organizers(5)

Literature Organizers/Sorters(5)

Workstations/Computer Desks(4)

Extension Cords(4)

Waste Containers & Accessories(3)

Paper Trimmers(3)

Power Strips(3)

Coat/Garment Hooks(3)

Air Purifiers/Cleaners/Humidifiers(3)

Air Dusters(2)

Desk Shelves(2)

CD/DVD Jewel Cases & Inserts(2)

Dry-Erase Boards(2)

CD/DVD Case Inserts(2)

Trash Bags & Liners(2)

Catalog Racks(2)

Shredder Oil(2)

Utility/Service Carts(2)

Report Covers(2)

Pencil Holders(2)

Mobile File Carts & Cabinets(1)

Towels & Wipes(1)

CPU Stands(1)

Storage Binders(1)

Mobile Device Accessories(1)

Computer Cloths/Wipes & Dusters(1)

Mice(1)

Computer Dust Covers(1)

Book Stand(1)

Multimedia Player Cases & Bags(1)

Mice & Keyboard Bundles(1)

Keyboards(1)

Document/Box Files(1)

Copyholders(1)

Nameplates(1)

Laminator Supplies(1)

Name Badge Holders(1)

Notes Holders / Dispensers(1)

Mailing & Address Labels(1)

Cubicle Hooks/Clips(1)

Wall Organizer Systems(1)

Telephone Stands & Holders(1)

Printer/Fax Stands(1)

Laptop Stands & Pads(1)

Phone Stands(1)

Tool Kits(1)

Computer Stands & Pads(1)

Tape Dispensers(1)

Paper Clip Holders(1)

Binder Clips(1)

 
Brand

Fellowes(409)

Bankers Box(101)

Office Suites(4)

 
Color

Black(223)

White(91)

Blue(82)

Clear(55)

Silver(35)

Gray(23)

Kraft(23)

Graphite(14)

Dark Silver(13)

Platinum(13)

Green(11)

Multicolor(10)

Dark Graphite(10)

Pearl(8)

Navy(7)

Crystal Clear(5)

Metallic Silver(4)

Purple(4)

Dove Gray(3)

Wood Grain(3)

Chrome(3)

Dark Gray(2)

Medium Oak(2)

Charcoal(2)

Red(2)

Sapphire(2)

Black Spine(1)

Light Gray(1)

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

16" x 10 ft(1)

 
Size

Letter(27)

A4(1)

 
Recycled

No(182)

Yes(136)

 
Sheet Size

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

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

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

 
 
 

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