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` = "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 `pinfo`.`sku` LIKE '%Lorell' THEN 1 ELSE 0 END DESC, 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

Currently Filtered by

Manufacturer

Lorell

Refine Search

  GO
 
Category

Contemporary - Laminate(408)

Executive/High Back Chairs(133)

Reception, Side & Guest Chairs(131)

Task Chairs(101)

Contemporary - Metal(78)

Meeting & Conference Room Tables(77)

Metal Lateral Files(65)

Metal Vertical Files(64)

Contemporary - Veneer(61)

Training Room Tables(57)

Dry-Erase Boards(56)

Folding/Stacking Chairs & Carts(55)

Management/Mid-Back Chairs(54)

Utility & Breakroom Tables(48)

Mobile Pedestals(39)

Panels/Partitions(39)

Adjustable Worksurfaces(39)

Lamps(39)

Storage Cabinets(35)

Stools & Drafting Chairs(35)

Legs(25)

Carpet Chair Mats(24)

Cork/Fabric Bulletin Boards(21)

Laminate Tops(21)

Wire Shelving(20)

Hard Floor Chair Mats(19)

Wall Clocks(19)

Folding Tables(17)

Mobile File Carts & Cabinets(17)

Educational Seating(15)

Metal Bookcases(15)

Book Racks(15)

Desktop Risers(15)

Protectors(14)

Utility/Service Carts(14)

Workstations/Computer Desks(13)

Desktop Organizers(13)

Wood Veneer Bookcases(12)

Shelf(12)

Bulletin Boards(11)

Casters(11)

Work Surfaces(10)

Heaters(10)

Ottomans(10)

Fans(10)

Desk Pads(9)

Easel Boards(9)

Backrests & Seat Cushions(9)

Panel System Hardware(8)

Bulletin Bars(8)

Industrial & Commercial Shelving(7)

Letter Trays(7)

Wall Files, Pockets & Accessories(7)

Laminate Bookcases(7)

Monitor Stands/Risers(7)

Big & Tall Chairs(7)

TV/VCR Stands & Mounts(7)

Pencil Holders(6)

Wood Lateral Files(6)

Monitor Arms(6)

Headrest(6)

Desktop File Sorters(5)

Foot Rests(5)

Lecterns(5)

Board Erasers(5)

Magnets(5)

Keyboard/Mouse Platforms & Trays(5)

Portable Storage Files & Bins(5)

Wall Racks(5)

Business Card Holders(5)

Power Strips(5)

Card Files & Holders(5)

Reception Area & Accent Tables(4)

Traditional - Laminate(4)

Base(4)

Refrigerators(4)

Arm Sets(4)

Hand Trucks & Dollies(4)

Laptop Cases & Bags(4)

Anti-Static Chair Mats(4)

Hooks & Hangers(4)

Desk Center Drawers(3)

Dry Erase Markers(3)

Open Shelf Files(3)

Coat/Garment Hooks(3)

Printer/Fax Stands(3)

Storage Drawers & Accessories(3)

Exam Tables(3)

Compact & Student Desks(3)

Active Seating(2)

Paper Clip Holders(2)

Notes Holders / Dispensers(2)

Projector Mounts(2)

Storage Boxes & Containers(2)

Reception Sofa(2)

Loveseat Sofa(2)

Coat/Garment Hangers(2)

Push Pins(2)

Signs & Sign Holders(2)

Magazine Files(2)

Combination Bulletin/Dry-Erase Boards(2)

Phone Stands(2)

Multimedia Carts(2)

Light Bulbs & Tubes(2)

Waste Containers & Accessories(2)

Telephone Stands & Holders(1)

Bookends(1)

Paper Clips(1)

Desktop Shelves(1)

Surge Protectors(1)

Mirrors(1)

Mail Carts(1)

Anti-Fatigue Mats(1)

Nameplates(1)

Doorstops(1)

Literature Organizers/Sorters(1)

Bulletin Board Sets(1)

Rulers & Yardsticks(1)

Sliders(1)

Pad Retainers(1)

Mounting Putty(1)

Business Card Refills(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Frames(1)

Drawer Organizers(1)

Scratch Pads(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Board Cleaners & Wipes(1)

Briefcases(1)

File Divider Kit(1)

File Rails/Frames(1)

Desk Clocks(1)

Laptop Stands & Pads(1)

 
Brand

Lorell(2290)

 
Color

Black(467)

Clear(85)

Mahogany(60)

Putty(52)

White(47)

Silver(47)

Light Gray(43)

Cherry(39)

Charcoal(31)

Gray(28)

Chrome(23)

Walnut(22)

Brown(19)

Green(17)

Blue(16)

Beige(13)

Espresso(10)

Medium Tone(9)

Charcoal Gray(8)

Apple Green(7)

Stratus(7)

Ocean(7)

Cloud(7)

Buff(7)

Navy(7)

Red(6)

Latte(5)

Aluminum(5)

Bronze(5)

Satin(5)

Pepper(5)

Periwinkle Blue(5)

Chrome - Handle(5)

Tan(4)

Natural(4)

Real Red(4)

Oxblood(4)

Malted(4)

Green Edge(3)

Latte Laminate(3)

Laminate(3)

Matte(3)

Transparent(3)

Frosted(2)

Orange(2)

- Frame(2)

Saddle(2)

Espresso Laminate(2)

Black Hanger(2)

Champagne Gold(2)

Burgundy(2)

Silver Mist(2)

Slate(2)

Dark Blue(2)

Clear Frame(2)

Ash(2)

Assorted(2)

White Shade(2)

Platinum(2)

Silver Metal(1)

Brick Beige(1)

Lime(1)

Smoke(1)

Black Cherry(1)

Black Mahogany(1)

Dark Gray(1)

Stone(1)

Black Base(1)

Hook(1)

Heat Wave(1)

Chinchilla(1)

Cherry - Frame(1)

Multi(1)

Light Blue(1)

Mahogany - Frame(1)

Taupe(1)

Charcoal Black(1)

Midnight Blue(1)

Stainless Steel(1)

 
Size

Large (L)(1)

 
Size Supported

Lateral File(1)

 
Recycled

No(1242)

Yes(462)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved