Thanks Teodor - this looks really helpful.
I think the interest in this topic shows there is a need for some sort of eCommerce Extension in Wappler sooner rather than later.
2 Likes
I am following your demo but am lost as to how you got form the cart_session under &_SESSION to the table columns shown below it.
You must define it under globals.
Then you use it to filter the query.
OK Thanks. I’ll continue trying to get this to work for me.
Just a suggestion… When you select a Connection Name from the Properties/Connection dropdown, can this not pre-populate the Database Connections screen with data initially entered for recurring selections of the same Connetection Name? Would save having to type it in everytime you add an insert/update/upload/delete action step.
Unrelated to this topic line but after you add more fields to the MySQL dB, how do you refresh the Database Query Builder to recognize the additional fields when you select the dB from the + dropdown?
I am not sure I understand this?
Open the database connection step and just click OK.
Yeah I figured this would be unclear… I’ll send a demo vid of what I mean in a few minutes.
Here is a short vid of what I was talking about earlier…
dBConnection vid.mp4 (11.6 MB)
And the next vid shows what I mean about refreshing after a dB field(s) are added…
Refresh dB.mp4 (8.4 MB)
I am not sure I understand what are you showing with your video exactly. Can you please explain it more detailed?
The opening frames in the vid show a connection data already filled in from a previous step. Then as I add another server action and add another dB connection, the Connection Options will not let me go any further unless I fill in the connection data again. If I select the connection name under Connection Properties, can the Option screen be populated with the info I already entered earlier?
Why don’t you just select the connection from the dropdown instead of creating a new one?
Ohhhh… closet light just went on. I was skipping right to the Options button first before selecting the connection name. You’re always way ahead of me 
Thanks
I agree… having this extension would indeed be very useful and enticing for purchasing Wappler since the demands for online sales is spiking.
After following this thread, I was going to wait until an e-commerce extension was made available. But I thought trying to build one would be good experience learning how to use sessions and understanding better how to xfer dynamic info from one page to another. So…
Per Teodor’s note above, I added a session variable to my server connection:
Then I set up the query conditions:
Then I added Teodor’s session code to the top of the involved pages:
Then I opened my gallery catalog page with repeating data rows and looked for a way to have the catalog item info set in session state and be carried over to the orderform. But here’s where I hit a dead end. The button, as shown in the capture, captures the Item Number OK (which I’m using as my unique identifier) and appends it to the URL as it opens the orderform page.
Now what needs to happen, and where I need a lot of direction, is how to get the related data fields in the orderform be populated with the user-selected catalog item info so it can be inserted into a MySQL dB -AND- send an order email notice to the site owner.
Any suggestions or help to chip away at this challenge would be greatly appreciated.
My test site is available for review at: http://statecollegedev.com
1 Like
there is a thread here that will help you
I know this topic is now over two years old and still no Stripe tools. I can only assume that it is not coming at all. So, back to my original question. Can I build the site in Wappler and then safely move it to Dreamweaver to add the shopping cart integration using the DMXZone extension?
My time is running out. I have to redo the site and after doing it for ten years for them I would hate to say I can no longer do it. I have been putting them off for more than two years.
You can check this tutorial Brad, it is already pretty comprehensive:
I have already read that tutorial many times. Not helpful for someone like me that knows nothing about Stripe integration. Doesn’t even say where to get the products from or how to add to a cart or anything.
Believe me, I have gone through all the Stripe tutorials on this site as well as Stripe. They make no sense.
1 Like
You can easily build your own shopping cart and design it as you wish using the data store component:
1 Like