My.ADVISOR.com Sign-In
Username
Password
Sign Up 
Go to Article
Advanced Search 

WEB DEVELOPMENT

Sell Your FileMaker Pro Solutions with PayPal

Learn how to integrate the Web viewer with PayPal to automate software sales.

 Subscribers: Sign-in to activate download link -- Database and additional files for implementing PayPal integration in FileMaker Pro solutions.
By Michael Petrov, FMWebschool partner

UNLOCKED -- This article is provided to subscribers of FILEMAKER ADVISOR or DATABASED ADVISOR or FILEMAKER ADVISOR. To subscribe or renew, go to Advisor Store.

Many commercial FileMaker Pro solution providers offer limited demonstration versions of their products. If the user likes it, he can call the company or visit a URL to purchase it. After the transaction is complete, he might get a new copy of the unlocked database solution, or an activation key to unlock the demonstration version. In either case, the vendor must be involved, which can lead to delays in processing time due to time zone differences and lack of automation. It also opens the possibility of support requests with the customer asking what to do with the limited solution, where to put the activation key, or other issues that may divert you from product development tasks. What if you could make this process streamlined, automated, and painless for everyone involved?

In this article I demonstrate how to build a solution with an automated registration procedure that requires no maintenance on your part and lets the user unlock the solution in minutes. The method doesn't require any plug-ins and uses PayPal as the payment processor. With some work, you can automate other payment processors in a similar manner. The requirements for this solution are: FileMaker Pro 9 or 8.5 (you'll need Web viewer support), a Web site to host the two HTML files, and a PayPal Sandbox account for testing purposes (click on the link to register free.

First, a few words about PayPal as an automated payment platform. One of the most popular payment processors online, it allows payment for services without sharing credit card details with the merchant. The PayPal platform offers many integration options such as product links for placement in e-mails, Web page links, recurring payments, and dynamically generated carts. You'll use the dynamically generated cart as the integration method in this solution. For this example, you'll call PayPal using an HTML form that sends variables to PayPal. The variables describe the payment and include additional instructions to redirect the user to a special page following a successful payment. The solution reads this special page for the activation code and unlocks the solution when the user reaches the successful payment page.

Let's get started

The first step is to create the HTML files on your server that will send the request to PayPal. Subscribers can download the product1_purchase.html file that provides a starting structure for the PayPal request. Open a copy of this file in your favorite text editor -- BBEdit or Notepad work well. The HTML file includes two sections: a JavaScript function to submit a form automatically (this function is called when the page finishes loading), and a form for PayPal information. You'll make a few simple changes to configure this page for your product.

First, customize the setting for the receiver of the payment. Find the hidden HTML input "business" and change "sales@yourdomain.com" to the PayPal address you use. Next, you want to produce a PayPal receipt. Find item_name and change "my product" to the name of your product, then find "amount" and change the 29.99 price to the price of your product. Make sure to use proper decimal notation and do not omit the period even if you've rounded the price to the dollar (e.g., use 10.00 for $10). Finally, set the special return page with the activation code as the page to go to after a successful transaction. Find "return" and change its value from http://yourdomain.com/product1_paid.html to the complete address of your successful payment page.

This simple HTML form sends information about your business to PayPal, a reference to the product, and a return page the user will be sent to when the payment is completed. Notice the form action sends the user to www.sandbox.paypal.com. When preparing this solution for a production environment, change this address to www.paypal.com to process real payments.

Sell Your Solutions with PayPal

No reader comments ... yet.

    What do YOU think about this topic? Share your advice and thoughts using this form.

    Your Name

    REQUIRED : PUBLIC

    Your E-Mail

    REQUIRED : PRIVATE

    Job, Company

    OPTIONAL : PUBLIC

    City, State, Country

    OPTIONAL : PUBLIC

    Your Web Site

    OPTIONAL : PUBLIC

    Your Comment

    Please help everyone by keeping your comments on-topic, using clean language, and not defaming or making personal attacks.


    Your e-mail address is required, but it will not be displayed to the public or given to anyone. See our Privacy Policy. Comments become visible after they pass our spam filter, and spammers and abusers are permanently blocked. Please report spam or abuse.

    Michael Petrov is a partner at FMWebschool Inc and co-author of FileMaker Web Publishing: A Complete Guide to Using the API for PHP. Michael has been instrumental in the development of the FMStudio Web publishing suite connecting FileMaker Pro and Adobe Dreamweaver, as well as the Dolphin Cart shopping cart system. With 10 years of experience in classical and Web programming environments, his current specialties are PHP, FileMaker, JavaScript, and MySQL. http://www.fmwebschool.com

    Printer-friendly
    page layout

    Keyword Tags: FileMaker, FileMaker Development, FileMaker FileMaker Pro, Web Development

    ADVISORAMA
    Compared with the Borg, this crew is inefficient and contentious. But it is capable of surprising acts of compassion.
    -- Seven of Nine, Star Trek: Voyager

    ARTICLE INFO

    FileMaker Advisor

    Web Edition: 2008 Week 02, Doc #19355

    Print Edition: March/April 2008, Page 32

    SUBSCRIBER ONLY ARTICLE LOCKED


    File: Database and additional files for implementing PayPal integration in FileMaker Pro solutions.
    Subscribers, log-in for Download link.

    Subscribe to FileMaker Advisor Magazine

    Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.

    FileMaker.Advisor.com

    Subscribe to Advisor Basics of FileMaker Pro

    Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!

    FileMaker.AdvisorBasics.com

    Secrets Of The Top Experts -- Now!

    See exactly how to do it, step-by-step, in Advisor Academy CDs created by the top experts. Click to see what you can learn right now.

    AdvisorAcademy.com

    Free E-Newsletters

    Keep up! Hot News, How-To, Tips & Tricks, Expert Advice, and more. Click to request your's free.

    AdvisorUpdate.info

    Need Know-How Now?

    What direction are you going with your business? Advisor Guides are packed with the answers you need to work smarter. Can you afford to fall behind?

    AdvisorStore.com

    Showcase Your Smarts

    Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!

    AdvisorTips.com

    Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
    Portions copyright ©1983-2008 Advisor Media, Inc. All Rights Reserved.
    Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
    ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
    Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
    petri001 posted 01/14/2008 modified 05/12/2008 03:44:13 AM ztfmfd/ztfmfd
    domino-144.advisor.com my.advisor.com 05/16/2008 12:29:43 PM