How to merge additional data to your product feed

In this article, we will outline the process of merging additional data to your feed using our merge feature.

Merging feature allows you to add more data from external sources to your existing product feed. Let's take an example:

You are missing EAN/GTIN numbers in your product data feed, but you have this information available on a Google Spreadsheet, XML/CSV file, FTP folder, etc. You can add that information to your feed with our merging feature. To do that, you have to make sure that you have a unique key that you will use to merge the file.

unique key is an attribute that is unique both in your imported data and in the file you are merging. Usually, that would be the unique id of your product.

Once you make sure that you have a unique key in both files, you can proceed with merging the file.

Let's take a case and go through the process step by step. Let's say you are missing EAN/GTIN numbers in your product feed, but you have them available in a Google Spreadsheet. 

First step:  we will make sure we have the unique key in place. In our case, we will have the product id as a unique key. 

Second step: we publish as a CSV the Google Spreadsheet. Please refer to this article to learn how to publish a Google Spreadsheet as a CSV .

Third step: we merge the data from the Google Spreadsheet to our existing product data feed. 

Fourth step: remember to re-import the feed for the merge to be completed.

Here is how it works in practice:

You can merge missing product data multiple times, from various sources. For example, you can merge data from an XML, followed by more data from a Google Spreadsheet, FTP folder, etc.