Dear Rick,
where could I find examples to use FoxPro for manage online purchases?
Or it is unsafe to create an e-commerce web application with FoxPro?
Many thanks for support

PMFJI, but my biggest Foxpro/WebConnect client is at https://www.interlightus.com/

We have tens of thousands of products on the site, so search speed optimization has been key.

The same codebase serves Canadian customers at https://www.interlight.ca/ in CD dollars, of course, using daily automatic updates of currency conversion rates.

Hi Michael,
great work! I'm trying to understand HOW e-commerce is developed with FoxPro: what are the procedures involved in online purchase transactions. I can no longer find the product that West Wind had dedicated for this purpose. Thanks

I didn't use the e-commerce version of webconnect. Rick can confirm - but I don't believe the e-commerce version of WebConnect is available any longer.

No matter - vanilla WebConnect does everything I need with greater flexibility.

The design process I use is to design your standard pages using a conventional web design tool (home page, generic product page, contact page, search pages). Then replace the parts that change (product name, price, description, etc) with hidden variables that will be populated from your VFP tables based on the product code. Your VFP code will then do a simple string replacement to populate your web page with product-specific info.

The workflow is just like designing an app in VFP, except that instead of using an SCX, you're using an html web page with embedded variables and capturing user-entered info (like product quantity) OnSubmit().

The WebConnect design process is described here: https://webconnection.west-wind.com/docs/_335108he0.htm but I prefer using HTML templates with the strtran() process I described above for more hand-crafted page designs.

HTH

I should add - for less customized website designs, Rick's standard page designs are great and easy to implement.

When it comes to collecting online payments, we can talk further. Lots of folks (Rick included, I think) grab the order tables from the website and process payments and shipping and such from a desktop app.

Dear Michael, thank you very much again for support.
I use Web Connection 6.05 with great satisfation, it is a powerful tool to enable FoxPro to web.
But I do not know anything about transactions and online purchases.

Luca, if you want any help, feel free to contact me. I have set up a few "web shops" using WWWC, although I admit that it's several years ago.

Many thanks, Tore!
I have the flu now, but as soon as I get better I will certainly write to you.
Sincerely

Good, I look forward to hearing from you.

Sorry - I misunderstood your question.

Most payment processors provide prebuilt checkout pages which you can easily edit with foxpro code. I like to use https://stripe.com/ which provides an easy-to-modify template. It redirects to their Stripe Payment Processing website (which can be customized) for payment, and then returns to the specified page on your website with the results (success, failure, cancellation).

Samples at https://github.com/stripe-samples/accept-a-payment

I have found Stripe to be relatively economical for small volume websites, and easy to customize.

Hi Michael,
this is just I need.
I will study it as soon as I will be recovered from the flu.
Sincerely

Dear Tore,
excuse me, but I do not know your email address.
Many thanks

Yes, you have. I will answer you later this week.

Another thing to consider is BrainTree - I use them because they provide a simple API to process both Credit Cards and PayPal as well as Apple Pay and a few other alternative services (although the Apple Pay integration is onerous).

Having PayPal handled through a direct API rather than the Redirect based back and forth via PayPal Flow is lot easier and transactions for both are captured in the same admin interface which is nice.

Unfortunately they haven't invested in nice pre-built UIs like Stripe which is a downside, but if you have the time you can build your own within the confines of their templates.

+++ Rick ---

Many thanks Rick.

Thank you very much, I understand now.