Forecast of sales to help with purchase orders

  • Resolved Gomle

    (@gomle)


    3 years, 8 months ago

    Hi, I am looking for something like the points listed below, and want to ask if your plugin can help:

    1. I select a supplier from a list of suppliers and a from-date and to-date in the past e.g. 30 days.
    2. The program then checks the sale of the products from that supplier within those dates.
    3. It checks the current stock for those products
    4. It calculates how many of each products I have to purchase from my supplier in order to have enough products to handle the next 30 days of sales.

    Is this at all possible with this plugin?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Salva Machi

    (@salvamb)

    Hi @gomle

    Not exactly as you described but in ATUM you have some calculated fields that can help you to know which products are in low stock and you can calculate how many of them you need to purchase.
    For example:

    Stock will Last (Days)

    Will tell you the average amount of days that a product will keep ‘in stock’ status. By default, we base this indicator on sales for the past seven days (We do not include the current day sales).

    Low stock status

    https://forum.stockmanagementlabs.com/d/1978-low-stock-formula

    And you can read all the columns available in ATUM’s Stock Central here:

    https://forum.stockmanagementlabs.com/d/410-stock-central-columns-data

    Best Regards,
    Salva.

    Thread Starter Gomle

    (@gomle)

    Hi, and thank you for your fast reply.

    Stock will Last (Days) seems very usable indeed!

    I have not yet tested the plugin, but in case there are no changing of the 7 days, that would have been an awesome feature for us that depend on far east orders incl. container traffic which often takes a while. 7 days will not help too much ??

    I look forward to when I have the time to install and get familiar with the plugin. I can’t wait to try it out.

    Thank you for providing this for free. It’s insane!

    Plugin Author Salva Machi

    (@salvamb)

    Thanks for your kind words. Very much appreciated ??

    Increasing that number could affect the performance a little on sites with many orders and products but if it isn’t your case or you have enough resources, this value could be increased with some custom coding by using one of the hooks we have in place.

    Best Regards,
    Salva.

    Thread Starter Gomle

    (@gomle)

    Ok, would you be able to point me in the right direction to where I can find the hooks available?

    Plugin Author Salva Machi

    (@salvamb)

    Hi @gomle

    It’s on our plans to create a hooks reference documentation in the future but don’t have one yet. So the only way to find hooks is by inspecting the code.

    Anyway, if you take a look at the method that displays this value:

    \Atum\StockCentral\Lists\ListTable::column_calc_will_last()

    You’ll see a hook there.
    And also you can try to adjust this value to fit your needs:

    ATUM Settings >> Show sales in the last selected days

    I hope this helps.

    Best Regards,
    Salva.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Forecast of sales to help with purchase orders’ is closed to new replies.