Import from SFTP to Shopify

SFTP to Shopify

This is now to Import data from an SFTP server to Shopify

You can import to Shopify from SFTP by pointing the address exactly to the file which you need to import.

To schedule the import automatically at regular time intervals, do the following.

In the Excelify app, in the Import section:

  1. Paste the link to your SFTP server file path which should be in the following format:
sftp://user:[email protected]:port/path/to/directory/file-name.xlsx

For example:

sftp://foo:[email protected]:22/test/my-file.xlsx

2. Press “Upload from URL” buttonImport to Shopify from SFTP - upload file

3. Wait for the app to download the file for the first time, and let it analyze it (or fix any issues if it says that the URL was not correct).

4. If you want to set up the scheduled or automatically repeated import, press the “Options” button and set it up there.

5. Press the “Import” button (or “Schedule Import” button if you are scheduling import to start at a certain time).

Schedule automated import from SFTP to ShopifyEach time when the next automatic import will run, it will download the fresh file from SFTP again and again.

Good to know

Export from Shopify to SFTP server

Shopify to SFTP

This is how to Export from Shopify to an SFTP server

In the Excelify app, in the Export section:

  1. Choose what data you want to export with checkboxes.
  2. Press the “Options” button
  3. Select the scheduling and repeating options if you want to repeat the export automatically.
  4. On the “Upload to:” line, choose the SFTP.
  5. Enter the SFTP link in the following format:
sftp://user:[email protected]:port/path/to/directory/

For example:

sftp://foo:[email protected]:22/test/

Don’t put the file name or file extension in that path – as this is generated automatically.

If you want your file name to be custom, then fill the field “Custom file name:” in the Options section.

Export from Shopify to SFTP - Options

Good to know

Export from Shopify to SFTP / Import to Shopify from SFTP

SFTP

You can now export data from Shopify to SFTP file server, and import from SFTP to Shopify.

The SFTP address is written in the following format:

sftp://user:[email protected]:port/path/to/directory/file-name.xlsx

See the related tutorials: