Seganiko Fast Import for WooCommerce

Description

Seganiko Fast Import for WooCommerce is a lightweight tool for importing and updating WooCommerce products from XLSX or CSV files. Designed for store managers who need to update large catalogs quickly and reliably.

Key features:

  • Import products from XLSX or CSV (UTF-8)
  • Supported fields: name, SKU, price, weight, description, images, categories, and custom meta fields
  • SKU-based update — existing products are updated, no duplicates created
  • Batch processing (up to 400 rows per batch) with real-time AJAX progress bar
  • Support for simple products, variable products, and variations
  • Custom meta fields — both flat values and array (serialized) format
  • Bulk media loader — import images from external URLs or upload a ZIP archive
  • Video support in the media loader — mp4, webm, mov and other formats; video is attached per product SKU
  • Optional bulk image optimization (ShortPixel integration)
  • Compatible with WooCommerce HPOS (custom order tables)

Requirements:

  • WooCommerce 9.3.3 or later
  • WordPress 6.2 or later
  • PHP 8.0 or later
  • PHP ZipArchive extension (required for XLSX import)

Usage

Prepare your file:

Supported formats: XLSX and CSV (UTF-8 encoding).

Required column:

  • sku — used to match existing products; if a product with this SKU exists it is updated, otherwise a new product is created

Optional columns:

  • name — product title
  • price — regular price (numeric)
  • weight — weight in kg (numeric)
  • description — product description (HTML allowed)
  • images — one or more image URLs separated by a pipe | (first image becomes the featured image)
  • categories — category names separated by / (hierarchy) or , (multiple categories)
  • Any extra column is saved as a product meta field under the column name

Import flow:

  1. Upload the XLSX/CSV file on the Import tab
  2. Review column mapping on the Mapping tab if needed
  3. Click Start Import — the batch runner processes rows in groups of 400 and shows progress in real time
  4. When finished, a summary shows how many products were created, updated, and skipped

Media Loader tab:

  • Paste product SKUs with their image/video URLs to bulk-attach media
  • Or upload a ZIP archive — the loader matches files inside to products by SKU
  • Video files (mp4, webm, mov, etc.) are attached to the product gallery per SKU/filename

Logs:

Import logs are saved to /wp-content/uploads/seganiko-fiw-logs/ and are also shown in the admin UI. Each log entry records the SKU, action (created/updated/skipped/error), and a short message.

External services

This plugin optionally connects to the ShortPixel Image Optimizer API to compress and optimize product images during the bulk media import process.

Service: ShortPixel — an image optimization and compression service.

What it is used for: When the user enables the “Optimize images with ShortPixel” option in the Media Loader settings and provides a valid ShortPixel API key, uploaded product images are sent to ShortPixel for lossy or lossless compression before being stored in the WordPress media library.

What data is sent: The plugin sends the publicly accessible URL of each uploaded image along with the user’s ShortPixel API key and optimization preferences (compression type, EXIF handling). No personal user data is transmitted.

When data is sent: Data is sent only when the site administrator has explicitly enabled ShortPixel optimization in the Media Loader settings tab and triggers a bulk media import. No data is sent if the feature is not enabled.

Service endpoint: https://api.shortpixel.com/v2/reducer.php

Terms of Service: https://shortpixel.com/tos
Privacy Policy: https://shortpixel.com/privacy

Credits

Developed by Seganiko / Project BGL.
Text Domain: seganiko-fast-import-for-woocommerce

Installation

  1. Upload the plugin folder to /wp-content/plugins/seganiko-fast-import-for-woocommerce/
  2. Activate the plugin from the WordPress Plugins screen
  3. Go to WooCommerce > Fast Import to start importing

FAQ

Which file formats are supported?

XLSX and CSV (UTF-8). For XLSX the PHP ZipArchive extension must be enabled on your server.

What happens if a product with the same SKU already exists?

It is updated — name, price, weight, description, and any other mapped fields are overwritten. Images are only updated if the images column is present and non-empty.

How are images imported?

Put one or more image URLs in the images column separated by |. The importer downloads each image, stores it in the WordPress media library, and attaches it to the product. The first URL becomes the featured image.

Are video files supported?

Yes, through the Media Loader tab. Upload a ZIP archive or provide URLs to video files (mp4, webm, mov, etc.). The loader attaches videos to products by matching the SKU found in the filename.

Can I import variable products?

Yes. Set the type column to variable for the parent and variation for each child row, and include a parent_sku column in variation rows pointing to the parent SKU.

Can I change the batch size?

The default is 400 rows per AJAX batch. This is configurable via the SEGANIKO_FIW_CFG.batch_limit JavaScript constant (adjustable in the Media Loader settings tab).

What permissions are required?

The plugin requires the manage_woocommerce capability. Only users with this role (typically Shop Manager or Administrator) can access the importer.

Reviews

There are no reviews for this plugin.

Contributors & Developers

“Seganiko Fast Import for WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.2.17

  • Security hardening: added wp_unslash() and sanitize_*() for all user inputs
  • Replaced wp_redirect() with wp_safe_redirect()
  • Replaced parse_url() with wp_parse_url()
  • Added output escaping for inline styles
  • PHPCS compliance updates for WordPress.org submission

1.2.0

  • Added Bulk Media Loader tab: image and video support, ZIP upload, optional image optimization
  • Improved theme and template compatibility
  • UI improvements in the progress panel

1.1.0

  • Added AJAX batch processing with real-time progress bar
  • Configurable batch size (default 400 rows)

1.0.0

  • Initial release
  • XLSX and CSV import
  • SKU-based create/update logic
  • Core fields: name, price, weight, description, images, categories