Choosing an import file

When creating or updating items by import, you can either upload a spreadsheet, provide a URL to a file, e.g. a Google Sheet, or a file hosted in WebDAV, or specify an FTP location.

Upload file

Choose a .csv or .xls file to upload from your computer.

Import from URL

Provider a URL to a .csv or xls file that has been uploaded to another service, e.g. BigCommerce WebDAV.

You can also import from

• Google Drive
• Google Sheets
• Dropbox

For each service, find the "share" URL, ensure the file is publically visible, and copy and paste the link in the URL field.

Dynamic import URLs

When specifying a URL, you might have a date or timestamp within it. When scheduling an import, it can be useful to be able to replace these with placeholders so that the latest file is imported on each run.

Read more on Scheduled imports, including the available placeholders.

Import from FTP/SFTP

To import a file via FTP or SFTP, choose the appropriate source and then provide a URL of the format:

sftp://{username}:{password}@{hostname}:{port}/{path}

If the connection test fails, be wary of any special characters.

Import from WebDAV

To send to BigCommerce WebDAV, you will need to find your WebDAV credentials.

Then create a URL that includes your username, password and path to location that you wish to export to within WebDAV:

https://{username}:{password}@{store-domain}/{path}

e.g.

https://username123:[email protected]/dav/content/

If the connection test fails, be wary of any special characters, for example the @ in your WebDAV username. It would need to be replaced with %40 e.g. apps%40hypaapps.com .

Special characters in URLs

Note that some special characters need to be replaced for their URL-encoded variants when they appear in usernames or passwords.

For example:

• space: %20  or +
• # : %23  (number sign/hash)
• % : %25  (percent sign)
• + : %2B  (plus sign)
• / : %2F  (slash)
• @ : %40  (at sign)
• : : %3A  (colon)
• ; : %3B  (semicolon)

So a username like group/foo would become group%2Ffoo