8 months ago

Integrating with a 3P Warehouse through custom FTP Feeds

Hi everyone,

We want to integrate our Shopify store with a new third party warehouse. We should be able to export our orders via a customised text file via ftp, import ftp ASN feeds that have the tracing numbers, and sync inventory daily.

We have been searching for such a service for a long time now to no avail. The problem we're having is that the files that need to be sent are extemely customised, for example the file name has to be in the format of [YYYYMMDDHHMMSS], if an order is UK based, then there has to be a certain value in there and if it is not, then the value needs to change, each order has to have different information on muliple rows so each column does to one type of value only, etc.

Let me know if you can help. Thank you so much!

Maris Shopify Partner excelify.io
4 months ago

Hello, Mo!

We at the Excelify.io app team are doing integrations like that: https://excelify.io

The app does the importing and exporting of data using different formats, and can take/put files on FTP. So the only thing to add is - teaching it your custom format requirements and you are good to go.

Please, send to support@excelify.io your export and import file requirements and we will give you the quote for implementing that.


Excelify.io | Bulk Import Export Update with Excel | https://apps.shopify.com/excel-export-import | https://excelify.io
Last edited 3 months ago

Hi Mo,

For the Order export part, our app EZ Exporter might be able to help with this.  It's designed for creating custom CSV/text exports (we support different types of delimiters, quoting options, and line terminators). It supports exporting to FTP, FTP with TLS, and SFTP (in addition to email, Dropbox, and Google Drive).

For the filename, we have variables that you can use to capture the timestamp. Using the vars {{ date }}{{ time }} in the filename for example would produce the YYYYMMDDHHMMSS format that you need (e.g. 20180907213153).

We also have a feature called "Calculated Fields" that would allow you to use conditonal statements like this:

"ABCDEF" if {{ shipping_address.country_code }} == "UK" else {{ shipping_address.country_code }}

For the daily inventory sync, we do have another app for auto-updating inventory quantity with multi-location inventory support: EZ Inventory

However, it can only sync the inventory quantity at the moment so I'm not sure if that's good enough for your needs.  It supports FTP/SFTP/Web feeds, hourly and daily sync, and different types of inventory updates (set/overwrite, increase, or decrease the stock level). It has a pretty flexible data filter option also so you can set conditions in the app to filter just the products you want to update from the feed.

Please feel free to reach out if you have any questions!

Log in or sign up for an account to reply.

Your Reply