How to use the Product Import/Export Feature

Overview

This article explains how to use the Product Import/Export feature in StoreFeeder to export your product catalogue, create new products in bulk, and update existing products.

Watch video

Go to Products > Product Import/Export to access this feature.

Exporting product information

1. Go to the Export tab.
2. Select the fields you want to export by ticking the boxes. Selecting Standard Fields exports all product information, excluding custom and variation attributes.
3. Select Export to download the file.

You can also download a Blank Product Template — a spreadsheet with headers for the fields you have selected, with no data rows.

Creating new products by import

1. Go to the Import (Create/New) tab.
2. Select Select File... and choose your spreadsheet. Supported file types are .xlsx, .xls, and .csv.

1. Map the spreadsheet columns to the matching fields in StoreFeeder. Fields that match exactly are mapped automatically.

1. Some fields show a Create New Items option. When set to On, any value in that field that does not already exist in StoreFeeder is created automatically. This is useful when importing products with brands not yet in the system.

1. Select Import to begin processing.

A message appears when the import is complete, indicating whether it was successful and listing any errors with line numbers.

Updating existing products by import

1. Go to the Import (Update Existing) tab.
2. Select Select File... and choose your spreadsheet. Supported file types are .xlsx, .xls, and .csv.

1. Select the Key Field to match against. This must be a unique identifier — use either Item ID or SKU. You cannot update the field you are using as the key field.
2. Map the remaining fields you want to update.

3. Set Skip Blank Fields:

   • Yes — blank fields in the import file are skipped; existing values are preserved
   • No — blank fields overwrite existing values with an empty value

1. If an Append New Records option appears, set it as needed:

   • Yes — the new value is added alongside the existing value (for example, adding a second category without removing the first)
   • No — the new value replaces the existing value
2. Select Import to begin processing.

A message appears when the import is complete, indicating whether it was successful and listing any errors with line numbers.