Focusing on managing products, variants, and collections through the API.
I am attempting to create a tool that will automatically keep track of the amount of sales made through shopify of each product variant by using shopifyQL with the products database. I can see that you can get the sales data for each product (ex: copper bracelet), but I don't see how you can get the data for product variants (ex: small copper bracelet, medium copper bracelet, large copper bracelet). Is this even possible?