php:magento
Differences
This shows you the differences between two versions of the page.
php:magento [2018/08/09 12:56] – [change domain from localhost to shop.babies.vn] admin | php:magento [2022/10/29 16:15] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 892: | Line 892: | ||
} | } | ||
</ | </ | ||
- | ==== other optimize methods ==== | + | ==== Other optimize methods ==== |
- re-index data | - re-index data | ||
* in admin | * in admin | ||
Line 1105: | Line 1105: | ||
Go to "Nhóm Sản Phẩm" | Go to "Nhóm Sản Phẩm" | ||
+ | ==== Update all categories to isAnchor ==== | ||
+ | <code sql> | ||
+ | SET value = 1 | ||
+ | WHERE attribute_id = (SELECT attribute_id | ||
+ | | ||
+ | | ||
+ | | ||
+ | </ | ||
+ | ==== Update Manufacture ==== | ||
+ | Research Manufacture database <code sql> | ||
+ | select attribute_id, | ||
+ | 137 4 manufacture | ||
+ | |||
+ | select option_id, value from eav_attribute_option_value where value like " | ||
+ | 40 Kim Home | ||
+ | 40 Kim Home | ||
+ | 40 Kim Home | ||
+ | |||
+ | select entity_id, | ||
+ | 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`, | ||
+ | |||
+ | --list all products have manufacture with name like "%KIM HOME%" | ||
+ | select catp.entity_type_id, | ||
+ | |||
+ | 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%"; | ||
+ | </ | ||
+ | Update Manufacture from database: | ||
+ | - Step1: Check manufacture information with name "Kim Home" from database< | ||
+ | select option_id, value from eav_attribute_option_value where value like " | ||
+ | 40 Kim Home | ||
+ | 40 Kim Home | ||
+ | 40 Kim Home | ||
+ | </ | ||
+ | - Step2: Update manufacture for all products with name like "%KIM HOME%" to manufacture value 40(Manufacture "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%"; | ||
+ | </ | ||
+ | - Step3: Recheck< | ||
+ | select catp.entity_type_id, | ||
+ | `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%"; | ||
+ | </ | ||
==== Magento upgrade ==== | ==== Magento upgrade ==== | ||
=== upgrade with magento connect === | === upgrade with magento connect === | ||
Line 1139: | Line 1183: | ||
rm -rf / | rm -rf / | ||
</ | </ | ||
+ | ==== Magento Email Configure ==== | ||
+ | - Advanced/ | ||
+ | - General/ | ||
+ | - Sales/Sales Emails: Send Order Email Copy To: | ||
+ | - You must sure that we can run cron command of magento | ||
===== Magento and Wordpress ===== | ===== Magento and Wordpress ===== | ||
refer: http:// | refer: http:// | ||
Line 1255: | Line 1304: | ||
truncate table catalogsearch_result; | truncate table catalogsearch_result; | ||
</ | </ | ||
- | ===== Lazada support ===== | ||
php/magento.1533819383.txt.gz · Last modified: 2022/10/29 16:15 (external edit)