mergeCombine multiple imports

If your product data is not all in one place, you can improve or add to your product data in Channable by combining data from different sources.

What you can do with combined imports:

  • Add new products: Add products that are not in your original import feed.

  • Enrich product data: Add information such as EAN numbers to your existing products.

  • Add the same information to all products: Add information to all products in a new field.

Before you start

  • Order of imports: the sequence of imports matters. The first import determines which items are imported. Subsequent imports combine fields where matches are found, but any IDs not present in the first import are ignored.

  • Case sensitivity: When combining on fields, the values must match exactly (case-sensitive). This means if one import has “SKU123” and another has “sku123”, they will not be considered the same value.

  • Field overwriting: Mapping to a field already filled by the first import will overwrite its data.

    • Solution 1: For different titles or prices for marketplaces, use unique field names (e.g., title_amazon, title_ebay).

    • Solution 2: To manage different language translations, rename fields or create new fields for each language to keep the original and allow multiple translations to be imported (e.g., title_en, description_en, title_nl, description_nl).

circle-info

Tip: In Channable, click See visualization at each merge option to see a visual explanation of how your import data will be affected.

1

Combine imports — Start

Go to your project > Setup > Import and click +Combine import.

2

Select data type & start import

Select your import data type, complete the import file information and click Start import.

3

Edit mapping

You will be directed to Edit mapping. The fields in the left column (fields from your feed) will be mapped to fields in Channable. Usually, you don't have to change these fields.

4

Choose merge options

Below the fields list, under Merge options, select one of the available merge options based on the outcome you want for your data. See the table below for descriptions and examples.

5

Save & import

Click Save & Import to complete the process.

Options to combine imports

Merge option
Description
Example

Add as new items

Adds new items from the new import as distinct, separate entries.

If you have products “A” and “B” in the first import and “B” and “D” in the new import, both versions of “B” are added separately, along with “A” and “D”.

Combine on field

Combines items that match a specific field value (e.g., ID to ID). For the merge to work, the field name in both imports must match exactly. When a match is found, values from the new import overwrite those in the existing one, and any new fields are automatically added.

If both imports have product “B” with the same ID, the fields from the second import overwrite those from the first.

Item enrichment

Adds extra information from the new import to all items from the first import without creating new items.

If you import a field called “URL_1” and you have “A”, “B”, “C” from the first import, all three get “URL_1” regardless of whether they initially had it.

Insert or merge

Merges new data from the second import with data from the first, retaining all unique information.

If both imports contain product “B”, the result will include all unique fields from both imports. Product “D” is added as a new item if it's only in the second.

Insert or replace

Replaces fields from the first import with those from the second if items match. Removes extra fields from the first import that aren't in the second.

Product “B” from the first import will be replaced with “B” from the second. Product “D” from the second import will be added as a new item, while “A” and “C” remain unchanged.

Adjust the order of your imports

You can reorder your imports by dragging and dropping them.

Last updated

Was this helpful?