Get Excelify now
Get Excelify now
Import to Shopify from URL|Export - copy link address

Paste the URL of the file to import to Shopify from URL.

Use this URL in scheduled import to always import file from the same path.

That URL can be pointing to a file on Web, FTP server, Dropbox or Google Drive shared link.

Import from FTP/SFTP server

To import from FTP or SFTP server, you can open the Excelify app and head into 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.
Find more details about how to set up a server in Excelify “Set up Servers for importing files to Shopify” tutorial.

Here is the detailed tutorial: Schedule import to Shopify from the FTP server.
Here is the detailed tutorial: Schedule import to Shopify from the SFTP server.

You can also set up import that monitors your FTP/SFTP directory and imports automatically any XLSX or CSV files that you put in it. (Available only for Big and Enterprise subscription plans.)

Import from URL with dynamic placeholders

You can also list dynamic placeholders.

This is especially useful for scheduled imports so that you can specify what the file name should be imported if your directory contains multiple files that have dates in file names.

ftp://user:[email protected]/path/to/file_%Y-%m-%d.xlsx

In the example above the app will look for the filename – “file_2019-08-20.xlsx

Here is detailed documentation: Using dynamic placeholders in imports and exports.

Import from full FTP/SFTP server URL

If you do not wish to save the server with Excelify, you can also import from the full URL by following this template.

For FTP:

ftp://user:[email protected]/path/to/file.xlsx

For SFTP:

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

Import from Dropbox

To import file from Dropbox, just paste the Dropbox shared file link that looks like this:

https://www.dropbox.com/s/df98s7df98d9f/file.xlsx?dl=0

Here is the detailed tutorial: Schedule import to Shopify from Dropbox.

Import from Google Drive

To import file from Dropbox, just paste the Dropbox shared file link that looks like this:

https://drive.google.com/open?id=1JVg6OUdrIrv2ge2xaT-3qheE3Up1oox-

Here is the detailed tutorial: Schedule import to Shopify from Google Drive.

Import from Google Sheets

To import file from Google Sheets, just paste the link which points to your docs.google.com file which is shared publicly.

That link looks like this:

https://docs.google.com/spreadsheets/d/1e8Ko5LOdJKO8c8BkhRmSAHvvDdy5hIjKHOpNe5XCYwM/edit#gid=32579783

Here is the detailed tutorial: Schedule import to Shopify from Google Sheets.

Batch Import From many URLs

Available only for Big and Enterprise subscription plans.

If you have multiple URLs to upload then you can construct JSON file with your URLs and import it for the app to create a Batch job with all your files.

The JSON structure looks like this:

{
  "files": [
    {
      "uri": "sftp://user:[email protected]/directory/filename.xlsx"
    },
    {
      "uri": "ftp://ftpuser:[email protected]/folder/file-name.csv"
    },
    {
      "uri": "https://docs.google.com/spreadsheets/d/1e8Ko/edit"
    },
    {
      "uri": "https://www.dropbox.com/s/df98s7df98d9f/file.xlsx?dl=0"
    },
    {
      "uri": "url to file"
    },
    {
      "uri": "url to file"
    },
    {
      "uri": "url to file"
    }
  ]
}

Here is the detailed tutorial: Import multiple files from URLs to Shopify using JSON file.