Product Pricing with Formulas and Input Field

[cella_ce]

Hi everyone,

I'm looking to sell gold leaf through my Shopify store. However, the gold price changes daily and so do the prices for gold leaf on my website. Updating each product variant manually every morning is not feasible. 

Does anyone know of a solution that allows me to implement pricing formulas for my products, instead of fixed prices, with one variable (wich I would use for the gold price) so that I can then update it daily in one place to make my product prices adjust all at once? 

Any help or advice would be greatly appreciated! 

[cella_ce]

Hi _is_null_, thank you for your response! I have tried the Live Gold Price Editor app, but couldn't make it work in my case. The way our prices are built is a little more complex and requires me to enter a different formula (including a variable for the gold price) for every single variant. 

I tried a few other apps and was able to make it work with 'Sheets - Data Connector' app. It allows me to enter my formulas in google sheets, bulk edit prices and upload them into my store. It's not the ideal solution but it works well for now and will save us a lot of time.