內容簡介
WDOnline Product CSV Manager for WooCommerce 是一款專為 WooCommerce 設計的外掛，幫助使用者精確匯出所需的產品數據，避免不必要的自訂元資料欄位，提升產品管理效率。
【主要功能】
• 精選 WooCommerce 標準欄位及自訂元鍵
• 支援按名稱或前綴搜尋元欄位
• 隱藏空欄位而不影響選擇
• 儲存、編輯及刪除可重用的匯出設定檔
• 依產品類別及狀態過濾
• 支援 UTF-8 CSV 檔案匯入與匯出
外掛標籤
開發者團隊
② 後台搜尋「WDOnline Product CSV Manager for WooCommerce」→ 直接安裝（推薦）
原文外掛簡介
Plugin details and documentation: https://wdonline.dk/wdonline-product-csv-manager-for-woocommerce/
WDOnline Product CSV Manager for WooCommerce helps you export exactly the product data you need, without exporting every custom meta field on your shop.
Select WooCommerce standard columns and individual custom meta keys.
Search meta fields by exact name or prefix and see rows with content and a sample.
Zero values are retained. Hide empty fields without losing selections.
Optionally omit selected meta columns that are empty throughout the selection.
Save, edit, copy, and delete reusable export profiles. Mark individual profiles or select all for bulk deletion.
Reorder columns by drag and drop or accessible move buttons.
Filter by product categories and their subcategories, parent product types, statuses, and specific products found by name, SKU, or ID.
Include variations as separate rows, with parent references in WooCommerce’s native format.
Analyze products in batches automatically when previewing or downloading. Preview is optional.
Download UTF-8 CSV with comma or semicolon delimiters.
Access is restricted to catalog managers. Export snapshots and uploaded CSV data have no public file URL.
Import UTF-8 CSV files with native column mapping, scalar custom meta, and create/update modes.
Resume uploads and imports after a stopped request or a closed browser.
Download a complete row results report with failed/skipped rows.
Administration is available under Products > Product CSV Manager. The plugin works independently, with WooCommerce as its only required plugin dependency.
First export
Choose Products, then filter the selection or leave categories/types empty to export all products with the selected statuses. Published is the default.
Choose fields to select product columns. Use Find meta fields to discover custom fields, or expand Add a field by its key to enter an exact key.
Choose Review export. Drag selected columns into order and choose the separator, then preview the first ten rows or download CSV directly.
Save these settings as a profile is available below every export step. Save the selection for next time, update the loaded profile, or save a new copy without moving to the last step.
Load a profile from the bar at the top to go directly to review/download. You can revisit Products or Fields at any time. New export resets the workflow.
The export status shows preparation and CSV writing separately. CSV writing counts snapshot rows visited, including rows skipped because their data or permissions changed. Once the server finishes sending the CSV, check your browser downloads for the saved file.
The ID selection is frozen when analysis starts. Data is captured in batches and can reflect edits made while analysis is running. Preview and download read the captured snapshot. Reanalyze to refresh it. Deleted products or revoked access can cause rows to be skipped.
Resumable CSV import
Open Import and select a UTF-8 CSV (comma or semicolon). Upload new CSV sends 96 KB chunks, avoiding a single large upload request.
Review the native auto-mapping. Choose Do not import for columns you want to leave untouched. Update existing products only is the default. You can also create only, or create and update.
New products/variations require a non-empty unique SKU so a saved row can be identified after a lost response. Update-only imports can match by SKU or a local product ID. IDs belong to the current site: skip ID when moving products between sites.
Import parent variable products before variations. Parent/related product references must already exist, using SKU or id: references; unresolved references fail the row instead of creating placeholders.
Start / resume import processes up to five rows per request by default, with a checkpoint after each row and an eight-second budget between rows. Set one row per request for slow images. A single image download or third-party hook can still exceed a hosting timeout.
Pause after current request stops the browser loop after the current request. If a network request fails, reopen Import, choose the saved run, Load saved run, and Start / resume import. Progress comes from the server, not the browser. Incomplete uploads require the original file again; already uploaded chunks are compared byte-for-byte before missing chunks are stored.
Follow the progress bar and CSV percentage, based on bytes processed (not an estimated number of products). Review created/updated/failed/skipped counts. The latest twenty row errors/skips appear on screen; Download results report includes all processed rows. Failed rows are recorded and processing continues. Correct those rows and import a corrected CSV separately; completed jobs do not automatically retry failures.
Imports require catalog management and product publishing rights, and object access is checked for existing/related products. Image mapping additionally requires upload_files. File/mapping review does not change products; starting the import does. Mapped blank values follow WooCommerce’s importer and may clear fields, while unmapped fields remain untouched.
Each import belongs to its uploader. Jobs use connection-owned database mutexes to prevent overlapping requests for the same run. Row receipts and temporary product markers recover completed saves if an acknowledgement/checkpoint was interrupted. This does not provide a transaction or guarantee that third-party hooks/image side effects run exactly once after an interruption during a save. Imported product changes are not rolled back when a run is paused or deleted.
Limits: 250 MB per CSV, 2,000 unique headers, 4 MB per CSV record, 1–25 rows per request, and twenty retained imports per user. Source data is kept as private database chunks, not public uploads. Memory use is bounded by the current record rather than the whole file. Hosting/database capacity still applies. Incomplete runs expire seven days after last activity; completed source CSV chunks are removed immediately and row results retained for seven days. Delete selected import data removes that run’s upload/results without deleting imported products. Deactivation retains imports for resuming after reactivation. Hourly/opportunistic cleanup removes expired data.
CSV and field safety
When WDOnline Quantity Discounts is active, map Meta: _wdonline_qd_quantity_discounts to import direct quantity prices such as 2|14.00;3|11.00. Edited prices update the rule-builder data as fixed unit prices, including on variations. Unchanged exported prices preserve existing percentage rules, even when the regular price is updated in the same row. A mapped empty cell removes the direct rules; category discounts may still apply. Invalid tiers fail the row before product changes are saved. Discount fields set to Do not import remain untouched.
Standard column headers and attribute/download groups follow the installed WooCommerce exporter. Custom meta uses Meta: key headers. Prices use stored decimal values rather than localized display formatting. Descriptions use WooCommerce’s native newline convention.
Repeated meta records and serialized, array, or object values are blocked for ordinary export. Internal and potential credential fields are blocked, including manually added keys. Unknown field ownership is not inferred from its prefix. Fields may contain sensitive text: only select data appropriate for your intended use.
Formula-like text is prefixed with an apostrophe for spreadsheet safety. Numeric negative values are preserved. This protection can affect how literal formula-like text is reimported; check those values before importing. Export does not change product data. Import changes mapped fields using WooCommerce’s normal behavior.
Privacy and retention
Analysis temporarily stores product snapshots and authorized field examples in two local database tables. Snapshots expire after one hour of inactivity. Access is refused after expiration; physical cleanup happens through hourly WP-Cron or the next analysis. Cancelling a job or deactivating the plugin removes temporary snapshots. Deactivation retains profiles, settings, and resumable import jobs; uninstall deletes this plugin’s tables, profiles, settings, CSV uploads, receipts, and operational product recovery markers. Imported products and their custom data remain.
No telemetry or analytics is sent to external services. Importing image URLs contacts the specified image hosts through WooCommerce’s normal image downloader. The support button opens PayPal only when clicked. Optional diagnostic hooks expose technical version/dependency/schema information and error codes, without product values or customer information. WD Online Support Diagnostics is not required.
Scope and limits
This version includes selective export and resumable CSV import using WooCommerce’s native field parsing and product CRUD. Imports update products immediately; there is no automatic rollback.
Only the classic WordPress post/postmeta product storage is supported. No external product storage adapter is included. Category selections include all descendant categories at every level. Variation type/category filters use the parent; both row and parent statuses must match. Selecting a variation exports only that variation when variations are enabled.
There is no fixed product-count cap. Safety limits are 2,000 discovered meta keys, 2,000 standard/dynamic headers, 4 MB per snapshot row, 500 specific product IDs, and 100 saved profiles. Processing time and database space depend on the catalog and hosting. Reduce the batch size on slow hosting. Final CSV download is streamed; very large downloads may still be limited by a hosting or proxy timeout.
Profiles use explicit field selections and retain keys absent from a current product selection. New fields are never automatically added. Profiles are shared with authorized catalog managers on the same site.
Support WD Online
Enjoying WDOnline Product CSV Manager for WooCommerce? You can help support its continued development.
Support via PayPal or card: https://www.paypal.com/ncp/payment/NKERMAVC4PXML
