2012年5月30日星期三

Magento import map, custom options (2)

Tried under the Magento 1.6 bulk import goods on behalf of more than diagrams and customization options, this side of the import is based on my previous article, share the handling precautions.fridge-magnet-online-shop
 
Please read my article on it again: the Magento import map, customization options
 
First, look at, I exported the store said that the set of commodities, the following screen shot page for Magento background, the System -> Import / Export -> the Dataflow - the Profiles in the Profile Wizard columns. I first export is because some people are the first batch already export commodity, edit and then batch update.foot locker

The Magento the Export field the mapping
 
* Note the red part of the figure.
 
The exported file, fridge magnet we need to be modified, the modified example: the Magento multi-map customization options batch import CSV sample file
 
This document are only examples, we have to modify according to their own circumstances, and then you can use. This example contains only a custom attribute.
 
Use the editor to open (I use Notepad + +), we can notice that the characteristics of its punctuation, such as the following screenshots.

Magento Bulk Import CSV file sample details
 
We can see if a property value is two, to have English double quotes, and other properties with only one value do not have double quotes.
 
The bulk import, the Magento will be prompted to the value of an attribute is not legitimate, but in fact is not necessarily that he prompts value, the value of the property adjacent. This problem there are two possibilities, a coding problem, for example, this value is in French, German, does not recognize. Another possibility is the double quotes, here it should be noted.
 
How to import multiple customization options?莆田论坛
 
Example: Size: drop_down: 1 Color: drop_down: 1
 
In CSV, more than one property either add a custom option.


 
Reported property values ​​is not correct, or error how is it?
 
Such as the alarm "Skip import row, required field" skus "not defined" This is not necessarily sku value of a problem, it is possible to coding causes.
 
Use UTF8 encoding to write your csv file, I use Notepad + + code conversion function to the CSV file as UTF8 format,
fridge magnets -Spongebob which will be reduced because the French, Spanish and other non-English language because of the code caused such alarm. And when a property has multiple values, if the alarm attribute value is incorrect, please try to use double quotation marks enclose the value up.


 
We can use excel to edit csv files, but we want to use another editor such as Notepad (I use Notepad + +) view of the file hash, whether some value in double quotes is not whether the coding problem, Magento bulk import support UTF-8 and ANSI encoding.
 
Suggest a classification of a CSV file, nike requin so better to operate some.
 
If you want to use Magento bulk import of the Dataflow - Advanced the Profiles
 
Actions XML of this article can refer to this document: the Magento-Actions-the xml(莆田论坛

没有评论:

发表评论