I have between 200-600 options per Product. Each one requires a different SKU.
I have noticed there are many apps that get past the 100 variant limit on Shopify BUT need an app that also lets me have a different SKU per option
I'm Richard - CRO Expert of PageFly page builder app. I'd love to provide my recommendation for you.
May I know have you tried to use product option apps such as Best Custom Product Options, Product Personalizer by Zepto, etc. I have an article to list the top 5 must-try product option apps here with pros, cons, pricing plans, etc so you can consult.
I hope my answer can help you. If you find it helpful, you can give it a like. Let me know if you have any further questions!
Richard - PageFly
The way they get around the variation limit is by adding properties to order lines during checkout. This doesn't let you control inventory for every possible variation.
If you need inventory control for all variations then you would need to break out the variations into different sets of products and edit your theme so you swap between a core option.
We help our users sort variations through our product management platform and could probably add automations to generate all the variations into defined products to get around the limit. If you would like to discuss further just send me an email to firstname.lastname@example.org
In the end you can probably achieve what you are after through Shopify admin in terms of splitting products. And yes I know it isn't the best solution because it's annoying to have to limit products to 100 variations when you need to control inventory!