Custom inventory adapter to sync stock levels between old ERP system and Wordpress Woocommerce site.
This project aimed to solve a problem between two divergent systems of a hardware store. The in shop stock system was using an ERP designed many years ago which was in no way easily equipped to sync to a modern ecommerce website. So the store would frequently run into issues where customers would be mislead by stock amounts on the website thinking things are available when in reality they wouldn't be. Or the opposite situation where users wouldn't go to the store or order online an item that was listed as out of stock but in reality was available.
To solve this issue, I built an adapter in nodejs which tracks inventory changes and syncs them between the systems. This syncing is done every 15 minutes in order to keep everything up to date and matching the pace of the business.
In order to provide the shop with some feedback on the syncs being successful as well as highlighting problems a telegram notification system was set up. Problems can include items on either system not matching, or invalid/nonsensical inventory amounts being found like negatives.