Can I Export Product Data in Shopsite and Upload to Woo Commerce?

• Details
• Reviews
• Installation
• Back up
• Development

With this WordPress plugin you tin can do Production Import and Export for Woocommerce in Bulk with Excel instantly – Unlimited Unproblematic products support.

Production Update Existing Unproblematic Products with Excel hands!

Product Export for Woocommerce of your Uncomplicated Products in Excel by the striking of a push

Data mapping – Drag and drib Excel Columns to Product Fields easily. No More Hassle with CSV'due south!

Ajax driven plugin to Import Products, very easy to utilize. All your data will be implemented on the spot, without any delay or inaccuracy.

The import products and update products features are based on Production Championship entered in an Excel Column.

Lastly, import Production Categories tree with excel to later use for your products.

The PRO Version of this wp plugin allows you to do Product Import Export for WooCommerce, Simple or Variable with Multiple Attributes, Product Prototype & Product Gallery images every bit well, update products by ID, SKU or Championship. Moreover, WPML compatibility and multilingual support for product import , Import WooCommerce Subscription Products , Schedule Product Import with CRON Job and create Import Template to Salvage Time, import Product Categories with their Images, all using Excel!

Click here if you need Orders Import – Orders Export, Coupons Import Export, Reviews & Products Import/Export Packet

Click hither if you need Bulk Edit + Excel Importer

Click hither if you need Excel Importer for Any Content Type
Click hither if y'all need Users & Customers Import Export with Excel
Click here if you lot need Stock Managing director with Excel & Auto Updates

How to

1. Create an excel or use the sample from plugin setting's page with tou data – 1st row is the heading eg. Title, 2d row volition have the product title. Utilize 1 row for each product. Each Column represents a field to import along with your product.
2. Upload the excel file on Product Excel Import & Export for WooCommerce settings page.
3. Once you upload, you will run into a screen where you lot can map the information from the excel to the production fields of WooCommerce.
4. Click Upload and expect. Production Import in Bulk will role with no hassle!

Supports

• Title
• Post Condition – new
• Description
• Short Description – Excerpt -NEW
• Product Category (multiple comma separated)
• Production Tags (multiple comma separated)
• Weight
• SKU
• Regular Cost
• Sale Toll
• Stock
• Author ID
• Url – Slug
• Virtual
• Taxables
• Tax Class

Extra

Categories/Tags are created along with the Product creation if they don't pre exist.

If a subcategory/subtag is selected on the excel, parent categories volition also exist added/selected for the relevant product. NEW: this is configurable!

Lastly, added "wpeieWoo" user capability for admin, you are complimentary to prepare this capability either programmatically or with a plugin like 'User Role Editor'.

Video Instructions

PRO VERSION

• PRODUCT IMPORT – SIMPLE & VARIABLE – You can upload simple products with attributes or variables, along with their attributes and their images!
• Import WooCommerce Subscription Products
• Support for WPML WooCommerce Product Translations Import with Excel
• Import / Export Affiliate/External products
• Schedule Product Import / Update with CRON Job
• Salve Template for Product Import to salvage time
• UPDATE Simple & VARIABLE PRODUCTS – Through WooCommerce Product Excel Importer Premium, users are free to update those products with simple attributes and variables.
• Ascertain which attributes will be used for your Variable Products during Import
• Update by Product ID, SKU or Title. You tin hands consign get the necessary fields and update back.
• Product IMPORT – SIMPLE PRODUCTS WITH ATTRIBUTES: add multiple attributes,comma separated, this means you lot need simply one Excel row for each product!
• Update Feature Supports Update past Production ID – given in the Consign Feature! This was you tin easily update uncomplicated products or variable, along with product variations on the fly!
• FIELDS SUPPORTED: User preConfigured Attributes, User preConfigured Custom Taxonomies, length, width, summit, downloadable, download url, download expiry, download limit, virtual, purchase note, crossell ids, upsell ids, buy notation, backorders, sold individually, featured, tax class, revenue enhancement status, stock status, shipping course
• CUSTOM FIELDS Support: ACF and other plugin's post meta fields – YOU CAN ALSO manually set the name of custom field you lot need to be available for import & export
• Import / Consign YOAST SEO Meta Product fields, like META TITLE, META DESCRIPTION
• IMPORTS PRODUCT IMAGES FROM URL – Superb flexibility here likewise! Y'all tin can import the product images locally or choose to import them from any URL. Last but not least, you are free to refer to the image name if epitome exists in Media. Dropbox public folder too suppported to go the epitome from.
• IMPORT IMAGES IN Product GALLERY – Do y'all want to create an image gallery for each product? Now y'all can do that! You tin can upload unlimited product images easily by inserting multiple URLs separated using a comma in an excel cavalcade.
• Compatible with YITH WooCommerce Color and Label Variations
• Compatible with Additional Variation Images Gallery for WooCommerce
• Uniform with Perfect Brands for WooCommerce
• Compatible with Variation Swatches for WooCommerce
• IMPORTS CUSTOM TAXONOMIES – forth with production creation you can import terms for whatever custom taxonomy which is pre assigned to mail type product.
• Consign Uncomplicated & VARIABLE PRODUCTS. The excel is providing the product or Variation ID, you can choose what products to show based on criteria and too choose which columns – product fields to export
• DELETE PRODUCTS WITH EXCEL – Only like you lot tin import multiple products, you can delete them as well. Deleting is based on ID or product Title.
• IMPORT Production CATEGORIES with Images: you lot are able to import multiple product categories individually from product creation along with uploading Product Category Paradigm. This allows you to complete your work a lot quicker, without missing out on of import stuff such as due east-shop categories.
• DELETE CATEGORY TERMS THROUGH EXCEL FILE
• HTML Back up for Product DESCRIPTION – directly from an excel column y'all can right html to import every bit content for your production clarification. Equally unproblematic every bit that!
• HTML SUPPORT for Product EXCERPT – straight from an excel column you lot can correct html to import as content for your product exceprt. As uncomplicated equally that!
• Set Default Attribute Combination for Variable Products

— Last but not least, define which WordPress function will admission the plugin apart from Admin straight in settings page

PRO VERSION DEMO user:demo – pass:demo
Get it Here

1. Upload the plugin files to the /wp-content/plugins directory and unzip, or install the plugin through the WordPress plugins screen straight.
2. Actuate the plugin through the 'Plugins' screen in WordPress
3. Use the Woo Product Importer menu link, 'Import from Excel' Submenu on Products or Submenu on Woocommerce or Settings link on plugins page to use the plugin.
4. Upload your excel file (there is a link for a sample excel file) and proceed to data mapping and creating your products.

How to exercise product import in excel for WooCommerce?

Add one row for each product and each column volition refer to a product field, such every bit championship, description, prices, etc. Example excel provided to download through plugin'southward configuration scren.

Can I update the existing products for WooCommerce?

Aye, update is also supported and will be mentioned while uploading. Update is based on Championship. If a championship entered in an excel column exists as product in your website, this product'southward fields will exist updated.

Tin I add categories with Excel for WooCommerce Products?

Yep, when you add a cateogory terms in excel, this will be created along with the product.
You can add them comma separated in an excel column.

How do i define if a WooCommerce Product is in stock?

By default, leaving stock column bare volition create products that are 'in stock'.
If you need the to be as 'out of stock', simple add '0' to stock column and map it through the import process.

Can I add together WooCommerce Product images (featured paradigm) / custom taxonomies along with the product?

This characteristic is available in the PRO Version.

Can I add WooCommerce Product Gallery Images?

This feature is available in the PRO Version.

Tin I import Orders, Coupons or Reviews with this plugin?

This feature is available in Products Reviews Orders Customers Coupons WooCommerce Migration Pro

Can I update by SKU?

This feature is available in the PRO Version.

Can I import / update Product ACF fields or other Custom Fields?

This characteristic is available in the PRO Version.
The only prerequisite is that you have already created manually a production and pressed 'PUBLISH' after you installed and created fields with ACF or other Similar plugin, then that the entry of this custom field exists in the database.

Can I import or export WordPress Users with this plugin?

For such a feature you can use Users Import Export with Excel.

Can I update just Stock and Prices automatically with Cron?

For such a feature you can use Product Stock Manager PRO.

Can I import Coupons and Products Reviews with this plugin?

For such a feature you tin use Orders, WooCommerce Subscriptions, Coupons, Reviews & Products shop Migration

Is plugin compatible with WPML?

WPML compatibility and multilingual support production import is available in the PRO Version.

Can Other user apart from admin access the plugin?

Yes, we added "wpeieWoo" user capability for admin, you are gratis to prepare this capability either programmatically or with a plugin like 'User Role Editor'

Can I import / export WooCommerce Orders and Subscriptions with this plugin?

This feature is available in the PRO Version of Orders Import Export for WooCommerce with Excel

Keep on cycling forever and does non import anything

The plugin is very expert, the support responds immediately to whatever problem that may occur and gives yous a solution. I suggest information technology.

dainty plugin like shooting fish in a barrel to upload products

The only trouble with this review that in that location is not 0 kickoff \ DO Non USE

Useless plugin, did non exported all of my products and also a few products have no proper noun and merely some random date instead.

hi so I am using PHP v8 unfortunately, the plugin uses the depreciated PHPExcel hence its non working with PHP v8 as information technology gives the following fault: PHPExcel Mistake: Assortment and string offset access syntax with curly braces is deprecated So kindly use the PHPSpreadsheet and migrate from PHPExcel Thank you

Read all 27 reviews

"WordPress Product Excel Import & Export for WooCommerce" is open source software. The following people have contributed to this plugin.

Contributors

4.7

added feature to import production cateogories tree with excel

4.6

extra check for wc_product return

4.v

fixed set_sale cost

4.iv

Fix production import index based on meta – SKU on backend – update WooCommerce table wc_product_meta_lookup

4.iii

Added feature for Automatching Excel Columns to Product Fields if Excel Label the same with product field
Fixed bug when importing Excel with empty Column

4.2

compatibility checks, alter descriptions

iv.1

Remove Sale price by adding 0 to excel cell
Ready Setting stock to zero by adding 0 to excel cell
Fix updating prices and stock number with values less than zero ( 0 )

4.0

Replace PHPExcel Library with PHPSpreadsheet

3.9

fixed export duplicates

three.8

added adequacy for user other than admin to access – check compatibility

iii.seven

add post condition to import

3.half-dozen

fixed compatibility with wp 5.5

iii.5

added option to import likewise paretn production categories

3.3

stock-still php fault on calculaction/functions.php
checked wooCommerce 3.7 compatibility

iii.2

changed consign functionality – export directly to .xlsx

3.1

Export prepare in chrome
Check WooCommerce compatibility 3.6.5

3.0

Export Simple Products to Excel for WooCommerce added
Issues fixes on import functionality
Wordpress five.ane compatibility.

2.0

Check WordPress v.0 compatibility.
Check latest woocommerce version compatibility.
Added Features: Import Author id, import URL Slug, Virtual Product

1.7

Issues fix for decimal values on weight, prices etc.

1.vi

Short Clarification field – Excerpt support for import

1.v

Elevate northward Drib for Excel Files

1.4

If description column non selected, during update previous content will be preserved

1.iii

Properly refresh the view for price changes for products – delete product_transients.

1.ii

Functionality to add multiple categories or tags from ane cell comma separated
Set up UI
Avert css conflicts

1.1

Fix bug with empty excel columns

1.0

lyncholes1941.blogspot.com

Source: https://wordpress.org/plugins/woo-product-excel-importer/