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

Executive/High Back Chairs(118)

Reception, Side & Guest Chairs(114)

Meeting & Conference Room Tables(93)

Contemporary - Metal(78)

Task Chairs(77)

Metal Lateral Files(65)

Metal Vertical Files(64)

Training Room Tables(64)

Dry-Erase Boards(51)

Utility & Breakroom Tables(50)

Management/Mid-Back Chairs(47)

Storage Cabinets(41)

Adjustable Worksurfaces(39)

Folding/Stacking Chairs & Carts(39)

Lamps(39)

Mobile Pedestals(37)

Stools & Drafting Chairs(32)

Contemporary - Veneer(30)

Panels/Partitions(25)

Carpet Chair Mats(24)

Industrial & Commercial Shelving(22)

Cork/Fabric Bulletin Boards(21)

Legs(21)

Wire Shelving(20)

Wall Clocks(19)

Wood Veneer Bookcases(17)

Laminate Tops(17)

Educational Seating(15)

Metal Bookcases(15)

Book Racks(15)

Mobile File Carts & Cabinets(15)

Folding Tables(15)

Protectors(14)

Desktop Risers(13)

Desktop Organizers(13)

Utility/Service Carts(13)

Shelf(12)

Bulletin Boards(11)

Casters(11)

Hard Floor Chair Mats(11)

Heaters(10)

Fans(10)

Work Surfaces(10)

Ottomans(10)

Easel Boards(9)

Backrests & Seat Cushions(9)

Bulletin Bars(8)

Panel System Hardware(8)

Workstations/Computer Desks(8)

Big & Tall Chairs(7)

Wall Files, Pockets & Accessories(7)

Monitor Stands/Risers(7)

Letter Trays(7)

Pencil Holders(6)

Wood Lateral Files(6)

Desk Pads(6)

Keyboard/Mouse Platforms & Trays(5)

Magnets(5)

Foot Rests(5)

Headrest(5)

Portable Storage Files & Bins(5)

Card Files & Holders(5)

Desktop File Sorters(5)

Power Strips(5)

Monitor Arms(5)

Board Erasers(5)

Business Card Holders(5)

Laminate Bookcases(5)

Arm Sets(4)

Refrigerators(4)

Base(4)

Wall Racks(4)

Hand Trucks & Dollies(4)

Reception Area & Accent Tables(4)

Laptop Cases & Bags(4)

Hooks & Hangers(4)

Anti-Static Chair Mats(4)

TV/VCR Stands & Mounts(4)

Storage Drawers & Accessories(3)

Desk Center Drawers(3)

Printer/Fax Stands(3)

Coat/Garment Hooks(3)

Compact & Student Desks(3)

Dry Erase Markers(3)

Lecterns(3)

Exam Tables(3)

Reception Sofa(2)

Loveseat Sofa(2)

Storage Boxes & Containers(2)

Combination Bulletin/Dry-Erase Boards(2)

Coat/Garment Hangers(2)

Multimedia Carts(2)

Phone Stands(2)

Traditional - Laminate(2)

Paper Clip Holders(2)

Recycling Bins(2)

Projector Mounts(2)

Magazine Files(2)

Active Seating(2)

Push Pins(2)

Light Bulbs & Tubes(2)

Notes Holders / Dispensers(2)

Open Shelf Files(2)

Waste Containers & Accessories(2)

Signs & Sign Holders(2)

Bookends(1)

Anti-Fatigue Mats(1)

Nameplates(1)

Surge Protectors(1)

Mail Carts(1)

Pads/Sliders(1)

Indoor Mats(1)

Desktop Shelves(1)

Paper Clips(1)

File Divider Kit(1)

Business Card Refills(1)

Sliders(1)

Frames(1)

Doorstops(1)

Mounting Putty(1)

Rulers & Yardsticks(1)

Literature Organizers/Sorters(1)

Pad Retainers(1)

Drawer Organizers(1)

Bulletin Board Sets(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Laptop Stands & Pads(1)

Scratch Pads(1)

Wall Planners & Organizers(1)

File Rails/Frames(1)

Briefcases(1)

Board Cleaners & Wipes(1)

Telephone Stands & Holders(1)

Brand

Lorell(2174)

Color

Black(461)

Clear(78)

Mahogany(53)

Putty(52)

Silver(46)

White(45)

Light Gray(41)

Cherry(34)

Charcoal(31)

Gray(27)

Chrome(23)

Walnut(22)

Brown(18)

Blue(17)

Green(15)

Beige(12)

Charcoal Gray(9)

Espresso(9)

Medium Tone(9)

Navy(7)

Apple Green(7)

Ocean(7)

Buff(7)

Stratus(7)

Cloud(7)

Red(5)

Chrome - Handle(5)

Bronze(5)

Aluminum(5)

Latte(5)

Pepper(5)

Natural(4)

Real Red(4)

Oxblood(4)

Platinum(4)

Malted(4)

Periwinkle Blue(4)

Tan(4)

Satin(4)

Metallic Silver(3)

Transparent(3)

Green Edge(3)

Laminate(3)

Orange(2)

Graphite(2)

Espresso Laminate(2)

- Frame(2)

Frosted(2)

Slate(2)

Burgundy(2)

Silver Mist(2)

White Shade(2)

Black Hanger(2)

Assorted(2)

Matte(2)

Dark Blue(2)

Clear Frame(2)

Champagne Gold(2)

Saddle(2)

Brick Beige(1)

Stainless Steel(1)

Lime(1)

Black Cherry(1)

Black Mahogany(1)

Smoke(1)

Dark Gray(1)

Hook(1)

Stone(1)

Heat Wave(1)

Chinchilla(1)

Cherry - Frame(1)

Multi(1)

Mahogany - Frame(1)

Taupe(1)

Charcoal Black(1)

Midnight Blue(1)

Light Blue(1)

Size

Large (L)(1)

Recycled

No(1115)

Yes(478)

Price Range

$0-$499.99(1966)

$500-$999.99(211)

$1000-$1499.99(11)

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