How to get the total purchase without taxes when you have applied a discount coupon?

jmorodg
6 years ago
0 +0 / -0

Hello, my name is Juan and I have Joomla 3.8.13, Virtuemart 3.2.14. I need to show the total of the purchase with a discount applied Awocupon without the tax in my invoices. In the image that I attach you can see the example, I that the data has to be somewhere but I do not know how to take it and show it.
thank you!!
seyi
6 years ago
0 +0 / -0

Hello,

Once an order is processed, awocoupon stores the details of the discount here:
table: #__awocoupon_history
column: total_product

if in awocoupon you have discount before tax set to 'yes', then total_product will hold the discount before tax, if the config is set to 'no', then it will be the discount including tax. But sounds like in your configuration you have it set to 'yes', so it should work. You can then subtract this from the virtuemart product total excluding tax to get the value you want.

This information is json encoded. So to get the
Regards
jmorodg
6 years ago
0 +0 / -0

Hello good day. I have managed to solve it, following the steps of this post: http://forum.virtuemart.net/index.php?topic=133598.0

Thank you very much for your help. I hope that this will also help other people with the same problem