Table of Contents

Connecting through SFTP

Stephen Choi Updated by Stephen Choi

If you are not using a platform which directly integrates with Convictional, data can still be shared through our SFTP server. This enables users to share data with Convictional by securely transferring files to us using an SFTP client. After onboarding, we will automatically process transferred files and load the data into our platform.

We are actively building out our SFTP capabilities. If you have any questions or feature requests, please reach out to us at support@convictional.com.

Connecting via SFTP

Provided below is the information needed to establish a SFTP connection:

  • Host: sftp.convictional.com
  • Port: 2122
  • Directory: /
The directory is the home directory (e.g. /) because our SFTP service is a virtual SFTP service backed by Google Cloud Platform. Our service can infer details about the file and process it independently of the SFTP entry point, so we don't use folders.
  • Credentials (Username + Password): available in our platform as part of the onboarding process

If you've forgotten your Username, you can view it from the settings->integrations tab.

If you've forgotten your Password, you can update it from the settings->integrations tab.

File Formats

We currently support processing CSV files. We currently support comma (,), bar (|) or tabs (/t) as delimiter/separator. If your file uses different delimiter/separator, please contact support@convictional.com for its inclusion.

We require that all column headers be non empty. We also require that all row entries be in a specified column header.

Products

When importing data through CSV we need to build an understanding of how your information can be represented in our system. We use the concept of CSV Mappings to enable this.

What are CSV Mappings?

CSV Mappings match one-to-one each of your product details with our Convictional product fields. You can find the list of product fields we support here. When syncing product details from your uploaded files, we will make use of CSV Mappings to accurately create your products in our system.

You will only need to create CSV Mappings one time, every uploaded product file will make use of these mappings.

How do I create CSV Mappings?

CSV Mappings are completable within our platform as part of the onboarding process. You can find the CSV Mappings creation tool on the products page. Start by clicking on "Create CSV Mappings". Below is a full walkthrough.

Step One: Upload your product file to the SFTP server

To begin setting up your CSV Mappings, you'll first need to have your product file uploaded to our SFTP server.

You can use our product template linked here to facilitate mappings between your CSV headers and our Convictional product fields.

This products CSV must also be uploaded to the SFTP server.

Note: If you do not include inventory levels in your Products CSV (recommended), you will need to upload a separate file including both inventory levels and Product SKUs.

Step Two: Select your product file

In the CSV Mappings creation tool on the products page, you'll first be prompted to select the appropriate product file from which the mappings will be based off of. We also ask that you specify the delimiter/separator used in your product file. This is most commonly a comma (,) for CSV files.

Step Three: Setup CSV Mappings

Upon submitting your product file and delimiter/separator, we will pull column headers and sample row data from the specified file. With this, you can begin mapping.

In each row, we provide our Convictional fields along with their corresponding descriptions. Through a dropdown selection, choose the appropriate column name from your product file that matches the Convictional field. Upon selection, we provide a preview of some of the values in that column from your file. Please match all fields that are applicable to your products. Note that it is possible to map multiple Convictional Fields to a column header multiple times. For example, if your products don't have product codes, you can set both Product Code -> Sku and Sku -> Sku.

Step Four: Convictional review

Upon submission, our support team will be notified to review your mappings. We currently only enable product syncing once mappings have been approved. We do so to help catch any potential mappings that could be problematic before syncing your catalogue into our system. Please give 2-3 business days for us to review. We will notify you when your products have synced.

Updating Product Details

For product updates, please upload your updated product file to our SFTP server. We require that the product file name is the same as the one chosen during the CSV Mappings process. This enables our system to easily identify which file to sync information from. Our product updates run periodically, your updates should be live within an hour.

Updating CSV Mappings

If your product file needs changes such as addition/removal of columns that were used in your CSV Mappings, please contact support@convictional.com to update your CSV Mappings.

CSV Mappings Errors

The following table contains common CSV Mappings errors along with suggested solutions to resolve the errors. The errors typically relate to problems in your product and/or inventory file(s) that prevent our system from ingesting your product data.

Error

Solution

Failed Integer Conversion

This field expects only an integer value. Remove any non numeric values.

Failed Number Conversion

This field expects only a numeric value. Use '.' for decimal points if needed. Remove any non numeric values.

Invalid field Count

The specified row is missing column value entries. Each row must have the same number of values as the number of column headers. Empty column values must still be present.

Example of an empty value for a comma (,) delimited file:

"value",,"other value"

note the empty value in between "value" and "other value"

Price List

Once the SFTP feed and products have been created, a price list must be created. See How to Set Up Pricing.

Partnership

The final step is to assign the price list to your buyer. See Adding Partners.

How did we do?

Connecting through EDI

Connecting through Web App

Contact