[leomoon]

5 years, 9 months ago #12576

For some reason, the _stock_status_s field, which I index as text, sortable in order to be able to put in-stock books first sometimes gets sent for indexing as having multiple values. I could not find a pattern, but here is a fragment of the debug info:

https://1drv.ms/t/s!Ah6mDhPS2VbWiKpkHIKUeVYFTYewlQ

Both of these have status out of stock, but the first one, has [outofstock, outofstock] and the second one has just [outofstock].
I checked the database, I checked product->data contents for this failing SKU (59747), but nowhere is stock_status anything but a single string ‘outofstock’. I am not sure why it gets multiplied before it gets sent for indexing?

[wpsolr]

5 years, 9 months ago #12581

The status could be a product taxonomy, and also a custom field?

[leomoon]

5 years, 9 months ago #12589

Status is definitely not a taxonomy – only a custom field. It is not listed under taxonomy choices. And for some reason this multiplication of stock_status field value does not happen on all products. I am able to index some 4000 without any problem before it runs into this issue.

[wpsolr]

5 years, 9 months ago #12590

Can I see your screen 2.2?

[leomoon]

5 years, 9 months ago #12602

https://1drv.ms/u/s!Ah6mDhPS2VbWiK5F_j0V-o-L7cq_YQ

https://1drv.ms/u/s!Ah6mDhPS2VbWiK5GdOy0_2PIl9LSeg

https://1drv.ms/u/s!Ah6mDhPS2VbWiK5H6EJx40xPO–Y9w

https://1drv.ms/u/s!Ah6mDhPS2VbWiK5IQuZ8m58QqUus6A

[wpsolr]

5 years, 9 months ago #12604

Thanks. Indeed, status is only a product custom field.

Can you send me the result of a query on the post_meta table for the product with an error?

[leomoon]

5 years, 9 months ago #12622

You are right, exactly 25 out of 63000+ products had duplicated stock_status meta. I have no idea how this came to be, but after doing manual cleanup, all is good now. Thanks!

[wpsolr]

5 years, 9 months ago #12624

Great.