M2.4.5 EE, v1.4.0: Fix the incompatibility with Magento Enterprise Edition

ISSUE:

We have purchased the bsscommerce/simple-detail-configurable extension of the enterprise edition. After installing the extension in a new fresh Magento , we are facing issues while applying the visibility filter on the product grid at admin. 

After that, we have also checked the log file. There is an error related to this module.

Next Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sdcp_only_display_product_page.entity_id' in 'on clause', query was: SELECT `e`.*, `sdcp_only_display_product_page`.`value` AS `sdcp_only_display_product_page_value`, `at_visibility`.`value` AS `visibility`, `at_qty`.`qty` FROM `catalog_product_entity` AS `e`

 LEFT JOIN `catalog_product_entity_int` AS `sdcp_only_display_product_page` ON (`sdcp_only_display_product_page`.`entity_id` = `e`.`entity_id`)

                     AND (`sdcp_only_display_product_page`.`attribute_id` = 202)

                      AND (`sdcp_only_display_product_page`.`store_id` = 0

 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`row_id` = `e`.`row_id`) AND (`at_visibility`.`attribute_id` = '99') AND (`at_visibility`.`store_id` = 0)

 LEFT JOIN `cataloginventory_stock_item` AS `at_qty` ON (at_qty.`product_id`=e.entity_id) AND (at_qty.stock_id=1) WHERE ((sdcp_only_display_product_page.value IS NULL OR sdcp_only_display_product_page.value = 0) AND (at_visibility.value = '4')) AND (e.created_in <= '1671557429') AND (e.updated_in > '1671557429') ORDER BY `e`.`entity_id` DESC

 LIMIT 20 in /var/www/html/magento245/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:109

SOLUTION:

Unfortunately, our module has not worked properly with Magento Enterprise Edition

To resolve the issue, please edit the following files:

app/code/Bss/Simpledetailconfigurable/Helper/ModuleConfig.php

app/code/Bss/Simpledetailconfigurable/Plugin/Ui/DataProvider/AbstractDataProvider.php

If you need any further assistance, please feel free to contact us. We'd be happy to support you!

Get to know about us!!

BSS Commerce is a trusted Magento 2 extensions provider with 14+ years of experience, serving 75,000+ customers worldwide. We are an Adobe Commerce Solution Bronze Partner and a Select Magento Extensions Builder, reinforcing our expertise in the Magento ecosystem.

We specialize in developing 150+ high-quality Magento 2 extensions that enhance functionality, improve user experience, and support scalable growth. Our reputation is built on long-term partnerships, positive feedback, and proven performance-driven solutions.

Explore our extensions: https://bsscommerce.com/magento-2-extensions.html 

Discover our top tier plugins:

• Magento 2 B2B Extension by BSS Commerce is an all-in-one solution that streamlines wholesale operations with advanced pricing, company management, and efficient B2B workflows.
• BSS Commerce’s Magento 2 SEO Extension is a powerful tool that enhances search visibility, automates SEO tasks, and drives more organic traffic to your Magento store.