Simple Product Import

The simple product importer is located in Products > Settings > General Settings > Import / Export, in the Simple Import section.

Simple Import section with the file field, the Import Now button and the CSV format help with the Download CSV Template button

To import products from a CSV file, click the file field, select the CSV file on your computer and click the Import Now button. The import starts immediately.

The time to complete depends on how many products the CSV contains. While the import is running, do not click any link or refresh the page, or the import will stop.

When the import is done, a message shows the number of products added. All imported products are published right away.

Product Image Import

Product images can be attached to products only if they are already in your media library. Use the full URL of the image uploaded to your website, for example https://example.com/wp-content/uploads/2026/10/lamp.jpg.

If you want the script to automatically import external images to the media library and assign them to products please see the Product CSV extension.

Import CSV template

You can download a template file with the Download CSV Template button. The file contains only the correct CSV headings. The columns must be in this order: Image URL, Name, Price, Categories, Short Description, Long Description. If prices are disabled, there is no Price column.

To assign a product to more than one category, separate the category names with a space, a vertical bar and a space, for example: Lamps | Outdoor. Categories that don’t exist yet are created.

The CSV separator depends on the Decimal Separator setting in the Payment and currency section. If the decimal separator is a comma, use a semicolon as the CSV separator. Otherwise, use a comma. The Simple Import section shows the separator to use.

Simple CSV import errors

If you see the message that the number of fields does not match, check that the file has exactly the expected columns and uses the correct CSV separator. The message lists the columns found in the file and the expected columns.

If failures occur, make sure that the file is UTF-8 encoded.

If any other error occurs, try to limit the number of products in one file. Your server resources may run out quickly if you import a large number of products at once.

Simple import limitations

There are two limitations:

  1. It is recommended to import no more than 100 products at once with simple importer. For some servers it may be even lower.
  2. You can import only Image URL, Name, Price, Categories, Short Description and Long Description

The simple importer always adds new products. It does not update existing ones, so importing the same file twice creates duplicates.
You can improve this with Product CSV extension which will let you import, export and update unlimited number of products at once and all product fields.

Simple CSV can be extended with Product CSV which is not limited by server timeout (the import is Ajax based so you can import as many products as you need in one file without any errors), can import and export all product fields, export rules can be applied, custom separator can be set, external images can be imported and many other useful features.

See also