File Transfer from other server to AmeriCommerce?
We have a few warehouse CSV files that show inventory levels, that are updated at regular intervals (for the items that we drop-ship). These files are on another server. They can be accessed by either FTP or by simply going to the URL.
How can we automate this? The AmeriCommerce Scheduled Import function works great, but will only use files already in our AmeriCommerce account.
Our roadblock is getting the files copied from the other server to our AmeriCommerce account. Is there any automated way to do this?
Any suggestions?
-
Not sure if you ever got and answer on this. As far as I am aware there is no built in way to do this. The only options that I am aware of are to use another webserver or FTP client to download the file from your suppliers ftp location and then upload it to AmeriCommerce via FTP.
I think you could accomplish using Microsoft IIS (Internet Information Service, aka web server) built into every Windows Pro machine if you have or know someone with asp programing experience. https://support.microsoft.com/en-us/help/247132/how-to-perform-a-server-to-server-ftp-transfer-by-using-iis
This is possible, but there are some security risks and it takes some technical knowledge of FTP clients or web server languages to accomplish.
-
In case anyone sees this, I have had a script written that accomplishes this goal. Contact me if you are interested in licensing it.
No local computers are needed. It's all server to server based. It takes a files (or series of files) from your server and copies them via SFTP to your AmeriCommerce site. Works like clockwork.
For example, one of our suppliers updates their warehouse inventory file at 11pm. At 11:05pm, I run the script to transfer the CSV file to a folder on my AmeriCommerce store. At 11:15pm, I run a scheduled import to update the inventory quantities I have available for sale on my AmeriCommerce site.
Please sign in to leave a comment.
Comments
2 comments