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...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.
Continue discussion
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...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.