Clear the cart but

Need help Database
1

Hello everyone,
I’m a beginner and I’m doing a test project to learn how elements and workflows work.

In this project, there is a table in the CartItem database with some fields and another called order with a cart_items field of the cartitem list type and other fields. After creating this order with the list and the items in the workflow, the items are also created in the CatItem table. How do I delete the items from the CartItem table (clear the cart) so that when the page reloads the cart is cleared, but I would like the cart_items list to remain in the order table? Because how will anyone see or print the order without the items? When I perform an action to change something or delete something from the Cartitem table, the same items disappear from the order and that’s not what I want. I want to clear the Cartitem and the items remain in the order table. Is it possible to do this?

2

Hey I believe the best option is to create another table - order items - so you can delete the items from cart table

1 Like
3

This order items table should contain the cart items, right? And is this table related to the order table or just the cart table? And in the workflow, do I delete the items from this table or from the cart? I’m a beginner, that’s why I have so many questions.