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).
Any ideas?
Hi Matt
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.
Kind regardsAnders
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Most popular products
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).
Any ideas?
Hi Matt
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.
Kind regards
Anders
is working on a reply...