cancel
Showing results for 
Search instead for 
Did you mean: 

Magento EE 2.3 Elastic Search Not working with B2B Commerce

Magento EE 2.3 Elastic Search Not working with B2B Commerce

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

3 REPLIES 3

Re: Magento EE 2.3 Elastic Search Not working with B2B Commerce

Hello @uttam_desai 

 

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

 

 


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: Magento EE 2.3 Elastic Search Not working with B2B Commerce

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.

Re: Magento EE 2.3 Elastic Search Not working with B2B Commerce

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

 

 


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer