Replace feed terms with the Dynamic Replacement list
Use the Dynamic Replacement list feature to replace existing terms dynamically in your feed via uploading a CSV file or URL in Productsup.
Introduction
The Dynamic Replacement list feature lets you create an extensive list of terms to update them dynamically via a CSV file or URL.
Note
Also, see Replace feed terms with the Standard Replacement list.
Set up the Dynamic Replacement list
Go to Lists from your site's main menu and select ADD LIST.
Next, choose Dynamic Replacement and select Continue.
In Name, give your replacement list a custom name.
Choose the way of adding the terms between two (2) options.
Option 1 - Upload a source file
Create a CSV file with a header and the following structure:
Note
The CSV file must contain a header since the platform skips the first row.
Drag your CSV list file to the Drag and drop a CSV file field, or select Browse to upload the file.
Select Add at the bottom of the page.
Option 2 - Add the source URL
Enter a source file URL in Source URL. To add a Google Sheets source file, see Add a list source file via Google Sheets and return to this section, step 2.
Enter credentials in Username and Password to access the source file.
In Delimiter, choose a delimiter. The platform selects the
tab (\t)
by default.Note
If you use a Google Sheet as a list source file, choose comma (
,
) as a delimiter.Optionally, in Encoding, add the encoding if it isn't UTF-8.
Optionally, in Enclosure, choose a desired enclosure, for example, (
‘’
or““
or||
).Select Add.
Toggle on Reset list on every import to remove all previous data from the feed after each new import. When toggled on, it also leaves all settings unchanged during an import.
To share the list at the account or project levels, toggle on Share list and select:
Account level – Share this list with all sites across all projects under this account.
Project level – Share this list with all sites under this project.
Note
If you share the list at the account or project level, the platform updates the list during an import from the original site where you created the list.
Once the platform uploads your CSV file, the list of defined values appears in the Replace term column.
Note
Whenever you change the source CSV file, select Import to update the list.
Add a list source file via Google Sheets
To add a list file in Google Sheets, you must modify the URL that leads to your list as follows:
In the URL, replace the text
edit
with:export?format=csv
If
#gid
exists in the spreadsheet URL, replace it with:&gid
The modified link should look similar to the following example:
https://docs.google.com/spreadsheets/d/{key}/export?format=csv&gid={gid}
In this example,
{key}
and{gid}
are placeholders.
Make the Google Sheets URL accessible to everyone. Productsup can only import publicly accessible sheets. Viewer mode is enough.
Test the URL by opening it in a browser. If you set it up correctly, once you hit enter, a CSV download begins.
Continue the setup in Option 2 - Add the source URL.
Add replacement rule boxes in Data View
Add the Replacement rule box
To apply your Dynamic Replacement list to your feed, add the Replacement rule box to your feed attributes in Data View.
The Replacement rule box doesn't replace the entire string in the attribute but only changes the parts of the string that match the list terms.
To add the Replacement rule box:
Go to Data View and select the intermediate or export stage from the drop-down menu in the top ribbon.
Select Edit for the attribute where you want to replace terms.
Select the Add Box drop-down menu.
Search for and select the Replacement rule box.
Choose a desired Dynamic Replacement list from the Select an Option drop-down menu.
Select Save.
Tip
You may manage different retailing sectors, for example, electronics and fashion, where the same terms may have different meanings. To prevent replacement with the wrong term, you should create separate replacement lists for each industry. When applying the replacement list with the Replacement rule box, you can choose the appropriate list.
For example, HP stands for Hewlett Packard in the electronics industry, while HP could refer to Handley Page in the aircraft industry.