Connectors - General Aspects

Connectors: General Aspects

 

Sales Layer is designed to not only centralize all your product information, but also as a means of exporting it to various destinations, such as Amazon, Magento, InDesign, as well as many others. The transfer of data to other platforms is done using Channels. As well as exporting, Channels can also be used to import data to your PIM by connecting your ERP to Sales Layer. Channels that take data from external sources and insert it into your account are known as Import Connectors

Configuring an Import Connector (by typing “ftp://”, the system will automatically display the options for connecting via FTP)
Configuring an Import Connector (by typing “ftp://”, the system will automatically display the options for connecting via FTP)

There are a large number of Channels available in Sales Layer, the first of which, displayed with green icons, are the most generic ones. These can be employed for a large number of uses: quickly generating CSV or Excel files, creating a connector to an API, or an Import Connector, which as you can see above can be configured with http or ftp to periodically load data from a CSV.

 Available Channels
Available Channels

Most of these connectors work in a very similar way, although there are small differences depending on the specifics of the channel. In every case there is a list of fields which you configure to determine the relationship between the fields in Sales Layer and those in the data source, in the case of import connectors, or those of the destination, in terms of export connectors.

Some connectors work with an Excel spreadsheet template, such as Leroy Merlin, Amazon, or El Corte Inglés. These platforms require you to upload your product information based on a template they provide. Sales Layer makes this easy by configuring the data you wish to export into the format of the template.

The Amazon Vendor Central Channel
The Amazon Vendor Central Channel

Other connectors such as Prestashop, Magento or WooCommerce, provide you with a plug-in to install on your platform. Guidance is provided to help install the plug-in. Once you have everything set up, your content can then be easily uploaded via the connector.

Another key element of Sales Layer is the ability to apply functions, called formulas, to certain fields. This allows you to modify the values of your fields by setting conditions such as:

  • Only exporting products with a specific value
  • Applying mathematical operations (incrementing a field’s value by 10%)
  • Concatenating values from different fields
  • As well as many others.

We will not explain every formula in too much detail here, as each one is explained with examples, in the manual that accompanies the formula’s section.

The Formulas Manual, easily accessible when editing a formula
The Formulas Manual, easily accessible when editing a formula

 

17.5 Each field in the channel has an option on the left (red color) to take it out of the content. At the right (Formula) there is one to add formulas.
Each field in the channel has an option on the left (red color) to take it out of the content. At the right (Formula) there is one to add formulas.
This option is not included in all connectors
This option is not included in all connectors

It is possible to add and take out fields when editing the channel, and also to print fields from other tables. To do the latter, we could use a formula like the following: PRINT({products.product_name}) We need to take into account that to print fields from another table, the table should be merged (and that option doesn’t exist in the API so we couldn’t do it from there: it’s possible in an Excel channel).