A
A
Alex Ozerov2020-03-15 17:42:06
XML
Alex Ozerov, 2020-03-15 17:42:06

Am I converting the xlsx file correctly?

Hello. I make a price list in excel for uploading to rozetka.com.ua. Then I convert the xlsx file with an online converter to xml.
5e6e40297bb13664268065.png
BUT, after converting the xml file becomes like this:

<table:table-cell office:value-type="string" calcext:value-type="string">
      <text:p>Вид</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string" calcext:value-type="string">
      <text:p>Куртки для мальчиков</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string" calcext:value-type="string">
      <text:p>Рост</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce5" office:value-type="float" office:value="110120128" calcext:value-type="float">
      <text:p>110,120,128</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string" calcext:value-type="string">
      <text:p>Сезон</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string" calcext:value-type="string">
      <text:p>Зимний</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string" calcext:value-type="string">
      <text:p>Цвет</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string" calcext:value-type="string">
      <text:p>Черный</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="string" calcext:value-type="string">

This is a piece of code, I mean that categories do not go in category tags.
And the store itself gives another code example:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE yml_catalog SYSTEM "shops.dtd">
<yml_catalog date="2011-07-20 14:58">
<shop>
<name>ABC</name>
<company>ABC inc.</company>
<url>http://www.abc.ua/</url>
<currencies>
<currency id="UAH" rate="1"/>
</currencies>
<categories>
<category id="2">Женская одежда</category>
<category id="261" parentId="2">Платья</category>
<category id="3">Мужская одежда</category>
<category id="391" parentId="3">Куртки</category>
</categories>
<offers>
<offer id="19305" available="true">
<url>http://abc.ua/catalog/muzhskaya_odezhda/kurtki/kurtkabx.html</url>
<price>4499</price>
<currencyId>UAH</currencyId>
<categoryId>391</categoryId>
<picture>http://abc.ua/upload/iblock/a53/a5391cddb40be91705.jpg</picture>
<picture>http://abc.ua/upload/iblock/9d0/9d06805d219fb525fc.jpg</picture>
<picture>http://abc.ua/upload/iblock/93d/93de38537e1cc1f8f2.jpg</picture>
<vendor>Abc clothes</vendor>
<stock_quantity>100</stock_quantity>
<name>Куртка Abc clothes Scoperandom-HH XL Черная (1323280942900)</name>
<description><![CDATA[<p>Одежда<b>Abc clothes</b> способствует развитию функций головного мозга за счет поощрения мелкой моторики.</p><p>В Abc <b>New Collection</b> будет особенно удобно лазать, прыгать, бегать.</p><p>За счет своей универсальноcти и многофункциональности, <b>Abc clothes</b> отлично подходит:</p><ul><li><b>Для весны</b></li><li><b>Для лета</b></li><li><b>Для ранней осени</b> </li></ul><br><p><b>Состав:</b><br>• 92% полиэстер, 8% эластан, нетоксичность подтверждена лабораторно.</p><p><b>Вес:</b> 305 г</p>]]></description>
<param name="Вид">Куртка</param>
<param name="Размер">XL</param>
<param name="Сезон">Весна-Осень</param>
<param name="Категория">Мужская</param>
<param name="Цвет">Черный</param>
<param name="Длина">Средней длины</param>
<param name="Стиль">Повседневный (casual)</param>
<param name="Особенности">Модель с капюшоном</param>
<param name="Состав">92% полиэстер, 8% эластан</param>
<param name="Артикул">58265468</param>
</offer>
</offers>
</shop>
</yml_catalog>
Подробнее: https://rozetka.com.ua/sellerinfo/pricelist/


I'm not strong in xml at all. Tell me how to fill in the excel file correctly, and where to convert it correctly into a free xml file?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question