I need to import the tables Category and Products into a new AC7 Database.
The previous database had this hierarchy (see pic):
Department > Categories > Products
1. I import the Categories into AC (using CategoryID as ParentId).
2. I import the Products into AC.
Question: How are the Products mapped to the Categories?
I don't see a field in the ac_Products table that maps to ac_Categories.
How do I do this?
I don't have to worry about the Department because
I can create categories for the "Departments" and move all the imported Categories into them later.
DataPort problem with Departments and Categories
Re: DataPort problem with Departments and Categories
Can this be done? thanks
Re: DataPort problem with Departments and Categories
Categories are associated to each other using ac_CategoryParents table. A separate many to many relation table as each category can have multiple parents and vice versa.
You can associate Products, Webpages and Links to categories using ac_CatalogNodes table. Here are the fields/columns:
CategoryId : the parent category
CatalogNodeId : the child node id, either product, webpage, link or category id
CatalogNodeTypeId : the type of the child catalog node, for 0 for category, 1 for product etc.
You can associate Products, Webpages and Links to categories using ac_CatalogNodes table. Here are the fields/columns:
CategoryId : the parent category
CatalogNodeId : the child node id, either product, webpage, link or category id
CatalogNodeTypeId : the type of the child catalog node, for 0 for category, 1 for product etc.
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