Quick Reference for Magento 1.x Reindex From Command Line

Obviously there are many articles on the internet about how to reindex Magento from the CLI or Terminal. But, this is my quick reference for which indexes need to be updated based on what admin action you take. Updating Magento Category Related Indexes php public_html/shell/indexer.php –reindex catalog_url,catalog_product_flat,catalog_category_flat,catalogsearch_fulltext,catalog_category_product notice the key here is not to included spaces between the comma separated values.  

Google Apps Definitive Outlook Guide

This is a concise setup guide for working with Google Apps (Gmail) Standard (the free version) and iOS devices and Outlook (Mac or PC) Backup your Mac outlook file (Use Apples Time Machine or perhaps this method http://www.maclife.com/article/howtos/how_back_and_restore_mail_outlook_2011) Create a new mail account on the Mac (Outlook) with IMAP credentials (https://support.google.com/mail/troubleshooter/1668960#ts=1665018,1665137,2769074) Incoming Mail (IMAP) Server – Requires SSL imap.gmail.com Port: 993 Requires SSL: Yes Outgoing Mail (SMTP) Server – Requires TLS smtp.gmail.com Port: 465 or 587 Requires SSL: Yes Requires authentication: Yes Use same settings as Continue reading →

SSHFS automount at boot with fstab on Ubuntu 14.04

I was able to make sshfs mount via fstab with Ubuntu 14.04 by doing using the following syntax as a standard user (note anything in CAPS is a variable for you to fill in): USER@HOST:/REMOTE_DIR /LOCAL_DIR fuse.sshfs delay_connect,_netdev,user,idmap=user,transform_symlinks,identityfile=/home/USERNAME/.ssh/id_rsa,allow_other,default_permissions,uid=USER_ID,gid=USER_GID 0 0 This is a combination of the information found here http://superuser.com/questions/669287/automount-sshfs-using-fstab-without-mount-a and adding the **delay_connect** from here http://askubuntu.com/questions/326977/sshfs-is-not-mounting-automatically-at-boot-despite-etc-fstab-configuration. I used this tutorial to get my USER_ID and USER_GID: https://kb.iu.edu/data/adwf.html To find a user’s UID or GID in Unix, use the id command. To find a specific Continue reading →

Magento 1.8 CE Import/Export from Shell on Bitnami

I’m running a Magento Commerce Community Edition store with 17k + skus. Previously, I only had 3k skus so I could use the build in Data Flow Profiles to import and export with ease. However, when I added the extra 14k skus, the web interface would hang. Furthermore, it would require me to leave the browser window open ” Warning: Please do not close the window during importing/exporting data ” which would preclude me from being able to start the processes at the end of Continue reading →

Your 2014 Tax Refund is Already Spent!

I already spent your tax refund next year!  It’s not going to be a vacation, definitely not a new car and sadly enough, it’s not even going to be a new gun. Unless you live in a cave and wash your laundry in a bucket, I know exactly what you are going to buy.  Well…that may not be entirely true, but if you are still limping around the internet on a computer running Microsoft Windows® XP, then you definitely need to read on. Unfortunately, all Continue reading →

Why Am I Not in Google?

I recently received this email from one of my customers: Hey David I just did a Google search on “landscaping marietta” “landscaping marietta ga” and “lawn care marietta” and we are no where to be found in the first 50 pages.  How is that possible?  I know it takes time for it to move up but how do we ever get it to move if it isn’t any where to be found?  All I see are the ads that we have posted. While I’m not Continue reading →