Product CSV Importer and Exporter

 

Create your CSV

To import new products or update existing products, you need a CSV containing your product information. You can:

• Export a CSV of products from an existing store.
• Download a CSV file with sample data from GitHub and replace it.
• Use your own CSV. Any information you wish to include should follow the formatting and columns of the Product CSV Import Schema.

If using the built-in WooCommerce Product CSV Importer and Exporter tool to export a CSV, it already follows the schema and is ready to use. If using the blank and formatted CSV file, it also follows the schema; just be sure to enter the info as instructed at Product CSV Import Schema.

General guidelines

• CSVs should be in UTF-8 format.
• Dates should be defined for the store’s local timezone.
• Use 1 or 0 in your CSV, if importing a Boolean value (true or false)
• Multiple values in a field get separated with commas.
• Wrapping values in quotes allows you to insert a comma.
• Prefix the id with id: if referencing an existing product ID. No prefix is needed if referencing an SKU. For example: id:100, SKU101
• Custom meta is supported/imported but only plain text – no support for JSON or Serialized data.
• Taxonomy term hierarchy is denoted with >, terms are separated with commas.
• Draft products are not exported, only published and privately published products.

Images

• Images need to be pre-uploaded or available online to import to your store.
• External URLs are supported and imported into the Media Library if used.
• You can define the filename if the image already exists in the Media Library.

Import

Adding New Products

First-time and existing store owners using WooCommerce can use the CSV to add new products with one upload.

 

1/ Go to: WooCommerce > Products.

2/ Select Import at the top. The Upload CSV File screen displays.