Importing products is simple with a CSV file! Just follow these easy steps and upload all your products in one go.
1. Navigate to Catalog -> Products and click "Import"
2. If you would like to upload images with your products, you will first want to upload all of the images into your image directory. You will see a link on the import product page that says "Click here to batch upload images". Click on that link and you will be taken to your Image Manager. Click batch upload and then select the images you would like to upload.
3. You will also see a link to download a Sample CSV file. The easiest thing to do is download this file and then replace the sample information with your information. The top row tells you what information should be entered in the column below and if it is required or not (for example Product Name (Required), Attributes (Optional), etc). In the following rows you will see a few examples of how the information should be entered. Just replace these examples with your actual product information (in the same format) and save your updated document.
4. Upload your updated CSV file!
You should upload product images, set up categories, attributes(if you have), and variations(if you have), tax(if you have) beforehand. Click here to see how to setup attributes and variations.
When importing product images you will need to include the full path (except for the main Images folder). For example, if you have an image named tshirt1.jpg and it's in a folder called tops you will need to enter the image as tops/tshirt1.jpg, so it is a good idea to take note of the folders your images are in while in the image manager to make things easier as you enter your product information for uploading.
Anything that isn't marked as Required can be left blank, if desired. If you leave a field blank, your product will automatically use the default for that field.
You can use HTML tags when entering your product description.
When entering attributes, you will enter them as attribute=value. For example, if one of your attributes is labeled "material" and one of values for that attribute is "cotton" you would enter this as "material=cotton". Use the "|" (Shift + \) key as a separator between attributes.
When entering variations, remember that you will need to fill out the details for every variation available. For example, if you have two sizes (small and large) and two colors (white and black), you will need to fill out the information for 4 products (small white, small black, large white, large black). This is done in the following format: color=black&size=small&mprice=59.95&mquantity=45 with the "|" separator between each variation.
When importing large quantity of products , we highly recommend you to import few of them at first, check the result and make sure the products imported successfully. Then, go on.