Use custom data source matching to join a supplemental data source to your primary data source using an attribute other than the ID [id] attribute. For example, if you'd like to add additional attributes based on your products' brand or product type rather than based on their ID, you may use a custom matching supplemental data source.
[id] attribute using the ID rule setting.This article explains how to use a custom matching data source.
On this page
How it works
When creating a supplemental data source, you'll change your selection to indicate that you'd like to join your data sources using an attribute other than ID. For example:
Primary data source:
ID [id] |
Title [title] |
Price [price] |
Brand [brand] |
|---|---|---|---|
| 1 | shirt | 34 GBP | Brand A |
| 2 | shoes | 55 GBP | Brand B |
| 3 | hiking boots | 100 GBP | Brand C |
| 4 | trousers | 75 GBP | Brand A |
Supplemental data source that uses the brand [brand] attribute rather than the ID [id] attribute to match to the primary data source:
Brand[brand] |
Custom label 0–4[custom_label_0-4] |
|---|---|
| Brand A | SALE |
Resulting data source:
ID[id] |
Title[title] |
Price[price] |
Brand[brand] |
Custom label 0–4[custom_label_0-4] |
|---|---|---|---|---|
| 1 | shirt | 34 GBP | Brand A | SALE |
| 2 | shoes | 55 GBP | Brand B | |
| 3 | hiking boots | 100 GBP | Brand C | |
| 4 | trousers | 75 GBP | Brand A | SALE |
Note: There's a limit of 30,000 rows for the supplemental data sources that you'd like to join to your primary data source.
Instructions
To create a supplemental data source:
- In your Merchant Center account, click on the Settings
in the left navigation menu.
- Select Data sources.
- Under the Product sources tab, select the Supplemental sources tab.
- Select Add supplemental product data to create a new supplemental data source.
- Choose how to set up your data source and connect your data to Merchant Center. You can choose one of the following:
- Add product data from a file
- Use Google Sheets
- Add product data using API
- Provide the necessary data and click Continue.
- Follow the flow and select the primary data source to which you'd like to join your new supplemental data source.
- Select Create data source.
Then, you'll need to set up rules for your new supplemental data source. Learn more about setting up attribute rules.