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

Reception, Side & Guest Chairs(128)

Executive/High Back Chairs(124)

Task Chairs(112)

Meeting & Conference Room Tables(70)

Metal Lateral Files(65)

Training Room Tables(62)

Folding/Stacking Chairs & Carts(59)

Dry-Erase Boards(55)

Utility & Breakroom Tables(53)

Metal Vertical Files(49)

Management/Mid-Back Chairs(43)

Contemporary - Metal(40)

Lamps(38)

Mobile Pedestals(38)

Workstations/Computer Desks(33)

Adjustable Worksurfaces(33)

Stools & Drafting Chairs(32)

Storage Cabinets(31)

Carpet Chair Mats(24)

Industrial & Commercial Shelving(22)

Cork/Fabric Bulletin Boards(21)

Wire Shelving(20)

Legs(19)

Wall Clocks(18)

Wood Veneer Bookcases(17)

Mobile File Carts & Cabinets(16)

Educational Seating(15)

Metal Bookcases(15)

Folding Tables(15)

Utility/Service Carts(15)

Backrests & Seat Cushions(14)

Book Racks(14)

Desktop Risers(14)

Hard Floor Chair Mats(14)

Protectors(13)

Desktop Organizers(13)

Easel Boards(12)

Heaters(12)

Shelf(12)

Certificate Frames & Holders(11)

Fans(11)

Ottomans(11)

Panels/Partitions(11)

Bulletin Boards(11)

Work Surfaces(10)

Reception Area & Accent Tables(9)

Monitor Stands/Risers(8)

Casters(7)

Portable Storage Files & Bins(7)

Big & Tall Chairs(7)

Board Erasers(6)

Hand Trucks & Dollies(6)

Wall Files, Pockets & Accessories(6)

Desk Pads(6)

Keyboard/Mouse Platforms & Trays(6)

Power Strips(6)

Monitor Arms(6)

Wood Lateral Files(6)

Laminate Tops(5)

Card Files & Holders(5)

Pencil Holders(5)

Headrest(5)

Desktop File Sorters(5)

Panel System Hardware(5)

Business Card Holders(5)

Letter Trays(5)

Magnets(5)

Contemporary - Veneer(5)

Anti-Static Chair Mats(4)

Foot Rests(4)

Bulletin Bars(4)

Arm Sets(4)

Reception Sofa(4)

Loveseat Sofa(4)

Hooks & Hangers(4)

Wall Racks(4)

Refrigerators(4)

Coat/Garment Hooks(3)

Lecterns(3)

Exam Tables(3)

Storage Drawers & Accessories(3)

Compact & Student Desks(3)

TV/VCR Stands & Mounts(3)

Dry Erase Markers(3)

Printer/Fax Stands(3)

Laptop Cases & Bags(3)

Recycling Bins(2)

Open Shelf Files(2)

Paper Clip Holders(2)

Anti-Fatigue Mats(2)

Notes Holders / Dispensers(2)

Magazine Files(2)

Phone Stands(2)

Active Seating(2)

Light Bulbs & Tubes(2)

Cable Management(2)

Combination Bulletin/Dry-Erase Boards(2)

Surge Protectors(2)

Multimedia Carts(2)

Waste Containers & Accessories(2)

Signs & Sign Holders(2)

Coat/Garment Hangers(2)

Business Card Refills(1)

Mounting Putty(1)

Paper Clips(1)

Pad Retainers(1)

Indoor Mats(1)

Desktop Shelves(1)

Nameplates(1)

Bookends(1)

Mail Carts(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Push Pins(1)

Bulletin Board Sets(1)

Frames(1)

Sliders(1)

Doorstops(1)

Drawer Organizers(1)

File Divider Kit(1)

Briefcases(1)

Board Cleaners & Wipes(1)

Scratch Pads(1)

Laminate Bookcases(1)

File Rails/Frames(1)

Literature Organizers/Sorters(1)

Rulers & Yardsticks(1)

Laptop Stands & Pads(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Telephone Stands & Holders(1)

Brand

Lorell(2076)

Color

Black(462)

Clear(75)

White(49)

Putty(47)

Silver(37)

Light Gray(36)

Mahogany(36)

Gray(29)

Charcoal(26)

Chrome(22)

Cherry(21)

Walnut(20)

Blue(17)

Brown(17)

Green(16)

Navy(11)

Espresso(10)

Charcoal Gray(9)

Medium Tone(9)

Beige(9)

Red(8)

Pepper(8)

Stratus(7)

Buff(7)

Ocean(7)

Apple Green(7)

Cloud(7)

Periwinkle Blue(7)

Malted(7)

Real Red(7)

Chrome - Handle(5)

Aluminum(5)

Bronze(5)

Natural(4)

Tan(4)

Satin(4)

Platinum(4)

Oxblood(4)

Transparent(3)

Metallic Silver(3)

Green Edge(3)

Laminate(3)

Chambray(3)

Roulette(3)

Graphite(2)

Saddle(2)

White Shade(2)

Dark Blue(2)

Orange(2)

Silver Mist(2)

Burgundy(2)

Matte(2)

Clear Frame(2)

Assorted(2)

Rosewood(2)

Slate(2)

Black Hanger(2)

Champagne Gold(2)

Citronella(1)

Cafe(1)

Brick Beige(1)

Stone(1)

Hook(1)

Dark Gray(1)

Ivory(1)

Blueberry(1)

Sand(1)

Light Blue(1)

Black Cherry(1)

Charcoal Black(1)

Black Mahogany(1)

Chinchilla(1)

Smoke(1)

Midnight Blue(1)

Heat Wave(1)

Lime(1)

Taupe(1)

Stainless Steel(1)

Recycled

No(1137)

Yes(436)

Price Range

$0-$499.99(1825)

$500-$999.99(233)

$1000-$1499.99(9)

To  GO

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

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