Is there a filter available to Format an item price to include a comma in Klaviyo?

Greetings @Taylor Tarpley ,

Thanks for your reply. Much appreciated.

We can’t do the change in the database, it will cause a series of data integrity issues, especially when you run a site for different countries and locales. The solution is to format product price on the front-end (which we do that already on our website).

The source you have shared doesn’t touch on numbers formatting, or at least, doesn’t cover my case. 

As I mentioned before, django’s intcomma function is what can be used in django to format monetary values into comma separated (1234.00 → 1,234.00). However, when I tried using it in the email template, it didn’t work.

Here is the code I used according to django’s docs: {{item.Price|intcomma}}

When testing the template, I get the following error:

Nothing is clear about the error. And apparently intcomma is not part of the django library that klaviyo use, or could be something else.

Now are you able to spot the problem, or perhaps, provide an alternative solution? Or should I consider it a limitation in Klaviyo?

Thanks,

Hi,

I’m using the code that Taylor posted — with some minor tweaks. I use “item.LineSubTotal” rather than “event|lookup:'$value'”. And I want two decimal places so I use “floatformat:2” instead of ‘stringformat:"d"’. See below:

{% with val=item.LineSubTotal %} {% if val|where:'val > 999' %} ${{ val|floatformat:2|slice:":-6" }},{{ val|floatformat:2|slice:"-6:" }} {% else %}{{ val|floatformat:2 }}{% endif %} {% endwith %}
 

The if statement doesn’t appear to be functioning correctly, since I get $,300.00 rather than $300.00!

Amounts larger than a thousand look correct.

Any insights?

Thanks!

Wolfgang

{% with val=feeds.feedname.0.price %}${% if val > 999 %}{{ val|stringformat:"d"|slice:":-3" }},{{ val|stringformat:"d"|slice:"-3:" }} {% else %}{{ val|stringformat:"d" }}{% endif %} {% endwith %}

Here’s a solve for anyone using a non-event lookup value @Wolfgang 

Hi,

I am having the same issue, the price shows up as $7000 instead of $70.00

I have tried all of the above solutions, but I am not able to get $70.00, all I am getting is $7,000.00

Here are the two different version of the code I tried.

Version 1:

{% with val=item.line_price %} {% if val|where:'val > 999' %} ${{ val|stringformat:"d"|slice:":-3" }},{{ val|stringformat:"d"|slice:"-3:" }} {% else %}{{ val|stringformat:"d" }}{% endif %} {% endwith %}

Version 2:

{% with val=item.line_price %}${% if val > 999 %}{{ val|floatformat:2|slice:":-6" }},{{ val|floatformat:2|slice:"-6:" }} {% else %}{{ val|floatformat:2 }}{% endif %} {% endwith %}

I am obviously doing something wrong. Can someone please provide a solution?

Thank you 

Hi,

In the meantime I have found the filter that accomplishes the desired effect. As stated in the Klaviyo docs most Django filters are supported and as of Django 3.2:

The g suffix to force grouping by thousand separators was added to floatformat.

https://docs.djangoproject.com/en/4.0/ref/templates/builtins/#floatformat

So, all that’s needed is to run your value through the following filter:

{{ val|floatformat:”2g” }}

This simplifies things considerably.

Hi, just wanted to add, in case someone was trying to add commas to a non-price number, the |intcomma filter works if you first load the humanize django library. So, for example, instead of…

{{ person|lookup:'LoyaltyPoints'|intcomma }}

… you can use…

{% load humanize %}{{ person|lookup:'LoyaltyPoints'|intcomma }}

More on the django.contrib.humanize library here.