
Smart Product Import Export for WooCommerce provides a powerful yet easy-to-use interface for importing and exporting WooCommerce products via CSV, Excel (.xlsx), or XML files. Files can be uploaded from your computer, fetched from an FTP/SFTP server, or imported directly from a URL — pointing either at a data file or at a product page whose details are extracted automatically. Product reviews can be handled the same way: pick “Product Reviews” as the import or export type and move review data (reviewer, email, review text, rating, date, status, and the product it belongs to) with the same mapping, validation, and background processing.
Features
- CSV, Excel & XML Import / Export: Upload CSV, Excel (.xlsx), or XML files via drag-and-drop; export products as CSV, Excel, or XML
- Product Review Import / Export: Import and export product reviews in CSV, Excel, or XML – map reviewer name, email, review content, rating, date, status, verified flag, IP address, and the product SKU or ID; review data is validated and skipped or invalid rows are reported
- FTP / SFTP File Transfers: Fetch import files from and push export files to FTP, FTPS, and SFTP servers with configurable connection details; credentials are used only for the transfer and never stored
- Import from URL: Provide a URL to import products — a CSV, Excel, or XML file at the URL is downloaded and validated, while a product page URL has its details (name, SKU, price, description, images) extracted automatically from schema.org Product data or OpenGraph meta tags; URLs are validated with SSRF protection and clear errors are reported when the page cannot be accessed or product details cannot be extracted
- Flexible Field Mapping: Map file columns to WooCommerce product fields with auto-mapping support
- Product Type Support: Simple, Variable, Variation, Grouped, External/Affiliate, Virtual, and Downloadable products
- Bulk Processing: Background processing for large files with configurable batch sizes
- Validation: Pre-import validation with detailed error reports
- Duplicate Handling: Multiple strategies for handling existing products (update, skip, create, fail)
- Categories, Tags & Attributes: Automatic creation of missing terms
- Image Import: Download and attach remote images from URLs
- Saved Mappings: Save and reuse field mappings for recurring imports
- Export Filters: Filter products by type, status, category, stock status, created date range, and more
- Security: Capability checks, nonces, sanitization, and SSRF protection
- Error Reporting: Detailed error logs with downloadable error CSV
Supported Product Types
- Simple products
- Variable products with variations
- Grouped products
- External/Affiliate products
- Virtual products
- Downloadable products
- Custom product types via adapter system
Requirements
- PHP 8.1 or higher
- PHP 8.5 compatible (tested)
- PHP Zip extension (bundled with PHP; required for Excel .xlsx support)
- WordPress 6.6 or higher
- WooCommerce (current stable version)
Screenshots

Import page with file upload and drag-and-drop

CSV preview

Field mapping interface

Import options and validation

Progress tracking during import

Export configuration

Import/export history

Plugin settings