Our client has multiple store locations which manage their stores with Shopify. Their locations were each utilizing a manual extract from Shopify then making adjustments in a Google Sheets file to identify the quantity of items needed for reorder. This process is done weekly to stock the stores and warehouse involving action from 4 different people.
Utilizing the Shopify API we pull the inventory information including variants at the push of the button so the team is working with latest data.
This image shows one of the outputs which includes a list of the products compared to the ordering guidelines and show which items need to be reordered.