[Solved] change m to mm for all products

Hi,

In the beginning we just used the default "Dimension symbols" parameters under Main -> Advanced Settings.
I don't know if the default values have to do with the fact that it's showing every product with "m"

1) Should I change m,dm,cm,mm,in,ft,yd into mm or can/should I leave this and change m to mm somewhere else?

I know I can do it for each product individully by going into the product and change the dropdown from m to mm.
But I want to do this for all products.

2) Can this be done in the backend? If not can I do this in the DB with phpmysql?

Regards,

SG

Hi there,

Indeed there is no way to do this through the back but a query can change this really easily.
The variable to change is "product_dimension_unit" in the table "alias_hikashop_product" (where alias is your tables' alias) so you have to make a request like this:

UPDATE alias_hikashop_product
 SET product_dimension_unit="mm"