Developer forum

Hello Barend,

- Field value conversions (Settings > Areas > Products > Attributes > Field value conversion > Field value conversion groups) are saved in the following tables: EcomFieldValueConversionGroup + EcomFieldValueConversion. Verified in DW10.20.8.

I know there have been some issues with the fields in earlier versions of DW10, so you might have to upgrade to latest version before it works as expected.

Br. Michael Knudsen

Hi Michael,

Thansk for your response.

Indeed EcomFieldValueConversionGroup and EcomFieldValueConversion contains the definition of the unit measures and conversions.
But is there a table that saves the relation between the product, their product field data and its corresponding measure?
In the above example: I know that ml -> L conversion in saved in the above stated tables, but the 'L' part of the '2 L' value is not.

I'm looking for the '2 L' fully.

Cheers!

Hello Barend,

- I think the value "2 L" are calculated each time you ask for the value in the field, so nothing are required to re-calculate if the conversions changes.

I found some new fields on EcomProductField:
ProductFieldValueConversionPreset + ProductFieldValueConversionDecimals + ProductFieldValueConversionDisplayRule

Br. Michael Knudsen

Yes, those fields correspond with these: 

For example. When importing decimal data, such as weight, it's not possible to specifically import into a unit that is not selected as default. 
Say we have 'weight', with gram -> kg as unit options. Default = gram, but this product has its data stated in kg, we have to make the conversion in the source file since we cannot state the unit in the import since it's not stored in the database.

When I compare it to DW9, the unit conversion is created as custom product field types, meaning that a value of 'weight' is stored as '9,5 kg'. Meaning you can import '10 gram' in weight, and it automatically selects 'gram' in the unit list. I'm not seeing a similar idea in DW10 so far.

Hi there,

I think I'm not understanding this fully.

Say I have a unit conversion of ml -> L:


The unit conversion is used on a product category field called 'Inhoud'.
On a test product the value 13,54 is filled with mililiters as the unit:


In the database only the numerical value is saved. How do we know this is specifically the value for ml?

Converting this to liters by selecting L is the list will not save the corresponding converted value in the database:

- Keeps 15.54 in the database

Is this the intended way for working with unit conversions?

I have a feeling it might have something to do with the presentation unit. Apparently, products will always bounce back to the unit selected here. On Product Fields we can set this back to nothing, this will also remove the selected conversion definition when save and close the product field. Also, this option is not available on product category fields.


Looking forward to hearing more.

Tested on DW versions 10.20.12 and 10.19.14.

Hi there,

Is there an update on this?