Home » Forums » Ubercart » Support
11 replies [Last post]
Tue, 12/16/2008 - 08:16
venkat-rk@drupal.org
venkat-rk@drupal.org's picture
Offline
Joined: 03/19/2008
Juice: 205
Was this information Helpful?

Can someone point to options for searching an ubercart store?

I am using both the default 'product' type (SKU hidden) and a 'book' CCK content type (SKU hidden) created using Ubercart's product classes. The CCK content type has text fields such as author (select list), ISBN (text field) and publisher (select list).

Which modules can I use to present to the user a search block or page on the lines of ZenCart's search features?

I have already tried faceted_search with CCK_facets (to expose the CCK text fields), but it seems way too complicated.

Thanks,
Venkatesh

Top
Tue, 12/16/2008 - 10:22
#1 View page
zeezhao
zeezhao's picture
Offline
Joined: 04/23/2008
Juice: 969
Re: Search options for Ubercart store?

Some other options include:

- ApacheSolr and its drupal interface (http://drupal.org/project/apachesolr)
ubercart.org uses this.

- Sphinx and its drupal interface (http://drupal.org/project/sphinxsearch )

Top
Tue, 12/16/2008 - 10:38
#2 View page
venkat-rk@drupal.org
venkat-rk@drupal.org's picture
Offline
Joined: 03/19/2008
Juice: 205
Re: Re: Search options for Ubercart store?

Thank you for the links.

ApacheSolr is out of the equation as the site is on shared hosting. So, it seems, is sphinx.

Actually, the client is looking for something like this:

That's the zencart site being rebuilt in Ubercart.

Top
Tue, 12/16/2008 - 12:58
#3 View page
Ryan
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Re: Re: Search options for Ubercart store?

My hunch is you can get something like this using exposed filters in a View. You'll have to theme it like crazy, because by default they show up in a horizontal table, but you can have select lists for the various fields and even a field for matching or approximating ISBNs.

Top
Tue, 12/16/2008 - 13:17
#4 View page
thill
thill's picture
Offline
Joined: 01/25/2008
Juice: 815
Re: Re: Re: Re: Search options for Ubercart store?

the other side note is Axquia is close to beta launch of the hosted Apachesolr search service allowing shared hosted sites to benefit from apachesolr.

Top
Tue, 12/16/2008 - 23:28
#5 View page
venkat-rk@drupal.org
venkat-rk@drupal.org's picture
Offline
Joined: 03/19/2008
Juice: 205
thill wrote:the other side
thill wrote:

the other side note is Axquia is close to beta launch of the hosted Apachesolr search service allowing shared hosted sites to benefit from apachesolr.

The client's deadline is next week, so I am not sure that's going to work out Smiling

Actually, using the faceted_search and associated modules are a good alternative to ApacheSolr, as this link explains:
http://civicactions.com/blog/faceted_search_as_a_valid_alternative_to_ap...

Top
Tue, 12/16/2008 - 23:22
#6 View page
venkat-rk@drupal.org
venkat-rk@drupal.org's picture
Offline
Joined: 03/19/2008
Juice: 205
My hunch is you can get
Ryan wrote:

My hunch is you can get something like this using exposed filters in a View.

Exposed filters is exactly what I had in mind, Ryan. But I haven't been able to get it going for some reason.

I experimented with faceted_search and cck_facets, and while I like many aspects of it, I wonder if they're worth the database hit involved.

Top
Fri, 10/21/2011 - 11:30
#7 View page
BigMike
BigMike's picture
Offline
Joined: 10/20/2008
Juice: 1057
zeezhao wrote: Some other
zeezhao wrote:

Some other options include:

- ApacheSolr and its drupal interface (http://drupal.org/project/apachesolr)
ubercart.org uses this.

- Sphinx and its drupal interface (http://drupal.org/project/sphinxsearch )

zeezhao: I am already running Sphinx Search on my server (using it for super fast searches on our 1-million post community forum) so this would be super easy for me to implement with Drupal (I only need to enable the module Laughing out loud)

My sandbox test-site runs on my WinXP laptop (XAMPP) which doesn't have Sphinx (I could always try to install it!) so the only way for me to test it out would be on my live production site, which I'd rather test it out before doing so first (especially since the module is still in development).

Sorry for the rambling, here is my Question: Have you used the Sphinx module? Does it include SKU search ability straight outta the box? If you have experience with this, would you mind sharing any useful tips for me to get it going?

Thank you very much for your help!!
Regards,
BigMike

Top
Fri, 10/21/2011 - 13:24
#8 View page
zeezhao
zeezhao's picture
Offline
Joined: 04/23/2008
Juice: 969
sphinxsearch module

Yes, I have used http://drupal.org/project/sphinxsearch module on D5 and D6. Follow its readme

It does SKU search straight out of box, once index built.

You can install XP version from here: http://sphinxsearch.com/downloads/release/

Its been a while now... So can only answer specific issues or questions.

Top
Fri, 10/21/2011 - 14:13
#9 View page
BigMike
BigMike's picture
Offline
Joined: 10/20/2008
Juice: 1057
Thank you for the reply. I

Thank you for the reply.

I got sphinsearch uploaded to my modules folder, have not enabled it yet, and was setting things up as per the instructions in the read me.

I am not sure what to do however; Can I have 1 instance of Sphinx installed on my machine and have it manage two different indexes? The reason I ask is because my forum is currently using Sphinx, so the configuration file at /usr/local/etc/sphinx.conf is already configured for my forum.

I wonder if I will need to modify the sphinxsearch module to look for a different sphinx configuration file, such as maybe /usr/local/etc/sphinx-smf.conf

What do you think? Again, thank you VERY MUCH for your help with this!!
BigMike

Top
Fri, 10/21/2011 - 15:09
#10 View page
zeezhao
zeezhao's picture
Offline
Joined: 04/23/2008
Juice: 969
Re: Thank you for the reply. I

You need to read the doc/sphinx.html file that comes in the sphinx zip file.

There is a "--config" flag that can be passed to indexer or searchd to determine where to read conf file.

My own installation was 1 conf file but with partitioned inde. I did this since number of nodes being over 2 million, hence to speed up building each index and enable to run on machine with low memory.

Top
Tue, 01/13/2009 - 07:38
#11 View page
venkat-rk@drupal.org
venkat-rk@drupal.org's picture
Offline
Joined: 03/19/2008
Juice: 205
Re: Search options for Ubercart store?

Just in case anyone is interested, the views_filterblock module lets you convert the default, horizontal filters on a view into a drupal block that you can customize like any other drupal block without all the headache of theming.

My problem is that, to get these exposed filters, I have to use views, which means I probably have to override the default catalog pages with a view and so on. Sounds troublesome to me just to get a block with drop-downs to filter based on CCK fields.

Still searching for an easier way. Sad

Edit: This was in response to Ryan's post above.

Top