In Progress

Create & Rebuild Database Daily

I have a website that sells lots of different products.

Part of the website lists the products in order of total sales.

I want to create a brand new way of ranking these products which will require rebuilding the ranking database every day.

How I want the new ranking system to work is this.

For every sale a product has made in the past 7 days it earns 1 ranking point.

For every sale made between 7-14 days ago it earns 0.8 ranking points.

Sales between 14-21 days ago earn 0.6 ranking points.

Sales between 21-28 days ago earn 0.5 ranking points.

Sales between 28-35 days ago earn 0.4 ranking points.

Sales between 35-42 days ago earn 0.3 ranking points.

Sales between 42-49 days ago earn 0.2 ranking points.

Sales between 49-56 days ago earn 0.1 ranking points.

All products that haven't made a sale the past 56 days are listed after all products that have, and in order of total sales made. The sales table already has a 'total_sales' column.

Every 24 hours the scores should be added up and the products listed in order of highest points first.

As of now these products are just listed by total sales, and can be searched by keyword and/or category.

On the results pages that display the products, I want to show the ranking points beside each product listing.

Skills: AJAX, Javascript, MySQL, PHP

See more: want create new website, want create database website, highest ranking, create sale website, website rebuilding, rebuilding, rebuild website, daily sale, create brand, create sales system table, points sales, php point sales, create website daily earn, create website earn, javascript table ranking, sales order table database, earn create website, point sale database, ranking system website, database point sale, daily sales database, sales system database, database lists, website earn daily, php point sales system

About the Employer:
( 60 reviews ) Belfast, United Kingdom

Project ID: #2512953

Awarded to:

remilion

Hi, I can do this simple task for you till your satisfaction. Please check PMB. Regards

£30 GBP in 2 days
(5 Reviews)
2.4

6 freelancers are bidding on average £205 for this job

epark

=====Expertness and honesty our goal . we are small team working good quality and accuracy. Ready to start your project.Please check pm.Thank you===========

£250 GBP in 14 days
(127 Reviews)
6.8
NulogeCorp

I'll make you a demo in 6-7 hours, without any obligation, Would you like a demo Sir?

£250 GBP in 0 days
(15 Reviews)
3.8
manan777

hi i am expert developer.i can do this job.

£100 GBP in 5 days
(4 Reviews)
4.2
israr57

Hi sir check your PM. Thanks

£400 GBP in 20 days
(0 Reviews)
0.0
ravivooda

We understand the requirements of the job and consider ourselves apt for it.

£200 GBP in 3 days
(1 Review)
0.0