woocommerce get products gets only first 100. #26

Activity

1. omandryk commented on Jan 31, 2020

   

   omandryk

   on Jan 31, 2020

   Owner

   More actions

   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
2. yilmazchef commented on Mar 23, 2020

   

   yilmazchef

   on Mar 23, 2020

   Author

   More actions

   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..
3. craftedsro commented on Apr 7, 2021

   

   craftedsro

   on Apr 7, 2021

   More actions

   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;
   		}
   	}
   }
   

   }