Skip to main content
Luca_Lattarini
Luca_Lattarini
Level 9
September 12, 2022
Solved

Importing Purchase Order data into AEP

Hello guys,

 

I am importing a purchase Order into AEP. Any suggestion to build the unique ID (_id), do we have some best practices to be followed? Every experience event must have Point Of Sale ID.

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ChetanyaJain-1
ChetanyaJain-1Accepted solution
Community Advisor
September 12, 2022

Hi @luca_lattarini, 

Before you construct, do consider the below points:

  • purchase orders can be from multiple stores (POS) and from online
  • orders may be stored in multiple systems (depending on scenarios from client)

The best way would be to prefix this sourceId, storeId, and the purchaseId of the order from that store. This will make it unique.

 

Thanks,

Chetanya

View in thread

10 replies

ChetanyaJain-1
Community Advisor
ChetanyaJain-1Community AdvisorAccepted solution
Community Advisor
September 12, 2022

Hi @luca_lattarini, 

Before you construct, do consider the below points:

  • purchase orders can be from multiple stores (POS) and from online
  • orders may be stored in multiple systems (depending on scenarios from client)

The best way would be to prefix this sourceId, storeId, and the purchaseId of the order from that store. This will make it unique.

 

Thanks,

Chetanya

Translate
    Danny-Miller
    Adobe Employee
    Danny-MillerAdobe Employee
    Adobe Employee
    September 12, 2022

    @luca_lattarini Another thing to consider is if a Purchase Order would ever change (e.g. status)?  If so, remember:

    1. Events are immutable.
    2. It will need to be ingested as a new Event
      1. Any _id strategy will need to accommodate this (e.g. concat(purchaseId + latest updated date) )
    Translate
      ChetanyaJain-1
      Community Advisor
      ChetanyaJain-1Community Advisor
      Community Advisor
      September 12, 2022

      Great point @danny-miller 

      Translate
        Anil_Umachigi
        Adobe Employee
        Anil_UmachigiAdobe Employee
        Adobe Employee
        September 13, 2022

        Couple more things i could think of 

        • Think on how purchase id/ sale id will work in case of returns and exchanges
        • Check timestamp and ensure it is order/txn timestamp. 
        Translate
          Luca_Lattarini
          Luca_LattariniAuthor
          Level 9
          September 13, 2022

          Thanks guys for the very helpful suggestion that I will use. 

          I have another question, assuming that i have an event with _id:"1000" email:"xxx", purchased:"shoes model 1" with no timestamp. What happend if  later I ingest another another event with same _id but for example _id:"1000" email:"xxx", purchased:"shoes model 2" .

          Is it possible that the last event overrides the previous event  and i will only see the last event ? 

          Thanks

           

          Translate
          Danny-Miller
          Adobe Employee
          Danny-MillerAdobe Employee
          Adobe Employee
          September 13, 2022

          @luca_lattarini 

          1. "No Timestamp"? 
            1. Sounds like a data quality issue in your source system that needs to be fixed
          2. If a duplicate _id for an Event is loaded into the same dataset (as part of a subsequent Event), it will be ignored or cause an error.
          Translate
          Terms & ConditionsAccessibility statement

          Loading footer...