Export WooCommerce Products using Import Export Suite for WooCommerce plugin

Import Export Suite for WooCommerce Plugin helps you to export a CSV/XML file that includes all the WooCommerce product’s data and import the same to the website much quickly. To export the WooCommerce products:

• Select the post type as Product.
• Select an export method.
• Filter data.
• Map and reorder export columns.
• Use advanced options/ batch export and scheduling.

To export WooCommerce products, click on WebToffee Import/Export(Pro) > Export.

As a first step, you need to choose the post type as Product.

Choose from the below options to continue with your export:

•  Quick export from DB
•  Based on a pre-saved template 
•  Advanced export

Let us have a look at each of these export methods:

Quick Export

• exports the basic/standard fields of the respective post type.  
• To include fields from Taxonomies, Meta(custom fields), Attributes and Hidden meta select the respective group’s checkboxes.
•  Click the Export button to complete the action or proceed to Step3 for advanced options.
• Navigate to Step 5 to know more about Advanced options/ Batch export/ Scheduling.

Pre-saved template

• exports data as per the specifications(filters, selective column, mapping.. etc) from the previously saved file.
• By selecting this option, one can choose a previously saved template from the Export template drop-down.

•  Click the Export button to complete the action or proceed to Step3 to filter data.
• Navigate to Step 3 to know more about filtering options.

Advanced Export

•  This option will take you through a detailed process of filtering/column selection/advanced options that may be required for your export. 

• Click on Step 3, to view the following window where one can filter data on the basis of:

1. Element – The data attribute you want to apply the filter on.
2. Condition – The rule that determines how the value is matched.
3. Value – The criteria used to include or exclude data from the export.

You may add multiple filter rules or remove existing ones as needed.

• Click on Step 4 to proceed further.

The column names appearing in this section can be edited if required. The preferred names and choices that were last saved can be viewed on choosing a pre-saved template. One can also move the columns to reorder the arrangement.

• Here, one can map and reorder the export columns under the following 5 fields:
  1. Default fields
  2. Taxonomies
  3. Meta(Custom fields)
  4. Attributes
  5. Hidden meta

• Click on Step 5 to proceed.

• On reaching Step 5, the following window will appear, from where one can:
  1. Export children SKU of grouped products: Exports children of grouped products by their SKU. Default is Product ID.
  2. Export file name: Filename for the exported file.
  3. Export File Format: Supports both CSV and XML.
  4. Delimiter: Separator for differentiating the columns in the CSV file. Assumes ‘,’ by default.
  5. Enable FTP export: On opting ‘Yes’, choose an FTP profile and specify the export path.

• On expanding Advanced options, one can:
  1. Convert shortcodes to HTML
  2. Export in batches of
  3. Export images as .zip file
• Save the template file for future export (if needed).

• Click on Export to finish and export or schedule the export to finish.