Skip to Content
Technical Articles
Author's profile photo Sebastian Solzbacher

Loading large coupon CSV files into SAP Marketing Cloud and SAP Marketing using Soap UI

This blog post and the described techniques are based on the great pre-work from my colleague Eileen Koehler back in 2016.

She originally wrote this blog post: which I used as template to provide this guide.


You want to upload large amounts of coupon codes into SAP Marketing Cloud or SAP Marketing (OnPrem) using CSV files.

The coupon maintenance UI allows a maximum file size of only 1MB, which corresponds to roughly 8,000 codes (depending on the number of columns). If you want to upload e.g. 2 million codes, you would have to split the data into a lot of files and upload them manually one after the other. This would obviously take up a large amount of time and would be quite error prone.

This tutorial shows you how the upload can easily be achieved using the open source tool Soap UI and provides you with the necessary files to configure the tool.

We use the OData API for Coupons that can also be used to integrate with other systems, e.g. via CPI.

Preparing the SAP Marketing system

SAP Marketing Cloud

Create a communication arrangement (along with the corresponding communication system and communication user) for the communication scenario SAP_COM_0317 (Marketing – Coupon Integration).

You can find an overview on how this setup is performed in the Integration Guide in the SAP Help Portal.

SAP Marketing (OnPrem 1809+)

The coupon OData API is available in the OnPrem release starting with version 1809.

Here, you copy the PFCG template role SAP_CEI_API_COUPON to a Z-role and maintain the necessary authorization values. Afterwards you create a dedicated service user and assign it the created role.

Checking the OData service

After you have performed the preparation steps, you should try to access the coupon API endpoint in your system with the created user by opening the following URL in a browser or another REST tool (be sure to adjust the server URL and port):


Hint: In the SAP Marketing Cloud, the final URL is displayed in the communication arrangement for easy access.

Preparing your (local) computer

Download the open source tool Soap UI and install it.

Getting the Soap UI project files

The Soap UI project files are currently not hosted. In case you require the files, please post in the comment section.

Preparing the Soap UI tool

Extract the downloaded file on your local computer to a known location (e.g. C:\SOAP UI\).

Open the SOAP UI application and import the project file CSV-Upload.xml (menu: File -> Import Project).

Prepare the data files

The data upload requires 2 files, one CSV file containing the data and one text file containing the mapping of the CSV columns to OData properties.

The CSV file requires a header row. Line items must be separated by semicolons. This is an example:












The metadata file contains the mapping from the OData Service property to the CSV column separated by colon. The corresponding metadata file for coupons therefore would look like this:






Your CSV file can contain more columns than you want to upload to the system. Only columns mapped in your metadata file will be uploaded.

The SOAP file contains examples for both files.

Data load

Open the imported project in Soap UI and drill down to the Settings section:

Double click the Settings section:

Double click on the respective values and maintain the necessary values:

Username/password are for the communication/service user created earlier.

The package size of 500 is a good balance between throughput and resource consumption on your PC as well as the SAP Marketing backend. You can change this value to adapt to your needs. If the value is too high, it can result in out-of-memory situations in the Soap UI application or the backend.

The hostname setting contains the hostname and the corresponding HTTP port of your backend system.

CouponUUID contains the UUID of the coupon in to which you want to upload the codes. You copy it from the Coupon app URL:

Ensure that you copy the UUID when in display mode. In edit mode, you’ll have another UUID which then subsequently won’t work for the upload.

DataFileName contains the complete path to the file containing your data.

MetadataFileName contains the complete path to the file containing the column to OData mapping.

Offset is a parameter you can normally ignore. With this parameter you can control from which line the upload should start. This might be helpful in case the upload failed after a certain package. After you fixed the file, you can start from this line again using this parameter.

Now you can start the upload. Double click on Code Upload:

Press the Start/Play button to start the upload.

If the upload was successful it will end with a corresponding success message.

If the upload fails, you can check the logs in Soap UI. You can always easily delete all existing codes in a coupon using the “Delete All Codes” button in the Coupon app and restart from scratch.

Info: the Soap UI log might contain error messages like this:

Thu May 23 14:18:48 CEST 2019:ERROR:An error occurred [Not in GZIP format], see error log for details


You can safely ignore those errors.


You have successfully uploaded coupon codes into SAP Marketing Cloud or SAP Marketing.

You can now distribute the coupon codes to your customers via email campaigns or the offer discovery service.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Andreas Walter
      Andreas Walter

      Good blog, well written and easy to reproduce!

      Thanks a lot!

      Author's profile photo Sebastian Solzbacher
      Sebastian Solzbacher
      Blog Post Author

      Thanks for your nice comment 🙂

      I hope this blog post helps everyone who has to manually upload coupon codes.

      Author's profile photo Saurabh Kabra
      Saurabh Kabra

      Thanks, Sebastian for this very nice step by step guide.

      Author's profile photo Viswa Gogineni
      Viswa Gogineni


      Thanks for the blog. it is useful. Please could you answer the following?

      1. What was the volume tested using this solution? How long does it take to import of 2 million coupons take?
      2. If you are recommending this for a production scenario in BAU situation where a continuous feed of coupons required into SMC, I hope you understand that this solution would need a dedicated manual resource?
      3. Why are you not using CPI? Does SAP believe that SOAP UI is better alternative to CPI for transferring the coupons? what is the scenario of uploading the csv file from SOAP UI rather than CPI?



      Author's profile photo Sebastian Solzbacher
      Sebastian Solzbacher
      Blog Post Author

      Hi Viswa,

      this tool is not meant to replace a CPI integration to upload coupon codes into SMC. In a productive environment where a code creation system exists, it is strongly recommended to implement an automated solution, e.g. via CPI.

      The CSV upload from the coupon maintenance UI is quite restricted regarding the maximum allowed file size. This tool was meant to be used whenever an automated integration is not possible (due to whatever reasons), and there is need to upload large amounts of codes manually.

      When it comes to performance, since the SOAP UI uses standard OData integration API API_MKT_COUPON_SRV (as would a CPI integration), the same recommendations and throughput figures as documented on apply.

      Best regards,


      Author's profile photo Peter pfitzner
      Peter pfitzner

      Hi Sebastian Solzbacher,

      happy to see you shared a solution for uploading a large amount of coupon codes.

      Unfortunately the link is broken.

      Could you please kindly provide the SoapUI project again?

      Thanks, Peter

      Author's profile photo Sebastian Solzbacher
      Sebastian Solzbacher
      Blog Post Author

      Hi Peter,

      thanks for notifying us about the dead link. It seems the server has been retired. We'll look for another option to provide the file and will update the link.

      Best regards,