Differences

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

--- php:magento [2018/08/13 17:22] – [Update Manufacture] 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_id=137;
+select attribute_id, entity_type_id, attribute_code from eav_attribute where attribute_code="manufacture";
 4 manufacture
@@ Line 1134: / Line 1142: @@
 </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%";
+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%";
+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 ====
@@ Line 1173: / 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:[email protected], [email protected]
+  - 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 1289: / Line 1304: @@
 truncate table catalogsearch_result;
 </code>
-===== Lazada support =====