Magento: How to build reporting datawarehouse for Magento?

Disclaimer : Below information is from my experience with Magento platform. Right! so you have experienced the kiss of death by your awesome report or a feed generation in the dead of night ? Why ? Data intensive jobs especially mundane tasks like sitemap/google feeds generation take up lot of your DB power and results
Continue reading Magento: How to build reporting datawarehouse for Magento?

Magento: Sales Order Line Item Schema

@Version 1.0      Table Name: reporting_sales_flat_order_item This table contains information about each line items as described below. If something does not fit into your ecommerce configuration, do give us a shout at info@suiteweekly.com Column title e.g value Description Notes item_id 1280555 Line Item ID This is the ID of the line item and can
Continue reading Magento: Sales Order Line Item Schema

Magento: Sales Order Schema

@Version 1.0      Table Name: reporting_sales_flat_order This table contains information about orders as described below. If some thing does not fit into your ecommerce configuration, do give us a shout at info@suiteweekly.com . sales_flat_order Description entity_id Order ID in Magento state The order state describes the position of an order in the workflow. Can be
Continue reading Magento: Sales Order Schema