Good afternoon folks, I would like to create an automation when the payment is successfully completed automatically send to the customer’s email a digital product searching the database.
The idea would be to create a database with several different passwords of the same product and as customers were buying were removed from stock and not sending the same password only once.
I am not a programmer, and would like your help. I know I have to create in backend an event called “onorderpaid” making a query to the database but I would like to know what specific code to use.
Could you copy and paste the code that you have written? Most likely you can send the code with the Wix email api - https://support.wix.com/en/article/velo-tutorial-sending-a-triggered-email-to-contacts
Once the code is sent via email you can then remove it from the database and save it to another “Purchased Codes” DB
Actually I didn’t write, I simply copied the codes from the wix help page. I created the database, even so I do not know if it is well created.
I identified the database in the code but redirect each digital product for each purchase or quantity I do not know!
I will send some screenshots and maybe then I can explain better.
I can’t post the code, wix blocks when I go to publish