SFTP Connections

SFTP connections can only be made from YourBarMate to your server. We do not offer an SFTP server.

Connections will be established from a fixed IP that can be added to the allow-list on your firewall. Authentication can happen with username & password and/or SSH key.

Fetching the product catalog via SFTP

The product catalog CSV files can be fetched daily from your server via SFTP.

Please provide these details:

  • hostname: The SFTP host
  • port: The SFTP port
  • username: The username
  • password: The password, if required
  • remote_file: The path to the product catalog CSV file
  • encoding: Either utf-8 or latin1 (ISO 8859-1)

Fetching the customer prices via SFTP

You may specify all price groups in a single CSV file or provide separate files per price group.

In addition to the above settings, please provide the following details:

  • remote_files: The paths to one or multiple product prices CSV files

Receiving orders via SFTP

We can place the order CSV file on your server via SFTP.

Please provide these details:

  • hostname: The SFTP host
  • port: The SFTP port
  • username: The username
  • password: The password, if required
  • remote_file: The path to the order CSV file to create
  • encoding: Either utf-8 or latin1 (ISO 8859-1)

The remote_file may contain these placeholders:

  • ${type}: Will be replaced with the order type, "delivery" or "return"
  • ${id}: Will be replaced with the order ID
  • ${date}: The date when the order was created in the format YYYY-MM-DD
  • ${time}: The time when the order was created in the format HHmmss