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.

Libreoffice calc online