POSTS - Web Solution | Magento 2

Magento add new class accourding to your module and you

October 30, 2014/0 Comments/in Magento2 /by puneetk00

add class with php

if ($root = $this->getLayout()->getBlock('root')) {
    $root->addBodyClass('whatever');
}

and xml

<reference name="root">
    <action method="addBodyClass"><classname>whatever</classname></action>
</reference>

Puneet Kumar Magento Developer

stiki menu jquery simple

October 13, 2014/0 Comments/in jQuery /by puneetk00

Puneet Kumar Magento Developer

Php mail script get offen error for special caractor we get solutions

September 26, 2014/0 Comments/in php mail /by puneetk00

php subject missing special character missing solved

$subject = “=?ISO-8859-15?Q?”.imap_8bit(“Deine Buchung für die Allgäuer Berufsoffensive”).”?=”;

Puneet Kumar Magento Developer

Magento Mask product set attribute value

September 17, 2014/0 Comments/in Magento2 /by puneetk00

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

September 8, 2014/0 Comments/in Magento2 /by puneetk00

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”, “Dadra Nagar Haveli”,”Dadra Nagar Haveli”), (NULL , “IN”, “Daman Diu”,”Daman Diu”), (NULL , “IN”, “Delhi”,”Delhi”), (NULL , “IN”, “Goa”,”Goa”), (NULL , “IN”, “Gujarat”,”Gujarat”), (NULL , “IN”, “Haryana”,”Haryana”), (NULL , “IN”, “Himachal Pradesh”,”Himachal Pradesh”), (NULL , “IN”, “Jammu Kashmir”,”Jammu Kashmir”), (NULL , “IN”, “Jharkhand”,”Jharkhand”), (NULL , “IN”, “Karnataka”,”Karnataka”), (NULL , “IN”, “Kerala”,”Kerala”), (NULL , “IN”, “Lakshadweep”,”Lakshadweep”), (NULL , “IN”, “Madhya Pradesh”,”Madhya Pradesh”), (NULL , “IN”, “Maharashtra”,”Maharashtra”), (NULL , “IN”, “Manipur”,”Manipur”), (NULL , “IN”, “Meghalaya”,”Meghalaya”), (NULL , “IN”, “Mizoram”,”Mizoram”), (NULL , “IN”, “Nagaland”,”Nagaland”), (NULL , “IN”, “Orissa”,”Orissa”), (NULL , “IN”, “Pondicherry”,”Pondicherry”), (NULL , “IN”, “Punjab”,”Punjab”), (NULL , “IN”, “Rajasthan”,”Rajasthan”), (NULL , “IN”, “Sikkim”,”Sikkim”), (NULL , “IN”, “Tamil Nadu”,”Tamil Nadu”), (NULL , “IN”, “Tripura”,”Tripura”), (NULL , “IN”, “Uttar Pradesh”,”Uttar Pradesh”), (NULL , “IN”, “Uttaranchal”,”Uttaranchal”), (NULL , “IN”, “West Bengal”,”West Bengal”); INSERT INTO `directory_country_region_name` (`locale` ,`region_id` ,`name` ) SELECT ‘en_US’, tmp.region_id, tmp.default_name FROM `directory_country_region` AS tmp WHERE tmp.country_id=’IN’;

Puneet Kumar Magento Developer

magento log clear query

September 5, 2014/0 Comments/in Magento2, Mysql /by puneetk00

Puneet Kumar Magento Developer

ruppee simbale code

September 5, 2014/0 Comments/in Simble /by puneetk00

Puneet Kumar Magento Developer

Export MySQL to CSV (php script)

September 1, 2014/0 Comments/in Uncategorized /by puneetk00

<?php /* vars for export */ // database record to be exported $db_record = 'XXXXXXXXX'; // optional where query $where = 'WHERE 1 ORDER BY 1'; // filename for export $csv_filename = 'db_export_'.$db_record.'_'.date('Y-m-d').'.csv'; // database variables $hostname = "localhost"; $user = "XXXXXXXXX"; $password = "XXXXXXXXX"; $database = "XXXXXXXXX"; // Database connecten voor alle services mysql_connect($hostname, $user, $password) or die('Could not connect: ' . mysql_error()); mysql_select_db($database) or die ('Could not select database ' . mysql_error()); // create empty variable to be filled with export data $csv_export = ''; // query to get data from database $query = mysql_query("SELECT * FROM ".$db_record." ".$where); $field = mysql_num_fields($query); // create line with field names for($i = 0; $i < $field; $i++) { $csv_export.= mysql_field_name($query,$i).';'; } // newline (seems to work both on Linux & Windows servers) $csv_export.= ' '; // loop through database query and fill export variable while($row = mysql_fetch_array($query)) { // create line with field values for($i = 0; $i < $field; $i++) { $csv_export.= '"'.$row[mysql_field_name($query,$i)].'";'; } $csv_export.= ' '; } // Export the data and prompt a csv file for download header("Content-type: text/x-csv"); header("Content-Disposition: attachment; filename=".$csv_filename.""); echo($csv_export); ?>

Puneet Kumar Magento Developer

Magento tranjectional mail with variable by template id

August 23, 2014/0 Comments/in Uncategorized /by puneetk00

Magento tranjectional mail with variable by template id

<?php
// Transactional Email Template's ID
 $templateId = 5;

// Set sender information
 $senderName = 'Kraftbuy';
 $senderEmail = $email_general;
 $sender = array('name' => “admin”, 
 ’email’ => “admin@gmail.com”);
 // Set recepient information 
 $recepientEmail = $email; 
 $recepientName = $Name_of_Contact_Person_for; 
 // Get Store ID 
 $store = Mage::app()->getStore()->getId();
//Set variables that can be used in email template you can assign this variable in tranjectional mail {{var ustomerName}}
 $vars = array(‘customerName’ => ‘puneet kumar’, 
 ‘customerEmail’ => ‘puneetk00@gmail.com’);
 $translate = Mage::getSingleton(‘core/translate’);
 // Send Transactional Email 
 Mage::getModel(‘core/email_template’) 
 ->addBcc($senderEmail) 
 ->sendTransactional($templateId, $sender, $recepientEmail, $recepientName, $vars, $storeId);
 $translate->setTranslateInline(true);
?>

Puneet Kumar Magento Developer

Magento Group product configrable product assign prices

June 4, 2014/0 Comments/in Uncategorized /by puneetk00

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 = productId;
};

looks like this:

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 = productId;
};

Puneet Kumar Magento Developer

Magento add new class accourding to your module and you

stiki menu jquery simple

Php mail script get offen error for special caractor we get solutions

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’<br /> # —> note the ID<br /> UPDATE catalog_product_entity_int SET value = 1 WHERE attribute_id = $id<br />

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

magento log clear query

ruppee simbale code

Export MySQL to CSV (php script)

Magento tranjectional mail with variable by template id

Magento Group product configrable product assign prices

Connect With Us

Contact

Product

Sitemap