AbleCommerce Shopping Cart Software

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.

Can this be done? thanks

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.