Link between Categories and Products tables

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
tcv
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Tue Dec 23, 2008 3:34 pm

Link between Categories and Products tables

Post by tcv » Tue Dec 23, 2008 4:41 pm

I am using a trial version of Able Commerce 7.0 Asp.NET 2.0 Shopping cart.
In the AbleCommerce database I am trying to figure out how the "ac_Categories" and "ac_Products" tables are linked with each other. In ac_Products table there is no foreign key to ac_categories table. I did not see any bridge table like "ac_ProductCategories either. Can any body let me know how these two tables are related?

Thanks

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Link between Categories and Products tables

Post by jmestep » Tue Dec 23, 2008 6:05 pm

The link is in the ac_CatalogNodes table.
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

Post Reply