We currently have an online sports goods store that sells many products among many sport categories as well as specific products to specific sports.
For example we sell footballs which sit under the football category, netballs which sit under the netball category, basketballs under the basketball category, etc...
There are also some products that are relevant for each sport such as water bottles that sit under each sport in a general training equipment category, so the one water bottle product sits in 3 categories (Football training equipment, Netball training equipment, Basketball training equipment).
What we are trying to do is be able to find out if a water bottle is purchased, which sport/category did it come from so we can see if a certain product doesn't sell to a particular sports audience, for budgeting for each sport, etc.
A solution we though of was to have a separate water bottle product for each sport with a unique SKU (WB-FB, WB-NB, WB-BB, etc) so when we look at invoices we can tell by the SKU it belonged to football because it had WB-FB.
Since the product itself is the same, we would need to get all 3 of the water bottle products to come off the one inventory/stock list that is used for all of them.
Is there a way to do this or a plugin that can help?