sql command to change values - Canada Post

[tony_sar]

Hey ..

I installed Canada post module , by default this module adds three field in products table , each with 12.00 as value , thus now all products have this value .

I have manually removed the default 12 from the field so now when i crate new product , there is no longer this value set in product height , width and length.

now i need to remove all that value from all the products.

is this sql statement correct for doing this ?


UPDATE zen_products SET products_length , products_weight , products_height = 0;

[tony_sar]

Hello.
I installed canada post on zc 1.38, by default values such as dimension are set to 12.00 so , i decided to remove that from products table and set to 0.00 using PHPmyadmin.

Again , i went back and set the number back to 12.00 , but default settings no longer apply to new product page .

I dropped those field in DB , and reinstall sql patch , still i have no default setting in my new product page .

i reinstalled canada post from module location , still the same thing.

it is very odd as why default values are not showing in canada post fields .
any suggestion ?

ps: no other value in db was altered.

Thanks.