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:

Upload the XLSX/CSV file on the Import tab
Review column mapping on the Mapping tab if needed
Click Start Import — the batch runner processes rows in groups of 400 and shows progress in real time
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