createdTS in item can be updated using impex?

[former_member620352]

Hi,

As part of migrating from another system, we are inserting records into hybris items through impex. We tried to update the createdTS using the value coming from the other system. But it is always getting updated with the current time stamp. Can we achieve it in any special way?

Thanks in advance Priyanka

[Former Member]

As far as I know CreatedTs o can not be updated in hybris system using impex.

To persist the createdTs of the other system in your new system, you can create a new attribute for the item to hold the createdTs of the source system. You can simply save the info in the Hybris system as well.

Please let me know if you have any questions.

[venky_194]

On top of this, you can do db level column swap so that data from new attribute can be copied in createdTS.

[former_member620352]

I found a way. If you check the abstractorder it has a "date" field which internally refers to "createdTS". In this case we can update the createdTS using "date" field in impex.

[Former Member]

on DB layer directly (while hybris is stopped):

 update products set createdTS = '2011-04-12 08:02:59’ (new time stamp) where PK = ‘8797113221121’ (product pk);
 

[Former Member]

I think that if you execute the impex on legacyMode you will be able to update that field.