Hello. I am creating an E commerce app that supports a wide range of products from clothes to accessories and more. After developing the various processes and flows within the app, i am stuck on creation of product variants. The current App can only support one product in its current document and i am able to list the available colours and sizes using the choice chips.
However, this flow is not in line with my inventory management needs because i am creating both a dashboard that will be able to help in Inventory management and Order management among other things.
The altenative for this problem was to be creating several documents of the same product and changing the size and colours of the product but i have found this to not be sustainable to the User experience and the outlook of the app
PRODUCT VARIANTS
My current attempt in addressing this issue with the help of AI solutions was to create a sub collection called variants in which i will be storing documents that have the fields of color, Sizes (list) and quantity available. however, i am unable to quary this document. I am sure there is a problem with this method that i cant see at the moment. But i was hopping to pick you guys's brains to see how you where able to create product variants on the app used by customers and how you created your dashboard to be able to manage your inventory levels. If you integrated with other third party systems, please help aswell.