This tutorial is regarding how to use the "Import Export" feature that has been introduced with Magento 1.5 and above in community edition.
I will demonstrate how to import simple product data via CSV files and CSV product related variants.
CSV format is as follows:
Have to put column names in the first table row
Make sure to keep - Field separator: comma
Make sure to keep - Text separator: double quotation marks (optional)
Make sure to keep character coding set to - Character set: UTF-8
Sample importing product format of CSV file.
We have used comma for separating column only for demonstration. Use CSV file as attached.
Column Names :
store, websites, _attribute_set, _type, sku, price, weight, name, image, thumbnail, small_image, short_description, description, status, visibility, tax_class_id, qty, is_in_stock
Values :
admin, base, Default, simple, sandy_product, 100, 0.5, sandy_product, /image1.jpg, /image1_thumb.jpg, /image1_small.jpg, sandy_product, sandy_product, 1, 4, 2, 100, 1
