Skip to main content
Academy Community Sign in

Amazon Pay (API & CSV)

  • Updated

Table of contents 

Amazon Pay is a payment plugin for online stores that are not used for the Amazon sales platform itself.

With the account type"AmazonPay (API)" in Xentral, credits (refunds) can be settled via Amazon Pay.  The procedure for this is the same as for PayPal refunds, so you can find more information about it here.

The CSV import is used to import the account statements. For this purpose a second account with the type"Account: Bank via CSV import" is created.

Create AmazonPay account

Via the button "+NEW" in the account overview, you can create a new AmazonPay account. If an account already exists, it can be edited via the Edit button. 

A new page appears where the necessary settings can be made.

Settings

  • Name → Name of the account
  • Type → Type of account. Here is "Account: AmazonPay (API)" select
  • Project → Assignment of the account to a project
  • Active → Indication that this account is actively used.
  • no e-mail → Normally, when payment is received, a mail is sent to the customer. If this should be suppressed this option must be set
  • Allow changes → Account postings may be changed subsequently. 

Live importer

Please note that a live import of incoming payments is not possible here. The following settings are nevertheless relevant to make credit entries from Xentral. 

  • Live import active → checkmark activates live import
  • Period → period in which the live import takes place
  • At times → Specify the time at which the live import takes place.
  • Access data → API code for live import
  • Password vault → The content of the password vault can be used in the data structure of the access data via the variable {PASSWORD}.

Enter one of the following two options under Access data live import:

Possibility 1:

SellerId=>XXXXXXX;
MWSAuthToken=>amzn.mws.XXXXXXX;

How to create the MWSAuthToken is described here 

Possibility 2:

SellerId=>XXXXXXX;
AWSAccessKeyId=>XXXXXXX;
AWSSecretKey=>XXXXXXXXXX;

You can find the information in your Amazon account:

mceclip0.png

Bank details (for type bank)

Since the AmazonPay account is not of the bank type, these fields are negligible.

DATEV

  • Account → Specification of the DATEV account

Create AmazonPay account via CSV

The second account with the type"Account: Bank via CSV import" is needed for importing the bank statements from Amazon Pay.

CSV import

  • First data line → line number containing real data (First line: 1)
  • Encoding → Set to UTF8 Encode in the standard to transfer the umlauts correctly
  • Separator → semicolon or comma. The separator is visible in the CSV file via a text editor
  • Masking → Quotation marks or no masking. The masking is visible in the CSV file via a text editor.
  • Remove null bytes → Specify that the null bytes are to be removed. 
  • Ignore last lines → enter a "0" in the default, unless the account statement contains additional information lines at the end that do not belong to the individual postings. To do this, specify as a number how many lines are to be ignored at the end
  • Date → column that contains the date. The corresponding column in the AmazonPay CSV template is the TransactionPostedDate column.
  • Input Format → Format how the date is specified in the CSV file. 
  • Output format → Format as it is output for Xentral must always be set to the format %3-%2-%1
  • Amount → column where the amount is located. The corresponding column in the AmazonPay CSV template is the TransactionAmount
  • Extra credit and debit → Required if the amount is divided between 2 lines (credit and debit).
  • Credit → column in which the amount for credit is located
  • Debit → column containing the amount for debit
  • Posting text → Specify the posting text. Use "+" to merge multiple columns (a checksum is calculated from the content, so make it as unique as possible). The corresponding column in the AmazonPay CSV template is the AmazonTransactionId.
  • Currency → column where the currency is located. The corresponding column in the AmazonPay CSV template is CurrencyCode.
  • Credit/Debit Identifier → Extra column where you can see what the amount is. 
  • Marking input → e.g. H or +.
  • Marking output → e.g. S or -.

 

Account allocation

In the Live Import field, you can already split the accounts that should be posted to. 

ACCOUNT_TRANSFER=>XXXX;
ACCOUNT_FEE=>XXXX;
ACCOUNT_SERVICE_FEE=>XXXX;
ACCOUNT_TRANSFER=>XXXX;

Note: XXXXX stands for your respective account number.

Bank statements in AmazonPay

To retrieve the CSV statements from AmazonPay, navigate in the AmazonPay interface, navigate to the"Payments" section. In the"Reports by period" tab you can create the statements for the desired period. With a click on the"Generate Report" button, you will generate the statement, which you can then download.

Related articles