How to easily Import Simple Woocommerce Products with Excel File
Categories: export product woocommerce, import product woocommerce, woocommerce, wordpress plugins
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
- Navigate to Product Import – Export à (Import-Update Products Tab).
- Insert in your excel file your products information.
- Choose the excel in the import screen.
- Map the fields.
- 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
B) Way to add Info in Excel
Example excel:
| TITLE | AUTHOR ID | URL SLUG | STATUS | DESCRIPTION | EXCERPT | SKU | WEIGHT | REGULAR PRICE | SALE PRICE | STOCK |
| title 1 | 1 | this-is-my-title-1 | publish | description for title 1 | excerpt 1 | 1 | 1 | 10 | 9 | 5 |
C) Map Excel Columns to Product Fields
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:
| TITLE | DESCRIPTION | EXCERPT | SKU | WEIGHT | REGULAR PRICE | SIZE | COLOR |
| title 2 | 2a | 2 | 9 | XL | BLUE | ||
| title 2 | description for title 2 | short description 2 | 2b | 2 | 9 | XL | RED |
* It is Mandatory to click the checkbox “Create Attributes, Not Variations”
GET WOO PRODUCT EXCEL IMPORT & EXPORT PRO
