Need Help setting Variant Option in Bulk , Color Option 1 , Size Variant Option 2 Width Variant Op 3

Hi,

I’ve imported products into Shopify from several different inventory management systems, but each system pushed product variants in a different order. For some products, the size comes first, while for others, the color or width appears first. I’d like to standardize the variant option order across all products as follows:

  • Variant Option 1 – Size

  • Variant Option 2 – Color

  • Variant Option 3 – Width

I initially tried doing this with the Ablestar Bulk Editor by exporting the product data to a CSV file and manually correcting the variant order. However, due to the size of my product database, the data started getting corrupted after a few hours of work. Ablestar support informed me that the in-app editor isn’t suitable for this task and suggested using a different app.

I also tested Matrixify, but it performed even worse with my large dataset.

If anyone can recommend an app that handles large catalogs more reliably

also if someone can recommend me for a better app or someone can write a flow that can create automation to the following senario’s I have many brands with similar logic the only difference would be for for example sizes that start with 3 if will also grab size 3.5 and size 35, so I would need a better logic

The API to call is https://shopify.dev/docs/api/admin-graphql/latest/mutations/productoptionsreorder

It’s possible to run a workflow against all your products and re-order the variants. But It’s not clear what logic you need to be able to reorder them across many different product and option combinations.

Hi Paul

thank you again for your reply , i am about to use shopify as my main inventory system, i do not know to which question you referring to

i clicked on the link and i did not understand nothing, if you can give me steps on what do i need to do

On my first task is to make sure the the variant option will be as bellow

Variant Option 1 = Color

Variant Option 2 -= Size

Variant Option 3 = Width (only if the product have width

the 2nd issue i created few topics i can add in detail url for this topic but the logic would be like this

when the vendor is Birkenstock and the Gender is Unisex if i add size 40, please fill up the following metafileds
each brand/gender would have different value, however the logic would be the same
Core Size - 40
Euro Size - 40
Women US Size - 9
Women US Size Range - 9.5
Men US Size - 7
Men US Size - 7.5
Size Description - 40 (Men 7-7.5/Women 9-9.5)
Thank You