How can I add products to LPGs by Product Extension filters?

Owned by Jana Volencová
Last updated: Aug 01, 2022 by Jan Panoušek
1 min read

Question

My project uses many Product Extensions (PX). How can I add products to LPGs by Product Extension filters? The requirement is simply: "to have more attributes in Product master" + "add Products into LPGs based on those extended attributes".

I can imagine using a Product Input Filter logic filtering on the PX attributes. But there is no option to show the PX attributes in the LPG Product Picker.

Answer

All product pickers can filter on the PX properties in the Advanced Filter Builder, if you enable "Allow Search" on the given extension. But you cannot add to the picker as a column. The reasoning is that the PX may have a 1-to-many relationship with products - so there is no way to add as a column and maintain data integrity.

Watch out for limitation of using filtering based on PX and advanced filtering with several sub-groups. It’s not working properly by default without the optimizeQueriesToExtensionTables option set.

Found an issue in documentation? Write to us.