How to use the Listing Import/Export Feature

Using the 'Listings Import/Export' feature in StoreFeeder will allow you to export all your listings for a single channel for you to review or make changes to in bulk. Your listings are exported in a .XLS format which can be easily viewed with most spreadsheet editing tools.

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

How to Export your Listing 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 first need to select the 'Channel' that you wish to export your listings from. You can only export listings from one channel at a time.

Once you have selected your export channel, you will then need to select the 'Fields To Export'. For more information on what fields are available for which channel, please see this knowledgebase. Checking the 'Standard Fields' option will export all fields for that channel.

When you have selected the fields to export, click the 'Export' button to download the listing information.

Only mapped listings can be exported from StoreFeeder.

How To Import Listing Data To Update your Listings

To update live listings on channel, you will need to use the 'Import (Update Existing)' tab on the left of the page. Here you will first need to select if you want StoreFeeder to automatically 'Update to Channel' when the file is imported and then select the channel you wish to update listings for. Next click the 'Select File...' button and find the spreadsheet you wish to upload.

If the 'Update to Channel' is set to 'NO', then the version of the listing in StoreFeeder will be changed to reflect the imported information, but the version of your listing on channel will not be updated until an automatic update occurs.

If the file is a supported format then you will see a confirmation image like the one shown in the image below.

You will need to have re-saved or made changes to the export file before it can be imported back into StoreFeeder.

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 'Listing ID' or 'Listing 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 drop down box.

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

The first import option you will see is 'Create New Items'. If this option is set to 'On' then any value that is in this field and is not already in StoreFeeder will be created.

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 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.

Once you have mapped the field and selected the options you want to use, click the 'Import' button to begin the listing update 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.