How to resolve Bed Bath & Beyond COLORGRP Error

Article author
Store Automator
  • Updated

Error: 2006|The attribute 'COLORGRP' (Color Group) is not in the possible values set in the value list

You can avoid getting this error if the values of the “color group” field are from the list of acceptable values in the Products and Offers template file. The screenshot below is showing an example of the acceptable values of the color group field which is located on the second column of the file. 

To learn about how to download the Products and offers template file, click on the following link: Bed Bath & Beyond Template setup.

If the values are different and do not match the ones that BBB requires, you can modify your product data file by including only acceptable values. 

If the data can not be changed, we can still resolve this error by using a formula and the replacements feature in SA. First, we need to implement a formula to convert all data to lowercase letters since the colorgroup code is all lowercase. 

The screenshot below is showing an example color grp custom fields named bbb-color and target color. You need to put your own color group custom field when implementing the formula in your template.

Formula to convert field values to lowercase letters:

If({Product.CustomFields[Put your custom field name here]},{Product.CustomFields[Put your custom field name here].ToLowercase})

Then we need to set up replacement values for the color group field. To do that, go to Settings> Templates then choose your template and go to the COLORGRP field and click the Edit button.

Click the second tab, which is called “Replacements” and start adding your values in the left side fields. In the right-side fields, add the acceptable BBB values. Click “Ok” and then save and close the template. 

Example: if you have the color “Transparent” in your data and the acceptable value by BBB is “clear”, you can type “^transparent$” in the left side field, choose “Free text” from the drop-down menu next to it, and type “clear” in the right-side field. Make sure that the values for both fields you enter are all lower-case letters. You may need to include as many replacements as you need depending on your data.

Was this article helpful?

0 out of 0 found this helpful