Product reviews import feature is added by the free Product Reviews add-on. It is not included in the X‑Cart core.


A CSV file for importing reviews must have the name reviews-yyyy-mm-dd.csv, where the part -yyyy-mm-dd can be any date you want, or can be omitted.

Examples of correct product CSV file names:

  • reviews.csv;

  • reviews-13-01-01.csv;

  • reviews-from-my-provider.csv

Below is a list of supported fields and their respective value types for the import of reviews:

Fields supported by X-Cart core

Field in CSV file

What this field describes

Value type

product*

Product SKU (Unique identifier of the product)

String
Max. length: 32

review

Customer review

String

response

Admin reply to the customer review (field value can be empty)

String

rating

Product rating set by the customer

Integer (1-5)

additionDate

Date of review posting

Date
(e.g. 1 Jan 2021)

responseDate

Date of response posting (field value can be empty)

Date
(e.g. 1 Jan 2021)

respondent

Email of the store administrator account that was used to respond to the review (field value can be empty)

email

reviewerName

Name of the customer who submitted the review

String
Max. length: 255

email

Email of the customer who submitted the review

email

status

Review status set by the store administrator (If set to ‘Approved’, the review is visible on the storefront)

Approved / Pending

useForMeta

If set to ‘Yes’, the review will be used in the product metatags

Yes/No

Fields added by the add-on Multivendor

Field in CSV file

What this field describes

Value type

vendor*

Product vendor login name

String

* Required field.

** See CSV Field Notices for more info.

Tips:

  • If you are going to import data into X-Cart and do not wish to update certain X-Cart fields during the import process, you should not include these fields in your CSV file for import. Simply remove the respective column(s) from the file.

Related pages:

Did this answer your question?