Smart Product Import Export for WooCommerce

By Sandeep Parihar

0+ active installationsVersion 1.0.4

Import and export WooCommerce products and reviews via CSV, Excel, XML, FTP/SFTP, or URL - with mapping, validation, and background.

Description

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
  • Scheduled Imports & Exports: Automatically run imports and exports hourly, daily, or weekly in a timezone of your choice
  • 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)

Installation

  1. Upload the plugin files to /wp-content/plugins/parihar-importer-for-woocommerce/ or install through the WordPress plugins screen.
  2. Activate the plugin through the ‘Plugins’ screen in WordPress.
  3. Ensure WooCommerce is installed and active.
  4. Navigate to Products > Product Import/Export to start using the plugin.

FAQ

Does this plugin require WooCommerce?

Yes, WooCommerce must be installed and active.

What CSV format is supported?

The plugin supports CSV files with comma, semicolon, tab, or pipe delimiters. UTF-8 and UTF-8 BOM encodings are supported.

Can I import XML files?

Yes. Upload an XML file whose root element is <products>, containing one <product> element per product with child elements such as <id/>, <name/>, <sku/>, <price/>, <description/>, <category/>, <quantity/>, and <status/>. Elements are auto-mapped to WooCommerce product fields during preview.

Can I import Excel (.xlsx) files?

Yes. Upload an .xlsx workbook whose first worksheet contains a header row with column names, followed by one product per row. Blank cells are treated as empty values, and the same validation and mapping steps apply as for CSV imports. Products can also be exported as .xlsx from the export screen.

Can I import from or export to an FTP/SFTP server?

Yes. Both screens include an FTP / SFTP section where you can enter the protocol (FTP, FTPS, or SFTP), host, port, username, password, and the remote file path or destination directory. Import files are fetched into the regular import flow, and completed exports can be pushed to the remote server; the destination directory must already exist. SFTP requires the PHP SSH2 extension on the server. Connection details are used only for the duration of the transfer and are never stored or written to logs, and connection or authentication failures are reported without exposing credentials.

Can I import products from a URL?

Yes. Open the Import from URL section on the import screen and paste a link. If the URL points to a CSV, Excel (.xlsx), or XML file, it is downloaded and validated, then continues through the regular preview and mapping flow. If the URL points to a product page, the product details (name, SKU, price, description, and images) are extracted automatically from the page’s schema.org Product data (JSON-LD) or OpenGraph meta tags, and you review them like any other import. URLs are validated before the request is made — only public HTTP/HTTPS addresses are allowed, and private or local addresses are blocked (SSRF protection). Clear errors are reported when the page cannot be reached, the server returns an HTTP error, or no product details could be extracted from the page.

Can I schedule imports and exports to run automatically?

Yes. Open Schedules under Product Import/Export to create schedules that run hourly, daily, or weekly at a set time in a timezone you choose. Scheduled imports use a saved supplier file, a URL that is fetched fresh on every run, or an FTP/FTPS/SFTP download together with a saved mapping; products are matched (by SKU by default) and only the mapped fields are updated, so recurring stock/price files update existing products instead of creating duplicates. Scheduled exports pick the product data and file format (CSV, Excel, or XML) and generate the file automatically at the scheduled time, optionally uploading it to an FTP/FTPS/SFTP destination afterwards. Each run is recorded in the schedule history with its time, status, records processed, and errors, and you can configure a failure alert email (alerts never contain credentials or connection details). Overlapping runs are prevented automatically, and failed runs are retried a limited number of times before an alert is sent.

Do scheduled runs work if my store has no visitors?

WordPress cron (WP-Cron) is triggered by visits to your site, orders, and other traffic — scheduled runs may be delayed on stores with little or no traffic. For reliable timing, disable WP-Cron by adding define("WP_CRON", false); to wp-config.php and create a system cron job (or a scheduled task on your server) that hits your site every minute.

If Action Scheduler is available (it ships with WooCommerce), scheduled runs are queued through it for more reliable background processing.

Are FTP/SFTP passwords stored for schedules?

Yes — unattended scheduled runs need the connection details on hand, so schedule credentials are stored in the database to be used at run time only. They are never displayed again after saving, never written to logs, and never included in history entries, failure alerts, or emails. For one-off transfers started manually from the import/export screens, nothing is stored at all.

Can I import and export product reviews?

Yes. Both the import and export screens include an “Import Type” / “Export Type” selector where you can switch between Products and Product Reviews. Review exports support CSV, Excel, and XML and can be filtered by review status (approved, pending, spam, trash) and review date range. For imports, upload a file with review columns such as review ID, product SKU or Product ID, reviewer name, email, review content, rating (1-5), date, status, website, IP address, and verified owner; the columns are auto-mapped to review fields during preview. Every row is validated before the import runs — rows that are invalid (for example a missing reviewer, an invalid rating, or a product that does not exist) or that duplicate an existing review (matched by review ID, or by product and reviewer email) are reported and skipped or failed according to your duplicate and error handling settings.

Can I import variable products with variations?

Yes, the plugin fully supports variable products and their variations. Parent products and variations can be imported in the same CSV file.

Is there a size limit for CSV files?

The default maximum file size is 100MB, but this can be adjusted in the plugin settings.

Can I save and reuse field mappings?

Yes, you can save field mappings and load them for future imports.

Does the plugin process large files in the background?

Yes, files with more than 100 rows are processed in the background using Action Scheduler or WordPress cron.

Screenshots

Changelog

1.0.4

  • Scheduled exports save generated files locally when no remote destination is configured, with a Download button in the schedule history for later retrieval; export files are automatically cleaned up after the configured expiration period (default 24 hours)
  • Improved schedule history display — export runs now show file format, creation time, and a Download link for locally generated files
  • File expiration setting added to Settings > General to control how long export files remain available for download

1.0.3

  • Added import and export functionality for product data in Excel (.xlsx) format
  • Added FTP/SFTP file transfers – import files from and export files to FTP, FTPS, and SFTP servers with configurable connection details
  • Added product import from URLs – provide a URL pointing to a CSV, Excel, or XML file or to a product page (name, SKU, price, description, and images extracted, URLs are validated with SSRF protection
  • Added product review import and export – import and export WooCommerce product reviews in CSV, Excel, or XML format
  • Added scheduled imports and exports – run hourly, daily, or weekly in any timezone with pause/resume/delete, run history with per-run record counts and errors, overlap prevention with retries, and failure alert emails

1.0.2

  • Added import and export functionality for product data to XML format
  • Warning Modal Popup – Enhanced UI (fixed viewport height, custom scrollbar, sticky column headers)
  • Product Import Count Limitation (CRITICAL) – validation now reports the accurate total product count instead of stopping at the first 100 rows
  • Warning Details Display (UX IMPROVEMENT) – clickable warnings link opens a modal listing row number, SKU, warning message and suggested fix

1.0.1

  • Initial release
  • CSV import and export for all WooCommerce product types
  • Field mapping with auto-mapping
  • Background processing for large files
  • Validation and error reporting
  • Saved mappings
  • Security hardening