comparing core_config_data

Find core_config_data differences between a production and development db.

SELECT path, value FROM (
SELECT path, value FROM your_dev_db.core_config_data
SELECT path, value FROM your_prod_db.core_config_data
) tbl
GROUP BY path, value
HAVING count(*) = 1

query("select * from core_config_data where path in (

foreach ($result as $row) {
echo "update `core_config_data` set `value` = '" . $row['value'] . "' where `path`='" . $row['path'] . "';" . PHP_EOL;

Magento 2 Simple Products and Virtual Products and Hey, There’s No Weight Attribute!

So you’re loving your new Magento 2 store when all of a sudden you realize, your simple products have started turning themselves into virtual products. Magento 2 automagically freely converts simple products to virtual and virtual products to simple based on whether or not the product has a weight.

All you have to do to turn those virtual products back into simple products is provide a value for weight. When you go in to edit the product, though, you may find there is no weight attribute on the screen!

Look in eav_attribute for the weight attribute_code and get its attribute_id (entity_type_id is probably 4). Look in catalog_eav_attribute where attribute_id is the one you just looked up from eav_attribute and set apply_to NULL. Reload product edit page, and you should see weight now

Weight Restored
Weight Restored

Magento 2 Get Paths Programatically

Looking for Mage::getBaseUrl in Magento 2?
Use the DirectoryList class in your constructor to get an instance of DirectoryList.

Magento\Framework\App\Filesystem\DirectoryList $directory_list

For getting your Magento 2 root folder you can use


For getting media folder you can use



Other possible uses are:

/* Get app folder */
/* Get configuration folder */
/* Get libraries or third-party components folder */
/* Get libraries/components that need to be accessible publicly through web-server folder */
/* Get public folder */
/* Get static folder */
/* Get var folder */
/* Get temporary files folder */
/* Get file system caching directory (if file system caching is used) */
/* Get logs of system messages and errors */
/* Get file system session directory (if file system session storage is used) */
/* Get directory for Setup application*/
/* Get Dependency injection related file directory */
/* Relative directory key for generated code*/
/* Temporary directory for uploading files by end-user */
/* Directory to store composer related files (config, cache etc.) in case if composer runs by Magento Application */
/* A suffix for temporary materialization directory where pre-processed files will be written (if necessary) */
/* Get template minification dir */

Magento Indexers – Programmatically Using Indexers

In some custom modules, you may need to change the index mode from manual to auto or vice versa or you may need to run one of the indexers.

    = Mage::getSingleton('index/indexer')->getProcessesCollection();
foreach ($pCollection as $process) {

    = Mage::getSingleton('index/indexer')->getProcessesCollection();
foreach ($pCollection as $process) {

Indexes can be loaded using either the process ID or the process code using the functions:

by ID:

$process = Mage::getSingleton('index/indexer')->getProcessById();

by CODE:

$process = Mage::getSingleton('index/indexer')->getProcessByCode(<process_code>);


The process code and ID can be found by checking the table index_process. The Magento provided indexes normally have the following ID and code.

Process Name ID Code
Product Attributes 1 catalog_product_attribute
Product Prices 2 catalog_product_price
Catalog URL Rewrites 3 catalog_url
Product Flat Data 4 catalog_product_flat
Category Flat Data 5 catalog_category_flat
Category Products 6 catalog_category_product
Catalog Search Index 7 catalogsearch_stock
Stock Status 8 cataloginventory_stock
Tag Aggregation Data 9 tag_summary


mysqldump from CLI select tables

Suppose you need to take just a few tables from a database, like all the customer tables from a magento install. You just need to set up a few shell variables and you can mysqldump away! You’ll need your mysql database user name and password.

$:SQL="select group_concat(table_name separator ' ') from information_schema.tables where table_schema='$DBTODUMP' and table_name like 'customer%'"
$:TBLIST=`mysql -u db_user -pPASSWORD -AN -e"$SQL"`
$:mysqldump -u db_user -pPASSWORD $DBTODUMP $TBLIST > customer_tables.sql

mysqldump to gz

mysqldump -u user -p[user_password] [database_name] | gzip > dumpfilename.sql.gz

the next thing you’re gonna ask …

scp username@hostname:/path/to/file/from/root/dumpfilename.sql.gz ./dumpfilename.sql.gz

and after that …

sed -i 's/DEFINER=[^*]*\*/\*/g' mydump.sql

and if you can’t create InnoDB tables and the create statements contain ROW_FORMAT

sed -ie 's/ROW_FORMAT=FIXED//g'

Magento Flush Cache from FTP

->FTP users can use the following command to cleanup Magento caches:

mrm -r ./var/cache ; mkdir ./var/cache

mrm -r ./var/full_page_cache ; mkdir ./var/full_page_cache

Magento Field Validation Class Options

‘validate-no-html-tags’ => ‘HTML tags are not allowed’

‘validate-select’ => ‘Please select an option.’

‘required-entry’ => ‘This is a required field.’

‘validate-number’ => ‘Please enter a valid number in this field.’

‘validate-number-range’ => ‘The value is not within the specified range.’

‘validate-digits’ => ‘Please use numbers only in this field. Please avoid spaces or other characters such as dots or commas.’

‘validate-digits-range’ => ‘The value is not within the specified range.’

‘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-alphanum-with-spaces’ => ‘Please use only letters (a-z or A-Z), numbers (0-9) or spaces only in this field.’

‘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-date-range’ => ‘The From Date value should be less than or equal to the To Date value.’ ‘validate-email’ => ‘Please enter a valid email address. For example’ ‘validate-emailSender’ => ‘Please use only visible characters and spaces.’ ‘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-both-passwords’ => ‘Please make sure your passwords match.’ ‘validate-url’ => ‘Please enter a valid URL. Protocol is required (http://, https:// or ftp://)’ ‘validate-clean-url’ => ‘Please enter a valid URL. For example or’ ‘validate-identifier’ => ‘Please enter a valid URL Key. 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 number 0 or greater in this field.’ ‘validate-zero-or-greater’ => ‘Please enter a number 0 or greater in this field.’ ‘validate-greater-than-zero’ => ‘Please enter a number greater than 0 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-cc-number’ => ‘Please enter a valid credit card number.’ ‘validate-cc-type’ => ‘Credit card number does not match credit card type.’ ‘validate-cc-type-select’ => ‘Card type does not match credit card number.’ ‘validate-cc-exp’ => ‘Incorrect credit card expiration date.’ ‘validate-cc-cvn’ => ‘Please enter a valid credit card verification number.’ ‘validate-ajax’ => ‘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’ => ‘Text length does not satisfy specified text range.’ ‘validate-percents’ => ‘Please enter a number lower than 100.’ ‘validate-cc-ukss’ => ‘Please enter issue number or start date for switch/solo card type.’