Is there a way to automatically update product information (in stock etc) from supplier excel files

Hi all, I am working with a client who has 13 different suppliers and each of them send over a spreadsheet each day with inventory updates. We don’t stock all of the products from each, but we would like to automate the process of when they send the spreadsheet we are able to map it over to Matrixify to update inventory and automatically remove/update the current stock on specific products. Mapping each spreadsheet to Google Sheets and then uploading them to Marixify doesn’t seem to sustainable, unless there is a better way to accomplish this. I have looked at Inventory Management apps and am not sure which one if any would be able to solve this issue. Manually uploading the Google Sheets once a week wouldn’t be to burdensome, but having to copy and paste the excel data and map it out properly could be time consuming even if we have a template in place. Curious if any others have found a fix for this issue. Thanks!

Hi Schludini,

Have you looked into Stock Sync or Simple Inventory? It looks like these might be able to achieve what you’re looking for here - but it could be worth reaching out to their teams directly to confirm.

1 Like

Thanks! I was able to get in contact with Stock Sync and their team confirmed that this would be possible, I just couldn’t find an app that would work prior! Thanks!