Skip to main content
Deutsch Français Nederlands

Validate transactions in a batch

  • Updated

How does batch processing work?

You start by creating an export of all transactions in a given period from your own system. Make sure you export the unique transaction IDs of transactions that have been completed or those that have been canceled.

  • Go to the 'Transactions'/'Batch Processing' menu.
  • Select the correct campaign (note: only one campaign per batch is possible).
  • Select the correct period.
  • Paste all Transaction IDs (or Daisycon ID 's) in the field. It is also possible to upload a CSV or XLS file with all transaction data in one batch. To do so, follow the steps below with 'batch processing by file upload'.
  • The system will select only the transactions from transaction IDs that are also registered by Daisycon.
  • Check if the data is correct and then choose to reject or approve depending on which transactions you exported from your own system.
  • Then click the 'Process' button. It may take several minutes for the import to complete.

Batch processing by file upload

It is also possible to approve a large number of transactions by uploading a CSV or XLS file. With this option it is also possible to modify transaction data such as commission. To do so, follow the following steps:

  • Go to the 'Transactions' 'Batch processing' menu.
  • Click 'Upload a file'.
  • Drag the file into the field or click to select the file containing the transaction data.
  • Important: The file must contain transactions from only one campaign.
  • Mandatory fields:
    • Transaction identification:
      Either Transaction ID OR Affiliatemarketing ID + Part ID
    • Update field:
      One of the following must be provided: Commission (excl.), Revenue, or Status
    • Status updates:
      The Status value must be one of the following:
      • open
      • approved
      • disapproved
    • If Status = disapproved, the Disapproved reason field is mandatory.
    • Accepted values for Disapproved reason:
      • "invalid" – Incorrect or fake order
      • "duplicate" – Order already exists
      • "cancelled" – Order was cancelled
      • "no payment" – Payment was not received
      • "refunded" – Order was refunded
      • "test order" – Transaction is a test
  • Configure the file and click 'Map columns'.
  • Wait a few seconds for the system to map the initial fields. Then, verify that all fields are correctly mapped. Unused fields do not need to be mapped.
  • Click 'Validate file'.
  • Review the data and click 'Import file'. The import process may take several minutes.

To process transactions properly (in batch), it is important that the Transaction ID and any other transaction data from your own system matches the values provided in the conversion pixel. Read all about implementing and optimizing the conversion pixel here.

Related articles