Import ↑ Back to top Adding New Products ↑ Back to topįirst-time and existing store owners using WooCommerce can use the CSV to add new products with one upload.Ĭonverting existing simple product to variable product ↑ Back to top You can define the filename if the image already exists in the Media Library.External URLs are supported and imported into the Media Library if used, provided the images are directly accessible and not behind a redirect script (as happens on some cloud storage services).Images need to be pre-uploaded or available online to import to your store.

Products will always use the next available ID, regardless of the ID included in the imported CSV.

It is not possible to assign a specific post ID to product on import.

Draft products are not exported, only published and privately published products.

Taxonomy term hierarchy is denoted with >, terms are separated with commas.

Custom meta is supported/imported but only plain text – no support for JSON or Serialized data.

No prefix is needed if referencing an SKU.

Prefix the id with id: if referencing an existing product ID.

Wrapping values in quotes allows you to insert a comma.

Multiple values in a field get separated with commas.

Use 1 or 0 in your CSV, if importing a Boolean value (true or false).

Dates should be defined for the store’s local timezone.

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. 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. Any information you wish to include should follow the formatting and columns of the Product CSV Import Schema.

Download a CSV file with sample data from GitHub and replace it.

Export a CSV of products from an existing store.

To import new products or update existing products, you need a CSV containing your product information. If possible, avoid Microsoft Excel due to formatting and character encoding issues.

Online spreadsheet editor Google Drive / Docs.

Create your CSV ↑ Back to top What CSV editors do you recommend? ↑ Back to top Note: If you are using the Product CSV Import Suite paid extension, refer to documentation at: Product CSV Import Suite.

Openoffice spreadsheet