If you are bulk uploading order data to your Shippit account using CSV (comma separated values) files, you can further automate your processes using an FTP (file transfer protocol) server. This is especially useful if you have a highly customised or bespoke workflow that doesn't integrate directly with the Shippit platform. This can help to save you time, and minimises the need for manual data entry, helping to reduce errors.
This article guides you through using an FTP server for successful CSV uploads. For general information and best practices about using CSV and FTP, see the understanding CSV and FTP article. For instructions about creating and uploading individual CSV files, see the uploading from CSV article.
FTP client software
You need to choose an FTP client to use to manage your CSV file. In most cases, this is an FTP client that is included in the software you are using to generate your CSV order data. However, if you need a stand alone FTP server, you can use FileZilla, which is free, open source, and available for use on Windows and MacOS.
To get started, you need to generate your FTP credentials in your Shippit account, and then use those to configure your FTP client software. You only need to do this once.
Generating FTP credentials
Log in to your Shippit account, and navigate to Settings → Integrations.
In the Select an integration section, click CSV/FTP.
Check Update via the FTP Service + Web interface and click Continue.
Record the server details, username, and password. This is the only time you see the password, so check it carefully.
Click Continue.
You can check that everything has been set up correctly by navigating to the FTP Service tab. Your service should show as Enabled, and your service connection details are displayed. You can also use this screen to reset your password, if you need to.
Connecting your FTP client
If you haven't already, install your FTP client software.
Create a new connection, and complete the FTP server details that you recorded earlier from your Shippit account.
Check that the connection works, and that you can connect to the Shippit FTP server. If the connection is successful, you can see the Orders directory, which contains sub-directories for Failed, Imported, and New orders.
⚠️ IMPORTANT: You might need to change the protocol you are connecting with for the connection to be successful. If you have trouble, try changing the hostname URI to use ftpes:// instead of ftps://.
Uploading CSV files
When you have a successful connection between your FTP client software and the Shippit FTP server, you can transfer files.
The Shippit FTP server contains a top-level Orders directory, with three sub-directories:
Orders
Failed
Imported
New
Add new CSV files to the New directory using your FTP client interface. You can't upload files directly to the Failed or Imported directories. The FTP server checks the New directory by default every fifteen minutes, and processed files are moved to either Imported if they are successful, or Failed if they are not.
You can download a sample CSV template for order uploads, so it's good idea to always use that template as your starting point. This ensures all required fields are present and correctly ordered. If you attempt to use a different CSV format, then your FTP upload can fail.
⚠️ IMPORTANT: The CSV template used by this method differs to the CSV template used by the Import function on the New Orders screen. Make sure you are using the correct template for the method you choose.
Check synchronisation history
You can check your synchronisation history in your Shippit account.
Checking your synchronisation history
Log in to your Shippit account, and navigate to Settings → Integrations.
Make sure you have selected the correct store at the top of the page.
In the CSV integration settings section, click Launch Connect.
In the Sync History section, each order that has been synchronised is shown, whether or not is was successfully imported.
Use the expand icon to the left of each entry to see more information, including any error information for failed imports.
CSV template
You can download this sample CSV file to use as a starting point: