Hello @AndrewK,

If you haven’t already, I would suggest checking out @elisegaines’s awesome answer to a similar topic in the Community post below:

In essence, you’ll want to review your Started Checkout and see if it’s passing any additional prices such as one that does include the GST/tax amount. 

If your Started Checkout event was not passing an additional price inclusive of the tax, another workaround would be using variables filters for math to calculate and display the product cost with the tax amount. This solution works great if you have a standard tax tax rate or if you’re passing an additional variable that is just the tax amount. I touched upon this a bit in the Community post below:

I hope this helps!

David

Hey @David To, thanks for your reply mate!

To my suprise, I couldn’t find that the Started Checkout event was passing the price incl. tax.

Just to confirm, the way I checked was I did a CMD+F/CTRL+F to see if there was the price including tax in the preview section.

In this case I was searching for $275 which was not there.

Ideally it’d be nice if the data came directly from Magento, however since it wasn’t there, I added the variable filter “|multiply:1.1” to manually add the GST which works fine!

The variable now reads: Total: ${{ item.RowTotal|multiply:1.1|floatformat:2 }}

*One concern I have is that occasionally the rounding isn’t always accurate.

Eg. the price of the product here should be incl. $139.00 incl. tax

After applying the variable filter shown above, it calculates the price as $139.01.

Would you have any advice for this?

Much appreciated.

Cheers,
Andrew

*Update, I was able to find the price including GST here:

However, when I use this string to get the price, it only displays the price of the first item across all the products in the event.

I’m not sure what to change with the string here

Hey @AndrewK,

Glad to hear you were able to find a data point that was passing your product price inclusive of the GST!

Since the price is reflecting the first product in the array, it sounds like you may not have reformat the variable correctly when you placed it into the dynamic table block. I would suggest taking a look at the following Help Center article to learn more about building dynamic table blocks. This would include instructions on how to reformat the variables you use within the table block. Essentially the reformatted variable you use will need to be aligned with how you’ve set up the row collection.

• How to Build Dynamic Blocks in a Flow Email (new editor)
• Repeating a Block Based on Dynamic Data (classic editor)
• How to build dynamic blocks in a flow email

Another great resource would be @Anna McCarthy’s Community post which I’ve linked below where she offers a walkthrough on how to build a dynamic table block. Although the video is centered on using the new editor, the methodologies and theories she explains would still translate to the classic editor.

David