Community Forums

by **automysqlbackup** » Fri Jul 13, 2012 2:05 pm

It works now. Thanks Daniel.

by **blackaqua** » Fri Jul 13, 2012 2:24 pm

I like the new update, subtle but good

by **MarketInSG** » Sat Jul 14, 2012 2:13 am

Thanks for the update, but just a little issue I noticed.

When I searched "Option Image", previously it only comes up with 1 page of result. Now it comes up with 757 results. Is it searching for Option OR Image, or is it searching for Option AND Image? I think the previous search system you had was very good and accurate

by **Daniel** » Sat Jul 14, 2012 4:42 am

people need to sort out there tags. this will take a while.

by **MarketInSG** » Sat Jul 14, 2012 5:18 am

Daniel wrote:people need to sort out there tags. this will take a while.

One thing I realised, during your upgrading, some people's descriptions turned into tags. Here's one example, have a look at the tags: http://www.opencart.com/index.php?route ... on_id=5873. Is it possible if you clean it up for them so that those old and expired or outdated extensions doesn't hinder the search results?

by **Daniel** » Sat Jul 14, 2012 7:40 am

maybe do a mass mail to all sellers

by **gob33** » Sat Jul 14, 2012 10:41 am

I would say the description box of an extension is too narrow, cant have a global view of the text and must scroll too much.
Due to the right menu column "Your account" which is too wide.
The main image also is not re-scaled on extension view.

by **nchankov** » Sat Jul 14, 2012 11:11 am

Hi Daniel,

first - very nice redesign, I like it.

second - few things regarding search and something other
1. a question, is it search only in tags or it search also in the Extension name and Description? If I search an extension by full name I would expect to see it on the first place, but searching this way I cannot see one of my extensions even in the first page. I think that you split the search phrase to words and search each of them against the tags, which is useful, but it should show the exact match first and then the chunks.

2. I've noticed that when I go between pages (pagination) the last 2 products are shown as first 2 in the next page. It's possible that since I searched someone adding/updating extensions and they are shifted

3. The extension details page is very good, but the cover image is with empty space in the top if it isn't square and sometimes it show just a piece of the image. I believe that this image should be cropped individually for this position.

that's it for now, I will keep you posted if I find anything else.

Regards

by **MarketInSG** » Sat Jul 14, 2012 11:44 am

Daniel wrote:maybe do a mass mail to all sellers

thanks for the effort put in

by **Johnathan** » Sat Jul 14, 2012 1:47 pm

The search function still seems to be doing an OR search. For example, I searched for "total-based shipping" and the first result that comes up is Jay's extension:

http://www.opencart.com/index.php?route ... on_id=5249

However, that does not contain the word "shipping" anywhere on the page. Even with tags, that's going to mean a lot of non-relevant results.

by **GoGo OpenCart** » Sat Jul 14, 2012 5:58 pm

Nice change, I like it a lot

Thanks Daniel, looks perfect

by **CypherUK** » Sat Jul 14, 2012 10:24 pm

Looks Good

by **JAY6390** » Sat Jul 14, 2012 10:38 pm

I'm sorry, but the new search needs to be updated, and quickly. You have it set to recently updated by default, which it shouldn't be. You've got it set to full text searching now, which is great, however if you don't order them by relevance, it's POINTLESS. For example, search for "Page Cache"....Since I updated my mod pretty quickly, I rank on the 6th page now below other mods that updated after mine with just the word "page" or just the word "cache". This is just retarded and needs fixing. You use full text searching to get a relevance score to sort by, helping people find what they want. Otherwise, what's the point?

Also, for full text searching, by default you will only have words 4 letters or more matching, so you need to adjust that in mysql to allow for 3 letters (2 is a bit too small, but a lot of mods have things like "url", "seo" etc in them)

I'm also a little pissed off with the email update to tell us we've got to use tags too even though the tag system was being used for searches already. A little lead time would have been appreciated

by **Qphoria** » Sun Jul 15, 2012 12:12 am

This new search is not working... PERIOD.
This is totally screwed. I am getting no matches on half of my searches and instead completely unrelated results show up.

Purchase Order search
Uber Checkout
Split Categories
Paypal Advanced

And dozens of other searches come up with nothing even close to the mods that should be found
Plus they all show multiple pages of results but when you click on the next page it shows empty results.

This is MAJOR and is killing all businesses, including opencart commissions. Please fix this ASAP!

by **Daniel** » Sun Jul 15, 2012 2:12 am

ok i have set it up to order by relevance.

if still not working we can go back to search in the descriptions.

this is the query

SELECT e.extension_id, e.name, e.description, e.image, e.license, e.price, m.username AS member, (
SELECT ROUND(AVG(rating))
FROM extension_rating er
WHERE er.extension_id = e.extension_id
GROUP BY er.extension_id
) AS rating, e.status, e.date_added, e.date_modified
FROM extension e
LEFT JOIN extension_download_to_download ed2d ON (e.extension_id = ed2d.extension_id)
LEFT JOIN member m ON (e.member_id = m.member_id)
WHERE e.publish = '1'
AND e.status = '1'
AND m.status = '1'
AND MATCH(e.tag) AGAINST('purchase order')
GROUP BY ed2d.extension_id
ORDER BY MATCH(e.tag) AGAINST('purchase order') DESC
LIMIT 0,12

by **Daniel** » Sun Jul 15, 2012 2:17 am

also adding 2checkout to the payment methods in the extension store. i get people emailing me everyday asking if they can pay by credit card because paypal won't work in their country.

by **MarketInSG** » Sun Jul 15, 2012 2:48 am

yes, working great now. Just tested and seems good

by **MarketInSG** » Sun Jul 15, 2012 2:50 am

One quick question, I searched 'SEO' and also 'seo' but it shows no result. It should had shown jay's extension: http://www.opencart.com/index.php?route ... on_id=3550 He has the tag 'seo' in it. hmm...