Posted on 13/05/2024 12:17:12
Damn. Ok
I had a look around for some concrete code examples of how to solve this with a custom price provider, but could find none.
Could someone point me in the correct direction?
Our design is currently based on an ExtranetLoginNotification which fires and grabs a customernumber for a group of users
This customer number is then used in an SQL query against 3 custom tables that are synced from the ERP (they together form the price matrix)
We were advised not to try adding all these customer / discount combinations into DW using the standard discount setup as this would cause way too many price checks, so thats why we imported the tables and used a query to get the customer specific discounts
From that query, we get a bunch of ProductID's and Discount percentages which we assign to a session object, and then use that session object with a LineAddedNotification Subscriber Its these productids / discounts / descriptions, that we want to use in the price provider, I would guess, but we do not know how to use the price providers
Hope someone can help.
Cheers
//Steve