This article handles the topic of synchronization between VentoryOne and other external inventory management systems like JTL Ameise, Xentral and PlentyMarkets.
Prerequisite for the synchronization, is the ability of your external management system to automatically export CSV files and save them on a FTP server.
To set up your SFTP Server, follow these steps:
1) We will give you access to our SFTP servers.
You can get your individual access credentials from Andrej. To request them, just ask for them in the chat and Andrej will send you all the needed data.
The access will look something like this:
User name
ventoryone_jtl_XXXX
Password
ui7hrb1vuww66jhzsl8jdfXXXXXXXXXXXXX
Host
12341342-XXX-1234.QWERT.com
If you are on Windows, it is best to use WinSCP. This can load the file on the server via shell scripts.
https://winscp.net/eng/docs/lang:de
Here an example:
@echo off
set csv_file_path=[z.B C:\users\Alex\documents\ventoryone\sales.csv]
set sftp_hostname=[SERVER IP]
set sftp_username=[SERVER USERNAME]
set sftp_password=[SERVER PASSWORD]
set sftp_hostkey=[SHA-256 KEY]
"C:\Program Files (x86)\WinSCP\WinSCP.com" /log="WinSCP.log" /ini=nul /command ^
"open sftp://%sftp_username%:%sftp_password%@%sftp_hostname% -hostkey=""%sftp_hostkey%"" -rawsettings ProxyPort=0" ^
"cd [SERVERPATH z.B ventory_ftp_1/daily_sales_demo]" ^
"put ""%csv_file_path%""" ^
"ls" ^
"exit"
pause
Replace everything in the square brackets "[...]" and delete the brackets. You can also get the "SSH host key fingerprint" from the WinSCP tool. The key will be displayed on the first connection and in the protocol log.
https://winscp.net/eng/docs/ui_fsinfo
2) The server needs to regularly be updated through the upload of your inventory file.
Sales numbers can also be read as inventory. Your export files has to be arranged the way it shows daily sales numbers in "daily_sales_for_import" and the stock numbers are uploaded in "warehouse_XYZ". Notice: "daily_sales_for_import" and "warehouse_XYZ" need to be two different folders.
Use the "warehouse_xyz" folder to define what VentoryOne warehouse you want to synchronize your inventory management with.
By clicking on the warehouse in VentoryOne, you will be able to see the ID in the URL of the Warehouse. For example:
4) The formatting of the files can be done as follows. Especially relevant are the columns highlighted in green: