This document describes the CSV file format used for FTP / SFTP imports of non-integrated POS systems.
The file must be encoded in UTF-8 and formatted as a comma-separated CSV (",").
A sample file is attached to this article.
ℹ️ Data Formats
Always use a dot as the decimal separator (e.g.,
1.23), not a comma.Values must be expressed in the currency used and not in cents (e.g.,
1.23and not123).
📋 CSV File Structure
Column | Description | Required |
order_remote_id | Unique identifier of the order | Yes |
order_date | Sale date, ISO8601 format | Yes |
order_covers | Number of covers | Non, defaults to 0 |
product_remote_id | Unique identifier of the product in the POS | Yes |
product_remote_name | Name of the product as defined in the POS | No |
product_quantity | Total quantity sold for this product | Yes |
product_amount_including_tax | Total amount including tax for the product sales, in euros | Yes |
product_amount_excluding_tax | Total amount excluding VAT for the product sales, in euros | Yes |
🧪 Validate your CSV file
Before uploading your file to the FTP server, you can verify that it follows the required format by using our validation tool:
👉 https://pos-import-report.yokitup.com
🔐 FTP / SFTP Connection
The connection credentials (server, username, password) are visible on the POS integration page.
⏱ File Processing Frequency
Files uploaded to the FTP are processed automatically every hour.
Each processing run will analyze the files present in the folder, based on their filename.
⚠️ Already Processed Files
Once a file has been processed, it cannot be processed again, even if:
the file is deleted and re-created with the same name;
the file contained an error (e.g. invalid format).
To force a new processing, you must change the file name (add a date, a version number, etc.).
🚫 No Deletion Possible
Once a file has been processed, the recorded sales and products cannot be deleted.
⚠️ So be very careful before uploading a file to the FTP.
✅ Duplicate Management
If a sale has already been processed (e.g. via another file), it will be automatically ignored during the next processing runs.
The identifier used for this check is the
order_remote_idfield, which must be unique for each sale.
🔔 Error Tracking
After uploading a file, you can check if it was processed correctly in the Events tab of your POS integration page. The file name is not displayed, so you’ll need to monitor the dates and error types shown.
📆 Recommendation for Night Sales
💡 Tip: if you have sales recorded between midnight and 6:00 AM and your export only contains the date (without time), we recommend assigning them to the previous day in your export.
This helps align the data with the operational reality of sites open late at night and ensures more consistent statistics.
👉 This behavior is often expected by operational teams, but it must be explicitly handled in the export script, as it is not the default behavior.