Inventory Tracker

 

What is this app?

  This app was built to get real time metrics on all product sales happening on Super73.com sales channel. Post Covid, inventory lead times were very unpredictable, so keeping products in stock became a challenge when shipping times would vary by months on any given day. Super73 had the challenge of knowing when, and how much inventory to order on a very fluid supply chain timeline.
  I developed a dashboard in Airtable that would receive transaction web hooks  constructed with Shopify Flows. Every transaction would instantly update the products inventory and forecast an estimated sellout date based on current inventory and live Sell Through Rate (STR). There was also a low inventory webhook that would alert a company slack channel when inventory reached a set low qty threshold. We could identify when a product with a 3 month lead-time entered a 3.5 month sellout projection. Our product team would be notified automatically which products needed attention in real time without needing to spend time updating forecast models.
‍
‍

Tech used

Shopify Plus
Shopfy Flows
Slack API
Airtable Automation  Scripts (javascript)