Guidance Needed for Migrating Free Text Attributes to List Type

[Franker26]

Dear Atrocore Team,

I hope this message finds you well.

I am writing to seek your advice on a migration task we are planning. Currently, many of our filterable attributes on our website are in free text format. To enhance the user experience and filtering capabilities on our site, we need to convert these attributes to list type.

We understand that performing this migration efficiently is crucial to minimizing the impact on our daily operations. Therefore, we would greatly appreciate any recommendations and best practices you could provide for carrying out this process.

Specifically, we would like to know:

What are the recommended steps to identify and migrate free text attributes to list type?
Which tools would you suggest using to facilitate this migration?
Are there methods to automate this process and ensure data consistency?
How can we ensure that the migration does not negatively affect site usability during and after the process?
Thank you in advance for your guidance and any additional resources you can provide.

We look forward to your response.

Best regards,

Franco Zanetti

[atrolex]

Hello Franco,

I think the best way would be to create a new attribute of this type,
export all the existing values as csv/xlsx,
in excel create a unique list of options.
Create a new list of options in PIM.
Import there all you unique options.

Then add a new column to your product list file and add there an appropriate option for this new attribute.

You can keep the old attribute/field for a while, just not sync this value further.
When you are 100% that everything went file remove the old attribute with values.