cancel
Showing results for 
Search instead for 
Did you mean: 

Magento Import product reviews from a csv magento 2.3

Magento Import product reviews from a csv magento 2.3

Hi,

can i Import product reviews from a csv in magento 2.3?

2 REPLIES 2

Re: Magento Import product reviews from a csv magento 2.3

Hello @decornmore 

 

I understand the requirement you are trying to achieve.

 

But by default there is no functionality to import product reviews using CSV file in the magento2.3.X

 

You will require to use third-party extensions for the same.

 

Below i am listing few extensions link which helps you to achieve the same.

 

https://bsscommerce.com/import-export-product-reviews-for-magento-2.html

 

https://www.mageants.com/product-reviews-import-export-for-magento-2.html

 

Also for more details refer this link - https://community.magento.com/t5/Magento-2-x-Programming/Import-Reviews-Magento-2/td-p/57845

 

Hope it helps !

if issue solved,Click Kudos & Accept as Solution

Re: Magento Import product reviews from a csv magento 2.3

If you are familiar with Magento DB structure for reviews, I would recommend using raw SQL.
For example:

-- Edit values
SET @PRODUCT_ID = 123;
SET @STORE_ID = 1;
SET @CUSTOMER_ID = NULL;
SET @REVIEW_TITLE = 'Lorem Ipsum';
SET @REVIEW_DETAIL = 'Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit...';
SET @REVIEW_RATING = 5; -- Between 1 to 5
SET @REVIEW_NICKNAME = 'John Doe';
SET @REVIEW_CREATED_AT = '2019-07-15'; -- OR date in YY-mm-dd HH:ii:ss format

-- No need to Edit
SET @REVIEW_ENTITY_ID = (SELECT entity_id FROM rating_entity WHERE entity_code = 'product'); -- 1: product, ...
SET @REVIEW_STATUS_ID = (SELECT status_id FROM review_status WHERE status_code = 'Pending'); -- 1: Approved, 2: Pending, 3: Not Approved

INSERT INTO review SET created_at = @REVIEW_CREATED_AT, entity_id = @REVIEW_ENTITY_ID, entity_pk_value = @PRODUCT_ID, status_id = @REVIEW_STATUS_ID;
SET @REVIEW_ID = (SELECT LAST_INSERT_ID());
INSERT INTO review_detail SET review_id = @REVIEW_ID, store_id = @STORE_ID, title = @REVIEW_TITLE, detail = @REVIEW_DETAIL, nickname = @REVIEW_NICKNAME, customer_id = @CUSTOMER_ID;
INSERT INTO review_store SET review_id = @REVIEW_ID, store_id = 0;
INSERT INTO review_store SET review_id = @REVIEW_ID, store_id = @STORE_ID;
INSERT INTO rating_option_vote SET option_id = 5, remote_ip = '', remote_ip_long = 0, customer_id = @CUSTOMER_ID, entity_pk_value = @PRODUCT_ID, rating_id = @REVIEW_ENTITY_ID,
review_id = @REVIEW_ID, percent = 100, value = @REVIEW_RATING;

For details on how to "Import Product Reviews in Magento via SQL", please visit
https://blog.magepsycho.com/import-product-reviews-in-magento-via-sql/