woocommerce get products gets only first 100.

[yilmazchef]

Dear Coder,

Firstly, I would like to thank you for providing such useful library. I have been developing a microservice-based application and using your library multiple times.

When I use the code below:

    Map<String, String> params = new HashMap<>();
    params.put("per_page", "100");
    params.put("offset", "0");
    List<Map<String, Object>> productsMap = wooCommerce.getAll(EndpointBaseType.PRODUCTS.getValue(), params);

Can you please help me to get all the products as Map<String, Object> because I will need to collect all the data from stores.

Thank you very much in advance.

Best regards,

Yilmaz.

[omandryk]

Hi Yilmaz, if you are using WC v3 try with the following params:

params.put("page", "1");
params.put("per_page", String.valueOf(Integer.MAX_VALUE));

Read more on WC Rest API Docs: http://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-products

Best regards, Oleksandr Mandryk

[yilmazchef]

Hello Oleksandr,

I have tried params.put("page", "1"); params.put("per_page", String.valueOf(Integer.MAX_VALUE));

however, I received an error..

Is there any other option.

I have coded another solution, I get data 100 products per page, and trying to cache them.

but it would be amazing if I could get all data..

[craftedsro]

To get all products you have to work with page...

import java.util.List; import java.util.ArrayList; import java.util.HashMap; import java.util.Map;

import com.icoderman.woocommerce.ApiVersionType; import com.icoderman.woocommerce.EndpointBaseType; import com.icoderman.woocommerce.WooCommerce; import com.icoderman.woocommerce.WooCommerceAPI; import com.icoderman.woocommerce.oauth.OAuthConfig;

public class Test {

public static void main(String[] args) {
    String url = "http://example.com";
    String ck = "customer_key_from_your_woocommerce_page";
    String cs = "customer_secret_from_your_woocommerce_page";

    Map<String, String> options = new HashMap<String, String>();
    OAuthConfig config = new OAuthConfig(url, ck, cs);
    WooCommerce woo = new WooCommerceAPI(config, ApiVersionType.V3);

    List<?> temp;
    List<HashMap<?, ?>> productsTmp = new ArrayList<HashMap<?, ?>>();

    int perPage = 100;
    int page = 1;
    boolean end = false;

    options.put("page", String.valueOf(page));
    options.put("per_page", String.valueOf(perPage));

    while(!end) {           
        temp = woo.getAll(EndpointBaseType.PRODUCTS.getValue(), options);

        if(!temp.isEmpty()) {
            for(int i = 0; i < temp.size(); i++) {
                productsTmp.add( (HashMap<?, ?>) temp.get(i) );
            }
            options.put("page", String.valueOf(++page));
        }
        else {
            end = true;
        }
    }
}

}