Scaling WooCommerce to work with 250K products

Job ID: 32209679

Budget: $30 – $250 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.
Related categories: WordPress WooCommerce