Dear programmer,
I recently build a webshop in magento with the help of a designer of freelancer. The webshop is looking nice, unfortunattely the product import did not go perfect. The designer didn't have an import extension/module. He tried to import the products from xml file by manually writing a csv file. The result is that products are placed in false main groups and subgroups. This is because the maingroups contain many subgroups that other groups also have.
The webshop sells animal products.
There are 6 maingroups:
Dogs
Cats
Rodents
Birds
Fish
Reptiles
Horses
And a lot of the maingroups have the same subgroups, like: food, cages etc..
My project for you is to put the right products in the right groups.
Here you see an example of the XML product file:
<Product>
<ARINTNUM>5</ARINTNUM>
<EAN>3065896440009</EAN>
<BASIS_OMS><![CDATA[PEDIGREE BLIK ADULT HART]]></BASIS_OMS>
<SUB_OMS><![CDATA[820 GR]]></SUB_OMS>
<VLGNR>01</VLGNR>
<GEWICHT>115</GEWICHT>
<VOORRAAD_GRH_EENHEID>11</VOORRAAD_GRH_EENHEID>
<MIN_VRD>7</MIN_VRD>
<VOORRAAD_CNS_EENHEID>132</VOORRAAD_CNS_EENHEID>
<MAG_LOK>E14b</MAG_LOK>
<HOOFDGROEPNUMMER>37</HOOFDGROEPNUMMER>
<HOOFDGROEP>HOND</HOOFDGROEP>
<SUBGROEP>NATVOER</SUBGROEP>
<MERK>PEDIGREE</MERK>
<EENHEID>12</EENHEID>
<ADVIESPRIJS_EXC_STUK>1.86</ADVIESPRIJS_EXC_STUK>
<ADVIESPRIJS_INC_STUK>2.21</ADVIESPRIJS_INC_STUK>
<UWPRIJS_EXC>17.679</UWPRIJS_EXC>
<UWPRIJS_INC>21.038</UWPRIJS_INC>
<ARTIKEL_CONTENT_HTML><![CDATA[Pedigree Adult Pate met Hart is een gezonde en complete maaltijd, bereid met goede, natuurlijke en smakelijke ingrediënten en vers vlees. Zo geeft u uw hond een kwalitatief hoogwaardige voeding die heerlijk smaakt, elke dag weer.
<p>Verreikt met vitamine B en ijzer voor het behoud van zijn vitaliteit, vitamine E om het natuurlijke afweersysteem te ondersteunen, calcium voor gezonde tanden en natuurlijke vezels voor een goede spijsvertering. </p>
<p><strong>Ingrediënten:<br></strong>Vlees en dierlijke bijproducten (min. 53%, waarvan min. 4% hart, min. 4% vers vlees), granen, mineralen, oliën en vetten, plantaardige bijproducten (min. 0.5% gedroogde suikerbietenpulp). </p>
<p>Op kamertemperatuur opdienen. Na opening twee dagen houdbaar in de koelkast. </p>
]]></ARTIKEL_CONTENT_HTML>
<BTW_PERC>19</BTW_PERC>
By the way this is Dutch ;) As you can see the product info shows where the product has to show up hoofdgroep (maingroup) and subgroep (subgroup) are given.
Requirements:
import products this way that:
- The structure (position) of the products is right.
- Under every subgroup there is a list of manufactures from which you can choose (also available in product data).
- The sale price can be determined by a % of the advice price which is on the xml file.
- I get an updated xml file every month, with price and product changes, I like to be able to update this myself, of course as easy as possible.
I am looking for a programmer that is experienced and has done this many times. There are 9000 products, i have to be sure this goes well. By the way the webshop is on [login to view URL]
Succes!
Kind regards,
Sander Hofmans
P.s. the xml file and product pictures are already on the host server, so no uploading needed.
(This already took a long time! :-()
We are ready to start working on the project. Please check PMB for our portfolio. That would be pleasure if we can get a chance to work with you. Thanks. AHT!
Hi, I'm Magento guru, just check my reviews about magento works, i've check your requirement, i have finish this kind of project before, please check my PMB for further details