Product Excel Import & Export for WooCommerce
| 开发者 |
taz_bambu
productexcelimport wpcodefactory algoritmika anbinder karzin omardabbas |
|---|---|
| 更新时间 | 2025年5月22日 17:18 |
| PHP版本: | 8.1 及以上 |
| WordPress版本: | 6.8 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
安装:
- Upload the plugin files to the
/wp-content/pluginsdirectory and unzip, or install the plugin through the WordPress plugins screen directly. - Activate the plugin through the "Plugins" screen in WordPress.
- Use the "WPFactory > Product Import Export" menu link, or "Settings" link on plugins page to use the plugin.
- Upload your excel file (there is a link for a sample excel file) and proceed to data mapping and creating your products.
屏幕截图:
常见问题:
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 category 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
更新日志:
- Fix - Translation loading fixed.
- Dev - Plugin settings moved to the "WPFactory" menu.
- Dev - "Recommendations" added.
- Dev - Code refactoring and cleanup.
- WC tested up to: 9.8.
- Tested up to: 6.8.
- PhpSpreadsheet updated to 3.4 version.
- Check woo compatibility.
- Rewrite import code to insert products in chunks and avoid any php memory limit.
- Compatibility woocommerce 8.7.
- Run js due to popup.
- Fix signup repeatedly showing.
- Check compatibility.
- Show signup only on plugin page.
- Fix dismiss note.
- Add product gallery import and export functionality.
- Fix export issues.
- Add product Image import and export functionality.
- Fix export issues.
- Check wp compatibility.
- Check PHP 8.2 compatibility.
- Localization fix.
- Fix PHP 8.06 compatibility.
- Added feature to import product categories tree with excel.
- Extra check for wc_product return.
- Fixed set_sale price.
- Fix product import index based on meta - SKU on backend - update WooCommerce table wc_product_meta_lookup.
- 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.
- Compatibility checks, change descriptions.
- 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 ).
- Replace PHPExcel Library with PHPSpreadsheet.
- Fixed export duplicates.
- Added capability for user other than admin to access - check compatibility.
- Add post status to import.
- Fixed compatibility with wp 5.5.
- Added option to import also parent product categories.
- Fixed php error on calculation/functions.php.
- Checked wooCommerce 3.7 compatibility.
- Changed export functionality - export directly to .xlsx.
- Export fix in chrome.
- Check WooCommerce compatibility 3.6.5.
- Export Simple Products to Excel for WooCommerce added.
- Bug fixes on import functionality.
- Wordpress 5.1 compatibility.
- Check Wordpress 5.0 compatibility.
- Check latest WooCommerce version compatibility.
- Added Features: Import Author id, import URL Slug, Virtual Product.
- Bug fix for decimal values on weight, prices etc.
- Short Description field - Excerpt support for import.
- Drag n Drop for Excel Files.
- If description column not selected, during update previous content will be preserved
- Properly refresh the view for price changes for products - delete product_transients.
- Functionality to add multiple categories or tags from one cell comma separated.
- Fix UI.
- Avoid css conflicts.
- Fix bug with empty excel columns.
- Initial release.