Magmi with multiple csv and category with links
I need to automatically update products from one vendor to magenta. I am using magmi.
This provider makes me a 3.csv: products, categories and images
How can I do to automatically update these products?
Also, I have another problem with .csv categories, I copy the example:
categories.csv
ID_CATEGORY | CATEGORY_NAME | CATEGORY_FATHER_ID
4 | JARDINERIA | 0
100 | Mobiliario jardin | 4
1085 | Conjuntos de jardin | 100
102 | Conjuntos de jardin | 100
109 | Mobiliario de jardin | 100
110 | Polyrattan Marron | 109
112 | Polyrattan Marfil | 109
product.csv
SKU | NAME | CAT | Shot_description | DESCRIPTION | PRICE | STOCK | img_number
01010080 | BLISTER ALAMBRE | 102 | Alambre | Carrete alambre galvanizado | 1.230000 | 84 | 1
images.csv
SKU | NUM_ORDER | URL
08091264 | 1 | http://www.xxxxx.com/img_artics/08091264.jpg
08091264 | 2 | http://www.xxxxx.com/img_artics/08091264_1.jpg
08091333 | 1 | http://www.xxxxx.com/img_artics/08091333.jpg
08091333 | 2 | http://www.xxxxx.com/img_artics/08091333_1.jpg
08091333 | 3 | http://www.xxxxx.com/img_artics/08091333_2.jpg
How can I do this with magma?
source to share
It is not possible to directly import this file. Magmi provides the Datapump API. you can use this function to import these files.
http://wiki.magmi.org/index.php?title=Magmi_Datapump_API
So here is my approach for importing these csv files:
1) Create PHP file for API datadump. 2) Write a PHP script that converts the CSV file to an array. 3) Importing an array using the data dump API. You can find an example from the link above.
source to share