Is there a way to calculate Gross Profit Margins for products?

There is a tab which I have placed on my thumbnails which states the percentage of savings made on products on sale. I would like to change this logic so that it displays profit margins for all products when wholesale clients purchase products. Is this possible through [%calc$]?

Find more posts tagged with

Integrations

Webstore

Accepted answers

All comments

Erik Merkley

Yep that's easily done with [%calc%]. Try this:

[%format type:'percent'%][%calc 100 * (([@store_price@] - [@cost@]) / [@store_price@]) /%][%/format%]

(assumes both your store price and cost price include GST)

Jonathon Mackay

Excellent thank you! If I were wanting cost price to be exc GST, is there a way to do so?

Erik Merkley

Yep just a bit more maths:

[%format type:'percent'%][%calc 100 * (([@store_price@] - [@cost@] * 1.1) / [@store_price@]) /%][%/format%]

Jonathon Mackay

Legend Erik! You're a lifesaver, I'm sure you'll be getting plenty of questions from me ?

Erik Merkley

Ha unfortunately I'm away for the next five weeks! But I'm sure Curtis can help you out. Also have a read through Neto's docs, they are now quite thorough.

Jonathon Mackay

Ah bummer! I'm sure Curtis will certainly help out!

I'll have a look at them.

Jonathon Mackay

Hi Erik,

The code you provided wasn't functioning correctly, in terms of ([@retail@] - [@store_price@]) / ([@retail@] / 1.1) is this possible to calculate Gross Profit?

In other words, the store price is (Ex GST Wholesale Price) divided by (RRP divided by 1.1).

Erik Merkley

Hi Jonathon,

Not too sure what you mean? Store price is the current listed price on your website for that user's group (taking into account any promotions etc). Retail is the RRP. So a GP calculation should be based on store price and cost price.

Jonathon Mackay

Hi Erik,

all is good as I figured it out! Was an issue of placement of code thanks for your help!!