1b.app
Link copied -

Questions about importing products

Interested in the following questions about importing products via XLS file:
1. "Search for products by barcode." https://prnt.sc/x5i4t1.
If the product is not found by barcode. Will the standard product search "id" --> "External id" --> "Article" be performed?
2. Product search by additional field https://prnt.sc/x5i7t9.
If the product is not found for the additional field. Will the standard product search "id" --> "External id" --> "Article" be performed?
If more than one product is found by value, which product will be updated?
3. "Delete old product filter values." https://prnt.sc/x5idbd.
Before importing, all filters from the found products will be removed and the ones specified in the file will be imported instead?
4. "Overwrite product filter values." https://prnt.sc/x5ifdq.
If the product is found during import, will the values of existing filters be updated, and filters that a
Original question is available on version: ru

Answers:


Markov Evgeny Igorevich
Employee wrote:
1. "Search for products by barcode." https://prnt.sc/x5i4t1.
If the product is not found by barcode. Will the standard product search "id" --> "External id" --> "Article" be performed?

Yes

Markov Evgeny Igorevich
Employee wrote:
2. Product search by additional field https://prnt.sc/x5i7t9.
If the product is not found for the additional field. Will the standard product search "id" --> "External id" --> "Article" be performed?
If more than one product is found by value, which product will be updated?

not quite, the search by the complementary field comes last, i.e. first by "id" --> "Barcode" --> "External id" --> "Article" and then if not found, then search by additional field
the product of which we find first will be updated: we go through the array of the specified additional fields, if there is a value in the file, then we look for this value and try to take the product.

Markov Evgeny Igorevich
Employee wrote:
3. "Delete old product filter values." https://prnt.sc/x5idbd.
Before importing, all filters from the found products will be removed and the ones specified in the file will be imported instead?

absolutely all product filters that are being updated will be removed

Markov Evgeny Igorevich
Employee wrote:
4. "Overwrite product filter values." https://prnt.sc/x5ifdq.
If the product is found during import, will the values of existing filters be updated, and filters that are not in the product will be added? Is the filter search performed by the filter name?

filter is searched by name
you have a filter in your product, for example color. And for example, it says red. Do you have an import file that specifies the color black for this product?
If the checkbox is not checked, then the product will have all 2 colors after import: red and black. If the checkbox is checked, then the product will have only 1 color - black
if at the same time you will load some kind of filter that the product does not yet have, it will still be added with and without a checkmark
19.01.2021, 15:24
Original comment available on version: ru

Thank you very much for such a detailed answer.
19.01.2021, 17:37
Original comment available on version: ru

I want to upload barcodes by article, but something doesn’t work, there are two columns articul and barcode, (barcodes are already filled in but not correctly), I check the box to overwrite filters and nothing happens
12.01.2022, 13:39
Original comment available on version: ru

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment