How to easily Import Simple Woocommerce Products with Excel File

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!

SIMPLE PRODUCTS – NO ATTRIBUTES

Insert in your excel file one product per row. Supported fields are defined above.

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

Example excel:

TITLEAUTHOR IDURL SLUGSTATUSDESCRIPTIONEXCERPTSKUWEIGHTREGULAR PRICESALE PRICESTOCK
title 11this-is-my-title-1publishdescription for title 1excerpt 1111095

 

C) Map Excel Columns to Product Fields

Import-map-columns

Simple Products With Attributes

 

HOW TO USE

Same process with simple products with the difference mentioned below:

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

 

Example excel also provided in the exact feature’s tab:

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

 

* It is Mandatory to click the checkbox  “Create Attributes, Not Variations”

Checkbox-attributes-simple-product

 


GET WOO PRODUCT EXCEL IMPORT & EXPORT PRO

product excel import export PRO for woocommerce

«
»