magento / magento/data-migration-tool

Customer Group Id for NOT_LOGGED_IN_ID is missmatch in DB and File

Open
#844 1 comment 0 reactions 0 assignees View on GitHub

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.

  1. After successfully migration, admin is working, and all the products status and stock is the same as Magento1

  2. At the front-end, the product individual page is working fine.

  3. 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.

  4. 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"

  5. 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

  6. And the product collection filter for customer group with "NOT LOGGED IN" is 0 : Magento\Customer\Model\Group::NOT_LOGGED_IN_ID

  7. Hence it could not found any matching product at the category page.

Expected result
  1. The ID for the "NOT LOGGED IN" should be the same at the DB/Admin side and at the Group Class.
  2. It should show the product on the category page.
Actual result

https://www.screencast.com/t/sycfh1wpS

What should we do in this case?

  1. Do we need to override the Group class for time being?

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.