magento / magento/data-migration-tool
Customer Group Id for NOT_LOGGED_IN_ID is missmatch in DB and File
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 339
- Forks
- 195
- PR merge metrics
- No merged PRs in 30d
Description
I have migrated from Magento 1.9.4.1 to 2.4.0.
-
After successfully migration, admin is working, and all the products status and stock is the same as Magento1
-
At the front-end, the product individual page is working fine.
-
But the category page is not showing any of the products for the non-logged-in user and showing error message We can't find products matching the selection.
-
After investigating this issue I found that the value for NOT_LOGGED_IN user is different into "catalog_product_index_price.customer_group_id" and "Magento\Customer\Model\Group::NOT_LOGGED_IN_ID"
-
In database customer_group_id for non-logged-in user is 6: table: https://www.screencast.com/t/HSBHPlrZDo Admin: https://www.screencast.com/t/ku2BiaT2
-
And the product collection filter for customer group with "NOT LOGGED IN" is 0 : Magento\Customer\Model\Group::NOT_LOGGED_IN_ID
-
Hence it could not found any matching product at the category page.
Expected result
- The ID for the "NOT LOGGED IN" should be the same at the DB/Admin side and at the Group Class.
- It should show the product on the category page.
Actual result
https://www.screencast.com/t/sycfh1wpS
What should we do in this case?
- Do we need to override the Group class for time being?
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by tracing Magento\Customer\Model\Group::NOT_LOGGED_IN_ID and the migration handling for catalog_product_index_price.customer_group_id. Reproduce the migrated-state category query for a non-logged-in user, then verify that the database value and group constant use the same ID and that products appear in the category page.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100