With use of Native Elastic Search and B2B Commerce Magento Community fetaures not working well.
- Product Collection get empty.
- 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.
go to category and which permission assign to category, please assign proper permission for this
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.
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