In this article we will see how to use the woocommerce REST API to have all the products on our client.
We are currently developing an android application for one of our clients.
One of the important features was to retrieve all the products from your woocommerce site. The problem is that with the new standard of the platform’s REST API, many tricks on the web are no longer functional.
In this troubleshooting we will give you the solution that allowed us to solve the problem and some tips so you don’t get lost.
Woocommerce – How to fetch all products via rest api – Troubleshooting
Prerequisites
This article is not a tutorial but a troubleshooting section. So we are not going to go into too much detail of the instructions and give detailed explanations on the problem encountered. The goal is to get straight to the point to unblock you.
Before offering you the solution there are steps of configuring your client application and the woocommerce platform to accomplish to be sure you are on the right track.
We will try to give you some prerequisites that could perhaps be a solution to your REST client not working. Let’s start:
- You will need to generate a connection key before using the API. To do this, you will need to go to Woocommerce -> Settings -> Advanced -> REST API See the documentation on the woocommerce website to guide you ( link https://docs.woocommerce.com/document/woocommerce-rest-api/ ). Be careful, save the keys generated elsewhere before generating it. Otherwise you will be forced to delete what you just created and start the process again.
- Check that the link: my_woocommerce_site.com //wp-json/wc/v3/products?consumer_key= customer_key &consumer_secret= secret_key is functional.
- NB: In production never put authentication information like the client key and the secret key of your platform in a hard url in your client application. It is better to manage authentication by modifying with your programming language the protocol of the request for more security. Each programming language has its own way of managing this procedure correctly.
With android using kotlin or java language, we can manage authentication using interceptors and OkHTTP. These details will be the subject of tutorials later. If everything works well then you can go directly to the solution.
Solution to find all products of my Woocommerce site via REST API
To find all the products on your WooCommerce site, you must apply filters so as not to mix unpublished products with those you are really looking for.
In our case, we are only interested in products that have at least the price, and are visible to the public. For this, our solution is to use the following URL:
mysite_woocommerce.com //wp-json/wc/v3/ products?status=publish&per_page=100&min_price=1
The product display limit is 100 per page. If we want to retrieve more, we will have to manage the pagination and add a new parameter. For all the details of the use of the API, I recommend you to see this documentation of the REST API .
This documentation is very complete and allows you to more easily test your requests as you modify the parameters.
This is the end of the troubleshooting on the recovery of all the products on our woocommerce by a request to the REST webservice.
The reason why you can’t retrieve 100 products at a time is because after a certain number of request processing times, the connection is automatically reset.
To avoid this situation, you should perform queries that take less time to execute.
If you liked this post, do not hesitate to subscribe to our Newsletter to receive more exclusive content and above all take advantage of good deals.
Let’s stay in touch!
