CatalogRelay Safe Importer for WooCommerce

Description

CatalogRelay is a free, local importer for product CSV files (simple, external, variable and variation products).

  • Check before you write. A read-only preflight finds invalid prices (abc, -5x, $$), invalid stock (xx), variations without a parent, children before their parent, duplicate SKUs, SKU conflicts and attribute mismatches. Variations without a parent are rejected: no “Import placeholder” products are created.
  • Preview. The dry run lists every changed field of every product (old value, new value) and writes nothing.
  • Resume. The import runs in the background in small chunks. If the server is killed, it continues at the last committed row; products are never created twice, not even rows without SKU.
  • Retry failed rows only. Failed rows are stored with their error, you can download them as a CSV (it can be imported again as it is) and retry just those rows.
  • Roll back safely. Price, stock and status are snapshotted before every write. A rollback restores prices and statuses only where nobody changed them since, moves stock by the difference (so orders placed after the import stay reduced), moves new products to the trash only when no order refers to them, and lists conflicts you can restore by hand.
  • Images are downloaded by separate background actions; a broken image URL only produces a warning. Private and reserved addresses (127.0.0.1, 169.254.169.254, 10.x …) are never contacted. Images over 20 MB or 50 million pixels are refused; images already in this site’s media library are reused, not downloaded again. Scheduled feed files may be up to 512 MB (filter catalogrelay_feed_max_bytes).
  • Works with HPOS (custom order tables) on and off. No code runs on the storefront.

What it does not do: multi-store sync, feed export, XLSX or Google Sheets sources, supplier price rules, converting simple products to variable ones, restoring anything but prices, stock and status on rollback.

Data safety

A bulk import overwrites prices and stock. CatalogRelay keeps rollback snapshots for 7 days by default (1 to 30 days in the settings), uploaded files for 7 days, row logs for 30 days and job summaries for 90 days. Rollback restores only prices (regular and sale), stock (quantity, stock management, stock status, backorders) and the product status, and removes the products the import created. Everything else the import wrote stays as imported: names, descriptions, images, SKU, GTIN, categories, tags, attributes and the values added to them, tax and shipping class, weight and dimensions, visibility, featured, low stock amount, sold individually, and the categories, tags and global attributes it created.

Privacy

No telemetry, no external requests except the image URLs and feed URLs you provide. Row logs contain row numbers, error codes and product IDs, never the cell values of your file. Uploaded files are stored in a directory with a random 128-bit name; on Nginx add a deny rule for uploads/catalogrelay/ (Site Health shows the path).

Development

The admin app in build/ is compiled with @wordpress/scripts from the readable source in assets/src/, which ships with the plugin. To rebuild it, run npm install && npm run build in the plugin directory (see package.json). vendor-prefixed/ holds the plugin’s own copy of the shared Rotosix library as plain, unminified PHP.

Installation

  1. Install and activate WooCommerce 10.0 or newer.
  2. Install CatalogRelay and open Rotosix > CatalogRelay import.
  3. Download the sample CSV on the empty page or start the import wizard.

Imports larger than the PHP upload limit: have an administrator define CATALOGRELAY_INCOMING_DIR in wp-config.php (a server directory) and choose the file there. On multisite each site reads its own subdirectory named after the site ID (for example <directory>/2). Write files there under a temporary name and rename them when complete: a file that changes while it is read is refused.

FAQ

Does an import run if I close the browser?

Yes. It runs in Action Scheduler; the page only shows the progress. If the queue is stalled the page offers “advance in this page”.

Can I roll back an import after customers ordered the products?

Yes. Stock is restored by the difference, so ordered units stay reduced. Changed prices and statuses are listed as conflicts and kept unless you force them.

The decimal comma?

Prices such as 12,50 are parsed with the separators of your store; if a file uses the other convention the preflight says so and you pick the file’s separator. German CSV files in Windows-1252 with ; work.

Reviews

There are no reviews for this plugin.

Contributors & Developers

“CatalogRelay Safe Importer for WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

0.2.0

  • First complete release: preflight, dry run with diff, resumable import, failed-row retry, conflict-aware rollback, background images, admin wizard.