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 | |
product* | Product SKU (Unique identifier of the product) | String |
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 |
responseDate | Date of response posting (field value can be empty) | Date |
respondent | Email of the store administrator account that was used to respond to the review (field value can be empty) | |
reviewerName | Name of the customer who submitted the review | String |
Email of the customer who submitted the review | ||
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 | |
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: