Import Products from any XML, CSV or Excel to WooCommerce

Descripción

“I’ve been doing eCommerce sites for almost a decade. The combination of WP All Import and WooCommerce is a game changer! I can now get clients into eCommerce sites that could never afford the time/energy or money it took to administrate a site. It has opened up a whole new client base for me.”
Mike Tidmore -Founder, Successful Online Stores

Whether you’re working with XML, CSV, Google Sheets, or Excel files, the WooCommerce add-on for WP All Import makes it easy to bulk import your products to WooCommerce in less than 10 minutes.

The left side of the plugin looks just like WooCommerce, and the right side displays product details in a table from your XML/CSV/ Excel file.

Drag & drop the data from your XML, CSV, or Excel into the WooCommerce fields to import it.

The importer is so intuitive it is almost like manually adding a product in WooCommerce.

WooCommerce CSV imports? WooCommerce XML imports? WooCommerce Excel Import? They are EASY with WP All Import.

Here’s why you should use the WooCommerce add-on for WP All Import:

  • Supports files in any format and structure. There are no requirements that the data in your file be organized in a certain way. WooCommerce CSV imports are easy, no matter the structure of your file. WooCommerce XML imports are flexible and work with any XML file.
  • Supports files of practically unlimited size by automatically splitting them into chunks. Import 200Mb+ product catalogs with ease, even on shared hosting.

WooCommerce Add-On Pro

The Pro edition of WP All Import + the WooCommerce add-on is a paid upgrade that includes premium support and adds the following features:

  • In-depth support for Variable products – example CSV and Excel files, ability to import variations from properly formatted XML, and much more.

  • Import External/Affiliate products

  • Import Grouped products

  • Import files from a URL – Download and import WooCommerce data from Google Sheets and external websites, even if they are password protected with HTTP authentication.

  • Cron Job/Recurring Imports – WP All Import Pro can periodically check a file for updates, and add, edit, delete, and update the stock status of the imported products accordingly.

  • Execution of Custom PHP Functions on data, i.e. use something like [my_function({xpath/to/a/field[1]})] in your template, to pass the value of {xpath/to/a/field[1]} to my_function and use whatever it returns.

  • Get access to our customer portal with documentation and tutorials, and e-mail technical support.

Upgrade to the Pro edition of WP All Import + the WooCommerce add-on now.

You need the WooCommerce add-on if you need to:

  • Import XML to WooCommerce
  • Import CSV/Excel to WooCommerce
  • Import Google Sheets to WooCommerce
  • Are frustrated with the limitations of the official WooThemes Product CSV Import Suite

WooCommerce CSV Imports

Of course, XML files can have complex structures, but for CSV files, you can easily edit them and change the column names.

When importing CSV files, you should use UTF-8 encoding (which is very standard) if you are having any trouble with CSV imports containing special characters. But other than that, there are no special requirements.

This importer is the best option for WooCommerce CSV import tasks – our importer is extremely flexible when doing CSV imports because you don’t need to edit your CSV files to import them to WooCommerce. WP All Import can import ANY CSV file to WooCommerce. You don’t need to layout your data in a specific way, and you don’t need your CSV to have specific column names. WP All Import’s drag & drop interface provides you with a visual way to map the columns in your CSV file to the appropriate fields in WooCommerce.

WooCommerce Excel Import / Google Sheets Import

Don’t want to convert your Excel or Google Sheets data to CSV? WP All Import also works as a Google Sheets and Excel importer for WooCommerce. Simply upload your Excel file as you would for CSV and WP All Import will automatically detect the columns in your file.

For Google Sheets, use the ‘Download a file’ option and paste your sheet’s public URL to import data to WooCommerce.

Related Plugins

Export any WordPress data to XML/CSV
Import any XML or CSV File to WordPress
Export Products to CSV/XML for WooCommerce
Custom Product Tabs for WooCommerce WP All Import Add-on
Export Orders to CSV/XML for WooCommerce
Export WordPress Users to CSV/XML

Related Tutorials

How to Import Product Types Including Simple, Grouped, Virtual, Downloadable, Bookable, Subscriptions, and Product Bundles
How to Sync WooCommerce Product Stock Levels
How to Import Product Customers
How to Import Product Image Galleries and Metadata
How to Import Product Categories, Tags, and Other Taxonomies
How to Schedule Product Imports
How to Migrate WooCommerce Products

Support

You can submit the support form on our website or email us at support@wpallimport.com. While we try to assist users of our free version, please note that support is not guaranteed and will depend on our capacity. For premium support, purchase WP All Import Pro.

Capturas

  • The WooCommerce add-on.

Instalación

First, install WP All Import.

Then install the WooCommerce add-on.

To install the WooCommerce add-on, either: –

  • Upload the plugin from the Plugins page in WordPress
  • Unzip woocommere-product-import-add-on-for-wp-all-import.zip and upload the contents to /wp-content/plugins/, and then activate the plugin from the Plugins page in WordPress

The WooCommerce add-on will appear in the Step 4 of WP All Import.

Preguntas frecuentes

How do I import WooCommerce products?

  1. Navigate to All Import › New Import.
  2. Upload the import file.
  3. Choose WooCommmerce Products as the import type.
  4. Map the incoming data elements to the product fields.
  5. Run the import and verify the imported data.

How do I import product images into WooCommerce?

  1. Go to All Import › New Import.
  2. Upload the import file.
  3. Select WooCommmerce Products as your import target.
  4. Map the incoming data elements to their product fields.
  5. Include product image data in the mapping process.
  6. Run the import and verify the imported data.

How do I import product attributes into WooCommerce?

To import product attributes into WooCommerce, use the Attributes tab of the WooCommerce Add-On section on the Drag & Drop screen. This will let you map incoming attribute data elements to the appropriate product attribute fields.

How do I add new variations to existing variable products in WooCommerce?

  1. Go to All Import › New Import.
  2. Upload the import file with the new variations.
  3. Choose WooCommerce Products as the import post type.
  4. Map the incoming data elements to their product fields.
  5. Use the “I’m importing new variations to existing products” option.
  6. Run the import and review the imported products.

Can I import any WooCommerce product type?

Yes. You can import any standard WooCommerce product type, including simple products, variable products, simple subscription products, grouped products, and affiliate products. Just set the product type during the import process.

How do I import WooCommerce products from a CSV or Excel file?

To import product data from a CSV or Excel file to WooCommerce, just specify it as the source file. WP All Import will automatically recognize the file type and adjust its interface accordingly.

How do I import WooCommerce products from an XML file?

To import WooCommerce products from an XML file, just upload the file. Our software will automatically identify the XML nodes and will let you import from any XML layout regardless of its complexity.

How do I import WooCommerce products from Google Sheets?

To import product data from Google Sheets to WooCommerce, just specify the file URL in the ‘Download a file’ option. WP All Import will automatically download data from the file and display it in a table for mapping.

How do I import a product feed into WooCommerce?

A product feed is usually organized around a URL or FTP/SFTP import source. Our plugin will handle either. Just select Download a File › From URL or Download a File › From FTP/SFTP and provide the information required by the interface.

How do I migrate WooCommerce products?

  1. Export the WooCommerce products that you want to migrate.
  2. Download the bundle file, which contains import instructions.
  3. Upload the bundle file on the destination site.
  4. WP All Import will use the bundle file to configure itself.
  5. Run the import and check the migrated products.

Reseñas

25 de noviembre de 2024
This is the best plugin, and their support is stellar also, but they need some time to respond to you, it won;t happen immediately. All in all, their plugin is battle tested throughout some years, and they keep it up to date with every update of wordpress core and woocommerce!This is the best import plugin you will find for wordpress, woocommerce and a slew of other data like ACF fields or users.
22 de septiembre de 2024
Good support always aviable Just it’s a little enoying that every time you have to give access credentials
Leer todas las 260 reseñas

Colaboradores y desarrolladores

“Import Products from any XML, CSV or Excel to WooCommerce” es un software de código abierto. Las siguientes personas han colaborado con este plugin.

Colaboradores

Registro de cambios

1.5.3

  • bug fix: don’t block use of HPOS

1.5.2

  • improvement: update upgrade links

1.5.1

  • bugfix: some output not properly sanitized
  • bugfix: update only these attributes option doesn’t work in some cases
  • bugfix: import attributes with < and > characters doesn’t work properly
  • bugfix: not possible to import “0” as an attribute value

1.5.0

  • bug fix: attributes with < and > characters weren’t imported correctly

1.4.9

  • bug fix: product_shipping_class taxonomy not updated

1.4.8

  • bug fix: downloadable permissions wan not imported correctly

1.4.7

  • bug fix: matching linked products didn’t work properly, this functionality moved to the end of import process
  • bug fix: import download limit and download expiry are set to 1, instead of being provided empty values
  • bug fix: featured image not updated when only “Images” is set to be updated in “Choose which data to update”

1.4.6

  • improvement: compatibility with WordPress 5.5

1.4.5

  • improvement: updated tested up to version

1.4.4

  • API: add wp_all_import_regenerate_lookup_tables filter to control lookup tables generation

1.4.3

  • bug fix: lookup table not updating after import
  • bug fix: attributes not re-counting after import

1.4.2

  • bug fix: grant incorrect downloadable product permissions
  • bug fix: update attributes with non utf-8 characters

1.4.1

  • bug fix: re-import options not rendering correctly

1.4.0

  • improvement: notice on plugin activation when WooCommerce Add-On Pro installed
  • improvement: match cross-sell products by title
  • bug fix: shipping class not imported properly in some cases

1.3.9

  • bug fix: do not execute product import code when importing other post types

1.3.8

  • bug fix: stock status not importing properly when _backorders custom field is not set
  • bug fix: product dimensions won’t import if ‘Virtual’ field is not set
  • bug fix: compatibility fix WooCommerce 2.6.x
  • bug fix: remove deprecated function calls for PHP 7.2 compatibility
  • bug fix: unable to import 0 as a value for attributes
  • bug fix: mirror new WooCommerce core behavior that forces all uncategorized products to be assigned to the Uncategorized category
  • bug fix: import attributes with special characters
  • bug fix: recount product terms when updating post status

1.3.7

  • improvement: added new filter wp_all_import_recount_terms_after_import
  • bug fix: compatibility with woo commerce 2.6
  • bug fix: do not update stock_status if _stock is not set to update

1.3.6

  • improvement: added ‘WooCommerce Advanced Options’ to re-import section
  • bug fix: variations title
  • bug fix: import first variation image
  • bug fix: updating featured product status
  • bug fix: WPML & link all variations option conflict
  • bug fix: add _price field for each variation
  • bug fix: terms re-count

1.3.5

  • bug fix: import product attributes

1.3.4

  • bug fix: import product visibility WC 3.0
  • bug fix: stock threshold

1.3.3

  • improvement: compatibility with WC 3.x

1.3.2

  • bug fix: updating product gallery
  • bug fix: import shipping class

1.3.1

  • improvement: compatibility with PHP 7.x

1.3.0

  • improvement: updated post types dropdown

1.2.9

  • fixed ucwords attributes names
  • fixed tooltips & css for woo 2.6 compatibility

1.2.8

  • fixed updating stock qty with disabled manage_stock import

1.2.7

  • fixed compatibility with WPML ( import multilingual attributes )
  • added possibility to import up & cross sells by product SKU, ID, Title

1.2.6

  • fixed setting up shipping class to -1 when «No shipping class» option chosen

1.2.5

  • fixed conflict between options [update only these custom fields & update only these attributes]
  • added feature to dynamically set attribute options
  • added new option “Convert decimal separator to a period”

1.2.4

  • added Variation Description field
  • added auto create shipping classes
  • removed ‘Virtual’ and ‘Downloadable’ checkboxes
  • hide ‘Downloadable’ settings if product not downloadable

1.2.3

  • fixed import total_sales

1.2.2

  • fixed import stock status for negative qty
  • fixed import shipping class when their slugs presented as numeric values

1.2.1

  • fixed css styles
  • added compatibility with woocommerce 2.3

1.2.0

  • IMPORTANT: WP All Import v4 (3.2.0) is a MAJOR update. Read this post before upgrading: (http://www.wpallimport.com/2014/11/free-version-wordpress-org-update-information)
  • speed up the import of taxonomies/categories
  • updated design
  • new option – adjust prices (mark up, mark down, convert currency)
  • added preview prices feature
  • fixed importing of menu order

1.1.6

  • fixed saving shipping class option
  • fixed import product attributes

1.1.5

  • fixed updating shipping class
  • fixed updating tax class

1.1.4

  • fixed automatic fixing of improperly formatted prices
  • fixed php notices
  • updated css for compatibility with wocommerce 2.1
  • added download type option
  • added file names option

1.1.3

  • Fixed price conversation

1.1.2

  • Compatibility with WooCommerce 2.1
  • updated price filter

1.1.1

  • Compatibility with WooCommerce 2.1
  • CSS fixes

1.1.0

  • Compatibility with WP 3.8

1.0.1

  • Fixed import product shipping class
  • Fixed import attributes;
  • Added SKU auto generation options;
  • Updated parsing price, now plugin will delect price correctly even it present with currency symbol, like $100.20

1.0

  • Official release on WP.org. Enhanced session handling.

0.9

  • Initial release on WP.org.