Ecomly has a built-in product CSV Importer and Exporter.
Import, export, or update hundreds or thousands of products in your Ecomly store with a single CSV. This tool supports most product types, including variations.
- First-time store owners get started more quickly by exporting and importing products during setup.
- Existing store owners can update tens or hundreds of products with new info or place them on sale, or sync multiple storefronts.
Create your CSV
What CSV editors do you recommend?
We recommend using:
If possible, avoid Microsoft Excel due to formatting and character encoding issues.
How to create the CSV?
To import new products or update existing products, you need a CSV containing your product information. You can:
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.
- It is not possible to assign a specific post ID to product on import. Products will always use the next available ID, regardless of the ID included in the imported CSV.
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.
How does import work?
Please visit this link to see the step-by-step guide.
Importing Product Variations
Product CSV Import Suite can also import product variations, although it does so with a separate, for-variations CSV. Here is an example to illustrate.