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 uzs, 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 uzs, 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.

The YML Yandex Market Language and YRL Yandex Realty Language standards are developed by Yandex and are based on the XML standard. Allowed encodings of YML and YRL files: 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"?>
<realty-feed xmlns="http://webmaster.yandex.ru/schemas/feed/realty/2010-06">
<offer internal-id="1245">         
<type>продажа</type>         
<property-type>жилая</property-type>         
<category>квартира</category>   
<deal-status>первичная продажа вторички</deal-status>               
<creation-date>2010-11-13T12:32:45+04:00</creation-date>
<location>             
  <country>Россия</country>             
  <locality-name>Москва</locality-name>             
  <address>Яузская улица, 27</address> 
  <apartment>135</apartment> 
  <metro>
          <name>Китай-город</name>
          <time-on-foot>10</time-on-foot>
          <time-on-transport>5</time-on-transport>
  </metro>       
</location>         
<sales-agent>
<category>agency</category>             
  <phone>+74951234567</phone>
</sales-agent>     
<price>     
  <value>4000000</value>        
  <currency>RUR</currency> 
</price>
<area>     
  <value>56</value>     
  <unit>кв. м</unit> 
</area> 
<rooms>1</rooms>
<rooms-offered>1</rooms-offered>
<floor>12</floor>
<yandex-building-id>12345</yandex-building-id>
<yandex-house-id>54321</yandex-house-id></offer> 
<offer internal-id="3">         
<type>аренда</type>         
<property-type>жилая</property-type>         
<category>комната</category>               
<creation-date>2010-11-13T12:32:45+04:00</creation-date>
<location>             
  <country>Россия</country>             
  <region>Ленинградская область</region>             
  <district>Выборгский район</district>             
  <locality-name>Выборг</locality-name>             
  <address>Cторожевой башни, 2</address>   
  <apartment>16</apartment>       
</location>          
<sales-agent>             
  <phone>+79104565459</phone>             
  <category>владелец</category>         
</sales-agent>
<image>http://yandex.ru/image/1.jpg</image>  
<price>     
  <value>15000</value>        
  <currency>RUR</currency>
  <period>месяц</period> 
</price>
<rent-pledge>да</rent-pledge>
<area>     
  <value>140</value>    
  <unit>кв. м</unit> 
</area>
<room-space>
  <value>15</value>
  <unit>кв. м</unit>
</room-space>
<living-space>
  <value>15</value>
  <unit>кв. м</unit>   
</living-space> 
<rooms>5</rooms>
<rooms-offered>1</rooms-offered>
<floor>12</floor>
</offer>
<offer internal-id="15">         
<type>продажа</type>                  
<category>гараж</category>  
<garage-type>гараж</garage-type>                    
<creation-date>2017-03-22T10:10:05+04:00</creation-date>
<location>             
  <country>Россия</country>
  <region>Московская область</region>             
  <locality-name>Протвино</locality-name>             
</location>          
<sales-agent>
<category>agency</category>             
  <phone>+74952203206</phone>             
</sales-agent>     
<price>     
  <value>600000</value>        
  <currency>RUR</currency> 
</price>
<area>     
  <value>20</value>     
  <unit>кв. м</unit> 
</area>
<building-type>железобетонный</building-type>
<heating-supply>да</heating-supply>
<electricity-supply>да</electricity-supply>
<water-supply>нет</water-supply>
<inspection-pit>нет</inspection-pit>
<cellar>да</cellar>
</offer>
</realty-feed>

<?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>