Expand my Community achievements bar.

SOLVED

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

Avatar

Level 3

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?  

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Community Advisor

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.

Avatar

Correct answer by
Community Advisor

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