i managed to import all fields except the two below:
- product id
- category id
below is the structure of the XML file
<products>
<product id="00003112">
<name>
<![CDATA[ THE TITLE GOES HERE ]]>
</name>
<link>
<![CDATA[
http://www.domainname.com/ombrela-3ch3-alouminiou-ekrou-me-manivela-hm6004_43228/?affid=4&skuId=45099
]]>
</link>
<price_with_vat>26.00</price_with_vat>
<category id="54897">
Home > Products > Outdoor > Equipment
</category>
<image>
<![CDATA[
http://www.domainname.com/uploads/images/65423/ombrela-3ch3-alouminiou-ekrou-me-manivela-hm6004-list.jpg
]]>
</image>
<manufacturer>
<![CDATA[ ]]>
</manufacturer>
<mpn>HM6004</mpn>
<instock>Y</instock>
<availability>In stock</availability>
</product>