Update Offer End-Date in SAP Marketing Cloud

[torsten-mittag]

Hello Community

we have the following problem updating offers in the SAP Marketing Cloud:

Current status:

The offers come from our SAP Commerce and are created there as a promotion rule. The transfer takes place via the Cloud Platform Integration. To do this, we use the standard integration flows for promotions (with slight adjustments) from the package "SAP Commerce Cloud Integration with SAP Marketing Cloud" (ref).

The standard does not provide for an update of the end date of the offer, so we have added this.

When updating, we then get the error message "Offer can only be updated if it has status "In Preparation" or "Paused".". Since our offer is already in the "Released" status, we only have the option of setting it to the "Paused" status. We did this via the API.

After this we were able to update the offer on our Q system.

We then transferred the adjustments to our P-System (CPI). There we pause the offer via the API and then transfer the new date.

However, we then receive the following error message on the P system: "Dates can't be changed while offer is paused (offer OFFER_ID, OFFER_ORIGIN)."

So the question is, how can we update the offer? According to the first message, the offer must be paused; according to the second message, it must not be paused?

And why does the second error only occur on our P-System, whereas it works without any problems on the Q-System?

I tried the whole process also via postman, with the same result, same error message. Some example payload:

Pause Offer:

{
   "OfferIdExt": "OFFER_ID",
   "OfferIdOrigin": "OFFER_ORIGIN",
   "ExternalStatus": "02",
   "ExternalStatusDescription": "Paused"
}

Update Date:

{
   "OfferIdExt": "OFFER_ID",
   "OfferIdOrigin": "OFFER_ORIGIN",
   "StartDate": "/Date(1641859200000)/",
   "EndDate": "/Date(1673395200000)/"
}

Resume Offer:

{
   "OfferIdExt": "OFFER_ID",
   "OfferIdOrigin": "OFFER_ORIGIN",
   "ExternalStatus": "01",
   "ExternalStatusDescription": "Externally Released"
}

Request URL is in each case:

{{Marketing_Cloud_URL}}/sap/opu/odata/SAP/CUAN_OFFER_IMPORT_SRV/Offers(OfferIdExt='OFFER_ID',OfferIdOrigin='OFFER_ORIGIN')

Has anyone ever had a similar problem or experience with updating offers in the SAP Marketing Cloud?

Best Regards

Torsten

[torsten-mittag · Accepted solution]

Resolution from SAP Support:

Dear customer,

I analyzed your issue: You try to update a paused offer in the P-system whose end date is already in the past.

We have some restrictions for updating paused offers: It is not allowed change the visibility and validity of an offer that are in the past, since this would break offer analytics. Therefore, you cannot extend the validity rule of the offer, since it already ended in the past.

In addition, there is a restriction for offers that have coupons assigned: Offers with the coupon attribute cannot contain any gaps in their time periods and cannot be assigned recurrence patterns. The recurrence pattern option will not be visible and gaps in time periods will result in an error when releasing the offer (see also the documentation: https://help.sap.com/viewer/b88f770e4b7c4ecead5477e7a6c7b8f7/2111.500/en-US/7b8f784a732f4691b3dd599e....

The reason for that restriction is that coupons can define by themselves how long a code is valid. This won't match in some cases with the offer validity if the offer has gaps in their validity.

Therefore, it is not possible to extend the offer in your case, unfortunately.