Import file from URL

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 Matrixify 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 Matrixify  “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 Matrixify, 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:password@server: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 Google Drive, just paste the Google Drive public 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.

Import from Microsoft SharePoint

You can import a file from Microsoft SharePoint.
Take the SharePoint link to a file, set it so that anyone with the link can view it, and use that link in the app to import from it.

The link looks like this:

https://mycompany.sharepoint.com/:x:/g/E123EppwV8KwPk-xIPnvrW_sAIU123ap2dXQeivUSWJ-GBg?e=agsbdJ

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.
Each URL would need to be a valid URL from which the app can download the Matrixify template file.

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"
    }
  ]
}

Just to be clear – this JSON cannot have the import data itself, it just points to URLs that return Matrixify template files.

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

Good to know!

• Matrixify is also able to Import from a URL which path does not end with a file name. The way this is found out is by the headers the web server responds with. At first the Matrixify app looks into those headers, and if there are no headers, then Matrixify will use the filename from the URL. The files can be anything that Matrixify can import – CSV, Excel XLSX, zip files, etc. – just there must be the appropriate headers that describe the file name and content. The web server should respond with the headers Content-Disposition and Content-Type .By accessing your file, you should be able to include those so that Matrixify knows what type of file you are importing:
  • Content-Disposition should contain the file name, for example, like this: attachment; filename="products.csv"
  • Content-Type should have the value text/csv.

• Here you can find out more about the headers Content-Disposition and Content-Type. You can also test your headers using the curl -I "<URL>" command in your Terminal – it will show your headers in plain text.
• When Matrixify app downloads file from public web URL, the app will first check if the file exists by downloading 0 data just to see that URL responds with correct HTTP response code 200.
  The URL check for public web downloads has a timeout of 30 seconds to quickly show in the App if the URL works or not. We are sending the header "Head-As-Get-Without-Content": "true". We do not use the HTTP HEAD method because many web servers don’t respond to HEAD. Once the URL check has been completed, the app will make a full proper HTTP GET request without that header to download a file. This file download has a timeout of 5 minutes.