There won’t be an answer without a lot of assumptions on what you’re trying to build.
In most cases you would group any and all information that relates to whatever you are trying to embed (which I believe in your case is a product or asset).
So the questions I have for you.
-
Is semantic searching better than keywords? What are the benefits?
-
How will you manage product updates? Does it make more sense to embed the products by description, and set the metadata as a pointer? This way your price and quantity can be regularly updated without extra work. Or do you not use another database? In which case using a single un-nested object as metadata can lead to some very effective filtering abilities
-
Is a vector database what you are looking for? Text-To-SQL is becoming more reliable, and ChatGPT plugins seems to be a great fit for a lot of cases. I mean, we’re talking about a whole separate database. Is it worth it?