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?
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @Prithwiraj_Deb - You can also create a mapping of the _id field in your dataset and map it to the guid() function.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Hi @Prithwiraj_Deb - You can also create a mapping of the _id field in your dataset and map it to the guid() function.
Views
Replies
Total Likes