Commerce Server Blog

I had a decimal property (“Weight”) created using commerce server catalog and inventory schema manager tool and I added this property as base property for all products. During catalog import, I am able to insert value with three or four precision into this field but when the business user  opens through catalog manager, the value is getting round off (only two precision showed). If mistakenly if he saves, wrong data is saved back to database.

For example, if the value in database is 4.2345, in catalog manager, it is showing as 4.23 as shown in the figure.

After analyzing the facts, what I found out is whenever a property of decimal is created from catalog manager, a new data column is created database products table of type float. Replacing float with Decimal (18,4), I am able to get back the entire value back in catalog manager, as shown in below.

If you like this post, please click on our sponsor advertisement.