Resolved Import some Virtue Mart product via XML

Hello,

Is working your test and xml from where I import, still i don't know why my sample don't working but is not matters.

There is an empty line before line <?xml version="1.0" encoding="UTF-8"?> in your file and so there are errors. Remove that empty line, save the file and run the import.

This time for parent product I made SKU - <sifra_nadartikla>,

I want import the first one A - with the same <sifra_nadartikla>NAD00367</sifra_nadartikla>
and I want skip others then again import the E and skip F

What kind of rule should I apply to achieve this?

You need to use CSVI Skip rule plugin to skip a node on import.

Is working your test and xml from where I import, still i don't know why my sample don't working but is not matters. That's fine so I have one more question hope is the last one

I have few products with the same parent sku so:

<strugarstvo>
<izdelek>
<sifra>A</sifra>
<sifra_nadartikla>NAD00367</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>B</sifra>
<sifra_nadartikla>NAD00367</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>C</sifra>
<sifra_nadartikla>NAD00367</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>D</sifra>
<sifra_nadartikla>NAD00367</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>E</sifra>
<sifra_nadartikla>NAD999999</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>F</sifra>
<sifra_nadartikla>NAD999999</sifra_nadartikla>
</izdelek>
</strugarstvo>


This time for parent product I made SKU - <sifra_nadartikla>,

I want import the first one A - with the same <sifra_nadartikla>NAD00367</sifra_nadartikla>
and I want skip others then again import the E and skip F

What kind of rule should I apply to achieve this?

Thank you.

Hi, yes your test.xml working.

and my test_product.xml dont, how is this possible?

Hello,
Please test with attached XML file and check how it goes. I can see that extra ; added with code on forum text.

I paste withaut :

<slika></slika>

but after submitting article add ;

<slika><;/slika>

actuality i paste without ;

<?xml version="1.0" encoding="UTF-8"?>
<strugarstvo>
<izdelek>
<sifra>018295</sifra>
<ean>3838909005324</ean>
<naziv>KLJUČ OBROČNI ART.180/1 Kromiran, glava polirana.</naziv>
<enota>kos</enota>
<pakiranje>1</pakiranje>
<pro_sifra>600532</pro_sifra>
<mera>27x29 mm</mera>
<skupina>ROČNO ORODJE</skupina>
<cena>10.84</cena>
<zaloga>1</zaloga>
<rabat>41</rabat>
<ppc>18.38</ppc>
<davek>22</davek>
<opis>Artikel: 180/1 material: krom vanadij površinska z aščita: kromiran po EN12540
polirane glave obročni del z LIF profilom v celoti izdelan v skladu s standardom ISO
10104 ( samo metrične dimenzije) kovan, v celoti poboljšan</opis>
<slika><![CDATA[https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg]]>;</slika>
<teza>590</teza>
<bruto_teza>600</bruto_teza>
<proizvajalec>UNIOR</proizvajalec>
</izdelek>
</strugarstvo>

But when i add in code here code add ;

Hi I made test xml file and try to import and don't work.

Thas is all file

<?xml version="1.0" encoding="UTF-8"?>

<strugarstvo>

    <izdelek>

        <sifra>018295</sifra>

        <ean>3838909005324</ean>

        <naziv>KLJUČ OBROČNI ART.180/1 Kromiran, glava polirana.</naziv>

        <enota>kos</enota>

        <pakiranje>1</pakiranje>

        <pro_sifra>600532</pro_sifra>

        <mera>27x29 mm</mera>

        <skupina>ROČNO ORODJE</skupina>

        <cena>10.84</cena>

        <zaloga>1</zaloga>

        <rabat>41</rabat>

        <ppc>18.38</ppc>

        <davek>22</davek>

        <opis>Artikel: 180/1 material: krom vanadij površinska z aščita: kromiran po EN12540

            polirane glave obročni del z LIF profilom v celoti izdelan v skladu s standardom ISO

            10104 ( samo metrične dimenzije) kovan, v celoti poboljšan</opis>

        <slika><![CDATA[https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg]]>;</slika>

        <teza>590</teza>

        <bruto_teza>600</bruto_teza>

        <proizvajalec>UNIOR</proizvajalec>

    </izdelek>

</strugarstvo>

Hello,
Thank you for posting the template XML. I found the problem is with <slika> node in your XML. There is a ; inside closing node which needs to be corrected. Also this node has special character & in its value and that is why XML is not read.

<slika>https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg<;;/slika>

Two ways to solve this
1. Replace & with & using RO CSVI Multi replace rule so slika value becomes

<slika>https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg<;/slika>

2. Second recommended way is to enclose <silka> value with CDATA so the parser ignores everything inside the CDATA section.

<?xml version="1.0" encoding="UTF-8"?>

<strugarstvo>

    <izdelek>

        <sifra>1018295</sifra>

        <ean>3838909005324</ean>

        <naziv>KLJUČ OBROČNI ART.180/1 Kromiran, glava polirana.</naziv>

        <enota>kos</enota>

        <pakiranje>1</pakiranje>

        <pro_sifra>600532</pro_sifra>

        <mera>27x29 mm</mera>

        <skupina>ROČNO ORODJE</skupina>

        <cena>10.84</cena>

        <zaloga>1</zaloga>

        <rabat>41</rabat>

        <ppc>18.38</ppc>

        <davek>22</davek>

        <opis>Artikel: 180/1 material: krom vanadij površinska z aščita: kromiran po EN12540

            polirane glave obročni del z LIF profilom v celoti izdelan v skladu s standardom ISO

            10104 ( samo metrične dimenzije) kovan, v celoti poboljšan</opis>

        <slika><![CDATA[https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg]]>;</slika>

        <teza>590</teza>

        <bruto_teza>600</bruto_teza>

        <proizvajalec>UNIOR</proizvajalec>

    </izdelek>

</strugarstvo>

I attach file

Hello,
Please post template XML file to check.To get the template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select the import template and download the XML file. Post the XML file.

Unfortunately still don't work

I have this structure xml to import

<?xml version="1.0" encoding="UTF-8"?>

<strugarstvo>

    <izdelek>

        <sifra>1018295</sifra>

        <ean>3838909005324</ean>

        <naziv>KLJUČ OBROČNI ART.180/1 Kromiran, glava polirana.</naziv>

        <enota>kos</enota>

        <pakiranje>1</pakiranje>

        <pro_sifra>600532</pro_sifra>

        <mera>27x29 mm</mera>

        <skupina>ROČNO ORODJE</skupina>

        <cena>10.84</cena>

        <zaloga>1</zaloga>

        <rabat>41</rabat>

        <ppc>18.38</ppc>

        <davek>22</davek>

        <opis>Artikel: 180/1 material: krom vanadij površinska z aščita: kromiran po EN12540

            polirane glave obročni del z LIF profilom v celoti izdelan v skladu s standardom ISO

            10104 ( samo metrične dimenzije) kovan, v celoti poboljšan</opis>

        <slika>https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg<;/slika>

        <teza>590</teza>

        <bruto_teza>600</bruto_teza>

        <proizvajalec>UNIOR</proizvajalec>

    </izdelek>

</strugarstvo>

I want import only price and stock so i configure template fields:

Record name: izdelek

Field name: product_sku
Your field: sifra

Field name: product_price
Your field: ppc

Field name: product_in_stock
Your field: zaloga

Unfortunately when I import I get at preview message - Import file contains 0 lines

And there is 0 lines

I finally figure out lol
you was thinking that field like
product_sku = CSVI field

I try to find - CSVI field - not a - product_sku - name in drop down list as is written, uh.

SIr please see video

https://strugarstvo.com/ro-csvi-field.webm

I update the list of available fields

Hello,

I don't have option to select at dropdown the CSVI field

What do you see in the dropdown? Make sure you have updated the list of available fields as well by going to Available Fields and click the Update button.