How to create variant combinations that link to a single product variant

[karmalord]

Hi, I own the store portapanel.shop, and I'm wondering if it's possible to make 2 variant selections, of which the combination is linked to an existing variant of the product. My product is portable solar panels, the original product from Aliexpress having 6 variants, 7W BROWN, 7W BLACK, 7W CAMO, 10W BROWN, 10W BLACK, 10W CAMO.
I'm wondering if instead of having these 6 selections, I can make 2 variants, "power" where the customer selects between 7W and 10W, and "color", where the customer selects between BLACK, BROWN and CAMO.

Anyone know how to do this?

[PaulNewton]

This is basic behavior using product-options in the product-admin by creating separate options.

If your using some tool or service to import products you need to build the process to generate the desired information architecture either by just using the CSV import/export or some automation app/service like the mechanic app or shopify-flow using the advanced admin actions to use the api.

[karmalord]

Thank you for your reply, although when I simply create separate options and insert the corresponding SKU, the quantity doesn't update and doesn't let me manually change it as it says "handled by Dsers fulfillment service". How do I link the newly creation variation to the product's variant, as the SKU doesn't do the task?

[PaulNewton]

For third party services contact that third parties support.

There's a lot of steps and details to work out between having your products managed by a third party to taking over the process your self with custom data transformations.

The granular detail of that is way beyond a forum post.

In general disconnect the service from the store and setup all products by your own process.

[karmalord]

Are you sure there's no app I can use to simply move a variant from inside one option to another option? It seems pretty simple I don't think I'll need to do anything complex

[PaulNewton]

Saying somethings simple doesn't make it so while the money keeps burning.

It's not magic,  it's work.

No I can't be sure there's not some quick fix app there's tens of thousands of apps and millions of services out there to dig for to find not just a specific fix but to also do it "simply".

Even just using macros and formulas in excel for importing a new data set you'd probably constantly hit logic problems that need constant tweaking. Like you'd need to ensure every given current variant has it's options cleanly split with only spaces and no ambiguity; i.e." 7W BLACK" split on spaces works meanwhile "7W (UK) BLACK" split on spaces breaks everything etc ad nausem.

And no idea if that solves any upstream fulfiller problems.

The logic your descriptions imply means something would need to know exactly how the variant-options exist currently and and what words to split them on or some other clean definable logic.

For every product type with it's own conventions i.e. "7W black" vs "XXX Large orange red-mens".

That implies custom script or building of data transformations is needed.

See the mechanic app to script something custom, or a tool like matrixify to work with a spreadsheet based workflow.

[karmalord]

I don't think you understand what I'm trying to do.

Instead of it being like this

I want it to be like this

but as you can see when I deleted a variant and created a new one it's not the same as the old one because the quantity says 0. I'm sure there has to be a way to simply move the actual variant that came when I pushed to shopify into another option. So instead of deleting the 7W Brown variant for example I just slide it from the color option into the power option?