Sorry - I didn't explain properly - All the products in my store are kgs/cm - no lbs/in

In the insert statement the product_status value '0' was being set after products_weight but should have been set after products_ready_to_ship according to the column order in statement

As a result the values for next 6 columns were off by 1 (width column was set to length value, height column was set to width value)