7 Feb , 2019 | Published by

How to easily Import Variable Woocommerce Products with Excel File

import product woocommerce, woocommerce, wordpress plugins
import-variable-product-excel

Are you tired of manually importing hundreds / thousands of products or trying to convert into CSV to do the job?

Take advantage of the easy to use excel file!
Import you Woocommerce Products easily from an Excel, map fields, drag and drop Excel Columns to Product Fields with Woo Product Excel Import & Export PRO.

HOW TO USE IT

  1. Navigate to Product Import – Export à (Import-Update Products Tab).
  2. Insert in your excel file your products information.
  3. Choose the excel in the import screen.
  4. Map the fields.
  5. Click Upload and Done!

VARIABLE PRODUCTS

Insert in your excel as many rows as the combination of your attributes. Title Needs to be the same.

Taxonomies – there can be multiple imported comma separated.

Image – Insert the Image URL where the image is located. If image already imported in WordPress Media Gallery you can also insert its URL or the image Name.

Product Gallery Image  –  can be multiple imported comma separated. For import and naming same principles apply with featured image.

 

HOW TO

A) Choose Excel File

Drop-excel-feature

B) Way to add Info in Excel

Insert in your excel as many rows as the combination of your attributes. Title Needs to be the same.
Eg color:blue-red,size:m,l : In this case you need to insert 4 rows.

Example excel:

TITLEDESCRIPTIONEXCERPTSKUWEIGHTREGULAR PRICESIZECOLOR
title 22a29LBLUE
title 2description for title 2short description 22b29LRED
title 22a29XLBLUE
title 2description for title 2short description 22b29XLRED

C) Map Excel Columns to Product Fields

Import-map-columns

The reason for this is because each row will also have unique meta data that reflect to the variable level.
Such fields are price, stock, dimensions, downloadable, virtual and image. The rest of the fields are on product level (Description, Excerpt, Purchase Note, Taxonomies, Category, Tags) .


GET WOO PRODUCT EXCEL IMPORT & EXPORT PRO

product excel import export PRO for woocommerce