Benefits of Product Import Export with Excel

Handle Images: #

A) Upload Images Via URL along with Product creationInsert in a column the image URL address eg. example.com/image.png

B) Upload multiple images manually to your Media Library independently from product creation

• Include the Name of an existing image in an Excel Column
• Map the column of the data to Image Field and image will be attached to product.

The 2nd approach is useful if you have the images stored locally in a folder and you have the list of image names along with product names.

Simple VS Variable Products
Importing Products means 3 options: #

1) Simple Products with NO Atrributes – 1 product (defined by unique title) per Excel row. Only one needed in the excel file.

2) Simple Products with Atrributes (eg color) NO Variations – 1 Row per product Attribute (title of product is the same) for Each Attribute. You need to click the checkbox “Create only attributes” while data mapping.

3) Variable Products with Atrributes (eg color) – 1 Row per product variation (title of product is the same) for Each Variation. You dont’t click the checkbox “Create only attributes” while data mapping.

4)Variable Products with Attributes (eg color,size) comma separated from Only 1 excel row. This means the variations share the same meta data such as prices, sku, stock, dimensions, images etc .Click the checkbox “Add Variable product from 1 row with attrributes comma separated” while data mapping.

Simple Products with Attributes #

Now, you can import Simple Products with multiple attributes, comma separated. This mean you need only one row for each product, one cell for each attribute, with the values comma separated. Prerequisite for this is to tick the box Create Attributes (if Any) ONLY, Not Variations

This saves time and import products much faster.

Import Affiliate / External Products #

Now, you can import easily import External Products. This is super easy, you can just follow the sample excel file, the only basically thing you need to do is map product_url and button_text excel fields. If the product added has product URL will be auto assigned the type of External.

Attribute Selection for Variation in Variable Products #

1. Upload your Excel
2. the mapping screen will appear. If your Excel file contains columnn you will map and refers to attribute Values, a checkbox will appear for each attribute.
3. If checkbox for the specific attribute is checked, this attribute will be used in Product Variation.

Add Variable Products with One Excel Row #

This may apply to cases where your variations share same data for prices, stock , image , etc and you just need to add more attribute variation combination and make procerss faster.Instead of using one row per variation in Excel, you will
1) insert Only one row , a
2) add the attribute values comma separated
3) Select the checkbox “Add Variable product from 1 row with attrributes comma separated”

Installation #

1. Upload the plugin files to the `/wp-content/plugins` directory and unzip, or install the plugin through the WordPress plugins screen directly.
2. Activate the plugin through the ‘Plugins’ screen in WordPress
3. Use the Woocommerce Importer Menu Link or Settings link on plugins page to use the plugin.
4. Insert the license number for the first time you use the plugin.
5. Upload your excel file (there is a link for a sample excel file) and proceed to data mapping and creating your products.