Background
Both brands were receiving inventory updates from suppliers via email, typically in spreadsheet form. The only way to keep their websites up to date was through manual reviews, line by line, of every inventory file. This process was time-consuming, error-prone, and costly, racking up about $5,000 in monthly labor.
We initially tried to streamline this process using Stock Sync, which can process inventory updates via email. However, Stock Sync requires a unique email address for each supplier. Since all supplier emails were sent to a shared inbox, we implemented a workaround using Google email filters that would forward emails from specific vendors to dedicated addresses. While this solution helped temporarily, it proved unreliable over time and was difficult to scale as more suppliers came on board.
Results
$4700
per month in labour cost saved.
Time
Countless hours have been returned to the client allowing them to focus on customer service
Refunds
No more inventory errors leading to refunds
The new system dramatically reduced manual workload and costs. Labor expenses dropped from $5,000 to just $300 per month. More importantly, the process became far more reliable. Inventory data is now synced automatically each day with no manual intervention. Errors due to outdated stock are nearly eliminated, leading to fewer returns and a better customer experience. By designing and implementing a solid inventory automation workflow, we helped these two furniture brands move from a manual, high-cost system to a streamlined, accurate, and scalable solution. This transformation has freed up their teams to focus on core business tasks while ensuring customers always see accurate inventory online.
{"type":"root","children":[{"type":"paragraph","children":[{"type":"text","value":"Zapier flow that uses Gmail attachment, then run through a few filters before uploading it using easyFTP and then labelling the email as processed."}]}]}
Two of our clients, both growing furniture retailers, rely on a wide network of suppliers, many of whom send inventory updates via email in spreadsheet format. With large and frequently changing catalogs, both brands struggled to keep their online listings accurate and up to date.