Find Jobs
Hire Freelancers

Tracking Project for Sales People/PHP/MYSQl addition

$30-250 USD

Closed
Posted almost 14 years ago

$30-250 USD

Paid on delivery
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 [login to view URL] “ <script type="text/javascript"><!-- [login to view URL](unescape("%3Cscript id='pap_x2s6df8d' src='" + (("https:" == [login to view URL]) ? "https://" : "http://") + "[login to view URL]' type='text/javascript'%3E%3C/script%3E"));//--> </script> <script type="text/javascript"><!-- try { [login to view URL](); } 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: [login to view URL] 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 [login to view URL] 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 [login to view URL]" type="text/javascript"> </script> <script type="text/javascript"> var sale = [login to view URL](); [login to view URL]('<?php echo $pPackagePrice ?>'); [login to view URL]('<?php echo $pOrderId ?>'); [login to view URL]('<?php echo $pPackageLongName ?>'); [login to view URL](); </script> 5. After email analysis form submission sees here: [login to view URL] 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!
Project ID: 672410

About the project

5 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $320 USD for this job
User Avatar
Please check out my work in pm
$299 USD in 9 days
4.9 (77 reviews)
7.6
7.6
User Avatar
I can do it. Thanks, cygital.
$250 USD in 10 days
4.9 (32 reviews)
5.9
5.9
User Avatar
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 need of any size within global reach. We have analyzed your project description and clearly understood your requirements. Please see PMB for more details and for our sample copy.
$600 USD in 30 days
4.7 (13 reviews)
5.8
5.8
User Avatar
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. Please Check PM... Thank.
$200 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Valencia, United States
4.9
333
Payment method verified
Member since Mar 3, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.