Monthly Archives: February 2015

Magento

import customerov

website,email,group_id,group,firstname,lastname,password_hash,billing_firstname,billing_lastname,billing_company,billing_street1,billing_street2,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_fax,shipping_firstname,shipping_lastname,shipping_company,shipping_street1,shipping_street2,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_fax,created_in,is_subscribed
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1
base,,General,General,,,,,,,,,,,,,,,,,,,,,,,,,,default,1

 

odkaz: http://www.summasolutions.net/blogposts/how-import-customers-magento

shell prikazy

Reidnex pouzitim shell prikazov a putty

original: http://www.propellermind.com/magento-tips/magento-re-index-data-with-command-shell/

pomocou shell prikazov sa treba dostat do shell adresara v roto folderi

catalog_product_attribute     Product Attributes
catalog_product_price         Product Prices
catalog_url                   Catalog Url Rewrites
catalog_product_flat          Product Flat Data
catalog_category_flat         Category Flat Data
catalog_category_product      Category Products
catalogsearch_fulltext        Catalog Search Index
cataloginventory_stock        Stock status

a samotne prikazy

php indexer.php --reindex catalog_product_attribute
php indexer.php --reindex catalog_product_price
php indexer.php --reindex catalog_url
php indexer.php --reindex catalog_product_flat
php indexer.php --reindex catalog_category_flat
php indexer.php --reindex catalog_category_product
php indexer.php --reindex catalogsearch_fulltext
php indexer.php --reindex cataloginventory_stock
php indexer.php --reindex tag_summary
shell prikazy

shell prikazy

rozbalenie

tar -vxf my_file.tar
dum database
$ mysqldump -u username -h localhost -p database_name | gzip -9 > backup_db.sql.gz

— ziskanie databazy —
mysqldump -u xxxx -pxxxx nazov > nazov.sql

mysqldump –insert-ignore …..

— zbalenie databazy —-

tar -czf nazov.tar.gz nazov.sql

— restore DB —–

$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]

———-
unzip

unzip -q nazov.zip

Magento

Pridanie noveho atributu do kategorie

!!! vzdy si treba spravit zalohu DB !!!

INSERT INTO `eav_attribute` (`entity_type_id`, `attribute_code`, `attribute_model`, `backend_model`, `backend_type`, `backend_table`, `frontend_model`, `frontend_input`, `frontend_label`, `frontend_class`, `source_model`, `is_required`, `is_user_defined`, `default_value`, `is_unique`, `note`) VALUES
(3, ‘header_description’, NULL, NULL, ‘varchar’, NULL, NULL, ‘text’, ‘Header Description’, NULL, ‘eav/entity_attribute_source_boolean’, 0, 0, ‘0’, 0, ”);

 po vytvoreni noveho attributu v tabulke eav_attribute .. si treba pozriet jeho ID .. napriklad teraz to je 123 .. a toto cislo sa pouzije v dalsich tabulkach dole

INSERT INTO `eav_entity_attribute` (`entity_type_id`, `attribute_set_id`, `attribute_group_id`, `attribute_id`, `sort_order`) VALUES
(3, 3, 3, 123, 11);

is_global = 1 – global ak =0 -store view

INSERT INTO `catalog_eav_attribute` (`attribute_id`, `frontend_input_renderer`, `is_global`, `is_visible`, `is_searchable`, `is_filterable`, `is_comparable`, `is_visible_on_front`, `is_html_allowed_on_front`, `is_used_for_price_rules`, `is_filterable_in_search`, `used_in_product_listing`, `used_for_sort_by`, `is_configurable`, `apply_to`, `is_visible_in_advanced_search`, `position`, `is_wysiwyg_enabled`) VALUES
(123, NULL, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, ”, 0, 0, 0);

——————- Obrazok ——————-
INSERT INTO `eav_attribute` (`entity_type_id`, `attribute_code`, `attribute_model`, `backend_model`, `backend_type`, `backend_table`, `frontend_model`, `frontend_input`, `frontend_label`, `frontend_class`, `source_model`, `is_required`, `is_user_defined`, `default_value`, `is_unique`, `note`) VALUES
(3, ‘header_back’, NULL,’catalog/category_attribute_backend_image’, ‘varchar’, NULL, NULL, ‘image’, ‘Header background’, NULL, ‘eav/entity_attribute_source_boolean’, 0, 0, ‘0’, 0, ”);

INSERT INTO `eav_entity_attribute` (`entity_type_id`, `attribute_set_id`, `attribute_group_id`, `attribute_id`, `sort_order`) VALUES
(3, 3, 4, 132, 11); .

INSERT INTO `catalog_eav_attribute` (`attribute_id`, `frontend_input_renderer`, `is_global`, `is_visible`, `is_searchable`, `is_filterable`, `is_comparable`, `is_visible_on_front`, `is_html_allowed_on_front`, `is_used_for_price_rules`, `is_filterable_in_search`, `used_in_product_listing`, `used_for_sort_by`, `is_configurable`, `apply_to`, `is_visible_in_advanced_search`, `position`, `is_wysiwyg_enabled`) VALUES
(132, NULL, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, NULL, 0, 0, 0);

<?php
$catId = Mage::getModel(‘catalog/layer’)->getCurrentCategory()->getId();
$_category = Mage::getModel(‘catalog/category’)->load($catId)->getData(‘header_back’);
$iamgeurl = Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA).’catalog/category/’.$_category;
?>
<img src=”<?php echo $iamgeurl; ?>”>