Requirements

Valid price list formats:

XLS and CSV

The XLS and CSV formats are convenient when generating a price list from a database or spreadsheet editor (for example: Excel, OpenOffice, Google Docs).

Download sample price list in XLS

    Requirements for price lists in XLS and CSV formats

    1. Each line in the file should contain a description of a single product offer.

    2. The first line must contain field names.

    3. The file must be UTF-8 encoded.

    4. Tabs and line breaks cannot be used inside fields.

    5. The file should not contain empty columns.

    6. There is no set order that columns (fields) must follow, but they must be kept in the same order within a single file.

    7. In CSV, the fields are separated by either a comma or semicolon.

    YML

    The YML (Yandex Market Language) standard was developed by Yandex and is based on the XML standard.

      Requirements for YML files

      1. The YML standard does not support nonprintable characters with ASCII codes 0 through 31 (except for characters 9, 10, and 13 — tab, new line, and carriage return).

      2. The " & > < and ' characters need to be replaced with their equivalent codes:

        Character in text

        Code for the YML file

        "
        &
        >
        <
        '
        &quot;
        &amp;
        &gt;
        &lt;
        &apos;
        Note. You can use the characters "&><'in the CDATA block in english-description, description.
      3. Acceptable YML file encodings: UTF-8, windows-1251.

      YML file structure

      <?xml version="1.0" encoding="UTF-8"?>
      <yml_catalog date="2017-02-05 17:22">
        <shop>
          <name>...</name>
          <company>...</company>
          <url>...</url>
          <currencies>
            <currency id="..." rate="..."/>
          </currencies>
          <categories>
            <category type="..." id="...">...</category>
          </categories>
          <offers>
            <offer>...</offer>
          </offers>
        </shop>
      </yml_catalog>
      ElementDescriptionRequired
      xml headerStandard XML header. The header should start from the first line with the null character.Required
      yml_catalogAny XML document can contain only one root element. The YML format uses the <yml_catalog> element as the root element. Thedate attribute of the <yml_catalog> element must match the date and time the YML file was generated on the store side. The date should be in the YYYY-MM-DD hh:mm format.Required
      shop

      Information about the store, and products.

      Required

      name

      The short name of the store, no more than 20 characters. The name cannot contain words that are not related to the store's name (such as “best” or “cheap”), and cannot include a phone number or other such information.

      Required

      company

      Full name of the company that owns the store.

      Required

      url

      URL of the store's home page. No more than 50 characters.

      Optional

      platform

      Content management system (CMS) used for the store.

      Optional

      version

      CMS version.

      Optional

      agency

      Name of the agency that provides technical support to the store and is responsible for the site's functionality.

      Optional

      email

      Contact email of the CMS developers or agency that provides tech support.

      Optional

      currencies

      List of store's exchange rates.

      Required
      categories

      List of store's categories.

      Required
      offers

      The store's products. Description of elements included in offers

      Required

      Example price list in YML

      <?xml version="1.0" encoding="UTF-8"?>
      <yml_catalog date="2018-02-05 17:22">
        <shop>
          <name>BestSeller</name>
          <company>Tne Best inc.</company>
          <url>http://best.seller.com</url>
          <currencies>
            <currency id="RUR" rate="1"/>
            <currency id="USD" rate="60"/>
          </currencies>
          <categories>
            <category type="1" id="1">Beauty & Health</category>
            <category type="1" id="2" parentId="1">Hair Care & Styling</category>
            <category type="1" id="3" parentId="2">Styling Products</category>
            <category type="1" id="4" parentId="3">Braid Maintenance</category>
          </categories>
          <offers>
            <offer id="12346">
              <english-name>INK small blue female bag</english-name>
              <name>Сумочка женская голубая от INK</name>
              <categoryId>1012345</categoryId>
              <price>1490</price>
              <oldprice>1620</oldprice>
              <currencyId>RUR</currencyId>
              <weight>1.2</weight>
              <cargo-type>100</cargo-type>
              <dimensions>50.5/25/75.2</dimensions>
              <picture>http://best.seller.com/img/large_12348.jpg</picture>
              <main-picture>http://best.seller.com/img/large_12443.jpg</main-picture>
              <vendor>INK</vendor>
              <english-description>
              <![CDATA[
                <p>Delicate female bag with a golden shoulder chain</p>
              ]]>
              </english-description>
              <description>Утонченная дамская сумочка с золотым ремешком 
               через плечо</description>
              <hs-code>1234567</hs-code>
              <param unit="Color">blue</param>
              <param unit="Season">summer</param>
              <group-id>1234567</group-id>
              <adult>false</adult>
            </offer>
          </offers>
        </shop>
      </yml_catalog>