Import your data with an XML Feed

The root node specifies the starting point for the import. When you first import an XML file, the Productsup parser scans the file and defines a root node automatically. This root node appears in Root Node Suggestions. If the parser detects the wrong root node, you must specify one manually.

If you must enter a root node manually, review the following cases and update Data Sources according to the case relevant to your XML file.

Insert the node containing all of your products, for instance, products, items, entries, so that the parser can identify them. In this case, it is not necessary to know the name of individual product tags. You only need to specify the group.

For this example, you would enter products in the root node field to import everything in the group. Each entry under <item> imports as a new row.

If your group, <products> in this example, contains irrelevant tags for your import, it is not sufficient to enter its node in the field.

Enter the name of the exact node containing your single items and add an exclamation mark after the term. In this example, the XML parser only imports your products and ignores everything else in the group tag.

Example: In this case, <name> is irrelevant, so enter item! in the root node to import these products only.

In this example, your XML contains information such as price and title that requires assigning to each variant. Therefore, you must add the entire node to the variant in the root node input field.

Example: In this example, you need to enter feed>product_list>productsin the root node field because the "products" tag contains information on all of your variants. The attributes that each variant should inherit are inside "product_list."

On import, the feed has the following structure:

Nodes with a value inside the tag name are "tag attributes", here: <products lang="en">. They import with an @-sign.

Note that if your XML file has inheritance logic and a non-standard case, you can add the exclamation mark inside the full path.

If you want to import only certain products from a feed, you can include tag attributes, sequences , or a combination of both in your root node input.

Example: tag attributes - If you want to import only Spanish products, enter products lang=esp in the root node field.

Example: sequences - If you want to import only products originating from the US, enter products #2 in the root node field.

Example: tag attributes and sequences: If you want to import only products in English from the US feed. Enter products lang=en #2 in the root node field and the parser searches for the second occurrence of "products" second for the attribute "lang=en."

After defining the root note, you must next define the depths of nodes for the parser. The parser ignores anything beyond the maximum depth.

Defining the maximum depth reduces import time significantly as the parser can move through your feed more quickly.

Note that you count XML levels from 0 as the first digit, which corresponds to the <feed> tag in this example:

Multiple nodes in the XML file are output as separate columns by default. However, you can bundle repeating nodes/attributes as one column.

Enter a delimiter to separate repeating attributes in the undle delimiter. A semicolon is the default delimiter.

Example: This XML file specifies multiple color variations per size. By default, the parser would output this file in the platform in this format:

However, if you enter 3 into Bundle repeating nodes and set comma as a delimiter, the XML file outputs in this format: