Your biggest factor here is the quality of the app users' Internet connectivity.
Only you can answer that question for us.
Regarding the complexity of online inventory management, there are some YouTube videos that show how to do inventory management on shared Google Sheets. I like Google Sheets as a shared data base because their contents are plainly visible to their owner in a browser.
Coincidentally, the test server ai2-test.appinventor.mit.edu has a Google Sheets component that's fairly simple to use, after some well documented administrative setup work with Google
Alternative ways of getting at your Google Sheets can be found at
if you are worried about that component never getting into production.