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
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.
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.
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.
From a connector you can access fields, searching from one table to another: from variants to products and from products to categories. To do this, use the formula
For example, starting from a variant, you can print the name of your product using the following formula:
Pay attention to the name of the field you want to look for in the product table.
On the other hand, searching for variant fields in the product table, it is only possible if the product table is merged with the variant table.
Warning: This option does not exist in connectors working through APIs.
In case the tables are not merged, you can use the following formula: