magmi与多个csv和类别与参考

问题描述

我需要自动将产品从一个供应商更新到magento。
我使用magmi。

这个供应商使我3 .csv：产品，类别和图片

此外，我对类别.csv有另一个问题，我复制一个示例：

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 |金银花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 
  

如何使用magmi？

解决方案

不能直接导入此文件.Magmi提供Datapump API。您可以使用此功能导入此文件。

这里是我导入这个csv文件的方法：

1）为datadump API创建PHP文件。
2）编写PHP脚本，将CSV文件转换为数组。
3）使用数据转储API导入数组。您可以在以上链接上找到示例。

I need to automatically update the products from one vendor to magento.I am using magmi.

This provider makes me 3 .csv: products, categories and images

How I can do to automatically upgrade these products?

In addition I have another problem with the categories .csv, I copy an 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 I can do it with magmi?

解决方案

It won't be possible import this file directly.Magmi provides Datapump API. you can use this feature for import this files.

http://wiki.magmi.org/index.php?title=Magmi_Datapump_API

So here is my approach for import this csv files :

1) Create PHP file for datadump API.2) Write PHP script which convert CSV file to array.3) Import array using data dump API. You can find example on Above link.

这篇关于magmi与多个csv和类别与参考的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！