XML IMPORT

[Hartung]

Hi,

 

I need to import an XML product file, what is the best service/ software to use?

 

The xml looks like this:

 

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

<Products version="1.1" issuedate="20150310_0551">

<Product id="1216591">

  <Content lang="NL">

    <Description>XEROX Phaser 8500, 8550 colorstix zwart standard capacity 3 x 1.000 pagina's 3-pack</Description>

    <Brand id="XER">Xerox</Brand>

    <UNSPSC id="44103106">Inkt sticks</UNSPSC>

    <Specifications>

      <Specification id="000008">

        <Description>kleur</Description>

        <Value>zwart</Value>

      </Specification>

      <Specification id="000012">

        <Description>verpakkingseenheid(-eenheden)</Description>

        <Value>3-pack</Value>

      </Specification>

      <Specification id="000013">

        <Description>capaciteit / rendement</Description>

        <Value>standard capacity</Value>

      </Specification>

      <Specification id="000018">

        <Description>inkt producttype</Description>

        <Value>colorstix</Value>

      </Specification>

      <Specification id="000031">

        <Description>Maateenheid</Description>

        <Value>doos 3</Value>

      </Specification>

      <Specification id="000002">

        <Description>nummer</Description>

        <Value>Phaser 8500, 8550</Value>

      </Specification>

      <Specification id="000011">

        <Description>afdrukken per eenheid</Description>

        <Value>3 x 1.000 pagina's</Value>

      </Specification>

    </Specifications>

  </Content>

  <Identifiers>

    <OEM>108R00668</OEM>

    <CustomerID></CustomerID>

    <EANProduct>95205242331</EANProduct>

    <EANMasterCarton>50095205242336</EANMasterCarton>

    <OnetrailPDI></OnetrailPDI>

    <OldAlphaNr>XER108R668</OldAlphaNr>

  </Identifiers>

  <Purchase>

    <Stock>0</Stock>

    <Price>46.66</Price>

    <Levy/>

    <MOQ>1</MOQ>

    <Status> </Status>

    <ReplacedBy> </ReplacedBy>

  </Purchase>

  <Images>

    <Product>https://www.alpha-international.eu/productimages/81726f86-d567-46de-b223-b9cad33db45a.jpg</Product>

    <Brand>https://www.alpha-international.eu/ec/cms2/media/img_2/logos/manufacturer_100x100/lo_83x26_xerox.gif</Brand>

  </Images>

  <Logistics>

    <ProductsPerOuterCarton/>

    <ProductsPerLayer/>

    <ProductsPerPallet>1728</ProductsPerPallet>

    <OuterCartonPerPallet>48</OuterCartonPerPallet>

    <Weights unit="gr">

      <ProductWeight>120.0</ProductWeight>

      <OuterCartonWeight>7280.0</OuterCartonWeight>

    </Weights>

    <Volumes unit="l">

      <ProductVolume>0.6</ProductVolume>

      <OuterCartonVolume>0.6</OuterCartonVolume>

    </Volumes>

    <Measures unit="cm">

      <ProductLength>15.9</ProductLength>

      <ProductWidth>8.5</ProductWidth>

      <ProductHeight>4.2</ProductHeight>

      <OuterCartonLength>52.5</OuterCartonLength>

      <OuterCartonWidth>33.7</OuterCartonWidth>

      <OuterCartonHeight>19.2</OuterCartonHeight>

    </Measures>

  </Logistics>

  <CrossSell></CrossSell>

</Product>

[tiluces]

you can change the .xml to a .csv (using libreoffice or  MS office,  or even a online converter   http://listoffreeware.com/list-of-best-free-online-xml-to-csv-converters/ ,  unless it is a sensible data..)

 

and then using the import tool  in your back office. (http://doc.prestashop.com/display/PS16/CSV+Import+Parameters)  in that link they explain  everthing detailed..

 

i hope this helps you in some way

Edited August 24, 2015 by tiluces (see edit history)

[RogueWaveLimited]

Were you interested in a one-time product import or a daily inventory update (quantity & price)?

 

I've got an inventory update priced at $25/month. Or I can do a product import for around $150.

 

If you are interested I can answer your questions here or by email at the address below.