we have about 800,000 reviews in our Magento 2.4 for products in one website/store view. Now we want to launch another website / store view for another country. In both countries almost the same products are available.
Now I have the task to make also the reviews available in the new website / store front.
My 1st approach was an SQL Statement for adding new datasets to the table review_store. That didn’t work. The reviews weren’t visible.
Then I created a console command for transferring them. With a small amount of reviews it works good. But the command needs about 70 seconds for just 1 (!) review. For all reviews this script would need over 1,5 years.
I think it’s because of the $review->save() and $review->aggregate() calls for every single review.
Is there a better way for transferring so many reviews to another website in Magento?
Thanks in advance!