I'm using digiSHOP 7.9.00 PRO.
Which table in the database stores customer purchases?
I want to see a product number, matched with a customer number so I can see which customer bought which product.
I would think it would be the ds_orders table, but it doesn;t appear to have all the info I would expect (I can;t see a product number anywhere).
The site I am using uses events as products, so purchasing a product is purchasing a place at a table at an event.
There is something in the ds_carts table but that adds a record everytime somebody adds an item to their shopping cart, so I don;t know who has paid and who has just added to cart.
I want to see a list of all custmers who have paid for each event / product.