Dor has 1-click integrations with Shopify, Vend, Lightspeed Retail, and Square. If you use one of these POS providers, you can find instructions to set up the integration here.
If you do not use one of these POS providers, custom POS integrations can be set up by Team Admins or Admins.
To get started with the integration, you will first need to send us a sample of your data from your POS provider in a CSV format. Please send this information to your dedicated Customer Success Manager or to support@getdor.com.
It does not matter specifically what the format is, but it is important that is has the following information:
Point of Sale CSV Format PDF
A unique ID to identify each location. It is important that this ID doesn't change between imports.
A unique ID to identify each transaction. In cases where a unique transaction ID is not available across all days/locations, we can generate one by combining other import fields to create a unique ID.
A total field. This represents the total amount of the transaction. Negative totals are treated as refunds.
Date and time fields. This can be a single date/time field or a field for each date and time.
File Format
Files must be sent in CSV format. Once configured, the format of the files sent should remain consistent. Any changes to file configuration will likely break the connection or cause unexpected errors.
Sending the Files
From there, you will have to decide whether you want this data to be sent to us over email via a file attachment (we set up an email address for you to send the data to), or via FTP (File Transfer Protocol) - which is a way to upload large files to a server. If you select this, we provide you with a username/password to connect. FTP is recommended as it is more secure.
We can accept imports via a special email address created for each customer. The customer should send transaction CSV files to the address as a single attachment for it to be processed automatically by our system.
If possible, all emails should also cc imports@getdor.com. This allows us to recover import emails in case any issues arise with automated processing.
FTP/sFTP
Imports can be accepted over an FTP or sFTP connection. sFTP is recommended since it is more secure. We will provide a username/password combination for the customer to connect with. For sFTP connections, we can optionally allow passwordless connections with a customer's public RSA key.
Files should be uploaded to the customer's root directory and will begin processing immediately. Customer accounts are restricted from renaming or deleting files within the FTP server since this would not update or delete already processed data. To update existing data, a new file with the same transaction IDs can be sent to overwrite the previous data.