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

Question

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?

arpan-garg · Accepted Answer

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

jayakrishnaaparthasarathy · Answer

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.

Cadastre-se

Fazer o login com rede social

Bem-vindo

Fazer o login com rede social