Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE3Mjg4NjI4NTUsImlzcyI6ImVLYXJ0IiwiZXhwIjoxNzI4ODY0NjU1LCJzdWIiOiJlS2FydCBBdXRoZW50aWNhdGlvbiJ9.x9icxxFwkgMcSAkqwBN7taRUcDYHLkc2Vl_FxFWrG1s

API URL : shop.php

Params :
array(12) {
  ["limit"]=>
  int(12)
  ["offset"]=>
  int(0)
  ["s"]=>
  string(0) ""
  ["category"]=>
  string(2) "22"
  ["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(22)  AND p.status = 1  AND c.status = 1