#526 advanced calculation needed - don't know how

Posted in ‘Technical Support / Bugs’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by Michael Melson on Monday, 03 November 2025 11:18 UTC

Michael Melson

Hi!
We find it amazing to built productzs based on normal articles - that really is a great feature.

I have to find a solution for a tricky task.

We are selling timeslots for digital signage displays.

The calcultaion base is a fixed price for 20 seconds. The client can name the length of his spot (input field?).

  • A discount has to be calcultated for each second less
  • An extrafee has to be calculated for each second above 20 seconds

Is this possible and if - how?

Thank you for any tipp!

Adam Melcher

Michael,

I'd love to offer you some tips on this, but need a little more information.

So there is a set price (let's say $1,000 for 20 seconds as a baseline). what is the shortest length timeslot you can sell and what is the longest?
extrafee's can be configured based on what each second costs (above and below)

is this the only variable you need to collect or are there other input fields needed as well?

Adam

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Michael Melson

Thank you.

Just left a 5star rating at the JED ;)

Here's the exact calculation needed:

Baaseprice for 20 secs. video for 30 days = 45 € (1.5 €/day)

1 day = 150 €/day

7-29 days = 75 €/day

baseprices may vary - but the system remains the same 

Adam Melcher

Michael,

 

Thank you for the review, every single one helps us get closer to our goal of being the #1 Ecommerce extension on the JED!

Regarding the pricing - we are getting closer, but I have a feeling it's more fleshed out in your head than in this ticket as I am still missing something... 

 

Let's start with the baseline product:

PRODUCT-A:
20 Sec Video Slot = 1.5€/day (do they have options for how many days besides 30?)

baseprices may vary - but the system remains the same - can you explain this in more detail? I have an idea of how I would handle this, but there are some gaps I need filling.

Walk me through an actual customer user case:

ie:

  • customer a wants to advertise a 20 second spot for 30 days  so his price is 1.5€/day x 30 days + 75 €/day x 30 days ?
  • customer b wants to advertise a 10 second spot for 15 days  so his price is 1€/day x 15 days + 75 €/day x 15 days ?
  • customer c wants to advertise a 20 second spot for 6 days  so his price is 1.5€/day x 6 days + ?

 

Adam

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Michael Melson

Sorry, but somehow I missed to save my reply :(

1 to 6 days = € 150/day

7 to 30 days = € 75/day

from 30 days = € 1.5/day

  • customer a wants to advertise a 20 second spot for 30 days  so his price is 1.5€/day x 30 days
    each second less gives a discount X and each additional second gives a surcharge X

  • customer b wants to advertise a 10 second spot for 15 days  so his price is (75€/day x 15 days) - discount X

  • customer c wants to advertise a 20 second spot for 6 days  so his price is 150€/day x 6 days

The result should be something like this:

https://wedooh.de/digitaleplakatwerbung/39128-magdeburg-crucigerstrasse-24-519-22

Can you configure this for us or evt. do some custom work to realize it?
What's the price?

 

Thanks in advance and regards

Michael

Stay Updated

Subscribe for free and be the first to know about the latest features, updates, and new additions.