Hello,
I use auto script. I want to display the average price of each car based on its build year filed on the listing page.
Please help me which file to edit and how?
Printable View
Hello,
I use auto script. I want to display the average price of each car based on its build year filed on the listing page.
Please help me which file to edit and how?
Hello,
Do you mean some formula by which the average price should be calculated?
Go to includes > controllers > listing_details.inc.php
and after:
assign a new price using your formula:PHP Code:Only registered members can view the code.
PHP Code:Only registered members can view the code.
Hi Rudi,
I think it is not true because the variable: $listing_data['price'] has format: 100|dollar and this variable cannot be used in a formula.
Mousa, how do you want to calculate the average price by build year? Send us formula and we will create code for it.
Also, Do you want it on details page or category browse page?
my mistake,
it can be done like that:
PHP Code:Only registered members can view the code.
Hello,Quote:
Originally Posted by Viktor
Thanks Viktor and Rudi for yours response.
I want calculate conditional average price by build year filed (Same AVERAGEIF Function in Ms Excel).
Please check Attached image
Attachment 2874
I don't see any formula, only list of prices by categories and years. But how do you want to calculate it?
Or maybe you want middle price between your cars? For example:
car1: 21000
car2: 22000
car3: 25000
formula will be: (car1+car2+car3)/3 = 22.666USD
I want to calculate the average price of each car based on its make year and to put it in the listing and tell the user that the price of this car is cheaper than the average of similar cars made in the same year or it's cheaper.
So I want to calculate the average price of each car based on its make year. For example, the car1 that was built in 2016 and has 5 ads, its average price. Only the average car1, the year of construction of which is 2016, is not included in the formula if the year of construction of the car1, in 2017 or any year except 2016.
Please see the attached image
Attachment 2877
so you need that the average price to be calculated based on the listings number with the same model and year ?
and this average price to be displayed on each listing of the group ?
if so, it can be done as a customization
your attached image is broken
Exactly. Average prices for similar cars built each year (based on the price of car ads that users have entered)
I want to insert a button "Price Analysis" in the box for each auto listing in listing page by clicking on it to show this message:
The average price for this car in 2016 is $1,000, and therefore the car's price is Suitable (cheap)
or
The average price of this car with the year 2016 is $700, so the price of this car is Unsuitable (expensive)
But prices for the same cars can be different. Many many criteria and conditions should be included for calculation final Average price.
For example, 2 cars with the same model and same year can be with different transmissions: automatic and manual and price should be different also.
That's why I don't know how do you want to calculate average price without formula. I know "Price Analysis" it will take all cars with the same model and year from your site and show users average price.
Like: your car cheaper for 5% than other cars on this site. OR your car expensive for 9% than other cars on this site.
Hello,
Thanks Viktor for your reply
I want to count the average price only based on the model and year. In defining categories, I've solved other problem types such as type of transmissions, etc.
as I said before we can make it as a customization