I can't to see how to set a discount for an affiliation in selected stores only.
If I add the affiliation's price group and the store's price group to a discount, the affiliation will get the discount in every store, and every customer will get the discount in the selected store.
It should be possible to group these price groups in a way, which will result in only that affiliation will get the discount, and only in a selected store.
Comments
This can be done with extensions in v7,8, or 10.
1) Create a custom relationship table between the retail channel and the retail affiliation
2) Extend the CDX sync framework to push this data to the retail server
3) Extend the CRT to filter the customer affiliation when a customer is added to the cart.
Category: Pricing, Discounts, and Taxes
Administrator on 2/4/2023 8:56:56 AM
You can use the "Match all associated price groups" setting on discount configuration to fulfill this need. If a discount is linked to an affiation based price group and channel (store) based price group, when this setting is on, Commerce pricing engine only applies this discount when both affiliation and channel in the sales order context matches the configured conditions. There's a feature enhancement planned for 2023 release Wave 2 to further simplify price group condition setup to better support such combination scenario. - Boyce Zhu, Principal Product Manager for Dynamics 365 Commerce