I am trying to decide which ecom atform to use for an upcoming clients site. The client sell products which prices are commodity based ie fuel/metals etc. I want to set the price of each item to be linked to this.
Methods I’ve come up with.
1 products have assigned quantity. Ie weight in grams. Then in another module you set the price per gram and update pricing preferably via SQL since other methods seem slow.
2 products use either a 1x formula for pricing and I can assign variables x y z etc a set amount.
Either way I need to be able to set the price per ounce on metals etc and have that automatically adjust all prices accordingly.
Any thoughts or ideas of extensions I can use or methods and suggestions for making my own.