EPiServer Commerce 1 and Associations

If working with associations in EPiServer commerce (e.g accessories or related products) and wonder which associations are active – just look in the tables CatalogAssociation  and CatalogEntryAssociation.

SELECT *
FROM [MyCommerceDB].[dbo].[CatalogAssociation]
WHERE Associationname LIKE '%Free%'

The column CatalogAssociationId indicates the foreign key in CatalogEntryAssociation table.

SELECT
[CatalogAssociationId]
,[CatalogEntryId]
,[SortOrder]
,[AssociationTypeId]
FROM [MyCommerceDB].[dbo.[CatalogEntryAssociation] where CatalogAssociationId = 123

Replace 123 with your CatalogAssoicationId.