MAGMI: Magento Mass Importer
来源:互联网 发布:linux开机出现dracut 编辑:程序博客网 时间:2024/06/04 18:26
Magmi is an open-source project of Sebastien Bracquemont to import large quantities of products, based on CSV files, directly in the Magento database.
The benefits:
- Super fast, direct SQL import.
- Enhanced features (simple and advanced imported products)
- Multiple storeviews and Websites possible
- Import and update: categories, images, pricing, stock, .... (not bundled)
- Translations of products at store level view
More information: http://sourceforge.net/projects/magmi/
Installation and configuration:
The installation from Magmi is rather simple. Magmi is a standalone plugin completely beside your Magento installation. It interacts directly with your Magento database. I advise you to extract the Magmi folder in the root folder of your Magento installation. Create now the following folders in your Magento root folder:
- /var/import (directory to import csv files)
- /media/import (directory for the import of product images)
Visit the magmi configuration page: http:// <magento-url> /magmi/web/magmi.php
Now you only have to make the database configuration of your Magento site in Magmi, fill out and save. All other parameters are standard to use if you have followed the above folder structure.
First product import:
The item processors are very useful plugins to do an advanced import. Check this item processors for our first product import:
- On the fly category creator / importer (allows for category titles instead of IDs to use)
- Image processing attributes (corresponding import product images)
You can also check all plugins to avoid problems.
CSV example:
sku;name;price;qty;is_in_stock;visibility;image;weight;categories;tax_class_id
demo-001;"Demo 1";12;19;1;4;demo.jpg;0;"demo categorie";2
Demo file: phpro-simple-demo.csv
If you save this csv file in the directory /var/import from magento and optionally post the image demo.jpg in the /media/import folder, you can select the csv file from the Data Sources tab of the Magmi imports page. Select the imported file from the dropdown, use ‘;’ as separator and " as enclosure. Go to the top of the 'Run magmi' tab and select "Create new items, new ones skip” and click Run.
When the import is successful you get a summary of the statistics from your import. You will get a list of error messages, when there is an import problem.
Go to the Magento backend and check if your first product was added to Catalog > Manage Products.
To view your product in the frontend, you need to re-index magento: System > index management.
This simple import is done with the minimum data required in magento. Just a list of parameters:
- SKU (unique number of a product)
- name (title of your product)
- price (price of your product)
- Qty (quantity of products in stock)
- is_in_stock (0 for no or 1 for yes, 1 is necessary to visualize your product in the shop)
- visibility (4 for visibility in catalog and search)
- Image (url of the image which is placed in the /media/import directory)
- weight (weight can be 0 if you do not use it in your shop)
- categories (the name of the category, if it does not exist it is created by the "on the fly category creator" plugin "demo/demo” to import in a subcategory)
- tax_class_id (2 for products with taxes or use a self-configured value)
Advanced product imports:
This more advanced import allows you to use almost all parameters inside your Magento site.
File: phpro-advanced-demo.csv
Let's take a closer look to use some additional parameters:
- store (default "admin" or a storeview to make translations possible. You can overwrite the title and description from "admin" at store level view).
- websites (default "base" or the code of the Web site where you want to add the products, only to be used for a Magento installation with multiple sites)
- attribute_set ('Default' or a self-generated code for a product with special attributes)
- Type (default 'simple' or 'configurable' to import configurable products)
- media_gallery (add extra images in addition to the standard picture)
- See also the most common attribute codes within magento: http://go.magento.com/support/kb/entry/name/working-with-product-csv-files
Kind regards,
- MAGMI: Magento Mass Importer
- magento -- 推荐插件 -- Mass Product Relater
- magento -- 推荐插件 -- Mass Product Relater
- MASS
- MASS
- importer.h
- EMF importer.Rose
- Item Importer and Exporter
- Android Drawable Importer
- Magento
- magento
- hbase exporter importer 导出 导入
- android drawable importer的使用
- AS插件-Android Drawable Importer
- Android Drawable Importer的使用
- Android Drawable Importer的使用
- Mass Storage
- mass spectrometry
- 如何让div中的内容垂直居中
- mac office 2011 du skal afslutte 安装 弹窗 报错
- javascript中的定时器
- 史上最全的ios源码汇总。欢迎收藏
- SUN系统 管理概念/命令
- MAGMI: Magento Mass Importer
- Java中的八种运算符
- [译]Nginx和Lua
- 使用jcrop进行头像剪切
- PIC单片机编译器的问题(摘自网络)
- 模拟求解迷宫问题(DFS+BFS)
- 如何迅速成为Java高手
- MMI
- POJ 3194 (DFS)