Restricting Options of Dropdown or Multi-select Attributes upon import

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 

Import Logs

*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:

  1. Go to the “Settings” section of the PIM under “Product attributes
  2. Create or edit a Dropdown or Multi-select attribute
  3. Click on “Restrict” Edit/Add options on import

restrict-dropdown-options


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. 

restricted-dropdown-option-exists

 


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. 

import-restricted-attribute

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.” 

 

log-import-restricted-attribute

log-restricted-attribute



What's next?

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 👇