XML file format in Stock Sync : Stock Sync

For the XML file format:

1. First, choose the Upload File method.

2. Then, set the File Format to XML.

3. For the Parent node and Variant node, refer below for more details.

The XML format can be quite hard for some users to set up.

Here is a step-by-step instruction with an example for the parent node and variant node:

Add the Parent node which is a mandatory field. Let's take the XML feed below as an example.
Based on the feed above, the Parent Node is <item>.
So you need to type in the item in the field. There is no Variant Node present in the example above.
Please input Variant Node if a nested node is present in the XML file.
The field mapping for XML will be straightforward. Based on the example above:
1. SKU = sku
2. Title = title
3. Description = description

You don't have to include the <> in the field mapping or node.

How to add a subnode?

If the XML file contains nodes like the below:

<title>Pants</title>

<description>Long Pants</description>

</product>

./product/title is the right way to write if it is a subnode.

Example 1

<item code="XYZ1001" description="Black Handlebar " instock="yes" wholesaleprice="100" rrp="150"/>

If the node is nested in this way, then you would need to map the variant node as the item

In field mapping, the code should be

@code

@description

@instock

Example 2: Product and variants

<products>
 <product>
  <id>XYZ0001</id>
  <title>Pants</title>
      <brand>
          <id>21</id>
          <title>New Collection</title>
     </brand>
 <variants>
  <variant>
  <id>31950</id>
  <type>S</type>
  <title>Small</title>
  </variant>
 <variant>
<id>31951</id>
<type>M</type>
<title>Medium</title>
</variant>

In this case, the parent node is a product and the variant node is a variant.

The product id or title can be used as the variant group.

To map the variant option, it will be ./title

Example 3

<description>

<long_desc xml:lang="eng"><style> </style> <br><br> <!-- tu zacystosowany do jednorazowej naprawy, przy dÅ‚ugotrwaÅ‚ym uÅ¼ytkowaniu ulega zniszczeniu!</li></long_desc>

<long_desc xml:lang="fre"><style> </style> <br><br> <!-- tu z Å›rubokrÄ™t pentalobe do Apple iPhone 4</p> </long_desc>

<long_desc xml:lang="ita"><style> </style> <br><br> <!-- tu zaczyna sie naglowek w kolorze niebieskim <br><br><li>Åšrubiu!</li></long_desc>

<long_desc xml:lang="pol">Serwisowy Å›rubokrÄ™t Pentalobe do telefonu iPhone

</long_desc>
</description>
<price gross="0.11" net="0.09"/>
<srp gross="0" net="0"/>
<sizes>
<size code_producer="000000221006" code="169-uniw" weight="14">
<stock xmlns:iaiext="http://www.iai-shop.com/developers/iof/extensions.phtml" id="1" quantity="848" iaiext:location_id="545" iaiext:location_text_id="03-047-B"/>
<price gross="0.11" net="0.09"/>
<srp gross="0" net="0"/>
</size>
</sizes>

To map with the long_desc xml:lang="eng", you should map as this long_desc[@xml:lang=“eng”]
To map with the price gross, you should map as this .//*[name()= 'price']/@gross or price/@gross
To map with the price net, you should map as this .//*[name()= 'price']/@net or price/@net
To map with the weight, you should map as this @weight

Example 4

<products>
<product>
<id>XYZ0001</id>
    <title>Pants</title>
             <Category>New Collection</Category>
</product>

To map with the id, you should map as the id
To map with the title, you should map as the title
For select Category, you can map as Category

Example 5

<ProductTitle>Kомплект в две части</ProductTitle>
<ProductType>Комплект</ProductType>
<Size>4XL</Size>
<Size>3XL</Size>
<Size>2XL</Size>
<Size>XL</Size>
<Size>L</Size>
<Size>M</Size>
<Size>S</Size>
<Sku>KL600/2</Sku>

When you want to map the size with the variant group, you can map it like this "Size" in the Variant group field. For example, for Variant option 1, you can map it with a dot which is this "."

Example 6

<childproduct>
<product_ code>ABCD01</product_ref>
<product name>Lipstick Pink</product name>
<stock level>10</stock level>
<option 1>Matte</option 1>
<option_2>Shinny</option 2>
<picture>https://uk.kordabusiness.com/img/product_pictures/originals/32101611155422.jpg</pictures
</child product>

<childproduct>
<product_code>ABCD03</product_ref>
<product_name>Lipstick Blue</product_name>
<stock level>230</stock level>
<option_1>Mattee</option 1>
<option 2>Shinny</option 2>
<picture>https://uk.kordabusiness.com/img/product_pictures/originals/18671611155419.jpg</picture>
</child product>

According to the above XML file, if you want to map the image of each variant, you can map it as this "./picture" in the image field. So, it will take a different image for each variant.

XML file format Print

Related Articles