Setup SFTP
Efficiently set up SFTP for seamless data transfer with NetSuite.
Setup SFTP
Configure SFTP Server
From the Home dashboard, select the Setup
link located in the top-right corner. Under the "Custom" section, choose SFTP Configuration
and click the New
function.
Add a New SFTP Server Configuration
In the "SFTP Servers" section, click the "New SFTP Server" button.
Define SFTP Server Details
Choose the "Preferred SFTP Configuration" form by default. Complete the details in the CUSTOM FORM.
Setting up a default directory is required for the SFTP connection to work. Please obtain this from the system admin team.
Field | Details | Required |
---|---|---|
SFTP GUID | Unique identifier for the SFTP configuration in NetSuite. | Yes |
SFTP SERVER | The address or domain of the SFTP server. | Yes |
USER ID | The username associated with the SFTP user. | Yes |
PORT | The port number used for SFTP communication (default is 22). | Yes |
HOST KEY | Authentication key provided by the SFTP server. | Yes |
DEFAULT FILE DIRECTORY | The default directory on the SFTP server for file operations. Example: /home/-sftp/netsuite/ | Yes |
TEST FILE FOR SFTP CONNECTION | A sample file used to test the connection with the SFTP server. | No |
TEST DOWNLOAD FOLDER ID | Identifier for the folder used in testing download operations. | No |
REPORT DATE TIMEZONE | Timezone setting for reporting purposes. | No |
RETRY FILES FOLDER ID | Identifier for the folder where retried files are stored. | No |
SCRIPT ID | Identifier for any associated scripts or automation. | No |
After entering the required details, click the "Save" button.
Obtaining SFTP GUID
Request SFTP Key Generation:
Ask the administration team to generate an RSA private key for the SFTP server in PEM format and they will share a file containing the generated key with you.
Upload Key to NetSuite:
Navigate to Setup > Company.
Click on "Keys."
Select "Create New" and name the file "sftp-private-key."
Provide a random ID.
Go to the "File" segment and upload the PEM file received.
Wait for the upload process to complete.
Save and Retrieve SFTP GUID:
Save the configuration.
Now, in the ID column, you will find the generated key (e.g., custkey999) representing the SFTP GUID.
Create SFTP locations on the SFTP server
To enable SFTP communication, it is necessary to define SFTP locations where NetSuite will put the required files in the specified format. To set up these SFTP locations, you can go ahead and execute a SuiteScript added below in NetSuite, which will generate the necessary locations on the SFTP server.
Last updated