Hello, the problem is that summary ratings are not properly linked to the reviews.
In frontend, you can view product overall rating
But the problem becomes with each user review, as you can see in frontend, there are no ratings
If we go to the backend, the review appears like this
The review is properly assigned to the customer, but the Summary rating and the Detailed rating are missing.
Which DB table I should show you to view more ?
16 answers
Hi there,
No, I excluded some websites, I don’t want to migrate all.
So, let’s provide me the admin credentials, ssh credentials and web root path of your M2 instance. I will check further and add more tweak code in the step #8 of our tool to help you out.
Regards,
Mall.
Hi there,
So, kindly do steps as followings:
Step 1: Download the php file at HERE
Step 2: Upload replace downloaded file to the file at path: pub/ub-tool/protected/controllers/Step8Controller.php
Step 3: Once done, let’s reset step #8 and restart data migration in this step.
And tell me know how it goes.
Regards,
Mall.
Hi there,
I want to know the new behavior of the code.
You can see the tweak code (in the file I mentioned in my previous reply) under the comment line below for reference:
// we only migrate review detail in migrated store
$storeId2 = isset($mappingStores[$reviewDetail->store_id]) ? $mappingStores[$reviewDetail->store_id] : null;
if (!is_null($storeId2)) {
...
}
As per such added syntax, you can see our tool only migrates review data under the store views you selected to migrate in step #2 of our tool.
Regards,
Mall.
Hi there,
It seem now the issue as you mentioned persisting in your product’s rating data only?
To handle more for product’s rating data, i have added more tweak code in the step #8 of our tool (you can compare with original file to clear more about my changed)
Please re-do steps as followings:
Step 1: Download the php file at HERE
Step 2: Upload replace downloaded file to the file at path: pub/ub-tool/protected/controllers/Step8Controller.php
Step 3: Once done, let’s reset step #8 and restart data migration in this step. (make sure that you do reset data migration in the step #8 before restart data migration in this step with new applied code)
And tell me know how it goes.
Regards,
Mall.
Mall, you cannot give me those details like this.
Your step 3 is very confusing, please explain better
Step 3: Once done, let’s reset step #8 and restart data migration in this step. (make sure that you do reset data migration in the step #8 before restart data migration in this step with new applied code)
Problem persist, I tried to reset auto increments after reseting whole step 8, now the IDS are correct but the problem persist.
Hi there,
I wonder if you already implement all steps I mentioned above?
Regarding step 3, I’d like to clarify again:
Once you complete both step 1 & 2 as per my note above, you need Reset step #8 first. Only then you re-migrate this step.
Regards,
Mall.
Hi Sergio B,
Regarding the issue:
Summary rating + detailed rating bug, no stars
My apology, I have detected further the issue you mentioned in my local instance and found a root issue that comes from my code migrating data in the table named rating_option_vote
For your information, the one wrong line of code (line 1092) is as follows:
$model2->review_id = $ratingId2;
The correct code should be as follows:
$model2->review_id = $reviewId2;
I’m sorry for this unexpected mistake. I have added such tweak code in the function named _migrateRatingOptionVotes() in the step #8 of our tool. Kindly re-follow the steps below:
Step 1: Download the php file at HERE
Step 2: Upload replace downloaded file to the file at path: pub/ub-tool/protected/controllers/Step8Controller.php
Step 3: Reset the step #8
Step 4: Once done, let’s manually truncate the table named ‘rating_option_vote_aggregated’ in your Magento2 database
Step 5: Start data migration in the step #8 again.
Thanks for your understanding.
Regards,
Mall.
