Post by automysqlbackup » Fri Jul 13, 2012 10:05 pm

It works now. Thanks Daniel.

User avatar
New member

Posts

Joined
Tue May 08, 2012 5:38 am
Location - USA

Post by blackaqua » Fri Jul 13, 2012 10:24 pm

I like the new update, subtle but good

Flag Icons - http://blackaqua.com/world-flag-icons


Newbie

Posts

Joined
Sat Mar 31, 2012 7:38 pm

Post by MarketInSG » Sat Jul 14, 2012 10: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 ;D


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by Daniel » Sat Jul 14, 2012 12:42 pm

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

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by MarketInSG » Sat Jul 14, 2012 1:18 pm

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? :)


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by Daniel » Sat Jul 14, 2012 3:40 pm

maybe do a mass mail to all sellers

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by gob33 » Sat Jul 14, 2012 6:41 pm

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.

All my extensions


Active Member

Posts

Joined
Wed Feb 10, 2010 8:43 am
Location - France

Post by nchankov » Sat Jul 14, 2012 7:11 pm

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

Edit your products with Mass Product Updater Pro directly from the product list.
Add news functionaity to your e-commerce site
Increase your sales by adding Coupon countdown in your site
--
See all available extensions here


Newbie

Posts

Joined
Tue Mar 01, 2011 3:56 am

Post by MarketInSG » Sat Jul 14, 2012 7:44 pm

Daniel wrote:maybe do a mass mail to all sellers
thanks for the effort put in :)


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by Johnathan » Sat Jul 14, 2012 9: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.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by GoGo OpenCart » Sun Jul 15, 2012 1:58 am

Nice change, I like it a lot :) Thanks Daniel, looks perfect ;)

See all my extensions: https://www.opencart.com/index.php?rout ... 20OpenCart


User avatar
Active Member

Posts

Joined
Mon Nov 14, 2011 11:30 pm

Post by CypherUK » Sun Jul 15, 2012 6:24 am

Looks Good :)

User avatar
New member

Posts

Joined
Sun Oct 17, 2010 7:36 pm
Location - Essex, United Kingdom

Post by JAY6390 » Sun Jul 15, 2012 6:38 am

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

Image


User avatar
Guru Member

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by Qphoria » Sun Jul 15, 2012 8: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!

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Daniel » Sun Jul 15, 2012 10: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

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by Daniel » Sun Jul 15, 2012 10: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.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by MarketInSG » Sun Jul 15, 2012 10: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...


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by Daniel » Sun Jul 15, 2012 11:31 am

i need to alter the mysql so it indexes words 3 characters like seo, url

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by Qphoria » Sun Jul 15, 2012 11:58 am

Daniel wrote:ok i have set it up to order by relevance.
AHA!! yes.. it seems to be working great now!

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 8 guests