The import speed depends on the amount of data present in the CSV, including attributes, taxonomies, image URL, network speed, server, etc. For CSVs with images, the import speed also depends on the time taken to download the images as well.
Import speed varies for each server and CSV file. During import, each CSV row and column import is accessing different tables in the database and entering data into each table. This will increase the import time as the data needs to be written to each field in the database and continuous database hits can slow down the server.
You can also import large CSVs in batches of 5000-10,000 per CSV so that import will not get stuck since the CSV is containing a large number of data.
We can suggest some methods to increase the import speed:
1. On import, map only the necessary columns.
2. If you are having the product images already in the WP media library, you may please specify the image name only.
3. Import large CSV in batches of 5000-10,000 products per CSV.
Can’t find what you need?