User Tools

Site Tools


php:magento

Differences

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

Link to this comparison view

php:magento [2018/08/13 17:36] – [Update Manufacture] adminphp:magento [2022/10/29 16:15] (current) – external edit 127.0.0.1
Line 1142: Line 1142:
 </code> => option_id = 40 </code> => option_id = 40
   - Step2: Update manufacture for all products with name like "%KIM HOME%" to manufacture value 40(Manufacture "Kim Home")<code sql>   - 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> </code>
   - Step3: Recheck<code sql>   - 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> </code>
 ==== Magento upgrade ==== ==== Magento upgrade ====
Line 1181: 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:[email protected], [email protected]
 +  - 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 1297: Line 1304:
 truncate table catalogsearch_result; truncate table catalogsearch_result;
 </code> </code>
-===== Lazada support ===== 
  
php/magento.1534181772.txt.gz · Last modified: 2022/10/29 16:15 (external edit)