Sitting Jazz Band Saxophonist

> For the complete documentation index, see [llms.txt](https://help.stockeo.solvenium.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.stockeo.solvenium.com/data-mapping/format/xml.md). # XML XML is a flexible, text-based format used for structuring and storing data, commonly used in web services and data exchange between systems.

## Product Element The key information required by Stockeo is the node name that contains the data for a single product. ```html 0260 Sitting Jazz Band Saxophonist 13.73 32.95 181 5050140026007 A sitting jazz man, playing the saxophone. https://www.hill-interiors.com/images/giant/0260.jpg 0261 Sitting Jazz Band Trumpeter 13.73 32.95 162 5050140026106 Bring timeless musical elegance to any setting with the Sitting Jazz Band Trumpeter. https://www.hill-interiors.com/images/giant/0261.jpg ``` In such a case above enter `Product` in the Product Element field.

Fields associated with the product are relative to the node used as Product Element: * Title * Description * Image URL * Product Type * Tag * Vendor * Product Metafield ## Variant Element Fill in this field only when variants are nested in the product node. {% hint style="info" %} If variants are in separate nodes at the product level and have a node with the same value for all variants of a specific product like product name, parent SKU, or parent ID, leave this field empty. For more information navigate to [Variants](/data-mapping/variants.md). {% endhint %} ```xml 0260 Sitting Jazz Band Saxophonist A sitting jazz man, playing the saxophone. https://www.hill-interiors.com/images/giant/0260.jpg 0260S 13.73 32.95 181 5050140026007 0260M 20.59 32.95 56 5050140026008 0260L 30.89 32.95 74 5050140026009 ``` In such a case above enter `Variants/Variant` in the Variant Element field.

Fields associated with the variant are relative to the node used as Variant Element: * SKU * Barcode * Compare at price * Continue selling when out of stock * Charge tax * Cost per item * Market Price * Price * Quantity * Weight * Variant Metafield * Option An example feed mapping, where variant nodes are embedded within product nodes, may look as follows:

Data Mapping section with Variant Element

## Basic Data Mapping In most XML feeds the data you need is stored as text inside nodes, and mapping it is straightforward - just enter the node name or the path to a nested node. The examples below use the following XML feed: ```xml WC-1001 Wooden Clock With Nickel Details Clocks 29.99 443 https://example.com/images/wc-1001-front.jpg https://example.com/images/wc-1001-side.jpg ``` In this example the Product Element is `Product`. ### Node name To get the text content of a child node, enter the node name. For example, to get the product title: ``` Title ``` ### Path to a nested node Use a **slash** (`/`) to navigate deeper. For example, to reach the first image inside `Images > Image`: ``` Images/Image ``` ### Pick a specific item from a list with \[index] When a node appears multiple times (like several `` nodes), you can pick a specific one by its position. The numbering starts at 1. For example, to get the **second** image: ``` Images/Image[2] ``` ### Read an attribute with @ Some feeds store data in XML attributes rather than as text content. To read an attribute, type the **@** sign followed by the **attribute name**. For an attribute on the product node itself (e.g. if ``): ``` @id ``` For an attribute on a nested node, combine the path with `@`. For example, to get the `currency` attribute from the `` node: ``` Price/@currency ``` You can also combine a path, an index, and an attribute. For example, if images were stored as ``, you would get the URL of the second image like this: ``` Images/Image[2]/@url ``` {% hint style="info" %} XML namespaces (prefixes like `xml:`, `iaiext:`, etc.) are automatically stripped by Stockeo. When referencing attributes, use the name without the prefix. For example, `xml:lang` becomes just `lang`. {% endhint %} ### Reading data from Variant Element attributes and values In some cases, values need to be retrieved directly from a variant element's attribute or its node value. ```xml 15 20 12 8 5 2 ``` To read an attribute from a variant element, use a Liquid formula with the `_attributes` object and specify the attribute name. ``` {{ _attributes.sku }} ``` To read the value of the variant element node itself, use `value` in the mapping field or in Liquid. ``` {{ value }} ``` A sample mapping for this type of XML is shown below:

Data mapping configuration showing how to read values from Variant Element attributes and element values — Data mapping example using Variant Element attributes and values

## Advanced Data Mapping with Liquid For anything beyond the expressions above — such as picking a node by the value of its attribute — use a Liquid template. {% hint style="warning" %} Selecting a node by attribute value (e.g. "get the name where language is English") is **not** supported with simple expressions. Use Liquid instead as shown below. {% endhint %} Consider the following XML where the product title is available in multiple languages: ```xml ``` ### Select a node by attribute value To extract the product title from the `` node where the language is `eng`, use the `where` filter: {% tabs %} {% tab title="Stockeo setting" %}

Select node with a specific attribute in the Stockeo automation

{% endtab %} {% tab title="Copy this setting" %} ``` {{ names.name | where: "_attributes.lang", "eng" | map: "value" | first }} ``` {% endtab %} {% endtabs %} ### Select an image by attribute value To pull the URL of the image with `priority="1"`: {% tabs %} {% tab title="Copy this setting" %} ``` {{ images.large.image | where: "_attributes.priority", "1" | map: "_attributes" | map: "url" | first }} ``` {% endtab %} {% endtabs %} And for the second image (`priority="2"`): {% tabs %} {% tab title="Copy this setting" %} ``` {{ images.large.image | where: "_attributes.priority", "2" | map: "_attributes" | map: "url" | first }} ``` {% endtab %} {% endtabs %}