Category Importing
Category Importing
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
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
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Category Importing
Are you making entries in the ac_CatalogNodes and ac_CategoryParents table? Those have to be populated also.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Re: Category Importing
Hello jmestep...
YOU ARE AN ANGEL !!!
It's working !!!
Thank you and have a good day !!!!!
YOU ARE AN ANGEL !!!
It's working !!!
Thank you and have a good day !!!!!
Re: Category Importing
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
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
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.
Thanks for your support
Naveed Ashraf
.com
AbleCommerce Help Center
AbleCommerce Developer WIKI
Follow us on Twitter
Naveed Ashraf
.com
AbleCommerce Help Center
AbleCommerce Developer WIKI
Follow us on Twitter
Re: Category Importing
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
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
Please check the following wiki article for explanation about the ac_CategoryParents table.
http://wiki.ablecommerce.com/index.php/ ... Categories
http://wiki.ablecommerce.com/index.php/ ... Categories
Thanks for your support
Naveed Ashraf
.com
AbleCommerce Help Center
AbleCommerce Developer WIKI
Follow us on Twitter
Naveed Ashraf
.com
AbleCommerce Help Center
AbleCommerce Developer WIKI
Follow us on Twitter
Re: Category Importing
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
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