前言介紹
- 這款 WordPress 外掛「Product Excel Import & Export for WooCommerce」是 2016-05-13 上架。
- 目前有 2000 個安裝啟用數。
- 上一次更新是 2024-11-20，距離現在已有 164 天。
- 外掛最低要求 WordPress 3.0.1 以上版本才可以安裝。
- 外掛要求網站主機運作至少需要 PHP 版本 8.1 以上。
- 有 30 人給過評分。
- 還沒有人在論壇上發問，可能目前使用數不多，還沒有什麼大問題。
外掛協作開發者
taz_bambu | productexcelimport |
外掛標籤
bulk import | excel import | product export | product import | import products |
內容簡介
這個 WordPress 外掛可以讓您使用 Excel 批量進出 WooCommerce 產品 - 無限支援普通產品。
使用 Excel 輕鬆更新既有的普通產品！
按下按鈕即可透過 Excel 匯出您的 WooCommerce 普通產品
資料映射 - 輕鬆將 Excel 欄位拖曳至產品欄位。不再為 CSV 檔案煩惱！
Ajax 驅動的外掛程式可以進口產品，非常容易使用。所有資料將立即實施，無延遲或不精確。
進口產品和更新產品功能是基於輸入在 Excel 欄位中的產品標題。
最後，使用 Excel 匯入產品分類樹後使用您的產品。
這個外掛的PRO 版本讓您可以使用 Excel 進出 WooCommerce 的產品之一產品可以是多變的，具有多個屬性，包括產品圖像和產品圖庫圖像，導入自訂欄位的圖像和庫，**通過 ID、SKU 或標題更新產品。此外，還支援 WPML 和多語言支援以進口產品，進口WooCommerce 訂閱產品，使用 CRON 工作排程產品進口並建立進口模板以節省時間，以及使用 Excel 匯入產品類別和它們的圖像！
如果您需要訂單進口 - 訂單出口，優惠券進出口，評論和產品進口/出口捆綁，請點擊此處
如果您需要批量編輯 + Excel 匯入器，請點選此處
如果您需要任何內容型態的 Excel 匯入器，請點選此處
如果您需要使用 Excel 進出用戶和客戶，請點選此處
如果您需要使用 Excel 和自動更新的庫存管理，請點選此處
如何使用
創建 Excel 或使用外掛程式設置頁面中的樣本與 tou 數據 - 第一行是標題，例如標題，第二行將具有產品標題。使用一行每個產品。每個欄位代表一個欄位來與您的產品一起導入。
在產品 Excel 匯入和出口設置頁面上上傳 Excel 檔案。
一旦您上傳，您將看到一個畫面，您可以從其中的 Excel 將資料映射到 WooCommerce 的產品欄位。
點擊上傳並等待。批量產品進口將無任何麻煩運作！
支援
標題
文章狀態 - 新
說明
短描述 - 摘要-新
產品類別（多個逗號分隔）
產品標籤（多個逗號分隔）
權重
SKU
定價
特價
庫存
作者 ID
網址- Slug
原文外掛簡介
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.
MAIN FEATURES
Product Import Simple Products with Excel
Product Update Simple Products with Excel easily , stock inventory and prices updates.
Product Export for Woocommerce of your Simple Products in Excel – by the hit of a button!
Filter Product Exports by keyword
Import Product Categories tree with excel – Independently from products to create your product categories hierarchy for your Eshop.
Data mapping – Drag and drop Excel Columns to Product Fields easily. No More Hassle with CSV’s!
Automatch feature – The plugin can automatically map excel columns to the relevant product fields based on label names.
OTHER FEATURES
define user role to use the plugin apart from admin
You need to Import / Export Variable Products?
The PRO Version of this wp plugin allows you to do Product Import Export for WooCommerce, Simple or Variable with Multiple Attributes, import Images & Galleries for custom fields – acf pro, update products by ID, SKU or TITLE. Moreover, WPML compatibility and multilingual support for product import , Import WooCommerce Subscription Products , Schedule Product Import with CRON Job and create Import Template to Save Time, import Product Categories with their Images, all using Excel!
How to
Create an excel or use the sample from plugin setting’s page with tou data – 1st row is the heading eg. 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.
Upload the excel file on Product Excel Import & Export for WooCommerce settings page.
Once you upload, you will see a screen where you can map the data from the excel to the product fields of WooCommerce.
Click Upload and wait. Product Import in Bulk will function with no hassle!
Lastly, added “wpeieWoo” user capability for admin, you are free to set this capability either programmatically or with a plugin like ‘User Role Editor’.
Video Instructions
PRO VERSION
PRODUCT IMPORT – SIMPLE & VARIABLE – You can upload simple products with attributes or variables, along with their attributes and their images!
Import WooCommerce Subscription Products
Support for WPML WooCommerce Product Translations Import with Excel
Import / Export Affiliate/External products
Import Product Featured image
Import Product Image Gallery
Schedule Product Import / Update with CRON JOB
Save Template for Product Import to save time
UPDATE SIMPLE & VARIABLE PRODUCTS – Through WooCommerce Product Excel Importer Premium, users are free to update those products with simple attributes and variables.
Define which attributes will be used for your Variable Products during Import
Update by Product ID, SKU or Title. You can easily export get the necessary fields and update back.
PRODUCT IMPORT – SIMPLE PRODUCTS WITH ATTRIBUTES: add multiple attributes,comma separated, this means you need only one Excel row for each product!
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!
FIELDS SUPPORTED: User preConfigured Attributes, User preConfigured Custom Taxonomies, length, width, height, downloadable, download url, download expiry, download limit, virtual, purchase note, crossell ids, upsell ids, purchase note, backorders, sold individually, featured, tax class, tax status, stock status, shipping class
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
Import / Export YOAST SEO Meta Product fields, like META TITLE, META DESCRIPTION
Compatible with YITH WooCommerce Color and Label Variations
Compatible with Additional Variation Images Gallery for WooCommerce
Compatible with Perfect Brands for WooCommerce
Compatible with Variation Swatches for WooCommerce
IMPORTS CUSTOM TAXONOMIES – along with product creation you can import terms for any custom taxonomy which is pre assigned to post type product.
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
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.
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.
DELETE CATEGORY TERMS THROUGH EXCEL FILE
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!
HTML SUPPORT for PRODUCT EXCERPT – directly from an excel column you can right html to import as content for your product exceprt. As simple as that!
Set Default Attribute Combination for Variable Products
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
— Last but not least, define which WordPress role will access the plugin apart from Admin straight in settings page
PRO VERSION DEMO user:demo – pass:demo
Get it Here
Check our other Plugins
Orders Import – Orders Export, Coupons Import Export, Reviews & Products Import/Export Bundle
Bulk Edit + Excel Importer
Excel Importer for Any Content Type
Users & Customers Import Export with Excel
Stock Manager with Excel & Auto Updates
各版本下載點
- 方法一：點下方版本號的連結下載 ZIP 檔案後，登入網站後台左側選單「外掛」的「安裝外掛」，然後選擇上方的「上傳外掛」，把下載回去的 ZIP 外掛打包檔案上傳上去安裝與啟用。
- 方法二：透過「安裝外掛」的畫面右方搜尋功能，搜尋外掛名稱「Product Excel Import & Export for WooCommerce」來進行安裝。
（建議使用方法二，確保安裝的版本符合當前運作的 WordPress 環境。
1.0 | 1.1 | 1.2 | 1.3 | 1.4 | 1.5 | 2.0 | 2.1 | 2.2 | 3.0 | 5.8 | 5.9 | 6.0 |
延伸相關外掛（你可能也想知道）
Import Content in WordPress & WooCommerce with Excel 》想做網站遷移但不想逐一添加內容嗎？需要從一個螢幕批量編輯內容嗎？現在你可以使用拖放功能從 Excel 文件中將內容導入 WordPress 了。, , 使用 Excel 導入帖...。
Import Users to IContact 》將 WordPress 與 iContact 整合的絕佳工具, 此外掛將添加「導入」按鈕到用戶清單中，管理員也可以批量將所有用戶導入到 iContact。。