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!
Search found 5 matches
- Thu Oct 14, 2010 6:11 pm
- Forum: 7.0 DataPort
- Topic: Category Import Issue
- Replies: 7
- Views: 7853
- Thu Oct 14, 2010 4:13 pm
- Forum: 7.0 DataPort
- Topic: Category Import Issue
- Replies: 7
- Views: 7853
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.
- Thu Oct 14, 2010 10:25 am
- Forum: 7.0 DataPort
- Topic: Category Import Issue
- Replies: 7
- Views: 7853
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
- Thu Oct 14, 2010 5:53 am
- Forum: 7.0 DataPort
- Topic: Category Import Issue
- Replies: 7
- Views: 7853
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 Fro...
- Wed Oct 13, 2010 11:37 am
- Forum: 7.0 DataPort
- Topic: Category Import Issue
- Replies: 7
- Views: 7853
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/Importing_Categories The categories do not display on the category tree. However, if we put the categoryid into the querystring of say, ...