Are you interested in inspiration for Digital Transformation? Or are you intrigued by our projects? Read on, discover what makes us tick and uncover the driving forces behind our passion.
Get the latest and greatest straight to your inbox.
Only the best case-studies, blogs and more.
A multi-channel retailer with 50.000 items on stock, three warehouses and 10.000 items in stock through a drop-shipper, all coming from a legacy ERP (Enterprise resource planning (ERP) is a type of software system that helps organizations automate and manage core business processes for optimal performance) going into three websites, of which one Magento and two WordPress sites
Not having this middleware creates a situation where customers order no longer available items. This situation leads to unhappy customers and a high overhead cost in refunding orders and time spent by customer service.
There are three things to consider:
We created a middleware capable of wrapping around the legacy database to deal with the first source of stock-information
Secondly, the drop-shipping sources are regular CSV files mapped to the internal SKUs. These have, during the import, some logic applied to determine what the desired adjustment should be. (If the stock is 1, treat it as 0)
Thirdly we bring the different values together and allow the creation of rules to override the stock and disable products.
The final piece of the puzzle is mapping the relevant products to the relevant websites. Every night we check which products have been added and removed from the website. This predefined map allows the products to be updated with the correct stock values as soon as an update comes in.
Always having up-to-date information on the websites is not humanly possible, with over 60.000 products changing status 24/7.
By automating the process, we have eliminated ghost sales and relieved the organization of needless customer service time and refund admin, paving the road to the next phase in their scaling process.