QRCode Suitefor WordPress
LoginStart free →
Documentation

Bulk QR for 10,000 products: a 7-minute benchmark

Last week a Pro customer asked: "can your bulk generator handle 10,000 SKUs in a single CSV?" We built a test harness with 10,000 representative product rows and ran it on a stock WordPress + WooCommerce install on a 2-CPU Railway instance. End-to-end completion: 7 minutes 12 seconds. Here is the pipeline breakdown.

  1. 1

    Test setup

    CSV: 10,000 rows with SKU, product name, target URL, campaign, template id. Hardware: Railway "Hobby" plan — 2 vCPU, 4 GB RAM, shared MySQL. WordPress 6.5, WooCommerce 8.6, QRCode Suite Business. No caching layer, no pre-warming.

  2. 2

    Phase 1 — CSV parse and DB insert (38s)

    Streaming CSV parser writes rows in 500-row batches to `meliqs_qr_codes`. With prepared statements and a transaction per batch, 10,000 rows insert in 38 seconds. The bottleneck is the unique-index check on `slug`.

  3. 3

    Phase 2 — QR rendering loop (5m 22s)

    Server-side rendering: SVG + PNG + PDF per row, written to `wp-content/uploads/meliqs/`. Single-threaded by default; we tested with 4 PHP-FPM workers in parallel which dropped Phase 2 to 1m 48s. The default keeps RAM bounded for shared hosts.

  4. 4

    Phase 3 — ZIP assembly (1m 12s)

    30,000 generated files (3 per QR × 10,000 QRs) zipped into a single download archive. The ZIPs are 220 MB total. PHP's ZipArchive is the bottleneck — node-zip would be 3-4× faster but we stayed in PHP to avoid an additional runtime dependency.

Frequently asked questions

What is QRCode Suite?

QRCode Suite is a premium WordPress plugin that generates branded, dynamic QR codes directly inside your WordPress dashboard. Scan data is stored on your own server — not on a third-party SaaS platform — and WooCommerce orders can be attributed to specific QR codes.

Does QRCode Suite require a separate subscription?

The Free plan is available at no cost. Paid plans (Pro, Business, Agency) are licensed per WordPress site and billed monthly or annually. There is no separate per-scan fee.

What QR code types does QRCode Suite support?

QRCode Suite supports 15 QR code types: URL, vCard, Wi-Fi, SMS, Email, WhatsApp, PDF, Coupon, Plain Text, Social profile, WooCommerce Product, WooCommerce Reorder, Link Hub, Phone, and Dynamic URL.

Can I change the destination of a QR code after printing it?

Yes. Dynamic QR codes use a short redirect URL. You can update the destination from your WordPress dashboard at any time without generating or reprinting the code.

Is QRCode Suite GDPR-compliant?

Yes. QRCode Suite hashes IP addresses with SHA-256 before storage so no raw IPs are ever saved. It also filters bot traffic automatically and includes configurable data-retention settings.

Need help getting started?

Download the free plugin or browse all documentation.

Download pluginAll docs