Show Discounted Line Item Price? (Shopify Order Confirmation with Dynamic Table)

Question

How do you display a discounted line item price in a dynamic table for Shopify order confirmations?

I’ve followed this article’s instructions, but found that the line item price is displayed as the actual price of the item, so it doesn’t take into account if our sales agents discount an item. Our totals at the bottom of the confirmation are correct, but it’s confusing for customers when they don’t see the actual discounted line item price in the dynamic table.

I’ve setup the data source for the row and have the following four columns. Is there a way to display the discounted price in the PRICE column? Or do I need to include a column that shows the discount amount, which gets calculated in the ITEM TOTAL column?

ITEM
{{ item.product.title }}

QUANTITY
${{ item.quantity|floatformat:0 }}

PRICE
${{ item.price|floatformat:2 }}

ITEM TOTAL
${{ item.line_price|floatformat:2 }}

cassy.lee · Accepted Answer

Hi @PRMjames,Can you try using{{ event|lookup:'Total Discounts' }}without copy + pasting. I think what might be happening, if I am seeing this correctly, is that your code above using incorrect syntax. You should be using the single quotation - I think what happened above is that I pasted in the incorrect syntax of the code.Notice how this code snippet:{{ event|lookup:‘Total Discounts’ }}has a different single quotation from this code snippet:{{ event|lookup:'Total Discounts' }}Please copy and paste the latter one, which should pull up the correct total discount value for you.Thanks,-Cassy

cassy.lee · Answer

Hi@PRMjames,Thanks for the great question, and for being a part of the Klaviyo Community forum!If this is a confirmation email in Klaviyo, you could include this event variable in PRICE, or add it as it’s own Discount column.{{ event|lookup:'Total Discounts' }}This code will display the total discount for the entire order.Additionally, “discounted item prices” can vary based on how you have the data structured, and you would need to find the correct variable within the Placed Order metric by using the directions found in the How to Find Event Variables section of this article.Hope this is helpful!-Cassy

Show Discounted Line Item Price? (Shopify Order Confirmation with Dynamic Table)

4 replies

Reply

Reply

Related topics

Flow Query wrt Smile rewardsicon

Feature Request: Allow Subscribers to Trigger Flows More than Onceicon

flow helpicon

Klaviyo Reviews are here!

Review reward - Klaviyo Reviewsicon

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded