Importing 10,000 Products from a WebToffee-format CSV
Deterministic repeat, Super Speedy Imports Pro 2.86.0: 12.950 seconds for the same 10,000-row WebToffee-format CSV. During the run, CPU averaged 42.29%, RAM averaged 1,242.4 MiB and disk activity averaged 19.43%. After subtracting the measured baseline, the complete job used 0.3404 vCPU-minutes, 2.516 seconds of disk-busy time and 197.129 MiB of writes. The repeat ran on WordPress 7.0.3 and WooCommerce 11.0.0, as stated on the comparison page. Inspect the measured result. The earlier recorded run and video remain below as separate evidence.
Earlier run, Super Speedy Imports Pro 2.83.0: imported 10,000 simple WooCommerce products in 15.947 seconds by browser wall time. The plugin reported 15.037 seconds and a 40 MB plugin peak memory figure. On the identical CSV, WebToffee Free took 1,016.141 seconds, making SSI 63.719× faster in this earlier run.
Earlier run summary
| Metric | Earlier run, Super Speedy Imports Pro 2.83.0 |
|---|---|
| Browser wall time | 15.947 s |
| Plugin total | 15.037 s |
| Throughput | 627.077 feed rows/s |
| Published products | 10,000 |
| Plugin peak memory | 40 MB |
| Database rows processed | 131,052 |
| Speed-up vs WebToffee Free | 63.719× |
See the WebToffee Free result or the direct comparison.
Dataset and configuration
- Initial feed: 10,000 simple products, 2,644,851 bytes, SHA-256
cd135ff65a4b15a717bc3057a7980f0b42b4d14e08c994541e25d54f90a3f64e. - Update feed: 10,000 rows, 2,816,718 bytes, SHA-256
43df664ec47e188443b6fbb4e978808c37c52f6935865ff1d95df9b47ca85b26. - Update changes: 2,500 existing products changed, 1,000 products added, 1,000 original products omitted, and 6,500 retained products unchanged.
- Mapped data: title, descriptions, SKU, regular and sale prices, weight, category, brand, global colour and global size.
- Edition: Pro build used for the earlier run, version 2.83.0.
- Build SHA-256:
e554deca032fa94145300ecb7355bc089147dffd740b33d3de0eb0b8e1cceede. - Workers: four, matching the server’s four vCPUs.
- Auto-configuration: recognised the WebToffee-format CSV and mapped the required WooCommerce fields automatically.
- Matching: SKU.
Stage timings (earlier 2.83.0 run)
| Stage | Duration |
|---|---|
| Load CSV | 4.768 s |
| Attach existing images | 0.152 s |
| Upload remote images | 0.155 s |
| Attach gallery images | 0.372 s |
| Finish product attributes | 4.061 s |
| Import taxonomies | 0.141 s |
| Insert posts | 0.447 s |
| Insert postmeta | 0.428 s |
| Upsert taxonomy relationships | 0.509 s |
| Process variable-product data | 0.211 s |
| Process deletes | 0.052 s |
| Reported stage sum | 11.503 s |
| SSI total | 15.037 s |
Environment (earlier 2.83.0 run)
| Component | Value |
|---|---|
| Server | Hetzner benchmark VPS, 4 vCPU, 8,121,954,304 bytes RAM |
| Stack | PHP 8.2.33, MariaDB 10.11.18, WooCommerce 10.3.8 |
| Isolation | Hetzner snapshot 390805640 restored before each plugin |
| Dataset | The exact same CSV bytes were supplied to both plugins |
| Images | None, so the test isolates CSV parsing and WooCommerce data writes |
Correctness and background housekeeping
The immediate result contained 10,000 unique published SKUs, and all 10,000 products had both global attributes plus category, brand, colour and size relationships. WooCommerce showed its background product-data notice immediately after import; a later server check found the queue clear and complete lookup-table coverage. That later wait was not timed and is not included in the earlier run’s 15.947-second time.
Post-import catalogue evidence
These screenshots were taken in the earlier 2.83.0 run, immediately after the plugin reported completion. They show the WooCommerce product total, category and brand counts, global attributes, and the colour and size term counts.
Reproduce
Download the reproduction bundle. It contains the exact WebToffee-format CSV that SSI consumed, rather than an equivalent regenerated SSI-specific file.
This is one controlled setup. Absolute timing will vary with the host and the shape of the feed.
Comments