Calculate price on start date

  • Resolved dizerbox

    (@dizerbox)


    8 years, 1 month ago

    Hi, before purchasing the pro version, I would like to know if it is possible to create the next formula:

    We sell “products” on e a month basis. Let say it is 50 euro a month. If someone starts their subscription in the middle of the month, is it possible to calculate the price on behalf of the start date? For example:

    50 euro a month
    I start on the 22end of januari, I need the new price to be:

    (50 euro / 31 days) * remaining days = new price

    Thanks in advance.
    Ferris

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

    (@sefin)

    Hi dizerbox,

    Thanks for your interest in our plugin.

    I tried your formula and it almost works. Almost because it calculates the price with Excel function TODAY() but it gives an other PHP issue.
    We plan to fix it for next release within the end of February.

    If you need this customization quickly we can do it just for you.
    To have the best quotation, please contact us with the support chat button on our site:
    woopricecalculator.com

    If we managed to resolve your issue, please close this topic.

    Thanks,
    Riccardo

    Plugin Author Altos

    (@sefin)

    I tried again your formula and it works great!
    There is just a trick to do because you don’t have input fields, but WPC requires atleast one.
    So you should create one fields to assign to a white cell on Excel works (and the hiding with CSS).
    I used TODAY() function to let it works on Excel.

    This trick will not be necessary with next release.

    At your disposal for any need for clarification.

    Best regards,
    Riccardo

    Plugin Author Altos

    (@sefin)

    Hello!

    It’s been a few days and we haven’t heard back from you about this thread. If we don’t hear from you in the next three days we will consider it solved.

    Please have a read of the recent comments and reply if you still need our help.

    Regards,

    Thread Starter dizerbox

    (@dizerbox)

    Hey I am sorry for my delayed reply. Thanks for your help, but I don’t understand the formula that I should use.. could you please help me out?

    by the way, I already bought the plug-in ??

    • This reply was modified 8 years, 1 month ago by dizerbox.
    Plugin Author Altos

    (@sefin)

    Hi dizerbox,

    Nice to hear about your purchase.
    From now you should have to write to our forum to get PRO support. In this way I will attach to your new post the excel sheet and explain how to use TODAY() function. We’re here https://www.woopricecalculator.com/forum/.

    Best regards,
    Riccardo

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Calculate price on start date’ is closed to new replies.