Magento EE 2.3 Elastic Search Not working with B2B Commerce

[uttam_desai]

With use of Native Elastic Search and B2B Commerce Magento Community fetaures not working well.

- Product Collection get empty.

Cos:
- when enable the options for the category permission in admin product collection getting empty.

- when disable the options for the category permission product collection working well.
feature link:
https://docs.magento.com/user-guide/catalog/category-permissions.html

[Sunil Patel]

Hello @uttam_desai 

go to category and which permission assign to category, please assign proper permission for this

[uttam_desai]

Thanks for your quick response.

I have check with all settings of category permission, i have also change the category-wise permission in category tree but not getting any product in search result.

[Sunil Patel]

Hello @uttam_desai 

please run below command if you are not using permission

update sharedcatalog_category_permissions set permission=-1;
Delete from `magento_catalogpermissions`;
Delete from `magento_catalogpermissions_index`;
Delete from `magento_catalogpermissions_index_product`;
Delete from `magento_catalogpermissions_index_product_replica`;
Delete from `magento_catalogpermissions_index_product_tmp`;
Delete from `magento_catalogpermissions_index_replica`;
Delete from `magento_catalogpermissions_index_tmp`;

and you need to repeat below query

INSERT INTO shared_catalog_product_item (customer_group_id, sku) SELECT 0, sku from catalog_product_entity where sku NOT IN (SELECT sku from shared_catalog_product_item where customer_group_id=0);

for each customer group here customer group id 0