Witam.
Mam taki oto problem. Posiadam plik XML (szablon) produktów, który chciałbym uzupełnić kolejnymi wartościami przygotowanymi w Excelu. Czyli mam przygotowane dane np parametr <name> kilkadziesiąt pozycji wklejam je podobnie jak to ma miejsce w exelu w odpowiednią kolumnę/miejsce itd. Potrzebne mi to jest do założenia kart produktów co bardzo usprawniłoby mi pracę.
Poniżej przedstawiam kod mojego XMLa.
<?xml version="1.0" encoding="UTF-8" ?>
<products>
<product>
<id>16420074</id>
<active>N</active>
<name><![CDATA[KOSZULA nowa (2)]]></name>
<price_brutto>2499</price_brutto>
<tax>23</tax>
<promotion>N</promotion>
<promotion_price>0</promotion_price>
<new>Y</new>
<external_codes>
<code name="Ean" />
<code name="Ceneo" />
<code name="Bdk" />
<code name="ProducerCode" />
<code name="CatalogId" />
</external_codes>
<producent>BYTOM</producent>
<deliver_code />
<short_description><![CDATA[]]></short_description>
<html_description><![CDATA[]]></html_description>
<params>
</params>
<keywords></keywords>
<measurement>szt.</measurement>
<availability>D</availability>
<shipping_time>3</shipping_time>
<post_dimentions>A</post_dimentions>
<weight>0</weight>
<height>0</height>
<length>0</length>
<width>0</width>
<package />
<package_weight />
<package_height />
<package_length />
<package_width />
<packaging_levels>
</packaging_levels>
<categories>
<category>Koszule</category>
</categories>
<photos>
</photos>
<variants_edit>
<variant_edit>
<variant_id>20268245</variant_id>
<properties>
<property name="Koszule">38 176/182</property>
</properties>
<variant_active>Y</variant_active>
<variant_quantity>1</variant_quantity>
</variant_edit>
</variants_edit>
</product>
<id>16418213</id>
<active>N</active>
<name><![CDATA[KOSZULA B]]></name>
<price_brutto>2499</price_brutto>
<tax>23</tax>
<promotion>N</promotion>
<promotion_price>0</promotion_price>
<new>Y</new>
<external_codes>
<code name="Ean" />
<code name="Ceneo" />
<code name="Bdk" />
<code name="ProducerCode" />
<code name="CatalogId" />
</external_codes>
<producent>FIRMA</producent>
<deliver_code />
<short_description><![CDATA[]]></short_description>
<html_description><![CDATA[]]></html_description>
<params>
</params>
<keywords></keywords>
<measurement>szt.</measurement>
<availability>D</availability>
<shipping_time>3</shipping_time>
<post_dimentions>A</post_dimentions>
<weight>0</weight>
<height>0</height>
<length>0</length>
<width>0</width>
<package />
<package_weight />
<package_height />
<package_length />
<package_width />
<packaging_levels>
</packaging_levels>
<categories>
<category>Koszule</category>
</categories>
<photos>
</photos>
<variants_edit>
<variant_edit>
<variant_id>20266260</variant_id>
<properties>
<property name="Koszule">38 176/182</property>
</properties>
<variant_active>Y</variant_active>
<variant_quantity>1</variant_quantity>
</variant_edit>
</variants_edit>
</product>
</products>