Wondering why can you post to periods that have been closed? E.g. Why is NetSuite allowing you to post to AP when the period is closed? Are you logged in as Administrator? Administrator users have the access to “Override Period Restrictions permission” by default. Create a new role and make sure this permission is removed.
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?
Our Schema for Ecommerce Clients for the different record types Order Information Schema Line Item Information Schema Product Information 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 email@example.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
@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 firstname.lastname@example.org . 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
@Version 1.0 Table Name: reporting_product_flat This table contains information about each product with all their attributes as described below. If some thing does not fit into your ecommerce configuration, do give us a shout at email@example.com. We do understand many of these attributes do not make sense to your business. This is complete customisable using
Continue reading Magento: Product Information Schema
Predicting Retail KPIs using Magento & Machine Learning from Rud Boruah
This is me speaking in the main stage of Magento Live UK 2014 in London.
If you missed my talk in the Magento Live UK 2014, you can find the slides and videos here. Conference Website: http://magentolive.com/uk/speakers/ Download Slides : http://www.slideshare.net/RudBoruah/predicting-retail-kpis-using-magento-machine-learning Video: