Announcement

Collapse
No announcement yet.

Ideas for determining the last order date of an item

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Ideas for determining the last order date of an item

    Hi guys, looking for ideas to determine the last time a product was ordered. Does anyone know of any fields on the Product object that would help with this? I'm assuming the LastUpdate field tells us the last time we changed the product on the admin side?

    I would really like to avoid iterating over all my orders and then iterating over each item to see when it was last purchased, but I guess that is an option... Just wanted to make sure I'm not missing something obvious.

    Is there a reporting API we could use?

  • #2
    Go to Reports > Products > Products Sold then at the Top Right it says select a product, choose your product. Set your date range and you should have what you are looking for.

    Hope this helps.
    Last edited by Pack Secure; 10-11-2017, 04:04 PM.
    http://www.pack-secure.com

    Packaging and Shipping Supply Specialists

    Comment


    • #3
      Ya the reporting part is great for finding out what our top products are, but I'm more interested in what products haven't sold in the past year. This way we know what products are good candidates to discontinue or to clear out.

      It's too much work to select each product individually to run a report on. We have over 12,000 skus...

      Comment


      • #4
        ozzyonfire PM me your phone #. I have an idea for you, but I really don't feel like typing it out.

        Comment


        • #5
          Originally posted by ozzyonfire View Post
          Hi guys, looking for ideas to determine the last time a product was ordered. Does anyone know of any fields on the Product object that would help with this? I'm assuming the LastUpdate field tells us the last time we changed the product on the admin side?

          I would really like to avoid iterating over all my orders and then iterating over each item to see when it was last purchased, but I guess that is an option... Just wanted to make sure I'm not missing something obvious.

          Is there a reporting API we could use?
          Sorry if I misunderstood what you were trying to say, you stated "ideas to determine the last time a product was ordered".
          http://www.pack-secure.com

          Packaging and Shipping Supply Specialists

          Comment


          • #6
            Ya I wasn't very clear in my use-case.
            I think for now I'm just going to iterate through all the orders (and the items ordered) and store the order date on a field on the item in my database, like a "LastOrderedDate" field. Then I can just query for items that don't have that field or are before a certain date.

            Thanks.

            Comment

            Working...
            X