WordPress Plugin to Import Products and Export Products for Woocommerce in Bulk with Excel.

Tom Anbinder

Pablo Pacheco

WPFactory

Omar AlDabbas

Algoritmika

extendWP

Product Excel Import

<p>With this WordPress plugin you can do Product Import & Export for Woocommerce in Bulk with Excel instantly.<br />
Unlimited import/updates of Simple products along with their images is possible as the process works in batched to avoid PHP memory limits.<br />
Export your WooCommerce products in excel file to later do Inventory Stock Updates or change your Prices in bulk.</p>
<h3>MAIN FEATURES</h3>
<ul>
<li><strong>Product Import Simple</strong> Products  with Excel</li>
<li><strong>Product Update Simple</strong> Products  with Excel easily , stock inventory and prices updates.</li>
<li><strong>Product Export for Woocommerce of your Simple Products</strong> in Excel – by the hit of a button!</li>
<li><strong>Filter Product Exports</strong> by keyword</li>
<li><strong>Import Product Categories tree</strong> with excel – Independently from products to create your product categories hierarchy for your eShop.</li>
<li><strong>Data mapping</strong> – Drag and drop Excel Columns to Product Fields easily. No More Hassle with CSV’s!</li>
<li><strong>Automatch feature</strong> – The plugin can automatically map excel columns to the relevant product fields based on label names.</li>
</ul>
<h3>OTHER FEATURES</h3>
<ul>
<li>define user role to use the plugin apart from admin</li>
</ul>
<h3>You need to Import / Export Variable Products?</h3>
<p>The <a href="https://extend-wp.com/product/wordpress-product-import-export-excel-woocommerce/" title="Woo Product Importer Exporter Premium" rel="nofollow ugc">PRO Version</a> of this wp plugin allows you to do Product Import Export for WooCommerce, <strong>Simple or Variable with Multiple Attributes</strong>,  <strong>import Images & Galleries for custom fields – <a href="https://www.advancedcustomfields.com/pro/" title="ACF pro" rel="nofollow ugc">ACF pro</a></strong>, <strong>update products by ID, SKU</strong> or TITLE. Moreover, <strong>WPML compatibility</strong> and multilingual support for product import , <strong>Import <a href="https://woocommerce.com/products/woocommerce-subscriptions/" title="WooCommerce Subscription Products" rel="nofollow ugc">WooCommerce Subscription Products</a></strong> , <strong>Schedule Product Import with CRON</strong> Job and create <strong>Import Template</strong> to Save Time, import <strong>Product Categories with their Images</strong>, all using Excel!</p>
<h4>How to</h4>
<ol>
<li>Create an excel or use the sample from plugin setting’s page with your data – 1st row  is the heading e.g., TITLE, 2nd row will have the product title. Use 1 row for each product. Each Column represents a field to import along with your product.</li>
<li>Upload the excel file on Product Excel Import & Export for WooCommerce settings page.</li>
<li>Once you upload, you will see a screen where you can map the data from the excel to the product fields of WooCommerce.</li>
<li>Click Upload and wait. Product Import in Bulk will function with no hassle!</li>
</ol>
<p>Lastly, added “wpeieWoo” user capability for admin, you are free to set this capability either programmatically or with a plugin like ‘User Role Editor’.</p>
<h4>Video Instructions</h4>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/Cgf2QoyhwLs?version=3&rel=0&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<p><strong>PRO VERSION</strong></p>
<ul>
<li>PRODUCT IMPORT – SIMPLE & VARIABLE – You can upload simple products with attributes or variables, along with their attributes and their images!</li>
<li>Import <a href="https://woocommerce.com/products/woocommerce-subscriptions/" title="WooCommerce Subscription Products" rel="nofollow ugc">WooCommerce Subscription Products</a></li>
<li>Support for WPML WooCommerce Product Translations Import with Excel</li>
<li>Import / Export Affiliate/External products</li>
<li>Import Product Featured image</li>
<li>Import Product Image Gallery</li>
<li>Schedule Product Import / Update with CRON JOB</li>
<li>Save Template for Product Import to save time</li>
<li>UPDATE SIMPLE & VARIABLE PRODUCTS – Through WooCommerce Product Excel Importer Premium, users are free to update those products with simple attributes and variables.</li>
<li>Define which attributes will be used for your Variable Products during Import</li>
<li>Update by Product ID, SKU or Title. You can easily export get the necessary fields and update back.</li>
<li>PRODUCT IMPORT – SIMPLE PRODUCTS WITH ATTRIBUTES: add multiple attributes,comma separated, this means you need only one Excel row for each product!</li>
<li>Update Feature Supports Update by PRODUCT ID – given in the Export Feature! This was you can easily update simple products or variable, along with product variations on the fly!</li>
<li>FIELDS SUPPORTED: User preConfigured Attributes, User preConfigured Custom Taxonomies, length, width, height, downloadable, download url, download expiry, download limit, virtual, purchase note, cross-sell ids, upsell ids, purchase note, backorders, sold individually, featured, tax class, tax status, stock status, shipping class</li>
<li>CUSTOM FIELDS SUPPORT: ACF / ACF PRO and other plugin’s post meta fields  – YOU CAN ALSO manually set the name of custom field you need to be available for import & export</li>
<li>Import / Export YOAST SEO Meta Product fields,  like META TITLE, META DESCRIPTION</li>
<li>Compatible with <a href="https://yithemes.com/themes/plugins/yith-woocommerce-color-and-label-variations/" title="YITH WooCommerce Color and Label Variations" rel="nofollow ugc">YITH WooCommerce Color and Label Variations</a></li>
<li>Compatible with <a href="https://wordpress.org/plugins/woo-variation-gallery/" title="Additional Variation Images Gallery for WooCommerce" rel="ugc">Additional Variation Images Gallery for WooCommerce</a></li>
<li>Compatible with <a href="https://wordpress.org/plugins/perfect-woocommerce-brands/" title="Perfect Brands for WooCommerce" rel="ugc">Perfect Brands for WooCommerce</a></li>
<li>Compatible with <a href="https://wordpress.org/plugins/woo-variation-swatches/" title="Variation Swatches for WooCommerce" rel="ugc">Variation Swatches for WooCommerce</a></li>
<li>IMPORTS CUSTOM TAXONOMIES – along with product creation you can import terms for any custom taxonomy which is pre assigned to post type product.</li>
<li>EXPORT SIMPLE & VARIABLE PRODUCTS. The excel is providing the product or Variation ID, you can choose what products to show based on criteria and also choose which columns – product fields to export</li>
<li>DELETE PRODUCTS WITH EXCEL – Just like you can import multiple products, you can delete them as well. Deleting is based on ID or product Title.</li>
<li>IMPORT PRODUCT CATEGORIES with Images: you are able to import multiple product categories individually from product creation along with uploading Product Category Image. This allows you to complete your work a lot quicker, without missing out on important stuff such as e-shop categories.</li>
<li>DELETE CATEGORY TERMS THROUGH EXCEL FILE</li>
<li>HTML SUPPORT for PRODUCT DESCRIPTION – directly from an excel column you can right html to import as content for your product description. As simple as that!</li>
<li>HTML SUPPORT for PRODUCT EXCERPT – directly from an excel column you can right html to import as content for your product excerpt. As simple as that!</li>
<li>Set Default Attribute Combination for Variable Products</li>
<li>Define custom separator for when importing / exporting multiple values of a field. This avoids conflicts with comma separated values , mixed with values with comma as delimiter</li>
</ul>
<p>— Last but not least, define which WordPress role will access the plugin apart from Admin straight in settings page</p>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/wCloPECyTPo?version=3&rel=0&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<p><a href="https://demo.extend-wp.com/enter" title="Woo Product Importer Exporter PRO" rel="nofollow ugc">PRO VERSION DEMO</a> user:demo – pass:demo<br />
<a href="https://extend-wp.com/product/wordpress-product-import-export-excel-woocommerce/" title="Woo Product Importer Exporter PRO" rel="nofollow ugc">Get it Here</a></p>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/w8YkbMrUuMY?version=3&rel=0&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<h3>Check our other Plugins</h3>
<p><a href="https://wordpress.org/plugins/store-migration-products-orders-import-export-with-excel/"" rel="ugc">Orders Import – Orders Export, Coupons Import Export, Reviews & Products Import/Export Bundle</a><br />
<a href="https://extend-wp.com/product/woocommerce-product-excel-importer-bulk-editing-pro/" title="WebD WooCommerce Product Excel Importer & Bulk Edit" rel="nofollow ugc">Bulk Edit + Excel Importer</a><br />
<a href="https://extend-wp.com/product/content-importer-wordpress-woocommerce-excel/" title="WordPress
CONTENT EXCEL IMPORTER">Excel Importer for Any Content Type</a><br />
<a href="https://wordpress.org/plugins/users-import-export-with-excel-for-wp/" title="Users & Customers Import Export with Excel" rel="ugc">Users & Customers Import Export with Excel</a><br />
<a href="https://wordpress.org/plugins/products-stock-manager-with-excel/"" rel="ugc">Stock Manager with Excel & Auto Updates</a></p>


Product Excel Import & Export for WooCommerce

Useless plugin, did not exported all of my products and also a few products have no name and just some random date instead.

Alternatives to Product Excel Import & Export for WooCommerce

Top alternatives