Solved

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

  • 25 January 2021
  • 1 reply
  • 82 views

Badge

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? 

 

Thanks! 

icon

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

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 }}.

image23.png

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.

image22.png 

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.

image15.png

 Hope that helps if it has not already been resolved.

View original

1 reply

Userlevel 5
Badge +3

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 }}.

image23.png

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.

image22.png 

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.

image15.png

 Hope that helps if it has not already been resolved.

Reply