Hello Eddie, Thank you for contacting us! The orders are stored in the sf_ec_order and sf_ec_order_detail tables for reference. the order details are the actual products that are a part of the order with their prices and quanttiites. They are accessible via API and you can query them based on the snippets provided here and if you need custom functionality we always recommend using the API instead of directly querying the database, since we work on top of an ORM that takes care of database mappings and a lot of infrastructure. Orders are searchable in the back-end are searchable by customer name or email. (see attached screenshot #1). Editing the order's id, products customer is not avaialbe, however you can edit the status of the order or add shipping tracking information and details(as seen in the second attachment). Editing is easy to achieve via API described in the docs, but it is best to get a better idea around your use case, because different considerations apply for different cases - for example if a customer was charged with $10 for an order and we change the order's total price in the database, but not the price of each product in it, there are calculation inconsistencies in the system in regards to what reports you get in Ecommerce vs. what a person actually paid. Let us know if we can provide any further details or if you have any other questions as well!
Regards, Svetla Telerik