Input Additional Performance Transactions - Processing Multiple Data (Bulk Upload of Transaction Data Generated in a Defined Format)

Upload Achievement Data and Process Multiple Data in Bulk from the Management Screen

Follow the steps below to upload achievement data created in a prescribed format from the management screen and process multiple data records in bulk.

[Preparation] Create the data to be additionally entered in the specified "Text Format" or "CSV Format."

!! Please Note !!

1. The maximum number of data records that can be uploaded at one time is 1000.
2. If the Member ID (U1) is entered incorrectly, the point reward site will not be able to correctly issue points to end-users. If you are processing data based on transaction logs downloaded from the management screen, please refer to the TIPS and exercise extreme caution.

---

<< For Text Format >>
(Items in red are mandatory.) Items in blue are mandatory as needed; please check below for details.

1. Character Code: Shift-JIS / UTF-8
2. Delimiter: | (Half-width pipe: "Shift" + "¥")
3. File Name: The file name is arbitrary, but the extension must be "txt" (e.g., tsuika.txt).

4. Item Contents: (Items in red below are mandatory):

   Order ID | SID (Site ID) | Purchase Date (yyyy-mm-dd) | SKU (Product Code) | Quantity | Amount | Currency (JPY) | E-mail | Payment Type | Postal Code | Product Name | Member ID (U1) | Reason

---

<< For CSV Format >>
(Items in red are mandatory.) Items in blue are mandatory as needed; please check below for details.

1. Character Code: Shift-JIS / UTF-8
2. Delimiter: , (Half-width comma)
3. File Name: The file name is arbitrary, but the extension must be "csv" (e.g., tsuika.csv).

4. Item Contents: (Items in red below are mandatory):

   Order ID , SID (Site ID) , Purchase Date (yyyy-mm-dd) , SKU (Product Code) , Quantity , Amount , Currency (JPY) , E-mail , Payment Type , Postal Code , Product Name , Member ID (U1) , Reason

---

[Notes on File Creation]

Enter one detail per line, and ensure each line ends with a line break.

Column headers (column names) are not required.

Each line (1 detail) requires 13 items separated by pipes or commas.
If you only enter mandatory items, leave the other items blank and separate them with pipes or commas.

Order ID|SID (Site ID)|Purchase Date (yyyy-mm-dd)|||Amount|||||||Reason[Line Break]

Order ID,SID (Site ID),Purchase Date (yyyy-mm-dd),,,Amount,,,,,,,Reason[Line Break]

---

[Mandatory Items]

1. Order ID (1st item)
   Up to 40 alphanumeric characters (half-width) can be entered.
2. Site ID (SID) (2nd item)
   Enter the Site ID (SID) of the affiliate to whom the reward will be paid. Rewards can only be paid to affiliated programs.
3. Purchase Date (3rd item)
   Enter the actual date of purchase or application.
   If left blank, the date of the achievement transaction's additional input will be automatically assigned, so please be careful.
   The reward conditions of the program the affiliate is participating in as of the specified date will apply.
4. SKU (4th item) Mandatory as needed
   SKU is a unique ID (product code) that identifies a product or service.
   If you are offering a program that changes rewards for specific products using an SKU list, please enter an SKU that exactly matches an SKU in the list (case-sensitive).
   This item is mandatory if you are offering a program that changes rewards for specific products using an SKU list.
5. Quantity (5th item) Mandatory as needed
   Specify the quantity purchased or applied for.
   If left blank, "1" will be set.
   This item is mandatory if you are offering a fixed-rate reward (per-transaction) program.
6. Amount (6th item)
   Enter the total amount of the product (unit price excluding tax x quantity).
   Please note that entering the unit price will not automatically multiply it by the quantity.
   If entering an achievement for a fixed-rate reward (per-transaction), enter "0" (half-width zero).
7. Member ID (U1) (12th item) For point reward systems, etc., this is mandatory.
   If paying rewards to an affiliate using a Member ID (signature/U1), it is crucial to enter the correct Member ID as it affects point allocation.
   Please pay special attention as it may include long numbers or numbers starting with zero.
8. Reason (13th item)
   Enter the reason for inputting the achievement from the management screen.
   (If unsure of the reason, "Achievement Addition" is sufficient.)

---

[Optional Items] (Leaving blank is acceptable)
Currency (7th item): Please leave blank.
E-mail (8th item): Please leave blank.
Payment Type (9th item): Enter the payment method.
Postal Code (10th item): Enter the postal code of the end-user who purchased the product. Hyphens are not required.
Product Name (11th item): Enter the name of the product or service.

 

 

Click 'Transactions' from the account menu in the management screen and click the 'Manual Credit' link.

Click 'Upload Multiple Transaction file' and select either the 'Text' or 'CSV' radio button corresponding to the file you created, then select the file using the 'Browse' button, and finally click the 'Submit' button to upload.

 

The uploaded data will be displayed. If there are no issues with the content, please click the 'Submit' button. If any corrections are needed, click the 'Cancel' button, upload the corrected file, and then click the 'Submit' button.

 

You will receive an email with the processing results of the entered achievements shortly. Please check for any errors.

The data will be processed shortly and will appear in the advertiser and affiliate site reports within 24 hours. (Please note that reward reflection may take until the next day or later.)

After performing the additional input of achievement transactions, please be sure to check the achievement input notification email from the management screen to confirm that it has been processed. If you do not receive an email or are unsure about error details, please contact customer support. The email sent will have content similar to the following:

Subject: MID: 〇〇〇〇 [Advertiser Name] - Achievement Input Notification from Management Screen

Body:
The processing results for achievements entered or canceled from the management screen are as follows:

1 item sent
1 item successful
0 items with errors

Additionally, please check the "Search Manual Transactions" to confirm that the additional input of achievement transactions has been processed. If any items remain in a "processing" state, please inform customer support.

---

<< LinkShare Japan Help Desk (For Advertisers Only) >>

1. Inquiry Form:
   https://linkshare-ec.zendesk.com/hc/ja/requests/new
2. Email Address:
   [e-mail]
   
   (Weekdays 9:00 AM - 5:00 PM JST / Mondays only 9:00 AM - 4:00 PM JST)

Regarding this task, a paid operational outsourcing service is also available.