How to Import Tiered Magento DataFlow Mapping
Magento DataFlow is a data import/export tool that comprises four major parts: adapters, parser, mapper and validator. At the time of publication, validator was still being developed. Dataflow of data exchange process in Magento framework is considered as profile and defined in XML structure. Magento offers import/export wizards for creating import/export profiles. For advanced users who have proficient XML knowledge, XML defining profiles without wizard tool and more custom dataflow operations are also available. Using Mapper, you can map the header of the *.csv file to Magento’s default attribute.
Instructions
-
-
1
Ensure that the csv file you want to import is ready and click “Start,” “All Prorgrams” and “Magento Store Manager” to enter its interface.
-
2
Map the “product_id” in csv file to “products” in the new data table using map method using XML file in Mapper:
<action type=“dataflow/convert_mapper_column" method=“map”>
<var name=“map”>
<map name=“product_ids”><! [CDATA [products]]></map>
</var>
<var name=“_only_specified”>true</var>
</action>
Execute the XML file in Mapper. -
-
3
Click “Import/Export products” on the tab on the right pane of the interface. The import wizard will appear.
-
4
Specify the source file by clicking “Browse.” Click “Next.” A preview of the *.csv file is shown and you should pay attention to the delimiter on the preview. Click “Next.”
-
5
Enter the delimiter you have recorded in the “Select delimiter which will be used to separate fields data.”
-
6
Check “Store View” box to update the default store view. Click “Next.”
-
7
Tick “ProductID” for the product identification method on the “Assign .csv Columns to Database Fields” interface. On the left pane, it shows the fields of the original file. The right pane shows the corresponding columns on the new table. Click “Next.”
-
8
Preview the import and go to the next step. Tick “Add and modify.” Tick “Cache import data.” Click “Import” button to start importation. A report will be generated upon the completion of importing.
-
1