The Problem
Orders placed online had to be manually re-keyed into the warehouse system. Stock levels on the website were only as current as the last time someone checked — which meant customers could buy products that were already sold out, and popular items showed as unavailable when they were sitting on the shelf.
The data formats and transmission protocols were quite different between the e-commerce platform and warehouse platform, so a straightforward API connection wasn't an option. The solution needed a polling-based approach that could collect, clean, and transfer data on a regular cycle — and do the same in reverse to keep stock levels current on the website.