The Import/Export tool is enabled to update multiple variant details at once, follow below steps to update your variant details
- Go to Import/Export Inventory
- Download variants you wish to modify
a. “Variants of selected product” opens up a pop up to select products whose variants you wish to download
b. Clicking on “All Variants” download all variants that exists in your inventory
- Your variants will be downloaded in excel with the list of variants selected to be downloaded
- Delete the First row, this is just for providing information. You can also remove other variants that does not require any change
- Make required changes in the sheet.
*Note : Save this as a new sheet in .xlsx format - Once the changes in excel are done, we need to upload it in our system
- Select the sheet from the options provided, you can either drag and drop excel or you can choose it from your file system
- Click on “Read Sheet” to read the contents of the sheet.
- If the sheet contains some invalid data then error/warning will be shown in the respective row
- “Upload” button will appear when sheet is correct and clicking on it will update the variants listed in the sheet