Overview
FTP Import allows the system to import csv files from FTP or SFTP connections.
CSV files can contain:
- Orders
Using standard or custom templates to imports orders to be shipped:
Download Standard Multi Line Template here: Multi Line Order Template
Download Standard Single Line Template here: Single Order Per Line
To create a custom template to use - see this guide: Custom Order Template Wizard - Despatch Update
Using this template will mark orders as despatched with the tracking number provided on the file typically by 3rd parties or drop shippers:
Download here: Despatch_Update Template - ASN
Used to import Advanced Shipping Notices / Purchase orders for your warehouse to receive
Download here: ASN Template - Stock Update
Using this file will completely over-write stock levels in Mintsoft with the values on the file.
Note - this will only work without multi-location management in use
Download template here: Stock Update Template
Basic Setup:
Setting | Description | Example |
Host | the ip address or host of the ftp server | ftp.mintsoft.co.uk |
UserName | The username required for connecting to the FTP server | mintsoft |
Password | The password required for connecting to the FTP server | password |
Port | Port used to connect |
21 = Standard FTP Port 22 = Standard FTP Port |
Path | The location of where we should look to get the files to import |
/neworders/ |
Result Path | The location of where we any tracking or result files to be placed |
/trackingexport/ |
FTP Hosting:
Please note Mintsoft does not provide any FTP hosting. You'll need to use an external provider for that. Some websites come with ftp hosting includes so check that or look at an external provider such as drivehq
Import Directory Structure
Within the path directory you'll need to place two additional sub folders so that files that have been imported can be moved to if they have been successfully processed or if they have failed. This will stop the system trying to continually import files that have already been processed.
e.g.
/neworders/
/neworders/processed/
/neworders/failed/
Templates
Comments
0 comments
Article is closed for comments.