Knowledgebase: Product Data
How to use the Product Import/Export Feature
Posted by Jack Liptrott on 10 Aug 2015 09:56

Last Modified by Adam Roberts on 27 Jan 2017 16:05

Using the 'Product Import/Export' feature in StoreFeeder will allow you to export your entire product catalogue for you to make changes to or review and make changes to or create new products in bulk. Your products are exported in a .xls format which can be easily viewed with most spreadsheet editing tools.

The 'Product Import/Export' page can be found in the products menu (Products>Product Import/Export).

How to Export your product information

You may first want to export your product data from StoreFeeder. The export function is found in the 'Export' tab on the left side of the page. You will see a dropdown menu containing all the fields relavant to your products, including any 'Custom Attributes' and 'Variation Attributes' you may have. To select a field to export simply check the box next to the field name you wish to review. Checking 'Standard Fields' will export all product information, not including any Custom or Variation attributes. When you have selected the fields to export, click the 'Export' button to download the product information.

You also have the option to download a 'Blank Product Template'. This will export a blank product spreadsheet containing the headers for the fields you have selected for export.

 

How To Import Product Data To Create New Products

To create new products in StoreFeeder, you will need to use the 'Import (Create/New)' tab on the left of the page. Here you will first need to click the 'Select File...' button and find the spreadsheet you wish to upload.

Supported file types are .xlsx, .xls and .csv.

 

Once the file has been uploaded, you will need to map the spreadsheet fields to the matching field in StoreFeeder. If the field name in the spreadsheet matches the field name in StoreFeeder exactly, it will be automatically mapped for you. To select a StoreFeeder field to map to, select it from the corresponding dropdown box.

Some fields will show the Yes/No option to 'Create New Items' next to them before you import the file. If this option is set to 'On' then any value that is in this field and is not already in StoreFeeder will be created. An example of where this would be used would be if you were adding Brands to products, but the brands you were adding were not currently in the system.

Once you have mapped the field and selected the options you want to use, click the 'Import' button to begin the file import process.

You will receive a message when the file has finished importing. It will inform you if the import was successful or if there were any errors during the process. The errors will be displayed in the same order as they were imported and show the line the error was on as well as what the error was.

 

How To Import Product Data To Update Existing Products

To update existing products in StoreFeeder, you will need to use the 'Import (Update Existing)' tab on the left of the page. Here you will first need to click the 'Select File...' button and find the spreadsheet you wish to upload.

Supported file types are .xlsx, .xls and .csv.

 

Once the file has been uploaded, you will need to first select the 'Key Field' to map against. This needs to be a unique identifier so you need to use either 'Item ID' or 'SKU'. Once this has been selected you will need to map the rest of the fields you are updating. If the field name in the spreadsheet matches the field name in StoreFeeder exactly, it will be automatically mapped for you. To select a StoreFeeder field to map to, select it from the corresponding dropdown box.

You cannot update the field you are using as the 'Key Field' when updating against it.

You will see that there is an option to 'Skip Blank Fields'. If this option is set to 'Yes' then any blank fields in your import file will be skipped over and the current value on that product for that field will be left unchanged. If the option is set to 'No', then the current value on the product for that field will be overwritten with an empty value.

 You may also see the option to 'Append New Records'. If set to 'Yes', this setting will add the new value in the this field to the end of the existing one in StoreFeeder. If set to 'No', then the existing value will be overwritten by the value in the file being imported. For example, if you are importing a category that the product is not currently in with Append New Records set to 'Yes', then the new category will be added to the product, but the old one will remain, leaving the product with two categories.

When you have finished the mapping process, click the 'Import' button to begin processing the file.

You will receive a message when the file has finished importing. It will inform you if the import was successful or if there were any errors during the process. The errors will be displayed in the same order as they were imported and show the line the error was on as well as what the error was.

 

For a full list of fields available to export please see the Available Product Import/Export Fields knowledgebase.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: