Scaling WooCommerce to work with 250K products

Job ID: 32209685

Budget: $250 – $750 USD

is building a website for a client. The client wants to import a lot of products from the wholesaler's website (250k). We're using a plugin to import the products via a CSV file, however, the import process stops at 6% as it's saying that the server is having issues. Here is the screenshot: https://cln.sh/4yYJ8Q

Also, the import process is taking way too long. It should take around half a day, not days. The client will update the CSV file every few days as the wholesaler's inventory gets updated, so the import process should be faster than it is now.

I need someone who knows how to optimize databases and has experience importing hundreds of thousands of products to WooCommerce/working with large stores.

This is urgent as the deadline for the project is near. We need someone to get on this asap and import all the products.
WooCommerce, WordPress
Related categories: PHP WordPress MySQL HTML WooCommerce