Search Translation Mapping

We have set up a custom search and have added a ‘translation’ mapping feature that allows you to map search terms with pre-set attributes to which products are assigned.

To ‘map’ is a computer / maths term to associate one element with another.  In this case you want to associate a ‘search word’ – say for example ‘a4 paper’ with a set ‘attribute’ – say ‘photo papers’ attributes.  So when someone types in ‘a4 paper’ in the search bar, the suggested attribute ‘photo paper’ will display.  In this way, you be very precise and customise the search results for customers.

To find the ‘translation mapping section, it is in the main menu of the website – go to ‘translation mapping’.

There are several things you can do here:

  1. View existing translations
  2. Add, manually, a translation
  3. Bulk import translations
  4. Edit existing translations


Lets add a translation manually and by CSV.

The first thing is to ensure that attribute exists.  There are a lot already uploaded, but if you are doing a new line of products, it’s worth checking.  Go to ‘CATALOG > ATTRIBUTES > MANAGE ATTRIBUTES and find the ‘narrow by product type’ attribute.

Click on the attribute and see if you relevant attribute is set up or not, and add it if required.

Download below sample csv file I have prepared.  Please note there are just two columns required:



The ‘find word’ is the new search word you are setting up

The ‘Target’ is the existing (already set up) ‘search attribute’

Download Sample CSV

Now lets set up the hypothetical case where we want ‘photo paper’ attribute to show up if I type in ‘a4 paper’

We would on the ‘find-word’ column enter ‘a4 paper’ and in the target column ‘photo papers’.

Add any others you want to import, go to the import dropdown, select your file and click on the ‘import’ button.

Please note, upload only new translations as existing translations will be duplicated.  It will not cause an error on the frontend but otherwise you could end up with lots of duplicate entries in the backend.

Any questions, please post a comment below.



Leave a Reply