Documentation/Import Export Suite for WooCommerce/How to import and export WooCommerce Product Reviews and Ratings

How to import and export WooCommerce Product Reviews and Ratings

Export Product Reviews

The product reviews can be exported in few easy steps:

Step 1: Select a post type

Export and download the respective post type into a CSV or XML. This file can also be used to import data related to the specific post type back into your WooCommerce shop. As a first step you need to choose the post type as products to start the export.

Step 2: Select an export method

Choose from the options below to continue with your export: quick export from DB, based on a pre-saved template or a new export with advanced options.

  • Quick Export: Quick export only exports all the basic/standard fields of the respective post type. You do not get to selectively filter the columns with this option except for the groups based on taxonomies/attributes/meta/hidden meta.
  • From pre-saved template: Using a pre-saved template retains the previous filter criteria and other column specifications as per the chosen file and exports data accordingly. You can also edit this file in the process and export accordingly or export straightaway.
  • New Export: A new export will take you through the entire process of filtering/column selection/advanced options that may be required for your export. You can also save this file for future use.

Step 3: Filter data

Filter data that needs to be exported as per the below criteria.

  • Offset-Specify the number of reviews that should be skipped from the beginning. e.g. An offset of 10 skips the first 10 reviews.
    Limit – The actual number of reviews you want to export. e.g. A limit of 500 with an offset 10 will export products from 11th to 510th position.
  • Date From – Date on which the review was received. Export products reviews received on and after the specified date.
  • Date To – Date on which the review was received. Export products reviews received upto the specified date.
  • Products – Input the product name to export respective reviews.
  • Stars – Export reviews of a specific star rating.
  • Customer/Guest Review- Export reviews by customer or guest or both.
  • Review with replies – Enable to include the replies along with the respective reviews.
  • Status – Export reviews by specific post status.
  • Sort Columns: Sort the exported data based on the selected column in the order specified. Defaulted to ascending order.
  • Sort By: Defaulted to Ascending. Applicable to above selected columns in the order specified.

Step 4: Map and reorder export columns

The default export column names can be seen in the screen below. You can edit these if required. If you have chosen a pre-saved template you can see the preferred names and choices that were last saved. You may also drag the columns accordingly to reorder them within the output file.

You can map the columns for export on the basis of following categories:

  • Default fields
  • Taxonomies
  • Meta(Custom fields)
  • Attributes
  • Hidden meta

Step 5: Advanced Options/Batch Export/Scheduling

Use advanced options from below to decide on the batch export count, schedule an export and/or export images separately. You can also save the template file for future exports.

You can click on Export to get the file downloaded into your system.

Import Product Reviews

Step 1: Select post type

Import the respective post type from a CSV/XML. As a first step you need to choose the post type to start the import.

Step 2: Select import method

Import Method

Choose from the options below to continue with your import: quick import, based on a pre-saved template or a new import with advanced options.
WooCommerce Product Reviews Import-Step 2

  • Quick Import: Quick import only imports the fields from the input file that conforms to the specific column headers as required by the plugin. You do not get to selectively filter the columns with this option except for the groups based on taxonomies/attributes/meta/hidden meta. Use this option primarily when your input file was exported using the same plugin.
  • From pre-saved template: Using a pre-saved template retains the previous filter criteria and other column specifications as per the chosen file and imports data accordingly. You can also edit this file in the process and import accordingly or import straightaway.
  • New import: A new import will take you through the entire process of filtering/column selection/advanced options that may be required for your import. You can also save this file as a template for future use.

Import Source(CSV/XML)

The products can be imported from following file formats:

  • Import from Local
  • Import from URL
  • Import from FTP

Step 3: Map and reorder import columns

Map the standard/meta/attributes/taxonomies and hidden meta columns with your CSV/XML column names.

Columns are mapped automatically only if a matching header name is found in the input file. If not the value is left blank. If your input file header does not have exact names or if you need to edit the existing mapping you can simply click on the respective value fields corresponding to each row. Furthermore you can also assign expressions based on the existing input file columns.

The columns are further grouped into following categories:

  • Default fields
  • Taxonomies
  • Meta(Custom fields)
  • Attributes
  • Hidden meta

Step 4: Advanced Options/Batch Export/Scheduling

Use advanced options from below to decide on the delimiter options, updates to existing products, batch import count or schedule an import. You can also save the template file for future imports.
WooCommerce Product Reviews Import-Step 4

  • Update only:
    • Yes: The store is updated with the data from the input file only for matching/existing records from the file. In case of a conflict with IDs of other existing post types the reviews will not be imported.
    • No: The entire data from the input file is processed for an update or insert as the case maybe.
  • If the reviews exists in the store:
    • Skip: Reviews are matched by their IDs. Retains the order in the store as is and skips the matching order from the input file.
    • Update: Reviews are matched by their IDs. Update order as per data from the input file.
      • Update even if empty values: Updates the order data respectively even if some of the columns in the input file contains empty value.
  • Associate product reviews by SKU:
    • Yes: Link the products reviews being imported with the respective products by their SKU.
    • No: Link the products reviews being imported with the respective products by their product ID. In case of a conflict with IDs of other existing post types the reviews will not be imported.
  • Advanced Options:
    • Import in batches of: The number of records that the server will process for every iteration within the configured timeout interval. If the import fails you can lower this number accordingly and try again. Defaulted to 100 records.

Step 5: Import/Schedule

You can either import the products directly into your store or schedule the import using FTP.

  • Was this article helpful?
  • YesNo