Lookup in Table is one of the mapping functions available in the Data Octopus app.
When is it worth using?
If you want to supplement the model with missing data
If you want to supply the model with additional data
In this way, you can add information to the model, such as margin, COGS (Cost of Goods Sold), stock levels, delivery time, data from ecommerce engine, Delavo, Ceneo, Liveprice or other data that you want to assign to products, in order to mark or segment them.
How to do it?
The whole process starts with uploading the import to the application in the Data Imports section. You can do this using Google Sheets, an XML file, CSV, or even a table in BigQuery. A comprehensive guide on how to submit such an import can be found here.
It is important that the uploaded import, in addition to the additional data, has a column with the same product identifiers as the product feed uploaded to the application. This is necessary to then, based on the key, which will be this ID, assign data from the additional import to individual products.
Then, when we have already uploaded the import, we go to the model level (Model and data mappings> master model). Here there are 2 possibilities, either pulling additional data into a newly created field (e.g. from the Product Fields Library) or into an already existing one (e.g. a custom label).
Enter the field into which you want to pull data from the import by clicking edit mapping.
2. Select Lookup In Table from the list of rules.
3. Then fill in the fields:
Select field - select the field on the basis of which additional data will be added to the product, usually it is the product ID..
Import or model - select from which import you want to send additional data
Key - select the key on the basis of which the data will be added (it must be a field in the additional import, the values of which match those from the field selected in Select field), usually it is the product ID
Alias - select the column from the additional import, from which the data is to be added (in this case, the additional_data import contained 2 columns - id and custom_label, and it is the values from this column that will be added).
4. Click Save and Run Mapping.
5. Now you can check if the data has been assigned correctly using the Preview function.
