The following ShopifyQL query is not working properly:
FROM products
SHOW sum(ordered_product_quantity) as total_quantity
GROUP BY product_id
SINCE today
ORDER BY total_quantity DESC LIMIT 20"
However, everything is working properly when I use “yesterday” instead of “today”.
This was my original query from two days ago, which stopped working yesterday. Was there any change to the ShopifyQL system?
FROM sales SHOW net_quantity GROUP BY product_id WHERE sale_line_type='product' SINCE today UNTIL today ORDER BY net_quantity DESC LIMIT 20