Manually inputting a lot of data through the Website Configuration page can be a tedious job. One example for this can be when adding Color Palettes to your website's configuration Record. Currently, there are ongoing Enhancement requests to add CSV Import functionality for this, but there is also a workaround that you can try to make things easier while they have not been implemented yet.
I can suggest modifying the JSON object of the SC Configuration record directly as a workaround for this.
You may do so by:
- Going to Customization > Lists, Records & Fields > Record Types > SC Configuration > Click on List > Edit the Configuration of your domain and website
- Copy the Contents of the JSON Configuration Text Area
- Paste the Contents of the JSON Configuration file into an Text Editor of your choosing. I also suggest saving a copy of this in case the file is corrupted.
- Look for the colorPalette object within the JSON file. Here you may add additional entries of Color Palettes to the sublist.
You may add your New Color Palettes to the end of the object like so:
5. Copy all the text on the file back into the SC Configuration record's JSON Configuration Text Area and Click Save.
6. The added Color Palettes should now appear on the Color Palette List
If you already have your color Palettes in a CSV format, I can also suggest using an online converter for CSV to JSON like: .
You can use the tool to convert your CSV from this:
To a JSON Object that you can copy paste into the JSON Configuration Text Area:
Please be warned that you may break your website if you break the structure of the configuration record's JSON object so it should be best practice to test this out on your sandbox account or test website to test the results first just to be safe.
Do you know any other useful tips for SuiteCommerce websites? Feel free to share them on the thread below!