Linux 软件免费装
Banner图

WordPress Product Excel Import & Export for WooCommerce

开发者 taz_bambu
productexcelimport
更新时间 2024年9月17日 12:23
捐献地址: 去捐款
PHP版本: 5.2.4 及以上
WordPress版本: 6.6.2
版权: GPLv2 or later
版权网址: 版权信息

标签

export products import products product import excel import bulk import product export

下载

2.2 3.0 2.0 1.1 5.8 5.9 1.4 1.2 1.0 1.3 1.5 2.1

详情介绍:

With this WordPress plugin you can do Product Import & Export for Woocommerce in Bulk with Excel instantly. Unlimited import/updates of Simple products along with their images is possible as the process works in batched to avoid PHP memory limits. Export your WooCommerce products in excel file to later do Inventory Stock Updates or change your Prices in bulk.

安装:

  1. Upload the plugin files to the /wp-content/plugins directory and unzip, or install the plugin through the WordPress plugins screen directly.
  2. Activate 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.

屏幕截图:

  • WordPress Product Excel Import & Export data mapping
  • WordPress Product Excel Import & Export mapped data
  • WordPress Product Excel Import & Export Functionality

升级注意事项:

1.1 Fix bug with empty excel columns 1.2 Functionality to add multiple categories or tags from one cell comma separated Fix UI Avoid css conflicts 1.3 Properly refresh the view for price changes for products - delete product_transients. 1.4 If description column not selected, during update previous content will be preserved 1.5 Drag n Drop for Excel Files 1.6 Short Description field - Excerpt support for import 1.7 Bug fix for decimal values on weight, prices etc. 2.0 Check Wordpress 5.0 compatibility. Check latest woocommerce version compatibility. Added Features: Import Author id, import URL Slug, Virtual Product 3.0 Export Simple Products to Excel for WooCommerce added Bug fixes on import functionality Wordpress 5.1 compatibility. 3.1 Export fix in chrome Check WooCommerce compatibility 3.6.5 3.2 changed export functionality - export directly to .xlsx 3.3 fixed php error on calculaction/functions.php checked wooCommerce 3.7 compatibility 3.5 added option to import also paretn product categories 3.6 fixed compatibility with wp 5.5 3.7 add post status to import 3.8 added capability for user other than admin to access - check compatibility 3.9 fixed export duplicates 4.0 Replace PHPExcel Library with PHPSpreadsheet 4.1 Remove Sale price by adding 0 to excel cell Fix Setting stock to zero by adding 0 to excel cell Fix updating prices and stock number with values less than zero ( 0 ) 4.2 compatibility checks, change descriptions 4.3 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.4 Fix product import index based on meta - SKU on backend - update WooCommerce table wc_product_meta_lookup 4.5 fixed set_sale price 4.6 extra check for wc_product return 4.7 added feature to import product cateogories tree with excel 4.8 fix PHP 8.06 compatibility 4.9 localization fix 5.0 check PHP 8.2 compatibility 5.1 check wp compatibility 5.2 add product Image import and export functionality fix export issues 5.3 fix export issues 5.4 fix dismiss note add product gallery import and export functionality 5.5 show signup only on plugin page 5.6 fix signup repeatedly showing check compatibility 5.7 run js due to popup 5.8 rewrite import code to insert products in chunks and avoid any php memory limit compatibility woocommerce 8.7 5.9 check woo compatibility

常见问题:

How to do product import in excel for WooCommerce?

Add one row for each product and each column will refer to a product field, such as title, description, prices, etc. Example excel provided to download through plugin's configuration scren.

Can I update the existing products for WooCommerce?

Yes, update is also supported and will be mentioned while uploading. Update is based on Title. If a title entered in an excel column exists as product in your website, this product's fields will be updated.

Can I add categories with Excel for WooCommerce Products?

Yes, 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 blank will 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.

How can I add custom taxonomies along with the product?

This feature is available in the PRO Version.

Can I add WooCommerce Product Gallery Images and Featured Image?

This feature is available in the PRO Version. = Can 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 feature is available in the PRO Version. The only prerequisite is that you have already created manually a product and pressed 'PUBLISH' after you installed and created fields with ACF or other Similar plugin, so 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 can use Orders, WooCommerce Subscriptions, Coupons, Reviews & Products shop Migration

Is plugin compatible with WPML?

WPML compatibility and multilingual support product 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 free to set 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

更新日志:

5.9 check woo compatibility 5.8 rewrite import code to insert products in chunks and avoid any php memory limit compatibility woocommerce 8.7 5.7 run js due to popup 5.6 fix signup repeatedly showing check compatibility 5.5 show signup only on plugin page 5.4 fix dismiss note add product gallery import and export functionality 5.3 fix export issues 5.2 add product Image import and export functionality fix export issues 5.1 check wp compatibility 5.0 check PHP 8.2 compatibility 4.9 localization fix 4.8 fix PHP 8.06 compatibility 4.7 added feature to import product cateogories tree with excel 4.6 extra check for wc_product return 4.5 fixed set_sale price 4.4 Fix product import index based on meta - SKU on backend - update WooCommerce table wc_product_meta_lookup 4.3 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, change descriptions 4.1 Remove Sale price by adding 0 to excel cell Fix 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 3.8 added capability for user other than admin to access - check compatibility 3.7 add post status to import 3.6 fixed compatibility with wp 5.5 3.5 added option to import also paretn product categories 3.3 fixed php error on calculaction/functions.php checked wooCommerce 3.7 compatibility 3.2 changed export functionality - export directly to .xlsx 3.1 Export fix in chrome Check WooCommerce compatibility 3.6.5 3.0 Export Simple Products to Excel for WooCommerce added Bug fixes on import functionality Wordpress 5.1 compatibility. 2.0 Check Wordpress 5.0 compatibility. Check latest woocommerce version compatibility. Added Features: Import Author id, import URL Slug, Virtual Product 1.7 Bug fix for decimal values on weight, prices etc. 1.6 Short Description field - Excerpt support for import 1.5 Drag n Drop for Excel Files 1.4 If description column not selected, during update previous content will be preserved 1.3 Properly refresh the view for price changes for products - delete product_transients. 1.2 Functionality to add multiple categories or tags from one cell comma separated Fix UI Avoid css conflicts 1.1 Fix bug with empty excel columns 1.0