EasySecure Data Import/Export for WooCommerce

By imminentsoftwares

0+ active installationsVersion 1.1.0

Import and export WooCommerce Orders, Customers and Subscriptions using CSV and XLSX files with background job processing.

Description

EasySecure Data Import/Export for WooCommerce allows store owners to import and export:

  • Orders
  • Customers
  • Subscriptions

Features:

  • CSV Import
  • CSV Export
  • XLSX Import
  • XLSX Export
  • Background Job Processing
  • Batch Processing
  • WooCommerce Compatible
  • Secure File Handling

Import:

Imports orders, customers and subscriptions from CSV or XLSX files, in the background, with a progress bar.
Can update existing records. A file only changes the columns it contains, and importing the same file twice never creates duplicate orders.
Handles multi-item orders with shipping, fees, tax, discounts and the file’s own totals.
Reads files as Excel saves them: Day-first or Month-first dates, currency amounts like ₹1,299.00, semicolon or tab separators, older encodings and loose column names.
Sends no customer emails and leaves stock alone, unless the “Send WooCommerce emails” box is ticked.
Keeps customers’ existing passwords when moving from another store.

Export:

Exports orders, customers and subscriptions to CSV or XLSX, in the background, 250 rows at a time, so large stores work.
Order exports can be filtered by status and date.
An optional setting includes guest buyers in the customer export.

Jobs and safety:

A Jobs tab lists every import and export, shows the failed rows with a CSV download, and lets you delete old jobs.
Several jobs take turns, so a small job is never stuck behind a large one.
Export files can only be downloaded by signed-in staff. They are deleted after 7 days.
Exported files are protected against spreadsheet formula attacks.
Imports can never create or change administrator or staff accounts.

FAQ

Does this plugin require WooCommerce?

Yes. WooCommerce must be installed and activated.

Which file formats are supported?

CSV and XLSX.

Changelog

1.1.0

  • Compatibility: tested with WordPress 7.1, WooCommerce 11.2 and PHP 8.2 to 8.5.
  • Compatibility: declared support for WooCommerce High-Performance Order Storage (HPOS) and cart/checkout blocks.
  • Compatibility: minimum requirements raised to WordPress 6.8, WooCommerce 10.0 and PHP 8.2.
  • Fix: fatal “class not found” error on activation and on the settings page (job queue classes, AJAX actions and JavaScript still used the old WIE prefix).
  • Fix: PHP 8.4+ deprecation notices from CSV reading/writing; CSV lines longer than 10,000 characters are no longer cut off.
  • Fix: jobs table can now be upgraded in place on plugin updates.
  • Fix: uploads now start processing within seconds (the previous loopback request never authenticated).
  • Fix: possible error when an XLSX file fails to parse.
  • Security: export format is whitelisted to CSV/XLSX and export file names are no longer guessable.
  • Change: legacy .xls uploads are rejected with a clear message (they could never be parsed).
  • Security: CSV exports neutralise spreadsheet formulas (CSV injection); the escape is undone when the file is imported again.
  • Security: export files can only be downloaded through the authenticated download action; direct URLs are blocked and files are deleted with their job or after 7 days.
  • Security: imports can no longer change administrator or other non-customer accounts.
  • Security: job progress now requires the manage_woocommerce capability; download endpoint only serves export files.
  • Fix: exports failed on hosts where the WordPress files are owned by a different user than the web server.
  • Fix: skipped and failed rows are listed with their row number; partly failed imports show how many rows succeeded.
  • Fix: malformed CSV lines are reported instead of silently dropped.
  • Fix: re-importing an order no longer adds a second “Imported Total” fee; a refund ID used as order_id is rejected.
  • Fix: large files are queued with batched inserts (5,000 rows in under a second).
  • Fix: subscription import/export is refused up front when WooCommerce Subscriptions is not active.
  • Fix: dates from XLSX files saved in Excel (stored as serial numbers) are converted correctly.
  • New: uninstall removes the jobs table, options, scheduled events and export files.
  • Fix: orders imported with a blank billing country now get the store’s own country instead of India.
  • Security: role changes in a customer import are checked against the person who uploaded the file (promote_users), not the background worker.
  • Security: an import can only give customer-level roles. Administrator, shop manager, editor and other staff roles are never granted.
  • Privacy: WooCommerce logs now record customer and order IDs, with emails masked (j***@example.com). Full details stay in the job’s error log.
  • New: exports run in the background. The Export button queues a job, the worker writes 250 rows at a time in order, and the page shows a progress bar and then a download link, so store size no longer matters.
  • Fix: only one batch of an export runs at a time, and a batch that is interrupted is rolled back before it is retried, so rows are never duplicated or mixed up.
  • Fix: XLSX exports keep phone numbers and codes with leading zeros as text.
  • Fix: export downloads are streamed instead of being loaded into memory.
  • Fix: order and customer imports no longer send WooCommerce emails (“Order complete”, “New account”) to customers. Tick “Send WooCommerce emails” on the import form to send them.
  • Fix: importing orders no longer reduces product stock.
  • Fix: importing the same file twice no longer creates duplicate orders. Orders from another store are matched by their order key or original order ID on the next import.
  • Fix: updating orders with a partial file (for example order_id and status) only changes the columns in the file; names, addresses, items and totals are kept.
  • Fix: an unknown order status, invalid email, date, amount or quantity fails that row with a clear message instead of being saved as something else.
  • Fix: order exports include every line item, shipping line and fee (line_items, shipping_items and fee_items columns), and re-importing an export rebuilds the order exactly, with the file’s shipping, tax, discount and total kept.
  • Fix: an unknown SKU is imported as a text line with its name and price, and the row notes it.
  • Fix: dates such as 15/01/2024 are read correctly. The import form has a “Day first / Month first” choice, defaulting from the store’s country; Excel dates, ISO dates and “15 Jan 2024” are also understood.
  • Fix: amounts with currency symbols and separators (₹1,299.00, 1.299,50, Rs. 1,29,999) are read correctly.
  • Fix: CSV files saved by Excel in other regions are understood: semicolon or tab separated, Windows-1252 and UTF-16 encodings.
  • Fix: column headers such as “User Email” or “BILLING-CITY” are recognised.
  • Fix: customer imports keep password hashes from another WordPress or WooCommerce store, so customers keep their passwords.
  • Fix: an order’s customer_id column links the order to that customer.
  • Fix: customers with the subscriber role (set by WooCommerce Subscriptions) are included in customer exports, and a new “Include guest buyers” option adds buyers who checked out without an account.
  • Fix: large XLSX files are read row by row, so a 30,000-row file no longer runs out of memory, and the first tab in Excel’s order is the one imported.
  • Fix: several imports and exports running together take turns, so a small job is not stuck behind a large one.
  • Fix: background jobs on sites in time zones ahead of UTC are no longer restarted while they are still running.
  • New: the Jobs tab shows the failed and skipped rows of any finished import, with a CSV download of the full error log.
  • Security: uploaded files are stored in a private folder until they are queued, and removed after a day if an upload is interrupted.

1.0.0

  • Initial release.