I am designing an e-commerce site where I am planning on selling gold jewellery. Prices for my products are fixed to gold price. I would like to input weight info (public) and profit (hidden and in weight unit) for my products, and prices for each product to be calculated with the daily gold price (I can update it manually). Is there a way to apply this type of feature to my product pricing?
For example, a gram of gold is $53 today. 5 grams of gold bracelet with a profit of 0.5 grams is priced as $291.5 today. I would like to change the gold price tomorrow and all my gold products are calculated with the new price. Is this doable in Wix?