I need to store some a lot of extraneous data for a product. We are building a custom product template to collect all this data. I am curious if there is a logical place to store this data. I can store it in JSON format if I need to but I wouldn't be able to query it well then, but if that makes the most sense then I will.
I thought about creating my own tables to store it, but my concern is that as the product moves from table to table as it moves through the process of being purchased that these values follow it along.
Thanks for any recommendations you can share.