For Commerce order data event ingestion what should be the unique id (_id) | Community
Skip to main content
Prithwiraj_Deb
Prithwiraj_Deb
Level 3
October 6, 2023
Solved

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

  • October 6, 2023
  • 2 replies
  • 683 views

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?  

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by arpan-garg

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

2 replies

jayakrishnaaparthasarathy
Community Advisor
jayakrishnaaparthasarathyCommunity Advisor
Community Advisor
October 6, 2023

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
Community Advisor
arpan-gargCommunity AdvisorAccepted solution
Community Advisor
October 9, 2023

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

Terms & ConditionsAccessibility statement

Loading footer...