Am I overcomplicating my Content Type?

So I’m making a ecommerce store to learn Strapi. I want to track inventory, but it’s a bit more complicated since each Product has a few variations (eg a shirt could have 3 different sizes and 4 different colors), and each variation needs it’s own inventory count.

I feel like I might be overcomplicating it with too many relations and stuff. What do you think?

This topic has been created from a Discord post (1226668823969796208) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord

The problem with this, that it’s not SEO friendly, e.g you want red shirt to take you to shirt variation red directly

last time i struggle with this i thought to make a plugin that can copy other entry to this one

and have a relation on each variant, so then you could calculate intersections

in any case, having component in there would affect only if you have like 10000 variants

and there is no known better way, all software has it’s own if's