What is the fastest way to import a database of 700,000 Wordpress products?

Question

WordPress

Hello. There is a task of importing 700 thousand products into the WP, using Wp All import, because I didn’t find another adequate option, it’s insanely long and sometimes the import freezes at all and doesn’t want to resume itself for some unknown reason, sawed the database into pieces of 100 k, the speed is insanely slow. There is no VPS, and every time the importer starts, you have to ask the host to extend the tariff for a couple of minutes, so as not to fall into an error. Does anyone have any experience in importing such a volume of a database of goods into WOO and what is the best way to do this?

Answer 1

This is most likely a one time operation.
Break your file into several parts 5/10/30/50/100 or how many at a time your plugin can "swallow" and let it work in parts.

Divide and rule

Answer 2

No matter how strange it sounds, buy a VPS.
It doesn't cost that much. Take it for a month, make a subdomain and delegate to VPS.
Take a site dump with a duplicator, raise it on the server, fill in the goods, return the ladies to the main hosting.

Answer 3

You need to figure out what exactly slows down and first eliminate this bottleneck.
Speed ​​up the processor, change hdd to ssd, choose server ssd instead of desktop, more RAM, change vps to bare metall once, etc.
Here they write that one of the reasons is that the source of the images is slow, they are probably downloaded in the same stream, check how it will be imported on the test base without images. If the reason is in them, upload the pictures yourself, multi-threaded or whatever, and then import, replacing the links with the local one.

Answer 4

WP can't handle 700,000 products