Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
I'm looking to find the most sold products, and would appreciate a point in the right direction.
I was thinking of looping through all orders using http://documentation.teacommerce.net/razor-api/order/getallfinalizedordersasxml/ and extracting the product count from there, but it seems quite cumbersome.
Or maybe when a product is sold, add a "sold" count to the product itself (effectively opposite of stock, but I could not find how to do this).
We dont have an extensive query API because that would bloat the software. So I think that I would just make a simple SQL call that did a count and returned the nodeIds for those products.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted