Category Import Issue
-
- Ensign (ENS)
- Posts: 5
- Joined: Tue Oct 12, 2010 7:55 pm
Category Import Issue
Hello,
We have manually imported category records into ac_Categories, ac_CategoryParents, and ac_CatalogNodes per the wiki @ http://wiki.ablecommerce.com/index.php/ ... Categories
The categories do not display on the category tree. However, if we put the categoryid into the querystring of say, the admin section for editing/managing the categories, the category information appears and we can even then drilldown into the subcategories and also the products associated within each category.
If anyone has any insight as to why they are not appearing in the category tree we woudl greatly appreciate it.
Thanks,
Jim
We have manually imported category records into ac_Categories, ac_CategoryParents, and ac_CatalogNodes per the wiki @ http://wiki.ablecommerce.com/index.php/ ... Categories
The categories do not display on the category tree. However, if we put the categoryid into the querystring of say, the admin section for editing/managing the categories, the category information appears and we can even then drilldown into the subcategories and also the products associated within each category.
If anyone has any insight as to why they are not appearing in the category tree we woudl greatly appreciate it.
Thanks,
Jim
Re: Category Import Issue
It seems that you don't specify top level categories during import process. To specify top level categories you need to provide its parent category Id to 0.
hope this helps!
__________________
s_ismail
AbleCommerce Customization
Free Plugins and Add-Ons
AbleCommerce Plugins and Add-Ons
Plugables Blog
__________________
s_ismail
AbleCommerce Customization
Free Plugins and Add-Ons
AbleCommerce Plugins and Add-Ons
Plugables Blog
-
- Ensign (ENS)
- Posts: 5
- Joined: Tue Oct 12, 2010 7:55 pm
Re: Category Import Issue
Thanks for the reply. Here are three categories from ac_CategoryParents. Categories 1 and 909 were system created thru the admin (1 is actually sample category) and category 534 was imported:
categoryid parentid parentlevel parentnumber
1 0 0 1
1 1 1 0
534 0 0 1
534 534 1 0
909 0 0 1
909 909 1 0
From here, it appears my category 534 has the proper parent number set but maybe I am missing something else.
Thanks!
categoryid parentid parentlevel parentnumber
1 0 0 1
1 1 1 0
534 0 0 1
534 534 1 0
909 0 0 1
909 909 1 0
From here, it appears my category 534 has the proper parent number set but maybe I am missing something else.
Thanks!
Re: Category Import Issue
You need to check 'ParentId' in 'ac_Categories' table. If it is top level category then its 'ParentId' should be 0.
hope this helps!
__________________
s_ismail
AbleCommerce Customization
Free Plugins and Add-Ons
AbleCommerce Plugins and Add-Ons
Plugables Blog
__________________
s_ismail
AbleCommerce Customization
Free Plugins and Add-Ons
AbleCommerce Plugins and Add-Ons
Plugables Blog
-
- Ensign (ENS)
- Posts: 5
- Joined: Tue Oct 12, 2010 7:55 pm
Re: Category Import Issue
Hi,
Here's ac_Categories, parentid is 0:
1 1 0 Sample Category
534 1 0 Interior Walls
909 1 0 testcategory
Here's ac_Categories, parentid is 0:
1 1 0 Sample Category
534 1 0 Interior Walls
909 1 0 testcategory
Re: Category Import Issue
Where you are using category tree admin side or store side?
If it is in store side then make sure its visibility is public by going on admin-->catalog-->category-->edit category page.
If it is in store side then make sure its visibility is public by going on admin-->catalog-->category-->edit category page.
hope this helps!
__________________
s_ismail
AbleCommerce Customization
Free Plugins and Add-Ons
AbleCommerce Plugins and Add-Ons
Plugables Blog
__________________
s_ismail
AbleCommerce Customization
Free Plugins and Add-Ons
AbleCommerce Plugins and Add-Ons
Plugables Blog
-
- Ensign (ENS)
- Posts: 5
- Joined: Tue Oct 12, 2010 7:55 pm
Re: Category Import Issue
Hello,
I am trying to use the tree in both admin and public. The visibility right now is set to 0 for each record....the two system created ones that are displaying along with the one I imported.
I am trying to use the tree in both admin and public. The visibility right now is set to 0 for each record....the two system created ones that are displaying along with the one I imported.
-
- Ensign (ENS)
- Posts: 5
- Joined: Tue Oct 12, 2010 7:55 pm
Re: Category Import Issue
Hi,
I resolved this issue. I completely disregarded that each top level category needs a record in ac_catalognodes with a categoryid of 0 and the catalognodeid the id of the tope level category. Doop!
I resolved this issue. I completely disregarded that each top level category needs a record in ac_catalognodes with a categoryid of 0 and the catalognodeid the id of the tope level category. Doop!