Home > Docs > Product Import Export Plugin for WooCommerce > Export WooCommerce Products

Export WooCommerce Products

Last updated on March 21, 2025

Exporting WooCommerce products is essential for backup, migration, bulk editing, and multi-channel selling. It allows store owners to safeguard product data, transfer items to a new website, or update product details efficiently in bulk. Exporting also helps integrate with third-party marketplaces, manage inventory across multiple stores, and maintain a structured product database. Product Import Export Plugin for WooCommerce helps you to export all the WooCommerce product’s data to a CSV/XML/Excel file in a quick and efficient manner. To export WooCommerce products:

  1. Select the post type as Product.
  2. Select an export method.
  3. Filter data.
  4. Map and reorder export columns.
  5. Use advanced options/ batch export and scheduling.

Export Products

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

Select post type - Product export
Select post type – Product export

Step 1: Select a post type

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

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 
  •  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. 
WooCommerce export product - Export methods
WooCommerce export product – Export methods

Step 3: Filter data

  • Click on Step 3, to view the following window where one can filter data on the basis of:
  1. Total number of products to export : The actual number of products you want to export. e.g. Entering 500 with a skip count of 10 will export products from 11th to 510th position.
  2. Skip first n products : Specify the number of products to be skipped from the beginning. e.g. Enter 10 to skip first 10 products from export.
  3. Product types : Filter products by their type. You can export multiple types together.
  4. Products : Export specific products. Key in the product names to export multiple products.
  5. Exclude Products : Use this to exclude a specific or multiple products from your export list.
  6. Product categories : Export products belonging to a particular or from multiple categories. Just select the respective categories.
  7. Product tags : Enter the product tags to export only the respective products that have been tagged accordingly.
  8. Product Status: Filter products by their status, private/draft/pending/future.
  9. Sort Columns: Defaulted to Ascending. Applicable to the above selected columns in the order specified.
  10. Sort By: Sorts are in ascending/descending order.
Export Product - Filter data
Export Product – Filter data
  • Click on Step 4 to proceed further.

Step 4: Map and reorder export columns

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

Map and reorder export column - Export product
Map and reorder export column – Export product
  • 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.

Step 5: Advanced Options/Batch Export/Scheduling

  • 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 CSV, XML, TSV, XLS, and XLSX.
    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.
Batch export/scheduling - Product export
Batch export/scheduling – Product export
  • 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).
 Save-template-option
Save template
  • Click on Export to finish and export or schedule the export to finish.