Simple SQL script to show all Associations in EPiServer Commerce 1

There seem to be no good way to show all Entry Assocations (e.g. entries that have listings for accesories or related products set),  in Commerce, so I just created some simple SQL scripts

Show all

If you need the associated entries as well, dig into this table:
[dbo].[CatalogEntryAssociation]

Where association contains ‘Expired’

Most common associations counted
A variant for showing the most common associations (counted) are:

Leave a Reply