Index need to rebuild

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
Able-fans
Ensign (ENS)
Ensign (ENS)
Posts: 11
Joined: Mon Sep 03, 2012 8:45 pm

Index need to rebuild

Post by Able-fans » Tue Nov 13, 2012 7:01 pm

I wrote a trigger to hide product once it's inventory level hit 0. This involves to update product's visibilityId. It works alright but it doesn't take the product off from website until I went to admin to rebuild indexes. Is there anyway I can rebuild index from my trigger so that no manual rebuilding needed.

Able-fans
Ensign (ENS)
Ensign (ENS)
Posts: 11
Joined: Mon Sep 03, 2012 8:45 pm

Re: Index need to rebuild

Post by Able-fans » Wed Nov 14, 2012 7:23 pm

I don't believe I can rebuild indexes from trigger. I wondering if there is a way Ablecommerce can detect a product's visibility is changed from backend then it rebuild index itself?

Able-fans
Ensign (ENS)
Ensign (ENS)
Posts: 11
Joined: Mon Sep 03, 2012 8:45 pm

Re: Index need to rebuild

Post by Able-fans » Thu Nov 15, 2012 5:25 pm

Can anyone answer this question? At lease your opinion if this is possible to be done or impossible. Or I did not make myself understand, if that's the case, I will explain in more detail. Thanks in advance

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Index need to rebuild

Post by jmestep » Fri Nov 16, 2012 7:00 am

It sounds like you did this outside of Able api code, so you could put code somewhere else in Able to trigger the index rebuild. I haven't looked at it, but if I were doing it, I would use the code that Able uses when you click the rebuild index button. If that isn't acceptable, then you could try Googling on Lucene. We're still learning about Lucene and search, but there is some info out there.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Index need to rebuild

Post by AbleMods » Fri Nov 16, 2012 9:54 am

Completely hiding out-of-stock products is going to murder any hope of organic SEO on your website. I wouldn't recommend it.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply