Tracking Project for Sales People/PHP/MYSQl addition

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 type="text/javascript"><!--

try {

[url removed, login to view]();

} catch (err) { }



(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:




(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]();


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.


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


Habilidades: MySQL, PHP

Ver más: sale php mysql project, www people, write note for special person, work from home success, work from home request email, work from home direct sales, work from home coupons, work from home affiliates, what do it people do, what can i do from home to make money, want a coder for a company, via swift, value city, validate credit card, us bank com, type of button in php with code, type name for design, total bank, thanks you notes, system err

Información del empleador:
( 333 comentarios ) Valencia, United States

Nº del proyecto: #672410

5 freelancers están ofertando el promedio de $320 para este trabajo


Please check out my work in pm

$299 USD en 9 días
(77 comentarios)

Hi,I am Interested and [login to view URL] check our users feedback on [login to view URL] you.

$250 USD en 5 días
(37 comentarios)

I can do it. Thanks, cygital.

$250 USD en 10 días
(32 comentarios)

We are a team of highly qualified professionals with years of experience in software development, web development, Graphics/Multimedia, and Data entry. We are dedicated to provide complete IT services to customer's nee Más

$600 USD en 30 días
(13 comentarios)

Hi, we would like to help you with your work. We have the required technical expertise and people to do the project. If you are comfortable to go along working with a company based in India, please let us know. Más

$200 USD en 20 días
(0 comentarios)