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!
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking
system and vote to affect the priority of the items