Start Free Trial
Start Free Trial

Export from Shopify to SFTP server directory

Shopify to SFTP

The ability to export Shopify data to an SFTP server is crucial to a lot of stores. Using servers helps with automation tasks, synchronization between internal and external third-party systems, and many more.
Let’s look into how to set up automatic export from your Shopify store to the SFTP server.

Note – video content might be outdated and show a different approach to the one explained in the more up-to-date tutorial below.
Both approaches should still work in the app.

This is how to Export from Shopify to an SFTP 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 SFTP 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.

save SFTP server in Shopify Matrixify settings data export import Excel CSV


2. Create new export in the app

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, you will need to select export format and data to export, see our “How it works” page for more details on setting up what to export.

3. Apply export Options to upload to SFTP 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 to which the app should upload data.

export to sftp server from Shopify data Matrixify Excel CSV

If the server is not set up in the app settings

You can also select to upload to “Full URL” and enter the full SFTP URL.

The URL should contain user credentials and the full path to the file in the following format:

sftp://user:[email protected]:port/path/to/directory/

For example:

sftp://matrixifyuser:[email protected]:22/Matrixify-exports-folder/

Read our “How it works” page for more details about export options.

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 SFTP 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