Differences

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

--- php:magento [2018/08/11 04:49] – [other optimize methods] admin
+++ php:magento [2022/10/29 16:15] (current) – external edit 127.0.0.1
@@ Line 1105: / Line 1105: @@
 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";
+	4	manufacture
+select option_id, value from eav_attribute_option_value where value like "%KIM%"
+	Kim Home
+	Kim Home
+	Kim Home
+select entity_id,NAME from catalog_product_flat_1 where NAME like "%KIM%";
+	GỐI LÕM CARA KIM HOME
+	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%"
+	Kim Home
+	Kim Home
+	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 ====
 === upgrade with magento connect ===
@@ Line 1139: / Line 1183: @@
 rm -rf /data/www/babyshopvnupdate/var/cache/*
 </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 =====
 refer: http://www.thetomorrowlab.com/2014/03/integrating-wordpress-magento-build-ecommerce-website/
@@ Line 1255: / Line 1304: @@
 truncate table catalogsearch_result;
 </code>
-===== Lazada support =====