What is the best way to import a lot of products via API?

Hey there,

You’re probably better off doing this scale of import using a CSV file.

If the products you’re importing are the base products supported by WooCommerce core, the built-in product import/export feature will suffice. You can learn more about that here – https://docs.woocommerce.com/document/product-csv-importer-exporter/.

If your products are more complex and include information stored in taxonomies, the Product CSV Import Suite extension would be the way to go.

• This reply was modified 6 years, 12 months ago by Luminus Alabi.

My products are pretty simple (images, attributes, prices, names, etc) but importing is very slowly.
I need to import 15000 items. How can I do it?

As mentioned above, the product import/export feature built into WooCommerce since version 3.1 would be the way to go.

This doc covers what you need to know – https://docs.woocommerce.com/document/product-csv-importer-exporter/

But I need to import and updating products automatically via cron job.

You’ll probably need to write some custom code to achieve that or look for a tool that provides that functionality.

Searching for import WooCommerce products via cron job in Google should pull up a number of options to consider.

@luminus, I’m trying to achieve the same as @vnzhlv.

I’m trying to integrate WooCommerce with a company’s ERP.

I need to do a cronjob to request the data to the ERP API, and then update WooCommerce accordingly.

Do you recon it is best to parse the response of this request to a JSON/CSV and then do import via whatever importer I’m using?

Hi @vnzhlv & @yunikweb

Having a quick google, this blog post might be a good starting point:

https://dominykasgel.com/woocommerce-rest-api-import-products-json/

Thanks,

@dougaitken, we are talking updating ~5000 products.

I don’t know if updating them through the API is the best solution, and WooCommerce API batch update endpoint only allows 100 products each request.

@yunikweb, I decided to use wp methods. It’s much faster but I had to write more lines of code (((
for example: https://paste.laravel.io/71e95768-87ed-475b-ab91-cb2c22137ab4

@vnzhlv, can I get your email or some form of contact please?

@yunikweb, “my_name_here”.zh@gmail

We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.