Export WooCommerce Products

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.

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 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. 

• 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.

• Click on Step 4 to proceed further.

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.

• 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 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.

• 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.