Install
Install

Export from Shopify to FTP server directory

Shopify data exported into an FTP server directory.

Using the Matrixify app you can export your store’s data to your FTP server directory.
Many Shopify stores need such a feature for their internal or external integration systems.

Follow this simple few-step tutorial to learn how to do just that!

In short how to Export from Shopify to FTP server

  1. Set up your server in Matrixify app settings.
  2. Create new export in the app and select what to export.
  3. Apply export Options to automatically repeat export and upload to FTP server.
  4. Start your export and enjoy!

1. Set up your server in Matrixify

Open the Matrixify app and head to the Settings page.
On this page, you can find the section “Servers” and there you can create a new server to save your user credentials. You can use two authentication methods – password and private key.
Find more details about how to set up a server in Matrixify “Set up Servers for importing files to Shopify” tutorial.

export Shopify data to FTP server automatically Matrixify Excel XLSX CSV

2. Create new export in the app and select what to export

Once you have your server setup saved you can start setting up your export.
Go to the Matrixify app Home page and in the “Export” section create new export.

First, choose the format and the data you want to export. See how to configure your export for more details on setting it up.

3. Apply export Options to upload to FTP server

Once you have selected what to export, in the export options you can set up how your export should work.

With Repeat every: and Schedule on: options you can set up when the job should first export and how often after that it should repeat.
If you wish for the first export to run immediately, but repeat every specific amount of time, do not select the Schedule on: option.

In the Upload to: option drop-down selects the server that you have set up in the app.
In the path field, enter the folder/directory path to which the app should upload data.

export Shopify data to FTP server automatically Matrixify Excel XLSX CSV 2

Upload to a Full URL

You can also select to upload to Full URL and enter the full FTP URL with the path to the directory. With the user and password in the URL, the server does not need to be saved in the app:

ftp://user:password@server:port/path/to/directory/

For example:

ftp://matrixifyuser:pass12345@cool-server:21/Matrixify-exports-folder/

If the server is saved in the app Settings, leave the password out. The app signs in with the saved server that has the same type, host and user:

ftp://matrixifyuser@cool-server/Matrixify-exports-folder/

The job keeps this URL without the password and signs in again on every run of a repeated Export. So a password changed later in Settings applies to the next run, and you do not need to edit the job. If no saved server matches the URL, the Export is refused when you create it with “Authentication failed for user …”. A full URL typed while a server is picked in Upload to wins over the picked server.

Read more about each Export Option in the documentation.

4. Start your export and enjoy!

When everything is set up, click on the “Export” button in the app to start the export.

Once the export finishes, you should see the file uploaded to your FTP server in your specified folder.
In the apps All Jobs page you can see all your past, running, and scheduled import and export jobs.

export to sftp server from Shopify data Matrixify Excel CSV repeat

Good to know

  • If the user is e-mail address then replace the “@” symbol with “%40”.
  • If the password contains # or @ symbol then please create such a password that doesn’t contain those symbols as those are special characters for the URL and will cause confusion. Or save the server in the app Settings and leave the password out of the URL.
  • FTP over TLS – at first we try to connect using TLS encryption. If it doesn’t succeed, then we try without the TLS.
  • You can import any of the file formats which are supported by Matrixify.
  • See this tutorial on how to import from an FTP server to Shopify.
  • See other FTP related tutorials.