is there a table that stores a specific product purchased? for example, if someone bought two wigits, would there be a table that has two additional rows because of that?
I'm asking because I want to sell non-shippable stuff, and when ecommerce tells me someone has purchased this product, I make a row in my table with a fk reference to the ecommerce table, so that later if they exchange or refund, I can see the ecommerce table row as well as my table row.
Look at ec_items table. The ecommerce doc at your-ecommerce-instance/doc/ecommerce-technical has information about the order states from ec_orders, which are linked.