New OpenCart Site
Re: New OpenCart Site
JAY6390 wrote:I'm sorry, but the new search needs to be updated, and quickly. This is just retarded and needs fixing.
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
Qphoria wrote: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. And dozens of other searches come up with nothing even close to the mods that should be found. This is MAJOR and is killing all businesses, including opencart commissions. Please fix this ASAP!
Daniel wrote:ok i have set it up to order by relevance.
Qphoria wrote:AHA!! yes.. it seems to be working great now!
Crisis averted. Phew! Thank god. The words "mutiny" "riot" and "mass exodus" amongst the devs were slowing starting to form in my head due to the tone the topic was taking.
Glad it's sorted now and balance can be restored to the OpenCart universe young Jedi.

I guess the real test will be though, will anyone actually notice an increase or decrease in sales from the extensions store do to the new design and search function. Only time will tell on that one...
Last edited by bigchili on Sun Jul 15, 2012 3:39 pm, edited 1 time in total.
-

bigchili - Posts: 550
- Joined: Tue May 15, 2012 7:00 pm
Re: New OpenCart Site
sales are on the slow at the moment because the summer holidays are starting and people are not wanting sites setup until when they get back.
OpenCart®
Project Owner & Developer.
OpenCart commercial support now available!
Project Owner & Developer.
OpenCart commercial support now available!
-

Daniel - Administrator
- Posts: 5173
- Joined: Fri Nov 03, 2006 10:57 am
Re: New OpenCart Site
just updated it again so it can search 3 letter words.
OpenCart®
Project Owner & Developer.
OpenCart commercial support now available!
Project Owner & Developer.
OpenCart commercial support now available!
-

Daniel - Administrator
- Posts: 5173
- Joined: Fri Nov 03, 2006 10:57 am
Re: New OpenCart Site
Thanks for making the change. The relevance search is far better now. I do think however that this should be on titles and descriptions though, not on a tag field. The tag field to me is just pointless, and can be manipulated more easily than titles and descriptions. Let's get rid of the tag field, and match against what it should be matching on....extension contents

Better Product SEO URL's - Perfectly structured product links
Better Category SEO URL's - Give subcategories the same SEO keyword
SEO URL's Route Editor - Fix all of your index.php links

-

JAY6390 - Posts: 4634
- Joined: Wed May 26, 2010 3:47 pm
- Location: United Kingdom
Re: New OpenCart Site
It would be nice if there are two search fields to be chosen from while searching, i.e. one to search through the Title and Description, and another one to search through Tags.
When searching through the Title and Description, it would be nice, the one who searches, to have an option to choose:
Search for the exact phrase
Search for every word
Search for any word
The Title and the Description should be joined while searching, i.e. if chosen Search for every word, and one of the search words is found in the Title, and the other one is found in the Description, that extension should be shown within the search results.
Example:
Title: Uber Checkout
Description: One page checkout extension...
User searches for: Uber extension
That extension should be shown within the search results.
When searching through the Title and Description, it would be nice, the one who searches, to have an option to choose:
Search for the exact phrase
Search for every word
Search for any word
The Title and the Description should be joined while searching, i.e. if chosen Search for every word, and one of the search words is found in the Title, and the other one is found in the Description, that extension should be shown within the search results.
Example:
Title: Uber Checkout
Description: One page checkout extension...
User searches for: Uber extension
That extension should be shown within the search results.
Last edited by GoGo OpenCart on Sun Jul 15, 2012 11:08 am, edited 1 time in total.
See all my extensions: http://www.opencart.com/index.php?route ... 20OpenCart
-

GoGo OpenCart - Posts: 445
- Joined: Mon Nov 14, 2011 3:30 pm
Re: New OpenCart Site
@Gogo - The current search should show matches for any word (and does), but match ones with both words first (ie relevance). This seems to be how it is working, but I'm sure there is sorting going on even with those which has me a bit flummoxed to be honest

Better Product SEO URL's - Perfectly structured product links
Better Category SEO URL's - Give subcategories the same SEO keyword
SEO URL's Route Editor - Fix all of your index.php links

-

JAY6390 - Posts: 4634
- Joined: Wed May 26, 2010 3:47 pm
- Location: United Kingdom
Re: New OpenCart Site
@JAY6390: Didn't know that, my bad 
Thanks for the info

Thanks for the info

See all my extensions: http://www.opencart.com/index.php?route ... 20OpenCart
-

GoGo OpenCart - Posts: 445
- Joined: Mon Nov 14, 2011 3:30 pm
Re: New OpenCart Site
Also, @Daniel
Can I ask why you've got the ed2d table on this? It seems totally unused, other than for the GROUP BY, which you could just change to e.extension_id and increase search performance instantly
- Code: Select all
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
Can I ask why you've got the ed2d table on this? It seems totally unused, other than for the GROUP BY, which you could just change to e.extension_id and increase search performance instantly

Better Product SEO URL's - Perfectly structured product links
Better Category SEO URL's - Give subcategories the same SEO keyword
SEO URL's Route Editor - Fix all of your index.php links

-

JAY6390 - Posts: 4634
- Joined: Wed May 26, 2010 3:47 pm
- Location: United Kingdom
Re: New OpenCart Site
this could be off topic, but is it possible to move the captcha field below the tabs, because when I change info for example on tabs and click submit I always need to go to the first tab. It's nothing special, but will make our life easier 
Also, since the possible update of extension is limited the captcha could be shown only if the user post new extension. I'm just saying

Also, since the possible update of extension is limited the captcha could be shown only if the user post new extension. I'm just saying

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
Add news functionaity to your e-commerce site
Increase your sales by adding Coupon countdown in your site
--
See all available extensions here
- nchankov
- Posts: 8
- Joined: Mon Feb 28, 2011 7:56 pm
Re: New OpenCart Site
nchankov wrote:this could be off topic, but is it possible to move the captcha field below the tabs, because when I change info for example on tabs and click submit I always need to go to the first tab. It's nothing special, but will make our life easier.
I Agree!
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
First Things First: Opencart Check List.
Documentation: Our Documentation section.
BUGs?: Known BUGS for All OC Versions.
Problemen met de BTW?: [How to] BTW + Verzend & betaalmethodes.
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
First Things First: Opencart Check List.
Documentation: Our Documentation section.
BUGs?: Known BUGS for All OC Versions.
Problemen met de BTW?: [How to] BTW + Verzend & betaalmethodes.
-

i2Paq - Global Moderator
- Posts: 9764
- Joined: Mon Nov 09, 2009 11:00 am
- Location: Winkel - The Netherlands
Re: New OpenCart Site
JAY6390 wrote:Also, @Daniel
- Code: Select all
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
Can I ask why you've got the ed2d table on this? It seems totally unused, other than for the GROUP BY, which you could just change to e.extension_id and increase search performance instantly
ed2d is for when you select which version you are using.
OpenCart®
Project Owner & Developer.
OpenCart commercial support now available!
Project Owner & Developer.
OpenCart commercial support now available!
-

Daniel - Administrator
- Posts: 5173
- Joined: Fri Nov 03, 2006 10:57 am
Re: New OpenCart Site
last 2 result of each page is repeated on the next page 

-

MarketInSG - Posts: 2603
- Joined: Wed Nov 16, 2011 3:53 am
- Location: Singapore
Re: New OpenCart Site
Ah I see, that does make more sense, though could be added conditionally to the query only if a specific version is selected?Daniel wrote:ed2d is for when you select which version you are using.

Better Product SEO URL's - Perfectly structured product links
Better Category SEO URL's - Give subcategories the same SEO keyword
SEO URL's Route Editor - Fix all of your index.php links

-

JAY6390 - Posts: 4634
- Joined: Wed May 26, 2010 3:47 pm
- Location: United Kingdom
Re: New OpenCart Site
Like the new graphics...
However, the new background in combination with the new textcolor makes the text really hard to read.
Maybe increase the contrast on the text and change the background. Maybe a CSS3 gradient from light gray to white (top to bottom)
However, the new background in combination with the new textcolor makes the text really hard to read.
Maybe increase the contrast on the text and change the background. Maybe a CSS3 gradient from light gray to white (top to bottom)
OpenCart extension and templates developer. Working for Shine Webb AB in Sweden. Feel free to PM/contact me if you are in need of an extension or a template.
-

rokdazone - Posts: 109
- Joined: Mon Jan 02, 2012 7:24 am
- Location: Sweden
Re: New OpenCart Site
rokdazone wrote:Like the new graphics...
However, the new background in combination with the new textcolor makes the text really hard to read.
Maybe increase the contrast on the text and change the background. Maybe a CSS3 gradient from light gray to white (top to bottom)
I agree 100%.
Also,
The thumbnail size / sizing has got to go. I'm not going to spend another hour on a graphic that is only to be chopped off....or distorted. I've already have to totally redo all of my extension graphics to begin with. There are certain rules to follow when translating graphics to the web. Not only are "everyone's main extension thumbnails messed up/chopped off or distorted, there is no logic I have found thus yet in taking a width x height size and stretching it like that? Were talking RASTER not VECTOR here. The word out now is that you insist on the thumbnail size? I recommend it be more intuitive.
-

avvici -arvixe- - Posts: 4331
- Joined: Tue Apr 05, 2011 4:09 am
- Location: Charlotte, NC
Re: New OpenCart Site
Hello, really don't like as the extension directory is done.
- Looks more like a css gallery at the moment
- The text is unreadable due to the background
- Long Description was very useful in old version
Hope things get better as the power of Opencart is due mainly for extensions to buy and sell easily.
Good work
- Looks more like a css gallery at the moment
- The text is unreadable due to the background
- Long Description was very useful in old version
Hope things get better as the power of Opencart is due mainly for extensions to buy and sell easily.
Good work
- andy2012
- Posts: 27
- Joined: Sat Jan 21, 2012 2:19 pm
Re: New OpenCart Site
just added a banner for featured extensions.
please add a banner. i will add the ones i find best looking or best coded extensions.
please add a banner. i will add the ones i find best looking or best coded extensions.
OpenCart®
Project Owner & Developer.
OpenCart commercial support now available!
Project Owner & Developer.
OpenCart commercial support now available!
-

Daniel - Administrator
- Posts: 5173
- Joined: Fri Nov 03, 2006 10:57 am
Re: New OpenCart Site
I was wondering where those came from 


Better Product SEO URL's - Perfectly structured product links
Better Category SEO URL's - Give subcategories the same SEO keyword
SEO URL's Route Editor - Fix all of your index.php links

-

JAY6390 - Posts: 4634
- Joined: Wed May 26, 2010 3:47 pm
- Location: United Kingdom
Re: New OpenCart Site
The banner is really nice feature. I already set one banner for the first extension of my signature
It gives best exposure to the extensions.
Especially for paid extension I believe you should set clear rules how you can appear on this banner. Probably best sales on monthly basis, which have banner image, but this way the ones which are in that list will be always best sales
Few ideas regarding the extensions (the left side bar under the search fields):
1. Recent comments in the extensions
2. Recently voted
3. Recently downloaded
Probably it's not bad to have a chart with let's say top 100 extensions on monthly basis. Top means sorted by votes, by downloads, by ratings, so this way newest extension will have chance to appear in that chart.
All those things are way to point to new comers which are valuable extensions.
It gives best exposure to the extensions.
Especially for paid extension I believe you should set clear rules how you can appear on this banner. Probably best sales on monthly basis, which have banner image, but this way the ones which are in that list will be always best sales

Few ideas regarding the extensions (the left side bar under the search fields):
1. Recent comments in the extensions
2. Recently voted
3. Recently downloaded
Probably it's not bad to have a chart with let's say top 100 extensions on monthly basis. Top means sorted by votes, by downloads, by ratings, so this way newest extension will have chance to appear in that chart.
All those things are way to point to new comers which are valuable extensions.
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
Add news functionaity to your e-commerce site
Increase your sales by adding Coupon countdown in your site
--
See all available extensions here
- nchankov
- Posts: 8
- Joined: Mon Feb 28, 2011 7:56 pm
Re: New OpenCart Site
I'm guessing my banners aren't good or the extension(s) are just not well coded 


Better Product SEO URL's - Perfectly structured product links
Better Category SEO URL's - Give subcategories the same SEO keyword
SEO URL's Route Editor - Fix all of your index.php links

-

JAY6390 - Posts: 4634
- Joined: Wed May 26, 2010 3:47 pm
- Location: United Kingdom
Return to News & Announcements
Who is online
Users browsing this forum: No registered users and 7 guests

















