DestinationLighting.com is the main Magento online store of Seattle Lighting Company – a 100-year old company that sells indoor and outdoor lighting, fixtures, furniture, and others home decor products. Constructors and builders – are the big part of the business. The company has 14 offline stores, 4 magento store views, 88 000 products, 180K online users.
All the transactions – from both offline and online stores go through internal ERP system – Epicor Eclipse. Customers, products, payments, promos, shippings – all interconnected in Eclipse. The critical point was to build correct synchronization solution between Epicor Eclipse and Magento. It was more complicated than usual as the company had several vendors pushing their products to Eclipse. And products from different vendors had to be processed in a different way.
As long as Epicor Eclipse integration to Magento was our main concern, we tried to cover as much functionality with 3rd party extensions as possible. Some of the extensions were not architectured to be working together and that led to performance issues. So all of the installations went through our internal code review process which helped to outline several bad SQL queries and make a website work 4x time faster.
Currently, we are building a plan for Magento 2 migration.