I am looking to install and configure a shipping extension for a store that I am working on. The issue I have is that the extension requires the product dimensions to be in CM when calculating shipping rates. When my products have been uploaded the dimensions for each are in MM, I therefore need a way to bulk convert these values for all products.
Is there a way for this to be done with a SQL UPDATE statement or maybe using magento collections?
Alternatively I think this could be done using magento's built in Import / Export feature. By exporting the SKU, width, length and depth columns only, update the exported CSV with the converted values, then re import . Although I figure this way is a little more manual and potentially longer?
Has anyone done something similar before? Or which of the above would be the best approach to take?