Do you have any data that you want to migrate? If yes it will be very tricky. But if no you once you removed the property you should be able to unlink it from the metaclass and then delete it using Commerce Manager.

There is existing data, but we can run a job to repopulate that data.  It's the product data, so would I have to delete the product data, restart the site without the property in the code, and then unlink and delete the property, then add the property back in with the new data type, restart the site again, and then repopulate the data?

Hi Brian,

I think there is no option in Episerver commerce UI to update datatype directly but you can change the datatype with help of the database approach:

• Open the database and find the tables in the database which you want to delete using the column name.

SELECT      COLUMN_NAME AS 'ColumnName'
            ,TABLE_NAME AS  'TableName'
FROM        INFORMATION_SCHEMA.COLUMNS
WHERE       COLUMN_NAME LIKE '%MyColumnName%'
ORDER BY    TableName
            ,ColumnName;

• Drop the column name for tables that will populate from the above query.

ALTER TABLE [Table 1]
DROP COLUMN MyColumnName

ALTER TABLE [Table 2]
DROP COLUMN MyColumnName

• Deleted MetaFileds and their Relations

DECLARE @MetaFieldId INT

SELECT @MetaFieldId=MetaFieldId  FROM MetaField WHERE Name='MyColumnName'
DELETE FROM MetaClassMetaFieldRelation WHERE MetaFieldId=@MetaFieldId

DELETE FROM MetaField WHERE Name='MyColumnName

• Change the datatype from DataType = MetaDataType.Double, for the meta field and re-run the solution.

Note: FYI Episerver does not recommend the database approach.

@Brian W (Whereoware) Yes, basically that.

• Remove the property from code, build and start the site FIRST
• Start and go to Commerce Manager and unlink the metafield from the MetaClass
• Readd the property to code with different type, build and start the site
• Repopulate the data

I Support Quan's answer and in any CMS it is not a good idea to directly update the table with queries.

But sometimes you can not lose data. If you delete and re-create column then you will lose data.

If I remember correctly double is a float data type in SQL. So according to SQL, you can convert decimal to float using the following query. (Remember first you need to change type in code. It will crash the website. Then you need to change in DB and restart it)

ALTER TABLE TableName
ALTER COLUMN ColumnName float;