I’m trying to find a way to extract ALL products that are in current cart to google sheets after they are being successfully purchased. I can only extract ONE product(its usually the first one that is added to the cart) but all other products are missing.
My database is consistent from Products, Order items and Carts/Orders. Everything works just fine, when user logs in the new cart is created then if he click on some product, that product is added to order items(that has a relationship with the current carts/orders colection) but then when he finishes that purchase I created a new row in my google sheet with all the info from the user but only part that is missing is products that the user has ordered.
I have been banging my head with this one so any help would be appreciated.