Product tags not displaying results

Hi Guys,

I am new to Opencart and I seem to be having a problem with product tags.

For example, if I give a product a tag of "screen". When I then click on the tag and the search results open I get the product displayed in the results.

However if I change the tag to "Screen", nothing shows up in the search results when clicking on the tag.

Anyone got any ideas? Do I have to use lowercase for all product tags?

Thanks!

Anyone got any ideas?

What's your cart version?

Hi, my cart version is 1.5.4

It shoul work with uppercase letters.
Check if there is special characters or if you have a multi-language

No special characters being used and the shop is just running stock as it comes.

Ah... yes. I looked through the code and in that version, the tag must be in lowercase.
The opencart uses another way to search the tag in sql script.

If you are like me and have all your tags in UPPERCASE, the new update for open cart will simply give you "no products have been found" when you click on them. I have over 1000 products and it seemed like a nightmare to convert each product tag manually. I searched the net for fixes, extensions, you name it for hours over hours and nothing seemed to work. So, I was keen on hitting the hammer on the head - right in the SQL database that stores the tags. Here is a few simple steps and works like magic:

1. Click on phpMyAdmin in your cpanel
2. Click on your open cart database in the left pane
3. Scroll down in the left pane to product_description and click on it
4. In the right pane click on Structure tab
5. Then you will find under Column attributes find the tag one and click on Change
6. In Collation drop-down menu select utf8_general_ci
7. Hit Save

Now your tags will work even if they are in uppercase.