I wanted to updated this.... a couple minutes later ... hahaha
so I did find third party products doing a general google search, can anyone give recommendations?
Also still would like to know which filemaker product will be needed. thank you!
Well, I'm fairly new to Filemaker but not online sales and SQL databases and programming. What I love about Filemaker so far is that it can save enormous amounts of time developing offline or desktop solutions.
I'm not sure it's quite ready for prime time as a heavy-duty ecommerce server on its own though as that isn't really what Filemaker is aimed at solving in my opinion.
The good news is that since Filemaker Pro is versatile in what it can import and export you can use any online ecommerce solution and most likely with little to no work, import the results into Filemaker on a regular basis.
I believe it's also possible to patch into say, your mySQL ecommerce database "live" and perhaps get the info you need for sales and reporting, so that's another possible option to glue your offline/online applications.
If you're going to do your complete ecommerce solution in Filemaker you'll probably need Filemaker pro advanced and Filemaker pro advanced server.
While I haven't done a Filemaker online ecommerce application yet, I think I'd personally suggest looking at one of the many existing and (possibly more) lightweight ecommerce apps in PHP/mySQL, and import data as needed. Since Filemaker can communicate with PHP, this may leave an upgrade path later should you decide to fully integrate Filemaker with the actual ecommerce/cart part of your application.