Post by jonnylaris » Tue Sep 18, 2012 9:52 pm

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!

Newbie

Posts

Joined
Tue Sep 18, 2012 9:49 pm

Post by jonnylaris » Wed Sep 19, 2012 7:43 pm

Anyone got any ideas?

Newbie

Posts

Joined
Tue Sep 18, 2012 9:49 pm

Post by ecgod.com » Wed Sep 19, 2012 8:05 pm

What's your cart version?

Please click here to donate us if my solutions help.
ECGOD Development Center
http://www.ecgod.com
sale@ecgod.com
Robert


User avatar
Active Member

Posts

Joined
Wed Sep 05, 2012 8:36 pm

Post by jonnylaris » Wed Sep 19, 2012 8:21 pm

Hi, my cart version is 1.5.4

Newbie

Posts

Joined
Tue Sep 18, 2012 9:49 pm

Post by ecgod.com » Wed Sep 19, 2012 8:43 pm

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

Please click here to donate us if my solutions help.
ECGOD Development Center
http://www.ecgod.com
sale@ecgod.com
Robert


User avatar
Active Member

Posts

Joined
Wed Sep 05, 2012 8:36 pm

Post by jonnylaris » Wed Sep 19, 2012 8:47 pm

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

Newbie

Posts

Joined
Tue Sep 18, 2012 9:49 pm

Post by ecgod.com » Wed Sep 19, 2012 10:00 pm

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.

Please click here to donate us if my solutions help.
ECGOD Development Center
http://www.ecgod.com
sale@ecgod.com
Robert


User avatar
Active Member

Posts

Joined
Wed Sep 05, 2012 8:36 pm

Post by etchano » Sun Oct 07, 2012 10:12 am

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.

Newbie

Posts

Joined
Sun Oct 07, 2012 9:37 am
Who is online

Users browsing this forum: No registered users and 29 guests