Page 1 of 1

Category Importing

Posted: Mon Oct 20, 2014 3:15 pm
by synergy
Hello,
We've Created a script to populate the AC Categories table and so far it is working. All the fields are filled correctly and we can see all the categories and subcategories on Import's Page.
Unfortunately we can't see on the webpage ecommerce as well.
When we are creating new records through the categories page is working perfectly fine, it looks like we are missing something but we couldn't identify.
Does anyone had the same kind of problem ?
Cheers

Re: Category Importing

Posted: Tue Oct 21, 2014 3:16 am
by jmestep
Are you making entries in the ac_CatalogNodes and ac_CategoryParents table? Those have to be populated also.

Re: Category Importing

Posted: Tue Oct 21, 2014 8:56 am
by synergy
Hello jmestep...

YOU ARE AN ANGEL !!! :)

It's working !!!

Thank you and have a good day !!!!!

Re: Category Importing

Posted: Fri May 15, 2015 7:36 am
by notsop
Hello,

I'm trying to import an incredibly complex category structure and I'm able to populate catalogNode and ac_category table but the ac_categoryParents table is kicking my butt. I was looking in the api reference and it mentions a category.updateParent method that will assist in recreating this table however I'm not familiar on how to call this method in a script.Can someone point me in correct direction?
Thank you very much for any suggestions.

Thanks,

Chandler

Re: Category Importing

Posted: Thu May 21, 2015 6:02 am
by Naveed
Are you trying to populate database records programmatically (using Asp.NET, C# etc.) or using some SQL script? it will help us answer your question if you post more details about your category structure and the way you want to populate.

Re: Category Importing

Posted: Thu May 21, 2015 6:52 am
by notsop
Hello Naveed,

I'm not populating the database records programmatically, I'm using a sql script to populate the ac_Categories and ac_CatalogNodes tables. I was just curious if there was an easier way of populating the ac_CategoryParents table based on what was in those two tables. I was able to successfully import those two tables and everything appears to be working without the CategoryParents populated, I was just asking becuase in the developers wiki, it mentioned a UpdateParent Method that I couldn't find listed in the gold help file. Anyway, I wasn't sure how I would run a programmatic script anyway because I've barely scratched the surface working with the code.

Thanks,

Chandler

Re: Category Importing

Posted: Thu May 21, 2015 8:33 am
by Naveed
Please check the following wiki article for explanation about the ac_CategoryParents table.

http://wiki.ablecommerce.com/index.php/ ... Categories

Re: Category Importing

Posted: Fri Jun 12, 2015 8:15 am
by notsop
Thanks, Naveed.

I saw this page earlier but I was just trying to be lazy and was trying to figure out how to run Category.UpdateParent

Apparently, there is no updateParent Method in Gold. If there is I couldn't find it.

Thanks again