To rearrange Shopify product variants:
- Export Products + Inventory / Variants (without images or Metafields)
- Find the column “Variant Position” and change the numbers as you like them to be. (no need to change the row order, just change the numbers)
- You could just import that same file back but it will update all the columns that you import. So, to make the import smaller and quicker, and to update just the positions and nothing else, you can select just the following columns:
- ID
- Handle
- Variant ID
- Variant Position
- Copy those columns to new empty Excel file.
- Set the name of the sheet “Products” (so that the app knows that those are the Products data there).
- Import that file. It will just update the variant positions of those variants.
You can, of course, import only the product rows that you really want to change. No need to import all the products back.
See the full tutorial in the video.
