my notes

User Tools

Site Tools

Trace:
php:magento

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

php:magento [2018/08/09 08:55] – [magento upgrade] adminphp:magento [2022/10/29 16:15] (current) – external edit 127.0.0.1
Line 266: Line 266:
   * customer/account/edit/   * customer/account/edit/
  
-===== Magento layout, pages, module and blocks =====+===== Magento layout, pages, blocks and links =====
 refer: http://www.magentocommerce.com/knowledge-base/entry/magento-for-dev-part-4-magento-layouts-blocks-and-templates refer: http://www.magentocommerce.com/knowledge-base/entry/magento-for-dev-part-4-magento-layouts-blocks-and-templates
 ==== Mangento layout or root template ==== ==== Mangento layout or root template ====
Line 442: Line 442:
     .....     .....
 </code> </code>
-==== default config for blocks in each pages  ====+==== Default config for blocks in each pages  ====
  
 === [core.xml] === === [core.xml] ===
Line 499: Line 499:
 </default> </default>
 </code> </code>
-==== default page with root templates(layout) and blocks ====+==== Default page with root templates(layout) and blocks ====
 Edit in Admin: **Quan ly CMS -> Page -> Home** Edit in Admin: **Quan ly CMS -> Page -> Home**
 Edit layout and page config in **Design** Edit layout and page config in **Design**
Line 577: Line 577:
 </default> </default>
 </code> </code>
-==== config and edit display of left column from admin ====+==== Config and edit display of left column from admin ====
   - step1: config display template **callouts/left_col.phtml** in left column by editing the layout file **layout/catalog.xml**<code xml>   - step1: config display template **callouts/left_col.phtml** in left column by editing the layout file **layout/catalog.xml**<code xml>
 <reference name="left"> <reference name="left">
Line 607: Line 607:
   - step4: update display chatango in left bar:<code html>   - step4: update display chatango in left bar:<code html>
 <script id="cid0020000087513494433" data-cfasync="false" async src="//st.chatango.com/js/gz/emb.js" style="width: 210px;height: 350px;">{"handle":"shopbabiesvn","arch":"js","styles":{"b":100,"c":"f97789","d":"006699","e":"fdfdfd","h":"f2f2f2","l":"9ddbf6","m":"FFFFFF","p":"10","q":"9ddbf6","r":100}}</script> <script id="cid0020000087513494433" data-cfasync="false" async src="//st.chatango.com/js/gz/emb.js" style="width: 210px;height: 350px;">{"handle":"shopbabiesvn","arch":"js","styles":{"b":100,"c":"f97789","d":"006699","e":"fdfdfd","h":"f2f2f2","l":"9ddbf6","m":"FFFFFF","p":"10","q":"9ddbf6","r":100}}</script>
 +</code>
 +==== top.links Header link (Include Login/Logout) ====
 +  * CMS Block to display links in **top.links.phtml**:<code php>
 +<?php if($toplinks && is_array($toplinks)): ?>
 +<ul class="links">
 +    <?php echo $this->getChildHtml() ?>
 +    <?php foreach($toplinks as $_toplink): ?>
 +    <li<?php if($_toplink['first']||$_toplink['last']): ?> class="<?php if($_toplink['first']): ?>first<?php endif; ?><?php if($_toplink['last']): ?> last<?php endif; ?>"<?php endif; ?> <?php echo $_toplink['liParams'] ?>><?php echo $_toplink['beforeText'] ?><a <?php echo $_toplink['aParams'] ?>><?php echo $_toplink['innerText'] ?></a><?php echo $_toplink['afterText'] ?></li>
 +    <?php endforeach; ?>
 +</ul>
 +</code>
 +  * Config links in layout customer.xml:<code xml>
 +<layout version="0.1.0">
 +
 +<!--
 +Default layout, loads most of the pages
 +-->
 +
 +    <default>
 +        <!-- Mage_Customer -->
 +        <reference name="top.links">
 +            <action method="addLink" translate="label title" module="customer"><label>My Account</label><url helper="customer/getAccountUrl"/><title>My Account</title><prepare/><urlParams/><position>10</position></action>
 +        </reference>
 +    </default>
 +
 +<!--
 +Load this update on every page when customer is logged in
 +-->
 +
 +    <customer_logged_in>
 +        <reference name="top.links">
 +            <action method="addLink" translate="label title" module="customer"><label>Log Out</label><url helper="customer/getLogoutUrl"/><title>Log Out</title><prepare/><urlParams/><position>100</position></action>
 +        </reference>
 +    </customer_logged_in>
 +
 +<!--
 +Load this update on every page when customer is logged out
 +-->
 +
 +    <customer_logged_out>
 +        <!---<reference name="right">
 +            <block type="customer/form_login" name="customer_form_mini_login" before="-" template="customer/form/mini.login.phtml"/>
 +        </reference>-->
 +        <reference name="top.links">
 +            <action method="addLink" translate="label title" module="customer"><label>Log In</label><url helper="customer/getLoginUrl"/><title>Log In</title><prepare/><urlParams/><position>100</position></action>
 +        </reference>
 +        <remove name="reorder"></remove>
 +    </customer_logged_out>
 </code> </code>
 ===== Database ===== ===== Database =====
-==== database init ====+==== Database init ====
 <code sql> <code sql>
 SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN ('/', '')) AND (store_id IN(0, 1)) SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN ('/', '')) AND (store_id IN(0, 1))
Line 633: Line 681:
 SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') ORDER BY `catalog_category_entity`.`position` ASC SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') ORDER BY `catalog_category_entity`.`position` ASC
 </code> </code>
-==== manage products ====+==== Manage products ====
 === category === === category ===
 <code sql> <code sql>
Line 844: Line 892:
 } }
 </code> </code>
-==== other optimize methods ====+==== Other optimize methods ====
   - re-index data   - re-index data
     * in admin     * in admin
Line 929: Line 977:
   * config base_url: table core_config_data: replace http://localhost to http://shop.babies.vn<code sql>   * config base_url: table core_config_data: replace http://localhost to http://shop.babies.vn<code sql>
 update core_config_data set value = 'http://shop.babies.vn/' where path in ('web/unsecure/base_url', 'web/secure/base_url','admin/dashboard/enable_charts'); update core_config_data set value = 'http://shop.babies.vn/' where path in ('web/unsecure/base_url', 'web/secure/base_url','admin/dashboard/enable_charts');
 +</code>
 +  * update site from https to non https:<code sql>
 +update core_config_data set value='0' where  path in ('web/secure/use_in_frontend', 'web/secure/use_in_adminhtml');
 </code> </code>
   * Clear all caches for activating new config:<code bash>   * Clear all caches for activating new config:<code bash>
Line 1054: Line 1105:
 Go to "Nhóm Sản Phẩm" -> Random Related Products to edit **"Number of items to show"** Go to "Nhóm Sản Phẩm" -> Random Related Products to edit **"Number of items to show"**
  
 +==== Update all categories to isAnchor ====
 +<code sql>UPDATE catalog_category_entity_int 
 +SET    value = 1 
 +WHERE  attribute_id = (SELECT attribute_id 
 +                       FROM   eav_attribute 
 +                       WHERE  attribute_code = 'is_anchor' 
 +                       LIMIT  1); 
 +</code>
 +==== Update Manufacture ====
 +Research Manufacture database <code sql>
 +select attribute_id, entity_type_id, attribute_code from eav_attribute where attribute_code="manufacture";
 +137 4 manufacture
 +
 +select option_id, value from eav_attribute_option_value where value like "%KIM%"
 +40 Kim Home
 +40 Kim Home
 +40 Kim Home
 +
 +select entity_id,NAME from catalog_product_flat_1 where NAME like "%KIM%";
 +1960 GỐI LÕM CARA KIM HOME
 +1955 GỐI ÔM CARA CHO BÉ 60x25cm KIM HOME
 +
 +INSERT INTO `catalog_product_entity_int` (`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES ('4', '137', '0', '1960', '40') ON DUPLICATE KEY UPDATE `value` = VALUES(`value`)--only chage parameter 40(manufacture Kim Home) and 1960(Product Name)
 +
 +--list all products have manufacture with name like "%KIM HOME%"
 +select catp.entity_type_id, catp.attribute_id, catp.entity_id, catflat.name, catp.value from `catalog_product_entity_int` as catp  join catalog_product_flat_1 as catflat on catp.`entity_type_id` = 4 and catp.`attribute_id`=137 and catp.`entity_id` = catflat.`entity_id` and catflat.name like "%KIM HOME%";
 +
 +update `catalog_product_entity_int` as catp, catalog_product_flat_1 as catflat set catp.value = 40 where catp.`entity_type_id` = 4 and catp.`attribute_id`=137 and catp.`entity_id` = catflat.`entity_id` and catflat.name like "%KIM HOME%";
 +</code>
 +Update Manufacture from database:
 +  - Step1: Check manufacture information with name "Kim Home" from database<code sql>
 +select option_id, value from eav_attribute_option_value where value like "%KIM%"
 +40 Kim Home
 +40 Kim Home
 +40 Kim Home
 +</code> => option_id = 40
 +  - Step2: Update manufacture for all products with name like "%KIM HOME%" to manufacture value 40(Manufacture "Kim Home")<code sql>
 +update `catalog_product_entity_int` as catp, catalog_product_flat_1 as catflat set catp.value = 40 
 +where catp.`entity_type_id` = 4 and catp.`attribute_id`=137 and catp.`entity_id` = catflat.`entity_id` and catflat.name like "%KIM HOME%";
 +</code>
 +  - Step3: Recheck<code sql>
 +select catp.entity_type_id, catp.attribute_id, catp.entity_id, catflat.name, catp.value from 
 +`catalog_product_entity_int` as catp  join catalog_product_flat_1 as catflat on catp.`entity_type_id` = 4 and catp.`attribute_id`=137 and catp.`entity_id` = catflat.`entity_id` and catflat.name like "%KIM HOME%";
 +</code>
 ==== Magento upgrade ==== ==== Magento upgrade ====
 === upgrade with magento connect === === upgrade with magento connect ===
Line 1088: Line 1183:
 rm -rf /data/www/babyshopvnupdate/var/cache/* rm -rf /data/www/babyshopvnupdate/var/cache/*
 </code> </code>
 +==== Magento Email Configure ====
 +  - Advanced/System/Mail Sending Settings
 +  - General/Store Email Address
 +  - Sales/Sales Emails: Send Order Email Copy To:anh.vochi@gmail.com, tranvungoctram@gmail.com
 +  - You must sure that we can run cron command of magento
 ===== Magento and Wordpress ===== ===== Magento and Wordpress =====
 refer: http://www.thetomorrowlab.com/2014/03/integrating-wordpress-magento-build-ecommerce-website/ refer: http://www.thetomorrowlab.com/2014/03/integrating-wordpress-magento-build-ecommerce-website/
Line 1204: Line 1304:
 truncate table catalogsearch_result; truncate table catalogsearch_result;
 </code> </code>
-===== Lazada support ===== 
  
php/magento.1533804932.txt.gz · Last modified: 2022/10/29 16:15 (external edit)