How-to configure a datasource

Navigate to the feed you have set up 

Select Data Sources to add a new datasource 

Select your datasource type. Current available types are External Data Source (FTP, SFTP, S3), Storeroom Data Source and SQL Data Source 

Common Datasource Fields:

• Name - The name you are giving your datasource

• Active? - Whether this datasource should be enabled and active. Note: this is checked by default, uncheck it to disable the datasource 

• Supplemental?

• Priority

• Status Behavior

• How to Handle Duplicate Items? - Allows you to specify what action should be taken if there are duplicate items in a product feed. The two available actions are "Error & Stop the Import" and "Ignore Them"

• Primary Attribute - The primary and unique ID for the feed/datasource

• Primary Attribute Strategy - Allows you to select whether you want to use "None (default, use the raw value)" or "Hash (run the value through SHA256 hash)"

• Additional Attributes - Allows you to map the feed attributes you added when creating the feed to attributes in the datasource. If the datasource attributes are named the same as your feed attributes, you can select the "Use Defaults" button to auto-populate these 

External Data Source (FTP, SFTP, S3) Fields:

• Connection

• File Name

• File Type

• File Compression

• Item Element

Storeroom Data Source Fields:

• Source Feed - Select an existing feed from the same client to use as the datasource for this feed

• Include Suppressed?

SQL Data Source Fields:

• Database Type

• Database Host

• Database Port

• Database User

• Database Password

• Remove the Password?

• Database Name

• Database Table (or View)

• Columns

Configure your datasource details and click Save