Showing Compare To Prices on Invoices

[mscmith11]

I see this question has been posed previously with no responses.

Many of our products are discounted, meaning the "Price" differs from the sale price or Shopify "Compare-at price".

This is an important piece of information for customers to see on the invoices produced, but none of the 3rd party apps seem to recognize discounted pricing unless you enter a manual discount to the items in the order or when a customer uses a discount code. Otherwise, customers are not shown the price paid versus the regular price.

How can we add the compare-at-price field on the invoice? I'm surprised this is not an important topic for retailers.

Thank you.

[Promer]

Hi @mscmith11 

Unfortunately, Shopify's native invoicing system doesn't automatically include this field, but here are a few recommendations you can explore:

1. Customizing your order confirmation template 

If you're using Shopify's built-in invoice system (via order confirmations), you might be able to modify the email template to include the Compare-at price. You can do this by editing the Liquid code in Settings > Notifications > Order Confirmation. Try adding:

{% for line in order.line_items %}
<p>{{ line.product.title }}</p>
<p>Regular Price: {{ line.compare_at_price | money }}</p>
<p>Sale Price: {{ line.price | money }}</p>
{% endfor %}

2. Custom invoice solutions via Shopify Scripts & Checkout Extensibility (for Shopify Plus)

If you're on Shopify Plus, you could:

• Use Shopify Scripts to create line-item scripts that display Compare-at prices on invoices.
• Build a custom Shopify Flow automation to generate invoices with the correct pricing data.

If you need a workaround, you can:

• Export your orders using an app like Data Export Reports or EZ Exporter.
• Include Compare-at prices in the exported file.
• Generate custom invoices using tools like Google Sheets, Excel, or an invoicing app like QuickBooks.