| Join Name | Join Condition | Join Details | Optional Join Configuration | Auto |
| Published Lookup Folder -> Assigned Products | Catalog - Published Lookup Folder.Lookup Code = Catalog - Assigned Products.Published | Always exist in master folder | None | No |
| Published Lookup Folder -> Catalog Exclusions | Catalog - Published Lookup Folder.Lookup Code = Catalog - Sections Excluded From Stores.Published | Always exist in master folder | One to one join | No |
| Published Lookup Folder -> Catalog Sections | Catalog - Published Lookup Folder.Lookup Code = Catalog - Sections With Or Without Stores.Published | Always exist in master folder | One to one join | No |
| Published Lookup Folder -> Empty Catalog Sections | Catalog - Published Lookup Folder.Lookup Code = Catalog - Empty Sections.Published | Always exist in master folder | One to one join | No |
| Published Lookup Folder -> Excluded Products | Catalog - Published Lookup Folder.Lookup Code = Catalog - Products Excluded By Store.Published | Always exist in master folder | None | No |
| Published Lookup Folder -> Products By Store | Catalog - Published Lookup Folder.Lookup Code = Catalog - Products By Store.Published | Always exist in master folder | None | No |
| Published Lookup Folder -> Unassigned Products | Catalog - Published Lookup Folder.Lookup Code = Catalog - Unassigned Products.Published | Always exist in master folder | None | No |