Page 3 of 8

Re: New OpenCart Site

Posted: Fri Jul 13, 2012 10:05 pm
by automysqlbackup
It works now. Thanks Daniel.

Re: New OpenCart Site

Posted: Fri Jul 13, 2012 10:24 pm
by blackaqua
I like the new update, subtle but good

Re: New OpenCart Site

Posted: Sat Jul 14, 2012 10:13 am
by MarketInSG
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 ;D

Re: New OpenCart Site

Posted: Sat Jul 14, 2012 12:42 pm
by Daniel
people need to sort out there tags. this will take a while.

Re: New OpenCart Site

Posted: Sat Jul 14, 2012 1:18 pm
by MarketInSG
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? :)

Re: New OpenCart Site

Posted: Sat Jul 14, 2012 3:40 pm
by Daniel
maybe do a mass mail to all sellers

Re: New OpenCart Site

Posted: Sat Jul 14, 2012 6:41 pm
by gob33
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.

Re: New OpenCart Site

Posted: Sat Jul 14, 2012 7:11 pm
by nchankov
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

Re: New OpenCart Site

Posted: Sat Jul 14, 2012 7:44 pm
by MarketInSG
Daniel wrote:maybe do a mass mail to all sellers
thanks for the effort put in :)

Re: New OpenCart Site

Posted: Sat Jul 14, 2012 9:47 pm
by Johnathan
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.

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 1:58 am
by GoGo OpenCart
Nice change, I like it a lot :) Thanks Daniel, looks perfect ;)

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 6:24 am
by CypherUK
Looks Good :)

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 6:38 am
by JAY6390
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

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 8:12 am
by Qphoria
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!

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 10:12 am
by Daniel
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

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 10:17 am
by Daniel
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.

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 10:48 am
by MarketInSG
yes, working great now. Just tested and seems good :)

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 10:50 am
by MarketInSG
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...

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 11:31 am
by Daniel
i need to alter the mysql so it indexes words 3 characters like seo, url

Re: New OpenCart Site

Posted: Sun Jul 15, 2012 11:58 am
by Qphoria
Daniel wrote:ok i have set it up to order by relevance.
AHA!! yes.. it seems to be working great now!