All Collections
Data Exchange
Exporting Product Data and Updating Existing Products & Listings
Exporting Product Data and Updating Existing Products & Listings

Learn how to export product and listing data and/or import data from a CSV spreadsheet to update existing listings on your marketplaces

Clare Cormican avatar
Written by Clare Cormican
Updated over a week ago

ChannelGrabber has a Data Exchange feature, which allows products and listings to be created and revised in bulk using spreadsheets instead of manually entering and amending information in ChannelGrabber.

This guide primarily focuses on exporting data, and also how to update/amend existing products and listings, after they have been created or imported into ChannelGrabber.

 

Important Note

Variation data cannot currently be exported from ChannelGrabber via the Data Exchange, so any data you export using this guide will only be at the listing/parent product level.  If you want to update stock or prices for items including variations, please see separate guide on Bulk Stock & Price Updates via Data Exchange or a full list of all SKUs including variations can be obtained by clicking on the Download All Products link from the main Products page, however the data contained in the generated file cannot be amended to include any other fields at this time:

 

Exporting Product & Listing Data

The first stage in the process is to select which fields of data you want to export from ChannelGrabber, and choose what you want each field to be named when your data file is generated, so that the file will suit your requirements. 

1.  a)  In ChannelGrabber, hover over the main Products button in the top navigation bar, then select Data Exchange from the sub-menu:

 

b)  Once in the Data Exchange, click on the Listings tab on the right of the grey bar, which will bring you to the Imports page.  Click onto the Exports tab on the left to open the export data mapping section:

 

2.  The two empty fields you will see are for selecting the data fields that you want to export from, and mapping them to the required product headers in your file.  For example, if you want to export the Product Title first, you would click on the left hand drop-down box to view a list of all the fields that can be exported from ChannelGrabber, then you would scroll through and select “Title”.  ChannelGrabber will automatically fill in the right hand field (which will become your data header in your exported file) to match the field name in ChannelGrabber, but if you wish to edit this to something different, you can, simply by clicking into the right hand field and editing/typing what you want the header to be:

Click on the Add Row button to create as many rows are you need, then select all the fields that you want to export.  The order doesn’t particularly matter, but you may find it helpful to use an order which is logical to you, or you can go through alphabetically, it’s up to you.  ChannelGrabber will automatically map out columns for SKU, Listing ID and Channel, so you do not need to map these out when exporting data:

 

The above example shows an export data mapping template for product data only.  It is also possible to export eBay and Amazon data too, however we recommend to export each channel to a separate file, as otherwise the file format can look a bit untidy if product and marketplace data is exported together, as you can end up with multiple rows for each SKU like this:

 

Important Note

If you are exporting eBay or Amazon data with the intention of amending existing listings from your data file, you will need to ensure that you export the following fields (as well as your other required data) and include them when you re-upload your amended data so that ChannelGrabber knows you are amending existing listings and not trying to create new ones.  If you do not include these fields, you may end up with new/duplicate listings instead of amending existing listings successfully:

 

eBay

Listing ID (exported automatically: no mapping required)

Channel (exported automatically: no mapping required)

eBay Account ID

eBay Nationality

 

Amazon

Listing ID (exported automatically: no mapping required)

Channel (exported automatically: no mapping required)

Amazon Account ID

 

3.  Once you have set up all the data mapping as required, you can save this as a template to avoid having to repeat this mapping process in future.  On the right side of the page, click the Template button, then name and save your template.  In future, you will be able to click on the Load drop-down menu to load the template you just saved:

 

4.  Once you have completed your data mapping and saved your template, you are ready to let ChannelGrabber process your data file.  Click theGenerate button and ChannelGrabber will start processing your data.  Once the data is ready, a Download button will automatically appear to the right of your template: simply click this to download your data file, which will be generated in CSV format:

 

Importing Data to Amend Existing Products & Listings

Once you have completed the product/listing data that you want to amend, you need to save it in CSV (Comma delimited) format – this is crucial, as ChannelGrabber will not be able to process any files that are not in CSV format. Please avoid the use of full stops in the filename as this will cause errors and stop the file from importing:

 

1.  You can now import the data into ChannelGrabber to amend the products/listings.  In ChannelGrabber, hover over the main Products button in the top navigation bar, then select Data Exchange from the sub-menu:

 

Once in the Data Exchange, click on the Listings tab on the right which will bring you to the Imports page:

 

2.  Click on Choose File to browse your computer for the CSV file you just saved, then click the Upload button to bring it into ChannelGrabber:

 

3.  Once your file is uploaded, additional fields will appear, which are for import data mapping.  The left hand drop-down menu shows all the column headers from your file and the right hand drop-down menu allows you to map your file header to the corresponding field in ChannelGrabber (the reverse of the export mapping).  This is how ChannelGrabber knows which fields to populate from your data.  If you have previously created the mapping for exporting your product data, you can click on the Load drop-down menu to select your export template, and it will apply the reverse mapping for the purpose of the import.  As with the export, you do not need to map in the SKU, Listing ID or Channel - as long as these are present in your file, ChannelGrabber will automatically map them in:

 

If you did not previously set up/save a data mapping template, click on the Add Row button to create as many rows are you need, then map all the headers in your file to the corresponding fields in ChannelGrabber.  The order doesn’t particularly matter, but you may find it helpful to use the same order as in your file, or you can go through alphabetically, it’s up to you.

 

4.  Once you have set up all the import data mapping, if you have not previously saved a template, or have added/changed any of the mapping for the purpose of the import, then you can save this as a new template to avoid having to repeat this process in future.  On the right side of the page, click theTemplate button, then name and save your template.  In future, you will be able to click on the Load drop-down menu to load the template you just saved:

 

5.  Once you have completed your data mapping and saved your template, you are ready to let ChannelGrabber process your data file.  Click theGenerate button and ChannelGrabber will start processing your data.  A progress box will appear at the top of the page to show you the total number of rows to be processed and will show how many successful rows have been processed as it goes along:

 

You do not have to remain on this page while your data is being processed, it will simply carry on in the background, so you can continue to use ChannelGrabber as normal or close the browser in the meantime.  Once the Data Exchange has finished processing your file, you can return to your main Products page if you want to check your revisions.  

 

6.  If you are amending existing eBay listings and you do see any listing errors, you can click the product name to go into the product, then navigate to the Listings tab and click Edit on the eBay profile to go into the eBay listing, and the error message from eBay will display in a banner at the top of the page.  You can manually make any necessary changes in ChannelGrabber, then click the Submit/Revise button to try and push it through to eBay again.  Once the listing goes through successfully, this will be confirmed in ChannelGrabber and the icon will change from Error to Active:

 

 

We hope this guide is useful, but if you need further guidance please feel free to contact our Support Team.

Did this answer your question?