Need Help - Copying Data from "Cart" Database to "Confirmed Orders" Databas

Dear Bubble Community,

I hope this email finds you well. I am currently working on a project where users can add items to their cart and proceed to checkout using the Stripe payment gateway. Once the payment is successfully completed, I would like to copy the data from the “Cart” database to a new database called “Confirmed Orders.”

I am reaching out to seek your expertise and guidance on the most efficient and straightforward method to achieve this. I have already set up the “Cart” database to store users’ selected items, but I am unsure of how to automate the process of transferring this data to the “Confirmed Orders” database upon successful Stripe payment.

If anyone has experience with a similar workflow or can suggest a simple approach to accomplish this task, I would greatly appreciate your assistance. I believe that your insights and expertise will be invaluable in solving this challenge.

Thank you in advance for your time and support. Your contributions to the Bubble community are immensely valuable, and I am looking forward to learning from your expertise.

Get rid of the Cart datatype and have them actually make the order items when they are adding to cart. Then a yes/no field on it indicating if it’s for a cart or an order. After successful payment switch all the item’s yes/no field.

Otherwise if you don’t want to do that, use the Data API, and the Bulk Create endpoint

Which would essentially copy over from one datatype to another once you have it all set up.

1 Like

Thank you so much for your help

1 Like