Help

Suggest a Retail price to match the profit margin

Topic Labels: Formulas
294 3
cancel
Showing results for 
Search instead for 
Did you mean: 
mp3dshop
4 - Data Explorer
4 - Data Explorer

Hi all,

Struggling with this one and I'm not sure if it's even possible.

I have a table that works out total cost of a product, total cost of a product inc fees on Etsy total cost of a product inc fees on shopify.

Etsy fees are always higher than shopify, so it makes things slightly easier.

I currently set the retail price manually and then it shows fees, profit margin for shopify and etsy separately.

What I'd like to be able to do is suggest a retail price for etsy, based on matching the profit margin of shopify. The fees of Etsy are higher so I can't just add the profit margin difference to the retail.

I do have individual columns for each fee type if that helps?

Here are my columns I currently have - 

  • Total Cost
  • Retail
  • Etsy Transaction Fee
  • Etsy Processing Fee
  • Etsy Operating Fee
  • Total Etsy Fees
  • Total Cost with Etsy Fees
  • Etsy Profit (£)
  • Etsy Profit Margin (%)
  • Shopify Fee
  • Total Cost with Shopify Fees
  • Shopify Profit (£)
  • Shopify Profit Margin (%)

    I'm assuming I'd need to do something like work out the % difference between both Total Cost with Etsy Fees and Total Cost with Shopify fees, then add this percentage to the Retail?
3 Replies 3

Could you provide a screenshot of your table with some example data and an example of the output you'd want generated?

mp3dshop
4 - Data Explorer
4 - Data Explorer

Hi Adam,

I've sent you a PM re another question, if I can ask you about this at the same time that would be great.

Yeap sure, I've received the PM and will reply there!