Imports combined on a unique key

Imports combined on a unique key

Imports combined on a unique key

After having configured the database and fully aware of the functions relating to the import of data from external sources, it is possible to understand how to carry out combined Connecteed imports, first of all, by understanding its basic functioning and potential.



Suppose you want to sell on Amazon, or send your CSV of products to your distributors and that for your purpose, you need to have a database made up of 4 fields: EANpricequantityweight ​Suppose you have, for this purpose, two different files (from two different suppliers), of which: from the first file, you are interested in acquiring the EAN code and quantity; from the second file you want to extrapolate the weight, which you will need to create rules relating to the shipping cost. and therefore want to build a database starting from different files, and for which no file, alone, contains the data necessary to populate the database from which to build your CSV or your flow towards Amazon or another marketplace. In these cases, it will be necessary to arrange a primary import (effectively inserting the first import into your project), using the file containing the greatest number of fields or in any case the file that you consider most complete in terms of number of references. Once the first import has been configured, from a primary source that contains code (EAN), quantity and price, it will be possible to associate a second file from which to import the weight, using the concatenation function, and in particular, using the unique EAN key as an association meter.The functional requirement for obtaining this combination is for the two files to contain, for each record (product) a piece of data that can unequivocally correlate the two products between two different files. It will therefore be sufficient for you to activate the first import in normal mode, and the second import, in combined mode, to obtain the desired effect. NB: if the second file does not offer weight information for one or more products, the import will still be processed, importing into the database only the value for the products in which it is present .


DOCS

DOCS

DOCS