I'm only very new to the code world and mainly using the very basic functions of a database rather than using code.
We are building a store, but we also want to use the store as a stock inventory system, so would need additional fields than the standard ones available, which are not visible to the customer. Things such as when and where the stock was bought and for how much etc.
I can't see anywhere for me to add a field in product data collection, so I thought maybe there is a way to have a separate data collection, link that and have the additional fields in there. With that route, I got completely lost before i started, I would want each record in the shop to have a record (and only one record) in the new data collection for me to then add additional information to.
Any help/direction/advice would be greatly appreciated.