Import categories and products from csv file under existing categories in magento webshop with magmi

[cbroeksema]

In my Magento shop i have some categories like "Baby", "Persoonlijke verzorging", "Wonen" with sub categories like "Slaapkamer", "Woonkamer" etc.

From my manufacturer i have a large csv file with lots of categories and products. The categories names in the csv file of my manufacturer are ok, but i want them to be importerd under the already existing categories in my shop.

The csv file of my manufacturer looks like this: articleNumber title brand description ean weight stock price recommendedPrice taxPercentage categoryId1 categoryId2 categoryId3 categoryId4 categoryName1 categoryName2 categoryName3 categoryName4 image1 image2 image3 image4 image5 image6 image7 image8 image9 image10 delivery warranty 1030 "Hama 1030 Hamafix Diaramen 5x5 cm 100 Stuks" Hama "Materiaal: Kunstof Inhoud: 100 Diaformaat: 5 x 5 cm Filmformaat: KB 24 x 36 mm Uitvoering: Lijst Diadikte: 2,3 mm Systeem: Hamafix " 4007249010308 1 true 1 5 21 2593 3392 "Foto / Video" "Diaprojektoren / Accessoires" http://url.nl "Direct leverbaar"

What i want to do is import all the products with magmi and with use of the magmi "On the fly category creator/importer". But if the categoryname1 from the csv file of my manufacturer equals "Foto / Video" it must be imported under an already existing category of my shop, lets say "Wonen".

The Magmi column "Categories" should than be like "Wonen/Foto / Video"

Is this possible with Magmi? or do i have to write a php script for this? I also want to exclude some products and categories from the manufacturer csv file. Lets say, if there is a column in the csv file like "Bricks". This column and all the products assigned to this column in the csv file, should not be imported.

Hope you can help me out with this one.

Thanks!

share improve this question

[dweeves]

replied on magento stackexchange : http://magento.stackexchange.com/questions/20994/import-categories-and-products-under-existing-categories/21052#21052

[PauloBoaventura]

Atualize...