PHP/MYSQL Work For Slight Changes To Daily Deal Site.
$30-250 USD
Cerrado
Publicado hace alrededor de 10 años
$30-250 USD
Pagado a la entrega
I am looking for someone with decent PHP/MYSQL skills and who is familiar with the groupon style daily deal website to make a few changes to our script.
It would help a lot if you are familiar with [login to view URL]
We will change this format slightly.
We want there to be 4 levels of price..
So for example his start price for up to 10 sales is $300
Then he needs to set a second price say, once it reaches 11 sales then the price drops to $280.
Then he needs to set a third price of say, once it reaches 21 sales then the price drops to $250
Then he needs to set a final 4th price of say once it reaches 31 sales it drops to say $200.
This is the price EVERYONE pays. Once the countdown timer ends, whatever the price it ends on.... everyone pays.
So with the above example.... If there were 34 sales made then the price everyone pays is $250 no matter when they committed to their purchase.
Now then.... how this should be set up is in the 'add new listing' page in admin area, we need the coder to copy and paste the existing code for setting 'price' and 'minimum sales' to have it repeated. In the case of above example, admin would put 'sales min' , 'sales max' , 'price'.
So will be
Level 1...(sales min = 1) , (sales max = 10) , (price = $300)
Level 1...(sales min = 11) , (sales max = 20) , (price = $280)
Level 1...(sales min = 21) , (sales max = 30) , (price = $250)
Level 1...(sales min = 31) , (sales max = 50) , (price = $200)
So you just need to add a few fields to the 'listings' table in the db to hold this data. This will be echoed on the front end listings page.
These are all simple query things that will be fast to implement.
The actual only bit of dynamic code we want you to write is to handle the front end listing page view... the visitor will see the 4 price levels and of course 'the number of sales made so far'..... At any one time, there will only be one level active, the other three must be greyed out, and the active level based on current sale will be prominent in bold. So once level one sales have surpassed, and it moves to the level 2 price, then level 2 data will be bold and level 1,3 and 4 will be greyed over. You can set this up by simply calling a CSS property to add a greyed effect.
Now then.... This website is for the Thailand market, and they do not like to use online payment like paypal... so that makes a problem for adding the sales, because the system won't know if anything has been paid, or whether many of the sales are faked to drive the price down..... so we have decided that admin will have to add sales manually.
So we need to add a 'current sales' field in the database that admin can update from the 'listings' page in admin panel.
Here is the flow of a sale.
Visitor hits 'buy' button, and is taken to a checkout page (we will add all this ourselves)... This will create an 'order' and will get added to db as a 'pending' sale and won't be added as a confirmed sale.
He is then presented with bank transfer details.
Customer will pay through bank transfer and will contact the admin who will set the order to 'paid'... The coder needs to add something for the admin to be able to update number of sales from listing page.
However, because the price changes, the customer only pays a deposit set by admin in the 'listing' page. Then the balance will be determined at the end of the countdown timer. The coder will need to add code to call a query from the 'listing' table to see what the number of sales were on expiry and then deduct the deposit from that price and issue an invoice to pay balance to all customers of that listing.
So the required work is simple.
Add 'qty/price' fields in 'admin>add listing' page.
Add 'deposit price' in 'admin>add listing' page.
Add code to grey out 3 inactive price levels and keep active 'bolded'.
Add code to work out 'final price' and subtract deposit and issue invoice for balance.
Add code for admin to manually update 'number of sales' info in admin>add listing' page.
hi
we could do it perfectly with accuracy,
please let us know if you want any clarification.
if you want us to share our skill and previous work
please initiate the chat..
Hello sir i am new user on freelancer but not to new on development i have last 5 yr exp on this so i need one chance I can complete your project within your budget and by the date you have specified.I am excited for this opportunity