Search This Blog

Tuesday, 15 May 2012

Add Multiple Select field / attribute to filter in Magento

 


Using addAttributeToFilter() with a multi-select attribute:

$this->_productCollection->addAttributeToFilter("stv_school", array("finset" => $allowedSchool);

OR

$allowedSchools = array(
  array(
    "finset" => array(348)
  ),
  array(
    "finset" => array(350)
  ),
);$this->_productCollection->addAttributeToFilter("stv_school", $allowedSchools);
Reference URLs:

Manage Cron Job using Putty


  1. Login to SSH via Putty
  2. Type crontab –e
  3. Use “I” for insert
  4. Make the necessary changes
  5. Press Escape
  6. Type :q (to quit without any changes)
  7. Type  :wq (to save changes and quit)
Disable CRON error emails: Add the following at the top of the Cron file
MAILTO=""

For more info Click Here

See the list of CRON process IDs:  pgrep crond

Cron Status: service crond status
Stop the Cron: /etc/init.d/crond stop
Start the Cron: /etc/init.d/crond start
Restart the Cron: /etc/init.d/crond restart 

Kill the Process by PID: kill PID

Get PID by Process name: pidof lighttpd

 
 

Thursday, 10 May 2012

Magento 1.7.0.0 installing errors

The latest Magento installation is producing errors due to following tables are not created when importing sample data in Database.
  1. tag
  2. tag_relation
The issue will be fixed if you manually create the tables by copying the sql queries from sample data SQL file.

Wednesday, 9 May 2012

Generating Bulk Coupon codes in Magento 1.7.0.0

Generating Bulk Coupon codes feature is now available in Magento 1.7.0.0. This feature allows the merchants to create bulk coupon codes with same rules and conditions in one click. Previously merchant needs to add the same rules and conditions multiple times if they want to create multiple coupon codes. This feature saves a lot of time of administrator.

Here are the detailed instruction on how to use it!!!
  1. Login to admin section and navigate to "Promotions" => "Shopping Cart Price Rules"
  2. Click on "Add New Rule" button
  3. Under "Rule Information"tab select "Coupon" as "Specific Coupon"
  4. Then you will see "Use Auto Generation" check box below "Coupon Code" Field
  5. Check the "Use Auto Generation" check box and fill the other information required for coupon
  6. Then click on "Save and Continue" button
  7. Now you will see new tab on left side "Manage Coupon Codes" click on it
  8. Under "Coupons Information" sub section enter the details and click on "Generate" button
    1. For default settings navigate to "System" => "Configuration"
    2. Click on "Promotions" link in left side bar under "Customers" sub heading In content section 
    3. "Auto Generated Specific Coupon Codes" you can set the default values rather than entering the details every time
  9. The coupon codes will be generated and listed under a grid ( below Coupons Information section)
  10. That's all you are done! 


Monday, 7 May 2012

Magento Javascript Validation Classes

Magento Javascript Validation Classes

There are many more validation classes you can assign and I list them here as a reference. For more information on this please use Google, experiment with the code or contact me via my email or the contact form.

validate-select

Please select an option

required-entry

This is a required field

validate-number

Please enter a valid number in this field

validate-digits

Please use numbers only in this field. please avoid spaces or other characters such as dots or commas

validate-alpha

Please use letters only (a-z or A-Z) in this field.

validate-code

Please use only letters (a-z), numbers (0-9) or underscore(_) in this field, first character should be a letter.

validate-alphanum

Please use only letters (a-z or A-Z) or numbers (0-9) only in this field. No spaces or other characters are allowed

validate-street

Please use only letters (a-z or A-Z) or numbers (0-9) or spaces and # only in this field

validate-phoneStrict

Please enter a valid phone number. For example (123) 456-7890 or 123-456-7890

validate-phoneLax

Please enter a valid phone number. For example (123) 456-7890 or 123-456-7890

validate-fax

Please enter a valid fax number. For example (123) 456-7890 or 123-456-7890

validate-date

Please enter a valid date

validate-email

Please enter a valid email address. For example johndoe@domain.com.

validate-emailSender

Please use only letters (a-z or A-Z), numbers (0-9) , underscore(_) or spaces in this field.

validate-password

Please enter 6 or more characters. Leading or trailing spaces will be ignored

validate-admin-password

Please enter 7 or more characters. Password should contain both numeric and alphabetic characters

validate-cpassword

Please make sure your passwords match

validate-url

Please enter a valid URL. http:// is required

validate-clean-url

Please enter a valid URL. For example http://www.example.com or www.example.com

validate-identifier

Please enter a valid Identifier. For example example-page, example-page.html or anotherlevel/example-page

validate-xml-identifier

Please enter a valid XML-identifier. For example something_1, block5, id-4

validate-ssn

Please enter a valid social security number. For example 123-45-6789

validate-zip

Please enter a valid zip code. For example 90602 or 90602-1234

validate-zip-international

Please enter a valid zip code

validate-date-au

Please use this date format: dd/mm/yyyy. For example 17/03/2006 for the 17th of March, 2006

validate-currency-dollar

Please enter a valid $ amount. For example $100.00

validate-one-required

Please select one of the above options.

validate-one-required-by-name

Please select one of the options.

validate-not-negative-number

Please enter a valid number in this field

validate-state

Please select State/Province

validate-new-password

Please enter 6 or more characters. Leading or trailing spaces will be ignored

validate-greater-than-zero

Please enter a number greater than 0 in this field

validate-zero-or-greater

Please enter a number 0 or greater in this field

validate-cc-number

Please enter a valid credit card number.

validate-cc-type

Credit card number doesn\’t match credit card type

validate-cc-type-select

Card type doesn\’t match credit card number

validate-cc-exp

Incorrect credit card expiration date

validate-cc-cvn

Please enter a valid credit card verification number.

validate-data

Please use only letters (a-z or A-Z), numbers (0-9) or underscore(_) in this field, first character should be a letter.

validate-css-length

Please input a valid CSS-length. For example 100px or 77pt or 20em or .5ex or 50%

validate-length

Maximum length exceeded

Allow zero price in "Tier Price" of product edit in Magento

 Allow zero price in "Tier Price" of product edit section in administration
Open:  \app\design\adminhtml\default\default\template\catalog\product\edit\price\tier.phtml file and replace the validation class "validate-greater-than-zero" with "validate-not-negative-number" so that field will allow zero and positive numbers.

 In User Section: If you want to show Free text next to the item.
In \app\design\frontend\base\default\template\catalog\product\price.phtml file add following script below  <?php endif; /* if ($_finalPrice == $_price): */ ?> to display "Customer Group: Free" text below the price.

      <?php $prdData = $_product->getData(); if(isset($prdData['tier_price']) and $prdData['tier_price'] != '' and $prdData['tier_price'] == 0): ?>
        <span class="minimal-price-link">
            <span class="label"><?php echo $this->__('Customer Group Price:') ?></span>
            <span class="price" id="product-minimal-price-<?php echo $_id ?><?php echo $this->getIdSuffix() ?>">Free</span>
        </span>
    <?php endif; ?>

Wednesday, 2 May 2012

Display date in specified format in Magento

Display date in specified format in Magento

Mage::helper('core')->formatDate($date, $format, $showTime=false)

Argument 1: Date that you want change the format (This may be database driven or manual)
Argument 2: Date format: short, long, medium, full
Argument 3: Show Time: True to display time and false to not display time