I need to to option bulk update as I noticed some of our SKUs has messy and mismatched option value. For example, Colour: 50ml Size: Blue. How can I fix this?

To fix mismatched option values in your SKUs, you can use DataEase to bulk update the option values. Here's how you can do it:

1. Export Products:

• In the DataEase app, create a new export.

• Select to export Products with Basic Columns and Inventory / Variants.

• This will give you a file with all the necessary details, including the option values.

2. Edit the Exported File:

• Open the exported file and locate the columns for Option1 Value, Option2 Value, and Option3 Value.

• Correct the mismatched option values, such as changing "Colour: 50ml" to the correct values like "Colour: Blue" and "Size: 50ml".

3. Prepare for Import:

• Ensure you keep the following columns in your file: ID, Handle, Variant ID, Variant SKU, and all columns that start with “Option …”.

• Remove any unnecessary columns to speed up the import process.

4. Import the Updated File:

• Go back to the DataEase app and import the updated file in the Import section.

• The app will analyze the file and update the option values for your products.

It's always a good idea to test the import with a few products first to ensure everything is set up correctly. If you encounter any errors during the import, you can download the Import Results file to see detailed error messages.

For more detailed guidance, you can check out our tutorial on https://dataease.app/products/