I did this for a mock movie DB in school.
You can have each product their own unique ID, and upon clicking it, have it open in a generic page based on the ID, and find everything identifying with it matching that ID.
So if a customer clicks a product, such as shampoo, with an ID of 3076, then it will pull up anything with 3076 associated.
Just pass this information from the listing page to the “Designated” page, and it should upload just fine. 🙂
All products have to share the same column names, so it all has to be local to one database table. This is the only exception.
By having one “upload” page, you save so much memory. It just takes the passed ID… it will not mater if it’s 3076, or 9999. It’ll always work.