↑↓ selectEnter openEsc close

    1. Elbuz

    How to get a supplier price list from FTP

    2 min readUpdated

    Elbuz fetches the price list from the supplier's FTP server by the path you set, on every source import. You don't need to download the file from the server manually.

    When you need this:

    • The supplier puts a fresh price list in a folder on their server — the program takes the file by its full path every time.
    • You need to make sure the server lets you in — the “Check connection” button answers right away.
    • The server is old and doesn't understand Cyrillic in file names — clear the “UTF-8” checkbox.

    Where to start: source card → “Source” section → “FTP” tile → server fields and file path.

    What getting a price list from FTP can do

    How to connect the supplier's FTP server

    The least common method. The supplier puts a fresh price list in a folder on their server, and the program fetches the file by the set path every time.

    FieldWhat to enterDefault
    “FTP server address”the server address, for example ftp.mysite.comempty
    “Port”the port, if the supplier gave a different one21
    “User name”the login from the supplierempty
    “Password”the password from the supplierempty
    “File path”the full path, for example /public/price.xlsempty
    “SFTP”nothing: the checkbox doesn't affect the import, see belowoff
    “UTF-8”clear it if the server is old and doesn't understand Cyrillic in file nameson

    What “Check connection” shows

    Write the address any way you like: the program strips the ftp:// and sftp:// prefixes and an extra server name at the start of the path. “Check connection” checks two things: does the server let you in, and is the file name filled in. The “Info” window shows a green “Connected” or “Error: …” with the server's text. Server OK but “File path” empty — a red “No file name specified in FTP settings!”. Address or port empty — “Fill in the required fields!”.

    The form has an “SFTP” checkbox, but the file is always fetched over plain FTP, both on import and by “Check connection”. The program won't open a server that works only over SFTP (via SSH, usually port 22): the check shows “Error: …”. Ask the supplier for plain FTP access or a direct link to the file.

    If you enter a folder with a trailing slash in “File path”, for example /public/, the program takes the first file the server returns in that folder's listing. Which file that is depends on the server, so for a price list a full path with the file name is more reliable.

    The check catches an empty path but not a wrong one: it doesn't try to open the file. A green “Connected” is quite possible with a misspelled file name or the wrong folder. So after a green answer, compare the path with the supplier's — file name included, not just the folder. With no path at all, the run logs “No file name specified in FTP settings!” and keeps the price list on the previous file.

    Scenarios

    The supplier named only the folder with the price list

    What to do. Ask the supplier for the file name and enter the full path in “File path”, for example /public/price.xls. Click “Check connection” and run the import manually.

    What you get. The run log shows the line “Getting file via FTP”, then the file goes into processing.

    What won't happen. If you leave the path as a folder with a trailing slash, the program takes the first file from the listing, and which file that is depends on the server.

    The supplier gave access only over SFTP

    What to do. Ask the supplier for plain FTP access or a direct link to the file. A link is connected with the “URL” tile — How to receive a supplier price list by link.

    What you get. The file is fetched over plain FTP or by link.

    What won't happen. The “SFTP” checkbox doesn't switch the connection: an SFTP server won't open, and the check shows “Error: …”.

    What to do when the file doesn't arrive from FTP

    Common problems
    What you seeWhyWhat to do
    “Error: ‹server text›” in the “Info” window The FTP server refused the connection Check the address, port, login and password (about FTP)
    “Fill in the required fields!” You clicked “Check connection”, but the server address or port is empty Fill them in and repeat the check (about FTP)
    “Connected”, but the file still doesn't arrive The check doesn't try to open the file itself: a name is entered, but it points to the wrong file or the wrong folder Compare “File path” with what the supplier gave you and look at the run log (about FTP)
    “No file name specified in FTP settings!” The FTP server is filled in, but “File path” isn't. Both the connection check and the run log show this line Enter the full path including the file name. While it's empty, the price list stays on the previous file (about FTP)
    “RETR response: 550” or another 5xx code when getting the file from FTP The supplier's server refused. 550 means “no such file or no access”, 530 — the login and password didn't work, 425 and 426 — the data channel didn't open Check the file path: it must be full and lead to the file itself, not a folder. Then the login and password: copying often adds an extra space at the start or end. (about FTP)

    FAQ

    The supplier gave SFTP access. Will it connect?

    No. The form has an “SFTP” checkbox, but the file is always fetched over plain FTP. Ask for plain FTP access or a direct link to the file.

    The check is green, but the file doesn't arrive. Why?

    The check doesn't try to open the file itself: it only sees that the server lets you in and the path is filled in. Compare “File path” with the supplier's, including the file name — about the check.

    Can I enter a folder instead of a file?

    Yes, with a trailing slash, for example /public/. The program takes the first file the server returns in the folder listing, so for a price list a full path with the file name is more reliable.

    How long does the program wait for a file from FTP?

    400 seconds for the download. If it doesn't finish, the partial file is deleted, the error text goes to the log, and the run continues on the previous file.

    The server can't see a file with a Cyrillic name. What should I change?

    Clear the “UTF-8” checkbox in the FTP fields: old servers don't understand Cyrillic in file names. The checkbox is on by default.

    Where it is and who has access

    Menu
    Directories → Processing price lists → List of price lists
    Source card
    the “Source” section → the “FTP” tile
    Access right
    the “List of price lists” window plus “Import settings” and “…price list file”
    Prepare
    server address, port, login, password, full path to the file, a sample file

    Why a source should have only one method set up — see the article on ways to receive a price list.

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free