Category Archives: Magento

Magento Indexing : Simple explanation

– In magneto, there is only database level indexing in spirit.

– Process of denormalization to allow faster operation of site.

PRODUCT
——-
product_id INT
sku VARCHAR

PRODUCT_ATTRIBUTE_VALUES
————————
product_id INT
attribute_id INT
value MISC

PRODUCT_ATTRIBUTES
——————
attribute_id
name

– Generate big table from beginning.
– So, queried from a single table.

– When you re-index, you are blowing up the old table and generating it again.

– Look up table are the magneto “indexes”

– So, for price of product if you query “catalog_product_index_price” instead of “catalog_product_entity_decimal”.

Create multiple store in magento

You can create multiple store in magento, just in a minute.

1) System > Manage stores

2) create website

-> example1.com and example2.com

3) Create root categories using ‘catalog > manage categories’ for these respective website individually.

4) While creating website, you must assing the respective root categories.

5) Create respetive store group and store view of these website.

6) In system > configuration > design

From the left, select the respective website,

In the General tab of configuration,

In the web section of general,

please put the respective ‘secure baseurl’ and ‘unsecurel baseurl’ like example1.com and example2.com

From design section,

Please select the respective design for your website.

7) In htaccess,

SetEnvIf Host www\.example1\.com MAGE_RUN_CODE=example2
SetEnvIf Host www\.example1\.com MAGE_RUN_TYPE=website
SetEnvIf Host example1\.com MAGE_RUN_CODE=example2

SetEnvIf Host example1\.com MAGE_RUN_TYPE=website

Changing within the same website, using store

SetEnvIf Host www\.example1\.com MAGE_RUN_CODE=english

SetEnvIf Host www\.example1\.com MAGE_RUN_TYPE=store
EnvIf Host ^example1\.com MAGE_RUN_CODE=english

SetEnvIf Host ^example1\.com MAGE_RUN_TYPE=store

8) You are ready to go.

Admin Login problem in magento

If you have used localhost during installation,Certainly, you will have problem during admin login.

Go to file : app/code/core/Mage/Core/Model/Session/Abstract/Varien.php.
Search for the below code and comment.
Note:: This code belongs to magento1.6
$cookieParams = array(
‘lifetime’ => $cookie->getLifetime(),
‘path’ => $cookie->getPath(),
‘domain’ => $cookie->getConfigDomain(),
‘secure’ => $cookie->isSecure(),
‘httponly’ => $cookie->getHttponly()
);

if (!$cookieParams[‘httponly’]) {
unset($cookieParams[‘httponly’]);
if (!$cookieParams[‘secure’]) {
unset($cookieParams[‘secure’]);
if (!$cookieParams[‘domain’]) {
unset($cookieParams[‘domain’]);
}
}
}