Skip to Content

New J2Commerce 6.6.5 is out. Here is everything in the release.

See What’s New

Search

Start For Free
Account
Enter the email address on your account.
Forgot your username?
Enter your password.
Forgot your password?

Or continue with

Open Public Technical Support / Bugs Ticket #526

advanced calculation needed - don't know how

This is a public ticket

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

Conversation

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 Staff

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

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 Staff

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

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