Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE3MjE3MjI0NDAsImlzcyI6ImVLYXJ0IiwiZXhwIjoxNzIxNzI0MjQwLCJzdWIiOiJlS2FydCBBdXRoZW50aWNhdGlvbiJ9.AUZm4CFcvbFDC-LULTqHZd9wHar0hY8WJcSNXCGFFNw

API URL : shop.php

Params :
array(12) {
  ["limit"]=>
  int(12)
  ["offset"]=>
  int(0)
  ["s"]=>
  string(0) ""
  ["category"]=>
  string(2) "28"
  ["sub-category"]=>
  string(0) ""
  ["sub-sub-category"]=>
  string(0) ""
  ["sort"]=>
  string(0) ""
  ["out_of_stock"]=>
  int(0)
  ["min_price"]=>
  int(0)
  ["max_price"]=>
  int(0)
  ["pincode"]=>
  string(0) ""
  ["accesskey"]=>
  string(5) "90336"
}


API Response :
SELECT count(p.id) as total,MIN(if(pv.discounted_price > 0, pv.discounted_price, pv.price)) as min_price, MAX(if(pv.discounted_price > 0, pv.discounted_price, pv.price)) as max_price FROM products p INNER JOIN category c on c.id=p.category_id INNER JOIN product_variant pv on p.id=pv.product_id  WHERE p.category_id IN(28)  AND p.status = 1  AND c.status = 1