Entries by puneetk00

Magento Mask product set attribute value

Magento Mask product set attribute value select * from eav_attribute where entity_type_id = 4 and attribute_code = ‘status’ # —> note the ID UPDATE catalog_product_entity_int SET value = 1 WHERE attribute_id = $id Puneet Kumar Magento Developer

States if India not displaying in dropdown list during checkout process in magento 1.7.0.2

States if India not displaying in dropdown list during checkout process in magento 1.7.0.2 INSERT INTO `directory_country_region` VALUES (NULL , “IN”, “Andaman Nicobar”,”Andaman Nicobar”), (NULL , “IN”, “Andhra Pradesh”,”Andhra Pradesh”), (NULL , “IN”, “Arunachal Pradesh”,”Arunachal Pradesh”), (NULL , “IN”, “Assam”,”Assam”), (NULL , “IN”, “Bihar”,”Bihar”), (NULL , “IN”, “Chandigarh”,”Chandigarh”), (NULL , “IN”, “Chhattisgarh”,”Chhattisgarh”), (NULL , “IN”, […]

magento log clear query

TRUNCATE dataflow_batch_export; TRUNCATE dataflow_batch_import; TRUNCATE log_customer; TRUNCATE log_quote; TRUNCATE log_summary; TRUNCATE log_summary_type; TRUNCATE log_url; TRUNCATE log_url_info; TRUNCATE log_visitor; TRUNCATE log_visitor_info; TRUNCATE log_visitor_online; TRUNCATE report_viewed_product_index; TRUNCATE report_compared_product_index; TRUNCATE report_event; TRUNCATE index_event; Puneet Kumar Magento Developer

Magento Group product configrable product assign prices

Looks like you are using SCP or the SimpleConfigurable products extension. That is known to cause issues. Please try the following: comment out lines 104-106 of /skin/frontend/base/default/js/scp_product_extension.js. However this may affect how SCP operates.so this code: Product.Config.prototype.updateFormProductId = function(productId){if (!productId){ return false; }var currentAction = $(‘product_addtocart_form’).action;newcurrentAction = currentAction.sub(/product/d+//, ‘product/’ + productId + ‘/’);$(‘product_addtocart_form’).action = newcurrentAction;$(‘product_addtocart_form’).product.value […]