Magento Website, Store and Store View. Configuration Table

Here is what can be set at each level:

Magento CE 1.6 and PE/EE 1.11 introduced database abstraction, this is the way to set up tables using the new code.

$table = $installer->getConnection()
    ->newTable($installer->getTable('your_module/table_name_in_xml'))
    ->...

This SQL:

select emm.view_name,
    emm.status,
    emm.version_id as metadata_version,
    cl_max_versions.max_version as cl_version,
    (cl_max_versions.max_version - emm.version_id) as behind
from enterprise_mview_metadata emm
left join (...

Note - this article only applies to nginx and PHP-FPM!

If you want to have stores which are accessed via subdirectories as opposed to domain names, the standard method I've found is to make a directory with a copy of index.php in it, using ...

Clean everything (use either):

Mage::app()->getCacheInstance()->flush();
Mage::app()->getCache()->clean();

Clean specific types:

Mage::app()->getCacheInstance()->cleanType('config');
Mage::app()->getCacheInstance()->cleanType('l...

A list of EAV tables and their purpose.

|----------------------------+-------------------------------------------------------------------------------------|
| Table | Contains ...

Fancy importing a subset of some product attributes on a per-store basis, whilst keeping the attributes that weren't imported using the defaults?

Tough, you can't!

Well, not with dataflow anyway. [This card](https://makandracards.com/magento...

Magento has a Datetime backend model but formats a Zend_Date object without the time. So if you want to store datetime (actually with time) you will need to setup your own backend model.

Here is how i've done it:

class Namespace_Module_Mod...

Here is a table showing major changes over the Magento version history:

| CE | PE | EE | Year | Major Changes ...

This is a high-level view of the Magento Model, Resource Model and Resource Collection Model structure