Closed

Tracking Project for Sales People/PHP/MYSQl addition

This project received 5 bids from talented freelancers with an average bid price of $320 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
5
Project Description

Tracking Project for Sales People/PHP/MYSQl addition to Admin Scripts.


We will provide you so you can check all script as shown in screenshots+
MySQl access for our DB and FTP area for your testing
Tasks in this project:

#1 . We need to add Affiliate tracking reading so sales people can be tracked for the customers they referred to the site and push to our admin interface.

*
You need to modify and add to this Success Script (paymentSuccess.php- see attached) for Credit Card Transaction that also push info a_aid for PostAffiliatePro JS – to also read this cookie of affiliate and add this to our admin interface see below so all our orders in our database also carry the referring affiliate a_aid value(some order would not have referring affiliates – so they will have default value of ‘Direct’ ***

See script attached

Here is the code that you need to grab referid and push into our admin interface
After wire and check payment

This is how our affiliate tracking pushes the a_aid value into their system for tracking
After a customer lands on our home page via an affiliate link:
Our [url removed, login to view]

<script type="text/javascript"><!--
[url removed, login to view](unescape("%3Cscript id='pap_x2s6df8d' src='" + (("https:" == [url removed, login to view]) ? "https://" : "http://") +
"[url removed, login to view]' type='text/javascript'%3E%3C/script%3E"));//-->
</script>
<script type="text/javascript"><!--
try {
[url removed, login to view]();
} catch (err) { }
//-->
</script>






(add in admin area later - another option menu with page to view all sales by referring affiliate, display all orders by date, status and by the referring affiliate with a n option to sort from higher to lower and the opposite)
Show their Tracking Code Info (from postaffiliatePro – what is in cookie see above)


#2. If you go to the signup process as a client
There is a small bug in confirm order – user has to click in middle to see page..we need to fix that..

3. on the signup page after filling up info:
[url removed, login to view]
see attached.
or the payment page screenshot
we need a field called
Have a Coupon? ( Input text field )Validate Coupon (button/link)
(do not worry
That will update price by subtracting or calculating if this is a % discount coupon to an amount deduction from total price.. the coupon price from total amount of package.(you have the amount of the package)
You need to add another table called Coupons
Where the field is
Coupon ID, CouponName, CouponDiscount% (can be null), CouponDiscountAmout), Notes, Status, CreateDate, Affiliate(if assigned by special affiliate), Associated2CheckoutPaymentLink, Expiration, PackageAssociation

• you need to bring the correct 2checkout payment link(will be created by us) based on the coupon showing for that special package.

** idea also that some sales people can be given special coupon for their prospective clients..I need an admin an area where I can assign a coupon like $20 off
Or whatever amount -> and assign to sales person. Only admin is authorized to assign coupons for salespeople which are set in database. Any other coupon would not be accepted.

You need to show if that order had a coupon also.

And of course you need to read the sales person cookie on the approval page and
Based on that to push to the correct sales person, and showing all in admin area as I said above



4. A. on the sign up page see below link:

I want also to add option By Wire/BY Check Request Form on this page

[url removed, login to view]

Customer will be shown a form (we can later make nicer)
of all field needed for check or wire. Please add the basic fields needed when someone make payment to company by check ( This Form/Page you will create will say: Please Send Payment by Check to: Company Name, Address:
City
State:
Country:
(I will give you info above)
Check in the Amount of: __________(Package Price)
For SEO Package: _________(Package Name)

I have read and agreed to all Terms and Conditions
and I will send Check to Company
Your Initial _____
Note: All SEO Work will start after Check has cleared.






Check Option fields would include also the
OrderID and would ask customer to print the OrderID and order amount(Print Form and Send with Your check)
And send it with his check.

• You need to push that info after He pressed Submit Check Payment
To the database with order set us pending, customer info, order info in to the tables in our database and our interface (including also payment type, Status, etc..All fields need to have the correct status – I will help you with the right statuses)


Would also go with an email confirmation to client after filling up info.
And will update all tables necessary with this info


B. The wire option:
Would List Company bank Info
And the needed fields ( Bank Routing number, Swift, Address , telephone..)
And update the DB with this info for the order like above just with the wire info.
Same process and design just for wire.
And also push all info to the database.

** Note You will need to add the Post affiliate Pro Code that push the cookie and sale info as shown above from our credit card page -> also send post affiliate pro also payment for wire and Check
And a filed that define type of payment – if possible with Post Affiliate Pro. I will help.




Both payment types by Check or Wire will have to be pending
Until money is received. Later admin can go to database and change their status
And also change them in Post Affiliate Pro – our affiliate program.

IMPORTANT: Both addition by Check and Wire also need to have their own
Approved page confirmation created by you.(basic) and both send the affiliate program
The order Id, amount, ProductID
That is also part of your Project.

For this Check and wire orders
<script id="pap_x2s6df8d" src="http://Our [url removed, login to view]" type="text/javascript"> </script> <script type="text/javascript">
var sale = [url removed, login to view]();
[url removed, login to view]('<?php echo $pPackagePrice ?>');
[url removed, login to view]('<?php echo $pOrderId ?>');
[url removed, login to view]('<?php echo $pPackageLongName ?>');

[url removed, login to view]();
</script>


5. After email analysis form submission sees here:
[url removed, login to view]
We need to push also to this table:
Affiliate ID to our database.

Note:
Referring Affiliate (You read also the a_aid cookie and send this into database, and send it to us also via email with the affiliate associated if any with this Lead.
If empty put : Direct

You read affiliate a_aid from the cookie entered into our site via the affiliate program

** full access to DB and files will be give to selected coder

Thanks!

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online