Import ads BETA

To import ads using an Excel spreadsheet, you must:

1. Download Xls file template on our portal.
2. Fill it and save.

First row of the table (the header) must contain the field names (cannot be deleted), all other rows of the field values for each imported item.
Second line in the XLS file template is shown as an example of filling, the line must be removed.

Field name	Description
id	Unique identifier (id) of the ads on the website Flagma is an integer. If you already have an ad with that id, it is updated, otherwise it will be added a new ad.
Type	Ad type - "Sell" or "Buy". If this field is empty, then the type is automatically defined as a "Sell".
Name *	Ad name. Please do not enter any contact information in this field. Mandatory field.
Description *	Describe one product or service. Please do not enter any contact information in this field. Mandatory field.
Final subcategory *	Final subcategory of the product or service. For the convenience of filling this field, you can download a list of all categories of the portal. Mandatory field
Price	Price of the product or service
Unit of measurement	Unit of measurement of the quantity of goods. Possible units: pc, t, kg, g, km, m, cm, ha, are, sq m, cu m, l, hour, day, week, month, service
Currency	Currency, monetary unit of price. One of byn, rub, usd, eur
Minimum wholesale price	Minimum wholesale price
Maximum wholesale price	Maximum wholesale price
Unit of measure for wholesale	Unit of measurement of the quantity of goods for the wholesale price. Possible units: pc, t, kg, g, km, m, cm, ha, are, sq m, cu m, l, hour, day, week, month, service
Currency for wholesale	Currency, monetary unit of wholesale price. One of byn, rub, usd, eur
Product photos	URL link for the item picture. You can add only one photo.
Inactive	If an ad is not active (not published on the website), enter "Yes."

List of categories of the portal FLAGMA.

To specify in the import file sections of goods / services download the list of sections of the FLAGMA portal.

Standard YML Yandex Market Language is developed by Yandex and is based on the XML standard. Valid encoding YML file: UTF-8.

<?xml version="1.0" encoding="UTF-8"?>
<yml_catalog date="2019-01-29 11:44">
  <shop>
    <name>Sunrise</name>
    <company>Sunrise, LLC</company>
    <url>https://nikopol.flagma.ua/en/1295100/</url>
    <currencies>
      <currency rate="1" id="uah"/>
      <currency rate="0.42" id="rub"/>
      <currency rate="27.79" id="usd"/>
      <currency rate="31.73" id="eur"/>
    </currencies>
    <categories>
      <category id="119">Oil Cheese Fat</category>
    </categories>
    <offers>
      <offer id="4797626" available="true">
        <name>Sunflower oil</name>
        <url>https://nikopol.flagma.ua/en/podsolnechnoe-maslo-o4797626.html</url>
        <price>30.00</price>
        <currencyId>uah</currencyId>
        <categoryId>119</categoryId>
        <photo>http://img01.flagma.ua/photo/podsolnechnoe-maslo-6493860_zoom.jpg</photo>
        <description>High quality sunflower oil.</description>
      </offer>
    </offers>
  </shop>
</yml_catalog>

<?xml version="1.0" encoding="UTF-8"?>
<price>
<name>Internet shop</name>
<currency code="USD" rate="28.00"/>
<catalog>
<category id="1">Мобильные телефоны</category>
<category id="1001" parentID="1">Мобильные телефоны Motorola</category>
</catalog>
<items>
<item id="330">
<name>Motorola A1200</name>
<categoryId>1001</categoryId>
<priceuah>1260</priceuah>
<image>http://url/images/image7402727981188804741.jpg</image>
<description>GSM 900/1800/1900. Тип корпуса: раскладушка. Аккумулятор: 850 мАч.....</description>
</item>
</items>
</price>