Posted on 24/08/2016 11:35:32
Hi Nicolai,
I can't use discounts. In this project we are usig Live Integration for both Discounts, Taxes and Shipping. If we add a DW discount and/or product price different than expected, it get's updated. They don't want live Prices, so we need to account for DW to show the prices from the DB in the product list and product detail pages (only the cart is fully controlled by the ERP)
This being said, I was afraid you would say that and it makes perfect sense. But because I need different prices on the product level based on the country, I will try the database approach though. Thanks.
If your suggestion does not work, the only thing I can think of is create a SQL procedure and/or a produce save notification that updates the price matrix for the product, creating the necessary prices. The customer would simply have to learn how to identify those.
Let me know if you remember anything else I can do.
Best Regards,
Nuno