Identifying products when importing the inventory sheet
In the picture below there is an example of the inventory sheet. Identifying products during the import to MetaKocka (MK) is executed according to the following order:
- if the value for ''ID'' exists, validation by product ID applies
- if the value for ''Product code'' exists, validation by Product code applies
- if the value for ''Bar-code'' exists, validation by Bar-code applies.
A practical example in two goods examples:
- product ID and product code are entered. In MK there is no product with the provided product ID, while it exists with the provided product code: import will not find the product, since it validates them by their IDs
''Product name'' and ''UM'' are not validated and are not mandatory data.
During the import, bar-code matching is also validated, but according to the following rules:
- if the bar code is entered in the Excel document, the product must have the same bar-code in MK. Otherwise, the error will appear during the import.
- if the bar code is entered in the Excel document and the product has no bar code in MK, an error will appear during the import.
However, the opposite is allowed: the product has a bar code entered in MK, but not in Excel.