Magento

I need to retrieve the order details from database ,when i searched the database i get confused. where are my orders ? but it is listed in admin portion, How the information is retrieved and from which table ?

First, you should have a look at the Entity-Attribute-Value model concept.
See for example:  http://en.wikipedia.org/wiki/Entity-Attribute-Value_model

Then have a look at sales_order_entity table that gives you the order entities relations (see entity_id, parent_id columns). Then lookup references to the other sales_order_entity_* tables which give you the values for the entities on the different attributes. You should check eav_attribute for the definition of these attributes.

Well, this requires a small effort to understand, but in the end, it’s quite straightforward.

Still, it’s not recommended to interact directly with the database, as it can change between Magento versions.
Would be wiser to build on the code objets, or future webservices that may be available…

or future webservices that may be available…

Currently, is there no API to get this kind of data ?

Here’s how to get an order by publicly available id:

Moshe, you rock. After a day of trying to figure out how to export orders, this gave me the answer about an hour later. I have to do it this way because my order feed keeps telling me my credentials are wrong.

my module will do this no problem http://www.magentocommerce.com/extension/2063

Is there a way of getting all orders and its details done on a particular date ?????????