Last updated for Magento CE 1.4.1.1 This is a work-in-progress to assemble and keep current, the SQL required to perform these actions which are currently not part of the Magento core package but which are often useful for testing and debugging. Remember to back up your database before using any of these scripts! Delete *All* Order & Full Article…
Search the Wiki
Viewing 191 to 200 of 233 items
Easiest way to open CSV with commas in Excel
CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this: Turns out it was a regional setting issue; Go into your control panel –> Regional Settings –> Advanced Settings and change your list separator to a comma. Mine was set to semi-colon for South Africa after Full Article…
Executing cron job for Magento use Cpanel
Cpanel cron jobs not working using magento? PHP Optional flags are sometimes required for a PHP cron job: php -q /home/username/public_html/cron.php SSH Command to run a code script cron job: /bin/sh /home/username/public_html/file.sh
Install Epel for Centos 6
Install Epel for Centos 6. wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm sudo rpm -Uvh remi-release-6*.rpm epel-release-6*.rpm
Install Epel and php mcrypt for centos 7
Install Rpel and php mbcrypt for centos 7 Epel: yum install http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm yum install php-mcrypt*
[CentOS-devel] Delta RPMs disabled by default?
[CentOS-devel] Delta RPMs disabled by default? You did a minimal install so the package selection you got is, err, minimal. You can enable delta rpms by installing the binary it needs and told you about. Running: yum install deltarpm
How To Install Linux, Apache, MySQL, PHP (LAMP) stack On CentOS 7
Introduction A "LAMP" stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is actually an acronym which represents the Linux operating system, with the Apache web server. The site data is stored in a MySQL database (using MariaDB), Full Article…
Create a Country Drop Down in the Frontend of Magento
<?php $_countries = Mage::getResourceModel('directory/country_collection') ->loadData() ->toOptionArray(false) ?> <?php if (count($_countries) > 0): ?> <select name="country" id="country"> <option value="">– Please Select –</option> <?php foreach($_countries as $_country): ?> <option value="<?php echo $_country[‘value’] ?>"> <?php echo $_country['label'] ?> </option> <?php endforeach; ?> </select> <?php endif; ?>
Enable mod_rewrite in Nginx
How to enable mod_rewrite in Nginx? You need to add the following line to Nginx configuration file: location / { try_files $uri $uri/ /index.php?q=$request_uri; }