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.

Saving Export Templates

To save an export structure for using later, you can save the channel and fields as an export template to load later. Select the channel and fields you want to save as a template and click Save Template.

You will then be prompted to give the template a name, whether or not you want this template to be a favourite or public.

How To Import Listing Data To Update Your Listings
 

To update live listings on your 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 file is a supported format then you will see a confirmation image like the one shown in the image below.

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.

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.

Export Unmapped Listings

If you want to see all your unmapped listings or need a spreadsheet of them to edit and import for our Import & Map Unmapped feature, you can export all your unmapped listings using this feature. Just select a channel and hit export to get a spreadsheet of all the unmapped listings on that channel.

This spreadsheet can be used as a reference for mapping listings or imported into the Import & Map Unmapped window.

Import & Map Unmapped

This window will allow you to map unmapped listings to products in bulk by importing data via a spreadsheet (possibly generated by Export Unmapped Listings). Select the spreadsheet to import, the channel whose unmapped listings you're mapping and select what (if any) product information you want to move over from the product to the listing once mapped. You can also select to move data from the listing back to the product if the listing is more up-to-date.

Import History

If you need to check any information on a previous listing import, you can see what channel the import was done on, who imported the data, when they imported it, the number of rows and fields affected and the file name imported.