Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save jordanvector/ef98f59d07880f445464512d303d3fc0 to your computer and use it in GitHub Desktop.
Save jordanvector/ef98f59d07880f445464512d303d3fc0 to your computer and use it in GitHub Desktop.
From 942da86e86cbcb7503bfc78d5d0c32a76aff8423 Mon Sep 17 00:00:00 2001
From: Jordan Schinella <[email protected]>
Date: Wed, 23 Mar 2022 18:18:54 -0400
Subject: [PATCH] fix inventory search indexer
---
.../Indexer/ConfigurableChildStockStatusModifier.php | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/Model/CatalogSearch/Indexer/ConfigurableChildStockStatusModifier.php b/Model/CatalogSearch/Indexer/ConfigurableChildStockStatusModifier.php
index 4dd5ac8..32cfa62 100644
--- a/Model/CatalogSearch/Indexer/ConfigurableChildStockStatusModifier.php
+++ b/Model/CatalogSearch/Indexer/ConfigurableChildStockStatusModifier.php
@@ -68,7 +68,7 @@ class ConfigurableChildStockStatusModifier implements SelectModifierInterface
['product_link_configurable' => $this->resourceConnection->getTableName('catalog_product_super_link')],
[new \Zend_Db_Expr('1')]
)->where(
- "product_link_configurable.parent_id = product.{$linkField}"
+ "product_link_configurable.parent_id = e.{$linkField}"
);
$existsSelect->join(
['product_child' => $this->resourceConnection->getTableName('catalog_product_entity')],
@@ -90,7 +90,7 @@ class ConfigurableChildStockStatusModifier implements SelectModifierInterface
)->where('stock_status_index_child.is_salable = 1');
$typeConfigurable = Configurable::TYPE_CODE;
$select->where(
- "product.type_id != '{$typeConfigurable}' OR EXISTS ({$existsSelect->assemble()})"
+ "e.type_id != '{$typeConfigurable}' OR EXISTS ({$existsSelect->assemble()})"
);
}
-}
+}
\ No newline at end of file
--
2.35.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment