GSPANN reviewed the existing processes that the client was following and came up with a sustainable solution to reduce the turnaround time and involvement of multiple teams. We proposed a new batch upload API process and developed a document explaining batch upload benefits compared to a single SKU per API call. GSPANN came up with a logic to handle multiple failure scenarios to avoid any program failure in implementing the batch API.
We used MuleSoft application to read the OMS inventory from Amazon Web Services (AWS) S3 in an XML format, prepared a batch API payload for ShopLinker (XML), and sent it to ShopLinker to update the inventory in a batch of 3000 SKUs per API. We also implemented a logic to determine the available SKUs on ShopLinker out of total 90K SKUs and those that are not relevant.
With the help of Splunk, we implemented the logging of cumulative records to publish a report for the client’s team and log all errors on Splunk. We also configured emails from Splunk to the client’s team for all reports and errors.