How to restrict and validate options for Dropdown or Multi-select attributes upon import in Plytix
When working with Dropdown or Multi-select attributes it can happen that you end up with having multiple terms for the same Dropdown or Multi-select option due to spelling mistakes or a not clearly defined naming convention for the options within these attributes which makes your data messy. In this article you will learn how to restrict the options within Dropdown or Multi-select attributes and restrict the creation of new options for these attributes upon import so that your data can be cleaner.
Restricting new options in the settings
Editing restricted attributes in the PIM
Matching CSV file to restricted attributes
*Skip to a section in this article by clicking on the links above
⚠️Only admins of an account are able to restrict options of a Dropdown or Multi-select attribute
Restricting new Dropdown or Multi-select options in the settings
As an admin in Plytix, you have the option to restrict new options upon import or creation when creating or editing a dropdown or multi-select type attribute.
For this you need to:
- Go to the “Settings” section of the PIM under “Product attributes”
- Create or edit a Dropdown or Multi-select attribute
- Click on “Restrict” Edit/Add options on import
Editing restricted attributes in the PIM
Users can still edit restricted Dropdown or Multi-select attributes from within the PIM in the settings section, adding or deleting options or even changing this attribute restriction.
However, users cannot add duplicate options that match an already existing one.
Matching CSV file to restricted attributes
When importing a CSV file that contains a restricted attribute there are a couple of things to keep in mind. When mapping the attributes you will see a little message saying “This is a restricted attribute. Only valid options will be accepted upon import.” This way you will know that this attribute is restricted.
Values that do not match any options available in the system will not be imported and will be case sensitive. But if the value matches an option’s letters but not the cases, then that option will be imported to the matching option (example: value RED or red will match option Red).
Import Logs
After you have successfully imported a CVS with values that didn’t match any options for a restricted Dropdown or Multi-select the “state” of the log is “finished” but the “result” is “warning”. If you open the log detail you can see which products were affected since these will be marked with a “warning” and contain the following message: “Attribute X has an invalid value “X”. New values were not added because they do not match valid options established for the attribute.”
What's next?
- Learn how to create and manage product attributes
- Learn more about attribute types
- Learn how to edit product attributes
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇