Came across this post which would be the ideal solution for stores selling products from different suppliers. This post was from 2015. Technology and software move so fast nowadays I can't believe Shopify or an app developer haven't created this yet.
If they have, and you know it, please share. Thank you.