Combinig few XML files into one

Help Center
1

Hi, is there a possibility to combine few xml’s into one, where data from all the files will be assigned according to the product id.

Exampe:

XML 1 variables:

  • product ID
  • product manufacturer
  • product price

XML 2 variables:

  • product ID
  • product description,
  • product name

I want to create one XML with ale the variables:

  • product ID
  • product manufacturer
  • product price
  • product description,
  • product name
2 Likes
2

Hello @piotr_miara,

yes, it is possible to achieve this with MERGADO. Follow these steps:

  1. Create export in MERGADO with Feed 1. If possible, don’t change the format.
  2. Create second export with Feed 2 and select Plain CSV as output format.
    • this converts data in Feed 2 into a CSV feed
    • make sure the first column contains the IDs - they are used for mapping the products together.
  3. Copy the URL of the output CSV feed to the clipboard.
  4. In Export 1, create new elements on the Elements page
    • name the new elements the same as the columns in the CSV feed you want to import (product description, product name, not ID)
  5. In Export 1, create a new “Data file import” rule, select the Import from URL option (not upload file), and paste the URL of the output CSV feed from Export 2.
  6. Apply rules

Feel free to ask if you need additional help with the above steps.

3 Likes