Magento Website, Store and Store View. Configuration Table
Same for 1 and 2
Related cards:
Websites, Stores, Store Views
Here is what can be set at each level:
Default | Web Site | Store | Store View | |
---|---|---|---|---|
Product attributes | X | X | ||
Product prices | X | X | ||
Product tax ... |
Table Creation In Magento 1.6/1.11+
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'))
->...
View Status of EE Mview Changelog Tables
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 (...
Nginx Virtual Store Subdirectories
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 ...
Cache Clearing And General Information
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...
EAV Tables
A list of EAV tables and their purpose.
|----------------------------+-------------------------------------------------------------------------------------|
| Table | Contains ...
Creating a Datetime attribute that stores time
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...
Display Out Of Stock Configuration Option
The decision of whether to show or hide a product based on this setting is implemented
by the Product Price Index.
You can verify this by changing the setting to "Yes" and then viewing ...
Setting Data Per-Store On Entites
Certain entities (Products and Categories, for example) have the concept of a
store scope, whereby you can set the default value for all stores, or you can
set a value on a per-store basis.
You could do it this way, and this is probably how most ...
Dataflow Per-Store Import Causing Copy of All Attributes
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...