How to set different costs over time?

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • October 28, 2021 at 3:47 pm #89826
    anthony
    Guest

    Hello,

    I use PRO version of this plugin and i use it for make inventory cost of my stock.
    I would like to know if it’s possible to indicate 2 differents price for the same product.

    -For exemple on 01/10/2021 i bought from my supplier: 5x tee shirt at 5€/pc.
    I sold 3piece => stay 2 piece in stock.
    -On 25/10/2021 i bought again 5pcs but at 6€/pc
    =>My cost inventory of 25/10/2021 is  :
    2pc at 5€
    3pc at 6€
    total stock = 10€+18€ = 28€

    Actually i change the price by new ( last) price for inventory cost so it’s false total cost.

    have you idea to manage this ?

    thanks,

    October 29, 2021 at 3:16 pm #89827
    Zohaib
    Participant

    Hi,

    You can set the plugin to use the average cost of the inventory. In the plugin’s settings:

    Products > Add stock > Cost calculation expression you can set the formula for average cost calculation.

    By default it is

    ( %stock_prev% * %cost_prev% + %stock% * %cost% ) / %stock_now%

    You can change the formula to suit your requirements.

    If you use the default formula, in your case this would be calculated as: (2x€5) + (3x€6) = €28/5 = €5.6 average cost per item and your total stock would be worth €28.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.