ProductVariants Indexer Fix

[bricht]

The product variants indexing process is inefficient, since it depends on catalog_product_category. Apply changes in https://github.com/magento/commerce-data-export/pull/11 Fix the faulty plugin so the indexer runs as expected on ee.

1. Removed reliance on generic product index in mview.xml and index.xml
2. Added some queries and plugins to make the indexing more specific and added a workaround for the disfunctional mview, by querying changes manually and adding to ids to the indexer_cl table in a CommitCallback.

[m2-assistant[bot]]

Hi @bricht. Thank you for your report. To help us process this issue please make sure that you provided sufficient information.

Please, add a comment to assign the issue: @magento I am working on this

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

[RuslanKostiv1]

fixed in scope of https://github.com/magento/catalog-storefront/issues/437