Yesterday I read a Inchoo’s post that expain very good how Magento store information about an invoice workflow, from quote until invoice, clearly explaining what tables are used that can serve us very well for reporting and make our sales information. To summarize and I like to put relational diagrams, the ... Read More
The 1.6 version of Magento has a total of some 250 tables, finding information is quite complicated, which is why we can get through mageverse table relationships. With regard to information of all orders, the main table is sales_flat_order and their relationships are: For example if we want to show ... Read More
