For Commerce order data event ingestion what should be the unique id (_id)

[Prithwiraj_Deb]

For Commerce order data event ingestion what should be the unique id (_id)

If we have incoming event fields like 

Order ID, LastOrderupdatetimestamp, Order Date 

I guess it should be Order ID + LastOrderupdateTimestamp even though Order IDs are generally unique in nature but AEP best practice suggest that to avoid duplicate _ID it should always be concatenated with another field. 

Any suggestion?  

[jayakrishnaaparthasarathy]

Hi @Prithwiraj_Deb  - Yes, you are right. Having order ID + LastOrderupdatetimestamp attribute is a best combination for _ID. Adobe also suggest the same combination to be unique in _ID value.

If you are pretty confident that Order ID alone is unique you can still use it under _ID, but to be safer side it is highly recommned to have concadenate with timestamp field.

[arpan-garg · Accepted solution]

Hi @Prithwiraj_Deb - You can also create a mapping of the _id field in your dataset and map it to the guid() function.