Shopify payments via API

Shopify Payments payments can be collected directly via an API interface via live-import. To do this, enter the Shopify credentials into the bank account. The account must be of type Account: Shopify (API).

Note: For the Shopify Payments business account to work correctly, there must have already been at least one payout (transfer from Shopify Payments to your bank account). Single transactions are not sufficient.

Live import access data

Enter the following fields in the live-import access data and fill them with your Shopify access data:- SHOP=>https://shop.myshopifyshop.de;** → please enter here the own store URL of your Shopify store.

When connecting multiple Shopify Payments, you must make sure that you stagger the "At Times" configuration, otherwise the API will only talk to the first one.

Example:
Accounto_1 at times 00,02,04,06,08,10,12,14,16,18,20,22
Accounto_2 at times 01,03,05,07,09,11,13,15,17,19,21,23

USER=>User name; → please enter here the API KEY from your Shopify store
PASSWORD=>{PASSWORD}; → please enter here the API password of your Shopify store directly or enter it into the password vault and set it via the variable {PASSWORD}
DAYS=>2; → optionally, the number of days to be picked up. Otherwise 5 days are fetched by default, but this value can also be specified: DAYS=>5;

The following keys can be used:

SHOP: SHOP, URL
USER: USER, USERNAME, USER_NAME
PASSWORD: PASSWORT, API_PASSWORT, API_PASSWORD, PASSWORD, API_KEY, KEY
DAYS: DAYS, TAGE

Shopify settings

In order to retrieve payments for Shopify in xentral, some permissions must be granted in Shopify Payments. Xentral requires read access for payouts, bank accounts, and accounts on Shopify Payments.

In addition, further read accesses are necessary. To do this, click on "Show inactive Admin API permissions" and give read permissions to all rights there.

Note: For the Shopify Payments business account to work correctly, there must have already been at least one paypot, i.e. a transfer from Shopify Payments to your own bank account. Single transactions are not sufficient here.

Status of picked up bookings

The Live Import of Shopify Payments bookings only imports bookings with the status "paid", as the API only allows the import of a specific status. Bookings that are scheduled, in transit or canceled will not be picked up.

Error message during live import (connection problems):

Please check if the data has been entered correctly or if a user or password etc. has changed at Shopify. The user may also not have the authorization to access.

Shopify payments via CSV

Alternatively, Shopify Payments postings can be manually imported via CSV file. Example of a Shopify Payments CSV:

Bank statement import

The import of Shopify Payments is possible both as a live import and as a CSV import. The order number is used to assign the store orders.

Known issues

Shopify offers the option to pay out revenue both weekly and daily. If you choose monthly payout, the live import may run into errors because the amount of data to be fetched is too large. Therefore, a daily payout is recommended.

Table of contents