Forum management
- Threads started by me
- Threads I participate in

Developer forum

Store discount values in the price matrix

E-mail notifications

Davy Capiau

Posted on 07/11/2024 14:05:35

Hi ,

Setup:

- DW10
- Swift

- Batch Integration with XML

- Prices stored in price matrix

Context:

- Show specific price of customer on the product page, generated from the price matrix

Question:

- Next to the individual price and the informative price we want to show the 'discount amount' and 'discount percentage' for a specific customer on the frontend on the product page. I think we should store it in the price matrix, but not sure how to?

- Below you see an excerpt of the data source and how it could be visualised on the frontend.

Replies

Davy Capiau

Posted on 08/11/2024 13:00:01

Response by Aleksandar Ivanov

this type of data can be stored in the DW database and displayed in the way you need but with some caveats.

The price matrix does not have a field to store the discount percentage, but if you have the Original amount and the Discount amount, this can be calculated and displayed in the frontend with some small modifications to the Swift template. I've put together a quick example

This is how it looks in the backend

The other issue I can see comparing against your data source is that the informative price needs to have its row in the PriceMatrix (EcomPrices table) which could be solved in the integration job.

You must be logged in to post in the forum