Missing feature: Calculate new order quantity

  • Resolved gerske

    (@gerske)


    1 year, 7 months ago

    ATUM is great, but I am a missing 2 features that would be very handy. Not only for me, but for most store owners. Also, it would be very easy to add to ATUM.

    Feature 1: Show sales for more than 30 days
    In ATUM, I can now only see up to a maximum of 30 days what the sales where of a product. I need to know what the sales where in for example 90 days.

    Feature 2: Calculate a suggestion how much to purchase
    When I make a new order to replenish the stock, I look at what the sales of a certain product where for the last X months. Then I calculate how much I would need to buy, so that I have enough stock for Y months. It is a very easy calculation, but I have to do this manually for all hundreds of products, as this is not (yet) a feature in ATUM (or Woocommerce).

    The calculation is very simple:
    Order_quantity_needed = Y/X * Number_of_sales_in_X_Months – Current_stock

    It would save so much time when the easy calculation above would be integrated in ATUM! Just add an extra column in Stock Central with “New Stock Needed”.

    Gerkse

    • This topic was modified 1 year, 7 months ago by gerske.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Jose Andres Piera

    (@japiera)

    1 year, 7 months ago

    Hi @gerske ,

    Thanks for your post.

    Regarding the features your asked for:

    1. You can already modify the number of days used to calculate the Last Days Sales column. It’s limited to a maximum of 31 from the UI, but you can use the “atum/get_option/sales_last_ndays” filter to set the number of days you want. Please note that the limit is set to 31 for a reason. The calculations needed for more days could require too much processing time and could slow down or even crash the server. Please use the filter carefully.
    2. Thanks for your suggestion in point 2. We have a Suggest a Feature section in our Public Forum. Please create a new thread asking for the feature. If enough people are interested, we’ll consider adding it for future versions.

    I include an example using the filter to change the number of days (to 50):

    add_filter( ‘atum/get_option/sales_last_ndays’, function ( $last_ndays ) {return 50;} );

    Best Regards,
    José Andrés

    Thread Starter gerske

    (@gerske)

    1 year, 7 months ago

    Hi Jose, thank you very much for the handy snippet. I will also add a new feature request to the forum.

    Kind regards, Gerson

    Plugin Author Jose Andres Piera

    (@japiera)

    1 year, 7 months ago

    Hi @gerske ,

    You’re welcome.

    Best Regards,
    José Andrés

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Missing feature: Calculate new order quantity’ is closed to new replies.