Web Connection
E-commerce with FoxPro
Gravatar is a globally recognized avatar based on your email address. E-commerce with FoxPro
  Luca
  All
  Dec 19, 2023 @ 07:42pm

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

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Michael Hogan (Ideate Hosting)
  Luca
  Dec 20, 2023 @ 04:18am

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.

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Luca
  Michael Hogan (Ideate Hosting)
  Dec 20, 2023 @ 04:46am

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

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Michael Hogan (Ideate Hosting)
  Luca
  Dec 20, 2023 @ 05:48am

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

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Michael Hogan (Ideate Hosting)
  Luca
  Dec 20, 2023 @ 06:10am

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.

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Luca
  Michael Hogan (Ideate Hosting)
  Dec 20, 2023 @ 08:43pm

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.

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Tore Bleken
  Luca
  Dec 21, 2023 @ 12:16am

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.

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Luca
  Tore Bleken
  Dec 21, 2023 @ 12:28am

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

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Tore Bleken
  Luca
  Dec 21, 2023 @ 12:31am

Good, I look forward to hearing from you.

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Michael Hogan (Ideate Hosting)
  Luca
  Dec 21, 2023 @ 06:04am

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.

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Luca
  Michael Hogan (Ideate Hosting)
  Dec 21, 2023 @ 07:04am

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

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Luca
  Tore Bleken
  Dec 27, 2023 @ 08:17pm

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

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Tore Bleken
  Luca
  Dec 27, 2023 @ 08:33pm

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

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Rick Strahl
  Michael Hogan (Ideate Hosting)
  Dec 28, 2023 @ 12:56pm

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

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Luca
  Rick Strahl
  Jan 2, 2024 @ 07:25pm

Many thanks Rick.

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  PaisleyStevens
  Luca
  Jan 26, 2024 @ 07:04pm

Well, while it's not a common choice these days, FoxPro can still be used for certain applications. However, building a secure e-commerce website with FoxPro might not be the best idea. If you're still on the hunt for a solution, here's my two cents: instead of going down the FoxPro route, you might want to consider Magento 2 development services. It's a more modern and reliable platform for managing online purchases, and it has a strong track record in the e-commerce world.

Gravatar is a globally recognized avatar based on your email address. re: E-commerce with FoxPro
  Luca
  PaisleyStevens
  Jan 26, 2024 @ 08:10pm

Thank you very much, I understand now.

© 1996-2024