How add product pricing with VAT included in a productblock. (For an abandoned cart mail)

  • 25 January 2021
  • 1 reply

Badge +3

I am currently struggling to add the right price from Magento to the product block in the abandoned cart email. The price is currently showing with VAT excluded. Has anyone found a way to include VAT in the product price? 




Best answer by Paul S 28 January 2021, 23:38

View original

1 reply

Userlevel 5
Badge +10

Hi @Nickdonsje,

If you follow the instructions below, you should be able to get this to work.


If you want to show the quantity and total price for each product, navigate back to the column where the product title is present.

Type in “Quantity:” in the text box. Next, navigate to the preview window to find the event variable -- for example, {{ event.extra.line_items.0.quantity }}.


After exiting this window, paste the variable next to “Quantity,” replacing the collection and number with the alias.

For the total, use the line_price event variable (e.g., {{ event.extra.line_items.0.line_price }}), which will show the total price of a product based on the quantity. For instance, if you have a lipstick that costs $12, and someone has added two of them, the line price will show as $24.


As with the quantity, write in “Total:” and replace the collection with the alias. To display the currency, either add in the currency symbol before the brackets — for instance, ${{ item.line_price }} — or add % currency_format inside the brackets and before the event variable as well as another before the closing brackets — for example, {% currency_format item.line_price %}. Note that the currency format tag cannot be used with the float format tag.


 Hope that helps if it has not already been resolved.