Categories are empty in store side
Categories are empty in store side
I imported data into categories, products, categoryParent and catalogNodes tables from non-ablecommerce compatible datasource. It looks alright from admin side. I can see all my products and sub-categories through Catalot -> Categories menu. it only display the categories in first level when I turn to store side. all sub-categories and products are disappeared from the first level categories. Thanks in advance for your answer.
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: Categories are empty in store side
I had this happen when setting up my Gold test site. A few hours later they showed up.
Re: Categories are empty in store side
Tim - It's been two days. I can't image it'll solve itself to give it two more decades.
It drives me crazy, I checked every detail of data imported. It looks just alright.
It drives me crazy, I checked every detail of data imported. It looks just alright.
Re: Categories are empty in store side
Try rebuilding the product indexes. AbleCommerce 8 Gold makes use of Lucene indexing engine. I think since you imported the data working directly with database indexes are not in sync with data. Go to Administration > Website > Indexes and hit rebuild index button and let it resync the indexes. Hopefully this will fix it for you.Able-fans wrote:I imported data into categories, products, categoryParent and catalogNodes tables from non-ablecommerce compatible datasource. It looks alright from admin side. I can see all my products and sub-categories through Catalot -> Categories menu. it only display the categories in first level when I turn to store side. all sub-categories and products are disappeared from the first level categories. Thanks in advance for your answer.
Re: Categories are empty in store side
mazhar wrote:Try rebuilding the product indexes. AbleCommerce 8 Gold makes use of Lucene indexing engine. I think since you imported the data working directly with database indexes are not in sync with data. Go to Administration > Website > Indexes and hit rebuild index button and let it resync the indexes. Hopefully this will fix it for you.Able-fans wrote:I imported data into categories, products, categoryParent and catalogNodes tables from non-ablecommerce compatible datasource. It looks alright from admin side. I can see all my products and sub-categories through Catalot -> Categories menu. it only display the categories in first level when I turn to store side. all sub-categories and products are disappeared from the first level categories. Thanks in advance for your answer.
That works, problem solved. Thank a lot!
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: Categories are empty in store side
That must be what did it for me as well and I just did not realize it.
- Logan Rhodehamel
- Developer
- Posts: 4116
- Joined: Wed Dec 10, 2003 5:26 pm
Re: Categories are empty in store side
Tim, if you ran an upgrade of AC707 data then the reindex is kicked off for you after the upgrade is done to build the initial index. The reindex runs in the background and takes a little while to complete. If you had a large number of products the process can take a while. During that period your searches and browsing will look funny because the index doesn't know about your imported data yet.
Cheers,
Logan
.com
If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
Logan
.com
If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: Categories are empty in store side
Yup.. My menu did not work at all because my current setup uses treeview but I was confused as to why there was no breadcrumb trail to use. Then when I tested it later on it started showing the breadcrumbs and worked fine.
Re: Categories are empty in store side
thanks for this. just lost 3 hours trying to figure why my data wasn't showing.. :-/
Re: Categories are empty in store side
I'm very sorry about that! I did just update our documentation, so now there is a note about reindexing the data if you are using the Lucene search provider. I didn't know that until today.pjs75 wrote:thanks for this. just lost 3 hours trying to figure why my data wasn't showing.. :-/
http://help.ablecommerce.com/mergedProj ... oducts.htm
Thank you for choosing AbleCommerce!
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support