Super Speedy Imports by WP Intense v1.58

Super Speedy Imports by WP Intense​

Lightning fast imports, import 1 million items in 100 minutes!

• Update 20,000 stock & prices in under a minute
• Add 1 million products, each with 10 terms, in 100 minutes
• Easy to use interface
• Over 100 times faster than traditional WordPress import techniques
• Developer friendly!

Super Speedy Imports is a SQL-first, developer-friendly, import tool. Instead of loading items to your site one-by-one, Super Speedy Imports stages imports in a custom table and then loads them all in one fast SQL query.

This architecture breathes life into your WordPress imports. Never again limit the size of your site because of how long your imports and updates take. Super Speedy Imports are so fast and lightweight that you can run them really at any time.

Import millions of items in minutes, not days. Whether you’re updating inventory, loading complex data sets, or expanding your site, Super Speedy Imports lets you handle it all without downtime or delays.

Super Speedy Imports is Developer Friendly​

The architecture of Super Speedy Imports is focused on speed first, with a close second being modularity and developer-friendliness. Super Speedy Imports runs its imports in ‘stages’. Templates define the stages and their execution order.
Typically:

1. import-csv – loads the CSV to 3 import tables. _batch for post and postmeta data, _terms for flat term info and _hierarchical for hierarchical terms
2. massage-data – runs PHP functions against each row of the table to manipulate the data, e.g. change xxs to ‘x-x-small’
3. import-terms – runs wp_insert_term for any missing terms
4. match-existing – updates the _batch table with existing post IDs based on the unique identifier (e.g. SKU)
5. update-posts – actually updates wp_posts with info from _batch
6. insert-posts – inserts to wp_posts from _batch
7. update-postmeta – updates wp_postmeta from _batch
8. insert-postmeta – inserts to wp_postmeta from _batch
9. upsert-relationships – deletes then reinserts to wp_term_relationships based on _term and _hierarchical
10. attach-existing-images – finds previously uploaded images and updates _batch
11. import-images – uploads and attaches missing images
12. save-posts – per row, invokes the save_post trigger

From the above you can see there are various dependencies, but not all stages are required in all cases.

For example, if you are running a simple stock & price update, you could run ‘import-csv’, ‘match-existing’ then ‘update-postmeta’ and skip the other stages.

Each stage will allow you to run stuff before & after that stage. Additionally, you will be able to define additional stages to execute and insert them at any point. So – if you need data sent into a separate custom table, that can happen all inside this plugin. If you need a stage to talk to AI, that can happen. There’s the usual ability to run a function per-row if you MUST, but really I want to educate people how to use this tool properly to build imports which are lightning fast.

Finally – each stage is replaceable in this modular system. Currently, the slowest stage is ‘massage-data’ but this could be replaced by a SQL-first stage if that’s an option for your import giving massive speed boosts.

The idea is that I want to make a great platform for myself & others to create the fastest possible imports for anything in WordPress. There is no requirement that imports should be to wp_posts, wp_postmeta, wp_terms etc – they could