Category Import Issue

[socrates99]

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

[s_ismail]

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.

[socrates99]

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!

[s_ismail]

You need to check 'ParentId' in 'ac_Categories' table. If it is top level category then its 'ParentId' should be 0.

[socrates99]

Hi,

Here's ac_Categories, parentid is 0:

1 1 0 Sample Category
534 1 0 Interior Walls
909 1 0 testcategory

[s_ismail]

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.

[socrates99]

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.

[socrates99]

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!