Colorado’s leading vape retailer and manufacturer with 9 offline stores and warehouses. In 2011, the company decided to move online and started looking for a solid eCommerce solution to move operations to digital and scale the future ones.
The client migrated to Magento 1 from Zencart in 2013 because Zencart wasn’t supporting configurable products. The company was operating on Magento 1 until 2017 and had to migrate to another platform due to QuickBooks frustration. By that time, the company had 9 offline stores, and the accounting system started to cause database corruptions because of the enormous amount of data. Our client had to regularly send all the data to the support office to fix the issues. Usually, it took a couple of days for them to do it and send the data back.
After these hotfixes, the staff had to add all the orders that they were getting during the restoration work back into the database manually. In addition, store managers noticed that data synchronization caused loyalty points losses. This led to big customers’ frustration as they couldn’t use their discounts in offline stores.
We started looking for new options that could help us to manage the business and sales. By that time Magento 1 was well-known for its performance issues and Magento 2 wasn’t a solid platform yet. We just kept searching. It took about a year to review all the options, but then Magento 2.2 rolled out.
Magento 2 offered online merchants an MSI (multi-source inventory), business intelligence out-of-box features, and enhanced performance. The better architecture and ability to split the database was perfect for keeping CRM, ERP, accounting and reports, loyalty programs, and POS using a single platform.
Finally, we found a set of extensions that covered inventory, reports, POS checkout, and internal transactions. We just had to customize them according to our business specifics. Once that was done, we started the whole QuickBooks migration to the Magento database. We wanted to get rid of QB as fast as possible because we wanted to have all the data above one roof:
- Products, attribute, images
- Inventory and warehouses
- About 100.000 customers
- 1.000.000 orders
- Customer rewards history
What is more important, we couldn’t just jump into Magento after the full QuickBooks import. We should have run both systems for some time. We’ve made a daily script that synchronizes the latest customers, orders, stock, and rewards from QB to Magento 2.
While we were migrating the data and test piloting our solution, which was built on Magento 2.2.6, Magento released a better PWA version, GraphQL updates, and 2.3.2 version. But for now, we’ll launch what we have this year. Next month we’ll roll our POS solution for the first offline store and test it works for a couple of weeks to get customer service team feedback.