cancel
Showing results for 
Search instead for 
Did you mean: 

Convert all product dimensions from mm to cm

Convert all product dimensions from mm to cm

Hi,

 

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?

 

Thanks.