Linux 软件免费装
Banner图

Super Speedy Imports Lite

开发者 dhilditch
更新时间 2026年10月26日 22:24
捐献地址: 去捐款
PHP版本: 8.0 及以上
WordPress版本: 7.1
版权: GPLv3 or later
版权网址: 版权信息

标签

woocommerce import csv import product import xml import

下载

2.99.21 3.40.0

详情介绍:

Super Speedy Imports Lite imports CSV, XML and JSON files into WooCommerce products, WordPress posts and pages, in bulk. It is unlimited: import as many products and posts as you want. This edition imports simple products; variable products, product galleries, custom post types and ACF fields are in Pro. Give it the file you want to import, uploaded from your computer or fetched from a URL that returns CSV, XML or JSON, and it works out where every column goes, including files separated by semicolons with decimal commas. Check the mapping, change anything you like, then run the import from the dashboard or with WP-CLI. Import an updated file and it updates the items already on your site and adds the new ones, or set the import to only update existing items or to remove items that are no longer in your file. Measured with the WordPress.org build of version 3.40.0 on a 4-vCPU server, through the dashboard: 100,000 simple WooCommerce products imported in 81 seconds, 1,000 products with their images downloaded from a remote image host and resized in 105 seconds, and a price and stock update of 10,000 products in 11 seconds. Full results and how to reproduce them. What it imports Your shop is ready when the import finishes When the products are in, it rebuilds WooCommerce's product lookup tables, the price, stock and SKU data your shop sorts and filters on, recounts your category, tag and attribute counts, and clears WooCommerce's caches, so the new prices, stock and counts show straight away. It also hands the rebuild of WooCommerce's attribute lookup table, the data that filter widgets and other plugins read, to WooCommerce, which runs it in the background. Each import's choices are under After Import, including a rebuild of the attribute lookup table with bulk SQL straight after the import. Keeping a catalogue in sync Run the same import each time your supplier sends a new file. Fields you have not mapped stay as they are, and a mapped column is applied as it is in the file, so an empty cell empties that field. Featured images downloaded on an earlier run are reused. To update only the items already on your site, set What should this import do? (the ⚙ options on New Import, or Additional Options on the Config tab) to Only update existing items: it updates every mapped field of those items and creates none. To remove the items this import loaded that are no longer in your file, set If an item is missing from your file… to Remove it, or tick Delete missing items under Additional Options. After each run they are moved to the Trash, or deleted permanently if you tick Force delete (skip trash). Items created by hand or by other imports are left as they are. Large files and how imports run A dashboard import runs as a series of short requests to your server. The plugin sizes each batch of rows from how long the previous batch took, so every request stays short, and when one big step takes longer than a request, the dashboard waits for the server to finish it and then carries on. It needs no exec or proc_open. A dashboard import runs while its tab is open. For unattended runs, use WP-CLI: wp ssi <import id> runs the whole import on the server with no browser. For a file larger than your server accepts as an upload, copy it into wp-content/uploads/super-speedy-imports by FTP or SFTP, then choose it under or pick a previously uploaded file on New Import. Running your own import
  1. Give it your file. Click New Import and drop in a CSV, XML or JSON file, or paste a URL that returns one and press Fetch. It reads the file and recognises what it holds (screenshots 1 and 2). For XML and JSON it finds the repeating record and shows the record path it chose, which you can change (screenshot 3).
  2. Check the mapping. The import is already configured: every column it recognises is mapped to its field, and the panel on the right shows the real values from your file, row by row (screenshot 4).
  3. Make any corrections you want. Map a column somewhere else, add a column, combine columns in a transform, or set the hierarchy and multiple-value separators for a taxonomy (screenshot 5).
  4. Run it. Preview & Run shows the file, the row count and what happens to items already on your site, then Start Import runs it with every stage and its timing on screen (screenshots 6 to 8).
  5. Or run it from WP-CLI with wp ssi <import id>, and add that command to cron to run it on a schedule (screenshot 9).
Every import matches rows to items already on your site with a unique identifier column. By default this is SKU for products and post title for posts, and you can choose another: GTIN / UPC / EAN / ISBN for products, post title + category for posts, or the post ID for either. Pro matches on any field or combination of fields. Three ways to run it Try it in one click
  1. Install and activate the plugin.
  2. Open Super Speedy > Imports and go to the Demo Data tab.
  3. Click Load this sample on one of the samples: 1,000 posts with featured images, 20,000 posts, or 1,000 simple WooCommerce products with categories, brands, colours and images.
  4. On the Imports tab, press Preview & Run, then Start Import, and watch it import.
Super Speedy Imports Pro Everything above is included here, unlimited. Pro, a separate download from superspeedyplugins.com, adds: Comparison and pricing

安装:

  1. In wp-admin, go to Plugins > Add New, search for "Super Speedy Imports", then click Install and Activate.
  2. Open Super Speedy > Imports and click New Import, or load a sample from the Demo Data tab.
WooCommerce is needed for product imports only. Requirements: WordPress 6.9 or newer and PHP 8.0 or newer.

屏幕截图:

  • Or paste the URL of a CSV file, here WooCommerce's own sample products file on GitHub.
  • Or drop in an XML or JSON file: it finds the repeating record and shows the record path it chose.
  • The import it configured from WooCommerce's sample file. The panel on the right shows the real values from your file, row by row.
  • Make any corrections you want: combine columns in a transform, or set the hierarchy and multiple-value separators.
  • Preview & Run shows the file, the row count, the matching field and what happens to items already on your site.
  • An import running, with every stage and its timing on screen.
  • The finished import, with every follow-up job done or handed to WooCommerce.
  • The same import from WP-CLI with `wp ssi <import id>`, ready to add to cron.
  • The imported products in WooCommerce, with prices, stock, categories, brands and featured images.
  • No CSV to hand? Load a sample from the Demo Data tab and run it.

常见问题:

How do I import products with images from URLs?

Put the image URL in a column of your file and map it to the featured image; automatic configuration does this for the image columns it recognises. The image is downloaded into your Media Library, and it can be on any public website, not only your own. Each URL is downloaded once, however many rows use it, and reused on later runs. Several images per product (galleries) are in Pro.

What happens when I run the same file again, or an updated one?

Each row is matched to the item already on your site by the import's unique identifier column, and that item is updated; rows with no match are added as new items. The identifier is SKU by default for products, or GTIN / UPC / EAN / ISBN, and post title by default for posts, or post title + category; either can also match on the post ID. Items created by other plugins or by hand are matched too, and images already downloaded are reused.

How do I remove products that are no longer in my supplier's file?

Set If an item is missing from your file… to Remove it when you create the import (in the ⚙ options on New Import), or tick Delete missing items under Additional Options. After each run, the items this import created or updated that are not in the new file are moved to the Trash; tick Force delete (skip trash) to delete them permanently instead. Items created by hand or by other imports are left as they are.

How do I import a large catalogue, such as 100,000 products? Should I split the file?

Import it as one file: imports are unlimited. Measured with the WordPress.org build of version 3.40.0 on a 4-vCPU server, through the dashboard, 100,000 simple WooCommerce products imported in 81 seconds. With Remove it set, each run removes the items that are not in that run's file, so keep the whole catalogue in one file. If the file is larger than your server accepts as an upload, copy it into wp-content/uploads/super-speedy-imports by FTP or SFTP and choose it under or pick a previously uploaded file.

Can an import run without a browser?

Yes, with WP-CLI: wp ssi <import id> runs the import on the server with no browser, and you can add it to cron. A dashboard import runs while its tab is open, so leave the tab open until it shows Import complete.

How do I import a CSV that uses semicolons, or commas for decimals?

Choose the file as usual. The plugin detects the semicolon separator and the decimal comma when you choose the file, and both settings are in the ⚙ options on New Import if you want to check them. Prices such as 12,50, 1.234,50 and € 9,95 are read as 12.5, 1234.5 and 9.95.

What format do prices and dates need?

Prices can carry currency symbols or codes and thousands separators: £12.99, $5, EUR 19.90 and 1,234.50 are all read as plain numbers. Write post dates as YYYY-MM-DD, optionally with a time (YYYY-MM-DD HH:MM:SS); ISO 8601 dates such as 2026-01-20T10:00:00Z work too.

How do I import an Excel spreadsheet?

Save it as CSV first (in Excel, File > Save As and choose a CSV format), then import the CSV file. If Excel saves it with semicolons and decimal commas, import it as it is.

How do I import a Google Sheet?

In Google Sheets, choose File > Share > Publish to web, pick the sheet and Comma-separated values (.csv), and paste that link under Import from URL on New Import. The sheet is downloaded when you press Fetch; press Fetch again to pick up later edits, then run the import.

How do I import a file from a URL or an API?

Paste the address under Import from URL on New Import and press Fetch, and the file is downloaded to your site. The URL can return CSV, XML or JSON, so an API endpoint that exports any of them works. To import a newer version, press Fetch again on the same URL under New Import: it downloads the new file, keeps the earlier one in wp-content/uploads/super-speedy-imports/previous, and the import uses the new file on its next run. Imports converted from WP All Import keep their URL source and fetch it again at the start of every run.

How do I run an import automatically, on a schedule?

wp ssi <import id> runs any import from WP-CLI. Add that command to cron to run it on a schedule, and turn on email reports to hear how each run went.

How do I get an email when an import finishes?

On the Schedule tab, under Email reports, add the recipients and tick the outcomes that send a report: Succeeded, Succeeded with issues, Failed and Stopped. You can also send a daily summary. Imports run from WP-CLI send reports too, so a cron job that runs your import can tell you how it went. Reports go out through your site's own WordPress email.

Does this edition import variable products?

Variable products and their variations are in Pro. This edition imports simple products.

Does this edition import custom post types or ACF fields?

Custom post types and ACF and SCF fields are in Pro. This edition imports posts, pages and simple WooCommerce products, with their custom fields (postmeta).

Can it import WooCommerce categories, tags, brands and attributes?

Yes: hierarchical categories such as Men > T-Shirts (> by default, and you can set any hierarchy separator on the mapping), tags and brands, and global attributes such as pa_color, which the import creates for you along with their terms. If your category names contain commas, set that taxonomy's multiple-value separator on the mapping to a character they do not use, such as |.

How does automatic configuration work?

When you create an import, the plugin reads your column names and sample values and recognises what the file holds, for example "Looks like WooCommerce products". It then maps each column it recognises to the matching field: prices, stock, categories, image URLs, dimensions and so on. WooCommerce's own sample product CSV comes in with its titles, descriptions, prices, stock, categories, tags, dimensions and images already mapped. You can change any mapping before you run.

Are there example CSV files, or can I try it without one?

Load one of the samples from the Demo Data tab, then press Preview & Run and Start Import. The sample brings its own CSV and demo categories, brands and colours.

How do I bring my WP All Import imports across?

Migration Tools reads the WP All Import imports saved on the same site and turns each one into a Super Speedy import. Check its mapping on the Config tab, then run it from the Imports tab like any other import.

Can I copy an import to another site?

Yes. Export the import's configuration as JSON from the Config tab and import it on the other site.

Where can I get help?

Post in this plugin's support forum on WordPress.org. Pro customers get direct help from the developer in the Super Speedy Plugins Discord.

What are the requirements?

WordPress 6.9 or newer and PHP 8.0 or newer, on MySQL or MariaDB. WooCommerce is needed for product imports only.

Which database storage engine does it use?

It uses InnoDB, the MySQL and MariaDB default since 2010. On a server without InnoDB it creates its working tables as MyISAM and imports with a single worker, and the Preview screen explains what that means before you start.

更新日志:

3.40.0