Best Way To Add 10,000 + Downloadable Products?

Hello @courtneybostdorff,

There is a built-in product importer in WooCommerce that can do what you need. You’ll need to do two things to make it work:

1. Upload all your downloadable files to your web server. A subfolder in the wp-content/uploads/woocommerce_uploads directory would work.
2. Create a CSV file with your products, following the sample CSV file format. You can also create one sample product and export that to generate your own sample. If you have any trouble, check out the documentation.

Note that you’ll need a column with your file locations for each product. You can use formulas to help you generate the column values you want from a list of filenames. I recommend testing with a small amount of products, 2 or 3 at once, until you have your columns set up correctly and the products look the way you want once they are uploaded. That way you can work out the kinks with small uploads, instead of waiting on 10,000. I’d also break up your uploads into batches of 1-2,000 or so, so that if an error occurs it is easier to narrow down which row is having an issue.

If you need help figuring out how to generate your CSV file, you might consider checking out the Community Slack or Facebook Group for community help with more advanced questions.

I’m marking this as ‘Resolved’ as the product importer is the bulk-product import option in WooCommerce core. We look forward to hearing back from you if you have any follow-up questions. Thanks!