The PIC client Rock N Rescue leverages the SOS Inventory. There is not a native solution to sync the inventory from SOS into WooCommerce or vice versa. However, SOS Inventory does offer an API that can allow us to communicate inventory between the two systems. Let’s look at how PIC uses this API to integrate SOS and WooCommerce for Rock N Rescue.

Previously, Rock N Rescue would retrieve information from their inventory system and then have to manually enter any updates into WPEngine. By creating a system to integrate changes in the SOS inventory, Rock N Rescue can now automatically update in the development center of WPEngine. This saves Rock N Rescue double digit number of hours per week in inventory management recording.

Some key points to remember include renting an Amazon server. This allows for creating a fixed ID that PIC and Rock N Rescue can whitelist to reliably pull data updates from the SOS Inventory to push to the WooCommerce API and automatically update WPEngine. Having a static Amazon server available also works for monitoring the inventory data that is or is not supposed to automatically update and track trends in item inventory and pricing.

At each run of the integration, we are saving information from the SOS Inventory and this information can be used for future developments. For example, we can use this procedure to alert clients of the status of item inventory. With information of available items, we can use time series analysis to predict when an item is soon to be out of stock. Building an intelligent dashboard could give recommendations to avoid interruptions in stock availability.

For further detail on the creation process and possible uses of this integration, see the link and image below.

https://piconsulting.slite.com/app/channels/wHYkrJC5~G/notes/oD0I79U1eq