Import Products from any XML, CSV or Excel to WooCommerce

Описание

“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.

Связанные плагины

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

Поддержка

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.

Скриншоты

  • The WooCommerce add-on.

Установка

First, install WP All Import.

Затем установите надстройку WooCommerce.

To install the WooCommerce add-on, either: —

  • Загрузите плагин со страницы Plugins в WordPress
  • Разархивируйте woocommere-product-import-add-on-for-wp-all-import.zip и загрузите содержимое в /wp-content/plugins/, а затем активируйте плагин на странице «Плагины» в WordPress.

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

Часто задаваемые вопросы

Как импортировать товары WooCommerce?

  1. Перейдите к «Весь импорт» > «Новый импорт» / All Import › New Import.
  2. Загрузите файл импорта.
  3. Выберите товары WooCommmerce в качестве типа импорта.
  4. Сопоставьте элементы входящих данных с полями товара.
  5. Запустите импорт и проверьте импортированные данные.

Как импортировать изображения товаров в WooCommerce?

  1. Перейдите в раздел «Весь импорт» > «Новый импорт» / All Import › New Import.
  2. Загрузите файл импорта.
  3. Выберите товары WooCommmerce в качестве цели импорта.
  4. Сопоставьте элементы входящих данных с полями товара.
  5. Включите данные изображения товара в процесс сопоставления.
  6. Запустите импорт и проверьте импортированные данные.

Как импортировать атрибуты товара в WooCommerce?

Чтобы импортировать атрибуты продукта в WooCommerce, используйте вкладку «Атрибуты» раздела «Дополнения WooCommerce» на панели «Drag & Опустить экран». Это позволит сопоставить входящие элементы данных атрибутов с соответствующими полями атрибутов продукта.

Как добавить новые варианты к существующим вариативным товарам в WooCommerce?

  1. Перейдите в раздел «Весь импорт» > «Новый импорт» / All Import › New Import.
  2. Загрузите файл импорта с новыми вариантами.
  3. Выберите «Товары WooCommerce» в качестве типа записи импорта.
  4. Сопоставьте элементы входящих данных с полями товара.
  5. Используйте опцию «Я импортирую новые варианты существующих товаров».
  6. Запустите импорт и просмотрите импортированные товары.

Могу ли я импортировать любой тип товара WooCommerce?

Да. Вы можете импортировать любой стандартный тип товара WooCommerce, включая простые товары, вариативные товары, простые товары по подписке, сгруппированные товары и партнерские товары. Просто укажите тип товара во время процесса импорта.

Как импортировать товары WooCommerce из файла CSV или Excel?

Чтобы импортировать товары WooCommerce из файла CSV или Excel, просто укажите исходный файл. WP All Import автоматически распознает тип файла и соответствующим образом настроит его интерфейс.

Как импортировать товары WooCommerce из XML-файла?

Чтобы импортировать товары WooCommerce из XML-файла, просто загрузите этот файл. Наше программное обеспечение автоматически идентифицирует узлы XML и позволит вам импортировать их из любого макета XML, независимо от его сложности.

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.

Как импортировать ленту товаров в WooCommerce?

Загрузка товара обычно организуется вокруг URL-адреса или источника импорта FTP/SFTP. Наш плагин справится и с тем, и с другим. Просто выберите «Загрузить файл › по URL-адресу» или «Загрузить файл › по FTP/SFTP» и укажите информацию, необходимую интерфейсу.

Как перенести товары WooCommerce?

  1. Экспортируйте товары WooCommerce, которые вы хотите перенести.
  2. Скачайте файл пакета, содержащий инструкции по импорту.
  3. Загрузите файл пакета на целевой, нужный вам сайт.
  4. WP All Import будет использовать файл пакета для своей настройки.
  5. Запустите импорт и проверьте перенесенные товары.

Отзывы

02.05.2025
Works incredibly well and support is fantastic (and fast); I had a small issue where it turned out my Query Monitor plugin was in conflict; I disabled it and voila! Product uploaded in no time, turned QM back on, and all is good with the world. Onya guys!
11.04.2025
I am using this plugin with the woocommerce add-on and it’s doing its job for an eCommerce online catalog that is currently in development. The tech support people have been very helpful answering questions relating to the import process and how to structure the import file. Very happy with this plugin.
06.04.2025
This plugin is great! I use it for Woocommerce Product imports and it’s very easy to use. Me not being the smartest when it comes to IT/coding, the drag & drop features help a ton. The interface is very intuitive. Their customer support is also fantastic and the reply times are super fast! 10/10 recommend
24.03.2025
worked perfecly with a large csv file! thank you!
Посмотреть все 270 отзывов

Участники и разработчики

«Import Products from any XML, CSV or Excel to WooCommerce» — проект с открытым исходным кодом. В развитие плагина внесли свой вклад следующие участники:

Участники

Журнал изменений

1.5.4

  • improvement: add ‘GTIN, UPC, EAN or ISBN’ field

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.