Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Matt 91 posts 237 karma points
    Mar 20, 2014 @ 15:27
    Matt
    0

    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?

  • Anders Burla 2560 posts 8256 karma points
    Mar 21, 2014 @ 08:51
    Anders Burla
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft