Bulk Import Transaction Inquiries

Introduction

The transaction inquiries system allows you to submit information about sales or orders referred by your site that do not appear as credited in your reports.

You can submit transaction inquiries in your Publisher Dashboard, individually or in bulk. This article outlines the process for submitting transaction inquiries in bulk. If you need to submit ten or fewer inquiries, you can do so individually.

Instructions

Follow these steps to get started:

  1. Go to Account in the navigation menu and click Transaction Inquiries.
  2. Click Add New Inquiry.
  3. Navigate to the Bulk Upload tab. This will open a three-step workflow to support the process.

Step 1: Select File

You will first be prompted to upload a file of your transaction inquiries. Click Download file template to prepare your import file. This template contains all the columns needed to create your transaction inquiries; click the + for more information on the columns:

MID
This is the unique ID for this advertiser that Rakuten Advertising assigned.
Order ID
The consumer reported the Order ID, which must be an exact match with the advertiser’s records.
Order Date
This is the order date that the consumer reported. To ensure the advertiser has had a chance to report the order, only submit a date seven days or more in the past. You also cannot submit a date over 180 days in the past.
Order Amount
This is the entire order amount that the consumer reported. You cannot select a currency when submitting transaction inquiries. We will always apply the order amount in the advertiser's network currency.
Member ID
This is the Member ID that you have assigned to this consumer.
Comments
This is where you share any additional details the consumer reported with their order or any other content you want to communicate to the advertiser. Some of our advertisers receive thousands of transaction inquiries monthly, so they might not read the comments closely.

Once a file is uploaded, we are going to check two aspects of your file:

  • The file must be saved in a CSV format.
  • The file must be less than 10MB in size.

If either of those requirements is missed, you will see an error message and cannot proceed to Step 2.

 Attention

You can only submit one file at a time.

Step 2: Error Check

In Step 2, the transaction inquiry system checks the data inside your CSV file for missing data or formatting errors that will prevent us from uploading it. If any errors are present, you must go back to Step 1 and upload a new file.

These are the errors our system will check for and the guidance to fix those errors; click the + for more information:

Too many rows

Error description: There is a limit of 10,000 rows for this upload.

Solution: Split your file into increments of 10,000 or less.

Missing required column

Error description: The specified column must be in your file.

Solution: The required columns are: MID, Order ID, Order Date, and Order Amount

Exceeded character limit

Error description: One or more values in the specified column exceed the limit of NUMBER characters.

Solution: The character limits for fields in this file are as follows:

  • Order ID = 40
  • Comments = 2000
Formatting error

Error description: One or more values in the MID column are improperly formatted. The value must be a positive whole number.

Solution: The MID is a whole number, typically 3-8 digits long.

Formatting error

Error description: One or more rows in the Order Date column are improperly formatted. The format is YYYY-MM-DD.

Solution: In Excel, use Format Cells to convert to our accepted date format.

Formatting error

Error description: One or more values in the Order Amount column are improperly formatted. The value must be a number with up to two decimal places.

Solution: The Order Amount can be a whole number or a number with up to two decimal places.
For Japan, the Order Amount must be a whole number.

Under date limit

Error description: One or more rows contain a transaction date that occurred less than seven days ago.

Solution: The Order Date must be at least seven days in the past, so the advertiser has a fair opportunity to report it.

Exceeded date limit

Error description: One or more rows contain a transaction date over 180 days in the past.

Solution: The Order Date cannot be more than 180 days in the past.

If our system does not detect any errors in your file, you will see a green confirmation message and be able to proceed to Step 3.

Step 3: Upload File

This step displays an overview of what the system sees in the file and what will be sent off for processing. That overview includes:

  • A count of rows in the file.
  • The names of the columns that will be imported.
  • The names of any columns that will not be imported.

If you see a column listed that will not import, it is either because:

  • The column name is not recognized. Be sure to use the column names provided in the template.
  • The column is not relevant to this upload.

You do not need to act on any of these columns unless you believe this to be an error. Our system will automatically remove the columns before processing the file.

When you are satisfied, click Upload File.

File Processing

When a file is submitted for processing, our system checks the Order ID and MID associated with each transaction inquiry to determine what will happen with each one.

These are the possible results as the system checks whether the Order ID you entered exists for the MID you specified; click the + for more information:

Order ID Not in System

Scenario: If the Order ID is not in our system for that MID, a new transaction inquiry is created.

Transaction Inquiry: Unresolved

Transaction Inquiry Resolution:

Order ID Exists; Sale Attributed to You

Scenario: The Order ID exists in our system for that MID, and the sale was attributed to your SID.

Transaction Inquiry: Denied

Transaction Inquiry Resolution: Auto Resolved
Look for 'Processed in Reports with Transaction Date of DD-MM-YY' in the comments on the detail page.

Order ID Exists; Sale Attributed to Other Publisher

Scenario: The Order ID exists in our system for that MID, but the sale was attributed to a different publisher.

Transaction Inquiry: Denied

Transaction Inquiry Resolution: Auto Resolved

Look for "Transaction Referred by Another Affiliate" in the comments on the detail page.

These are the possible results if the system finds that you already have a transaction inquiry for the Order ID or MID, depending on the status of that transaction inquiry; click the + for more information:

Approved

Scenario: You already have an approved transaction inquiry for this Order ID or MID.

Transaction Inquiry: Approved

Transaction Inquiry Resolution: Look for "Processed in Reports with Transaction Date of DD-MM-YY" in the comments on the detail page.

Unresolved

Scenario: You already have a transaction inquiry for this Order ID or MID that is unresolved.

Transaction Inquiry: N/A

Transaction Inquiry Resolution: The new transaction was discarded. It is no longer in the system.

Denied

Scenario: You already have a denied transaction inquiry for this Order ID or MID.

Transaction Inquiry: N/A

Transaction Inquiry Resolution: The new transaction was discarded. It is no longer in the system.

 Note

Processing can take up to eight hours.

Next Steps

Once processed, your new inquiries will be displayed on the Transaction Inquiries main page, where you can track their resolution. To see which inquiries were added to the system, apply an inquiry date filter on the page for the date the file was submitted.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.