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?