I have a potential customer who wants a website to sell silver and gold coins. Because the price of these metals fluctuate daily, it can be challenging to update the prices of all of the items to keep the markup at a certain amount or percentage.
Is there a way, a module, etc. out there that would allow me to say on "this" item i want a $2 markup over the spot silver price and have the website automatically update the prices?
It would be a similar concept to the currency converter. Depending on the exchange rate for any given day, the website will update it accordingly. I want to do the same thing, just with my product prices.
The kicker is that it would only be certain products that would need to be automatically updated. If I could set an entire category to automatically update I can make that work if it's easier than each product individually.
Please help--me getting this job depends on whether or not I can make this work!
Thank you in advance!



