Integration with Webasyst - duplicate products. Bug

To analyze the problem - provide an example of a product that duplicates.

For example product: Curtains matting Jade SRG-1609. Full list of duplicates in the attached file. [file]1194[/file]

[quote] Fokin Vladimir Sergeevich wrote: Now there are a lot of duplicate products. Full list of duplicates in the attached file. [/quote] 16 duplicate products - is this a complete list? I thought the problem is more critical. If not all products are duplicated - most likely the problem is not in the import, which you say was implemented several years ago. I also checked that the import action has not been changed since 2019. I can assume that there may have been some problem with the articles on the part of WebAsyst - for the test, we can remove some duplicate product (which you specify) and check if it will be imported again as a duplicate and based on what data?

There are duplicates in the file for the last couple of weeks, we manually deleted the previous about 400 pieces. For the test, you can remove the goods: Curtains matting Jade SRG-1609 code 10518 and Brushes for curtains KCS dairy code 10573. Thank you!

[quote] Fokin Vladimir Sergeevich wrote: There are duplicates in the file for the last couple of weeks, we manually deleted the previous about 400 pieces. [/quote] And they are no longer duplicated?

after removing 400 duplicates manually, new duplicates of products appeared, the list of which was given to you above (16 pieces)

[quote] Fokin Vladimir Sergeevich wrote: after removing 400 duplicates manually, new duplicates of products appeared, the list of which was given to you above (16 pieces) [/quote] I am interested in the question - does a duplicate product appear constantly if you delete it?

Yes. For example, there are duplicates of "Brushes for curtains..." in the file, they were deleted before but they appeared again.

[quote] Fokin Vladimir Sergeevich wrote: Yes. For example, there are duplicates of "Brushes for curtains..." in the file, they were deleted before but they appeared again. [/quote] For example, 2 products: initial - https://box.lanita-shtor.com.ua/admin/shop/products/5055/edit/ - sku with webasyst = 5532 duplicate - https://box.lanita-shtor.com.ua/admin/shop/products/10573/edit/ - sku with webasyst = 9580 Most likely, the problem is that on the webasyst side, the article was changed for the goods - the goods themselves were not found by key / code - and a new one was created with a new identifier from the webasyst side.

Thank you! Regarding the type of goods "Brushes" from your example - there really were changes in the articles, now there are two of them - wholesale price and retail price, before there was one. And the question is - how to make appropriate changes to the import actions for this type of goods? But about the type of goods "Curtains" (for example Curtains matting Jade SRG-1609 code 10518) - the articles for this type have not changed since the import, but duplicates still appear ... What could be the reason?

[quote] Fokin Vladimir Sergeevich wrote: Thank you! Regarding the type of goods "Brushes" from your example - there really were changes in the articles, now there are two of them - wholesale price and retail price, before there was one. And the question is - how to make appropriate changes to the import actions for this type of goods? [/quote] As far as I understand - in action for this there is a setting how to import options - and the choice "as price levels". It turns out that according to the main article it will create a product, and according to the second one, it will add a price level to it. [quote] Fokin Vladimir Sergeevich wrote: But about the type of goods "Curtains" (for example Curtains matting Jade SRG-1609 code 10518) - the articles for this type have not changed since the import, but duplicates still appear ... What could be the reason? [/quote] Similarly, the article was 8181 and 8184

In the Webasyst API settings / Import products, we always had "price types" selected [file]1372[/file] >> Similarly, the article was 8181 and 8184 A duplicate of this product does not have an External ID, there is a product for sku 8181, but sku 8184 does not exist [file]1373[/file]

<<let's look at this on a specific product (give a link) - I'll look at the output by article of this product>> Thank you! In the attached file there are new duplicates that have appeared over the past week (highlighted in color) and links to one of the products with a duplicate + links to the old duplicate from the "Curtains" category. [file]1486[/file]

I did not ask for another file with duplicates - but an example of 1 product (link to OneBox) for which there should be price types.

There are just such links in the file)) for example https://box.lanita-shtor.com.ua/admin/shop/products/5202/edit/

I don't see this product in the search results yet..

[quote] Tyndyk Maxim Vadimovich wrote: I don't see this product in the search results yet.. [/quote] Now in the API results there is no product with the name "KCS purple curtain brushes" and sku_id 5268

Unfortunately, we cannot track the issuance via the API, but in fact in the Products we have both the above-mentioned product and a duplicate for it [file]1536[/file] . A duplicate of the same product at the link https://box.lanita-shtor.com.ua/admin/shop/products/10615/edit/ Why is this happening? There is also an example of a product https://box.lanita-shtor.com.ua/admin/shop/products/6688/edit/ and its duplicate https://box.lanita-shtor.com.ua/admin/shop/products /10499/edit/

so how do we solve the problem of duplicates?

[quote] Fokin Vladimir Sergeevich wrote: Unfortunately, we cannot track the issuance by API, but in fact in the Products we have both the aforementioned product and a duplicate for it. A duplicate of the same product at the link https://box.lanita-shtor.com.ua/admin/shop/products/10615/edit/ Why is this happening? There is also an example of a product https://box.lanita-shtor.com.ua/admin/shop/products/6688/edit/ and its duplicate https://box.lanita-shtor.com.ua/admin/shop/products /10499/edit/ [/quote] I cannot look into the past and point out specifically what was wrong before in the upload or on the WebAsyst side. But one thing I can say for sure - the integration has been for several years, and no changes have been made from our side - most likely something has changed on the Webasyst side. The fact that positions with different SKUs were transferred is obvious. Why they did not contact as types of prices then - I do not know the same. And why positions were issued, but now they are not issued - this is the same question for WebAsyst. [quote] Fokin Vladimir Sergeevich wrote: so how do we solve the problem of duplicates? [/quote] Now I will look at the issue of the product https://box.lanita-shtor.com.ua/admin/shop/products/6688/edit/ , maybe it is in the issue and the situation will clear up

Yes, I understand what happened to you. Here is the output by the name of this product [quote] array ( [id] => 2469 [id_1c] => f5b6223e-acb1-46e9-ab42-dd3454c48346 [name] => Plain curtains T-033 burgundy [summary] => The online store lanita-shtor.com.ua also recommends buying tulle for the kitchen. A huge selection of goods with delivery anywhere in Ukr$ [meta_title] => [meta_keywords] => [meta_description] => [description] => <p></p> <p></p> [contact_id] => 1 [create_datetime] => 2014-10-17 20:50:29 [edit_datetime] => 2020-12-03 15:14:50 [status] => 1 [type_id] => 1 [image_id] => 6154 [image_filename] => [video_url] => [sku_id] => 8527 [ext] => jpg [url] => 2469 [rating] => 0 [price] => 2.3 [total_price] => 0.0000 [compare_price] => 0 [currency] => USD [min_price] => 1.5 [max_price] => 2.3 [tax_id] => [count] => [cross-selling] => [upselling] => [rating_count] => 0 [total_sales] => 0 [category_id] => 631 [badge] => [sku_type] => 0 [base_price_selectable] => 0 [sku_count] => 2 [compare_price_selectable] => 0.0000 [purchase_price_selectable] => 0.0000 [total_sales_html] => [rating_html] => <span class="rate nowrap" title="Average customer rating: 0 / 5"><i class="icon10 star-empty"></i><i class="icon10 star-empty" ></i><i class="icon10 star-empty"></i><i class="icon1$ [image_url] => https://lanita-shtor.com.ua/wa-data/public/shop/products/69/24/2469/images/6154/6154.200x0.jpg ) [/quote] that is, this is a product with sku_id=8527 - which you consider to be a duplicate https://box.lanita-shtor.com.ua/admin/shop/products/10499/edit/ and here is the issue of its constituent SKU [quote] array ( [0] ( [id] => 1417 [product_id] => 2469 [id_1c] => 255801a5-3d74-4fe6-9aaa-3874814b67bb [sku] => [sort] => 1 [name] => Wholesale price (from one roll) [image_id] => [price] => 1.5 [primary_price] => 1.5 [total_price] => 0.0000 [purchase_price] => 0 [compare_price] => 0 [count] => 0 [available] => 1 [dimension_id] => [file_name] => [file_size] => 0 [file_description] => [virtual] => 0 [stock] => array ( ) [currency] => USD ) [1] ( [id] => 8527 [product_id] => 2469 [id_1c] => [sku] => [sort] => 2 [name] => Price per cut [image_id] => [price] => 2.3 [primary_price] => 2.3 [total_price] => 0.0000 [purchase_price] => 0 [compare_price] => 0 [count] => [available] => 1 [dimension_id] => [file_name] => [file_size] => 0 [file_description] => [virtual] => 0 [stock] => array ( ) [currency] => USD ) ) [/quote] in fact, everything worked correctly (see the screenshot in the attachment) - the correspondence id=8527 was taken as the price of the goods, and 1417 - as the price level "Wholesale price (from one roll)" and this product https://box.lanita-shtor.com.ua/admin/shop/products/6688/edit/ - well, apparently you previously had 1, without a price level - and then supposedly a price level was not added to it (in this case, a duplicate would not have been created), but a new product was created and this one allegedly became a price level (we have added a price level, old products are not deleted) in fact, what you need is to figure out that you really have a double, which is already registered in another product as a price level - and delete such a double. [file]1648[/file]

Thanks for the detailed explanation! Let's try to remove the "correct" duplicates... Let's observe)