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

Manufacturer

Currently Filtered by

Manufacturer

Lorell

Refine Search

  GO
Category

Contemporary - Laminate(391)

Executive/High Back Chairs(127)

Reception, Side & Guest Chairs(119)

Task Chairs(90)

Meeting & Conference Room Tables(75)

Metal Lateral Files(65)

Training Room Tables(55)

Metal Vertical Files(54)

Folding/Stacking Chairs & Carts(49)

Management/Mid-Back Chairs(46)

Utility & Breakroom Tables(46)

Dry-Erase Boards(40)

Adjustable Worksurfaces(39)

Lamps(39)

Contemporary - Metal(38)

Contemporary - Veneer(37)

Stools & Drafting Chairs(35)

Mobile Pedestals(34)

Storage Cabinets(34)

Panels/Partitions(25)

Carpet Chair Mats(24)

Legs(21)

Wire Shelving(20)

Wall Clocks(19)

Laminate Tops(18)

Desktop Organizers(16)

Educational Seating(15)

Mobile File Carts & Cabinets(15)

Book Racks(15)

Metal Bookcases(15)

Folding Tables(15)

Wood Veneer Bookcases(14)

Protectors(14)

Cork/Fabric Bulletin Boards(13)

Desktop Risers(13)

Utility/Service Carts(13)

Shelf(12)

Bulletin Boards(11)

Hard Floor Chair Mats(11)

Casters(11)

Heaters(10)

Work Surfaces(10)

Ottomans(10)

Easel Boards(9)

Backrests & Seat Cushions(9)

Fans(9)

Panel System Hardware(8)

Workstations/Computer Desks(8)

Letter Trays(7)

Big & Tall Chairs(7)

Industrial & Commercial Shelving(7)

Business Card Holders(6)

Foot Rests(6)

Desk Pads(6)

Monitor Stands/Risers(6)

Wood Lateral Files(6)

Laminate Bookcases(6)

Board Erasers(5)

Desktop File Sorters(5)

Magnets(5)

Card Files & Holders(5)

Monitor Arms(5)

Portable Storage Files & Bins(5)

Pencil Holders(5)

Power Strips(5)

Headrest(5)

Keyboard/Mouse Platforms & Trays(4)

Traditional - Laminate(4)

Wall Racks(4)

Reception Area & Accent Tables(4)

Hand Trucks & Dollies(4)

Base(4)

Anti-Static Chair Mats(4)

Hooks & Hangers(4)

Laptop Cases & Bags(4)

Refrigerators(4)

Bulletin Bars(4)

Arm Sets(4)

Wall Files, Pockets & Accessories(3)

Printer/Fax Stands(3)

TV/VCR Stands & Mounts(3)

Coat/Garment Hooks(3)

Compact & Student Desks(3)

Exam Tables(3)

Desk Center Drawers(3)

Storage Drawers & Accessories(3)

Dry Erase Markers(3)

Lecterns(3)

Loveseat Sofa(2)

Reception Sofa(2)

Phone Stands(2)

Notes Holders / Dispensers(2)

Paper Clip Holders(2)

Signs & Sign Holders(2)

Combination Bulletin/Dry-Erase Boards(2)

Coat/Garment Hangers(2)

Projector Mounts(2)

Active Seating(2)

Waste Containers & Accessories(2)

Multimedia Carts(2)

Open Shelf Files(2)

Light Bulbs & Tubes(2)

Pad Retainers(1)

Push Pins(1)

Mounting Putty(1)

Magazine Files(1)

Mail Carts(1)

Surge Protectors(1)

Anti-Fatigue Mats(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Literature Organizers/Sorters(1)

Desktop Shelves(1)

Bookends(1)

Nameplates(1)

Sliders(1)

Ice Buckets(1)

Frames(1)

File Divider Kit(1)

Briefcases(1)

File Rails/Frames(1)

Doorstops(1)

Business Card Refills(1)

Board Cleaners & Wipes(1)

Bulletin Board Sets(1)

Rulers & Yardsticks(1)

Telephone Stands & Holders(1)

Laptop Stands & Pads(1)

Paper Clips(1)

Brand

Lorell(2051)

Color

Black(423)

Clear(71)

Mahogany(53)

Putty(50)

Silver(46)

Light Gray(41)

White(41)

Cherry(35)

Charcoal(28)

Gray(25)

Chrome(23)

Walnut(22)

Brown(18)

Blue(15)

Green(15)

Beige(13)

Medium Tone(9)

Espresso(9)

Charcoal Gray(8)

Navy(7)

Stratus(7)

Cloud(7)

Buff(7)

Apple Green(7)

Ocean(7)

Aluminum(5)

Latte(5)

Red(5)

Pepper(5)

Bronze(5)

Oxblood(4)

Natural(4)

Satin(4)

Real Red(4)

Periwinkle Blue(4)

Malted(4)

Tan(4)

Laminate(3)

Green Edge(3)

Transparent(3)

Frosted(2)

Espresso Laminate(2)

Orange(2)

- Frame(2)

Platinum(2)

Saddle(2)

Clear Frame(2)

Silver Mist(2)

Matte(2)

Slate(2)

Assorted(2)

Dark Blue(2)

Black Hanger(2)

White Shade(2)

Wine(2)

Ash(2)

Brick Beige(1)

Light Blue(1)

Stainless Steel(1)

Cafe(1)

Citronella(1)

Blueberry(1)

Black Cherry(1)

Sand(1)

Lime(1)

Black Base(1)

Hook(1)

Champagne(1)

Black Mahogany(1)

Heat Wave(1)

Taupe(1)

Mahogany - Frame(1)

Cherry - Frame(1)

Midnight Blue(1)

Gray Black(1)

Chinchilla(1)

Charcoal Black(1)

Multi(1)

Size

Large (L)(1)

Size Supported

Lateral File(1)

Recycled

No(1093)

Yes(417)

Price Range

$0-$499.99(1890)

$500-$999.99(150)

$1000-$1499.99(2)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2018-2019 Granite Office, LLC, All Rights Reserved