Just a quick one this. When exporting columns of text for .csv files you will probably want to have the text blocks encased in double quotes. To do this in excel, before saving as .csv, simply
- highlight the cells you want to quote-up
- right-click on them and choose “format cells”
- choose custom from the “Category” list (under the number tab)
- in the “Type” box type the following: \”@\”
- hit ok
The backslash is the escape character used to say “use the symbol that comes next” and the @ can be considered to be the wildcard or placeholder for the current contents.
Saves having to use your code/text editor to add in all the quotes.
So you have got your site all nicely working with your ssl certificate ready for your site to run fully in https:// to appease Google but your padlock never stays green. I traced this down to the various form submission URLs such as “add to cart”. Here is how I finally solved it.
Continue reading Magento – Making add to cart urls use https when site is secure
When your Magento installation has multiple sites set up within it, you will probably want to change which site shows based on domain or subdomain URL. You can do this via .htaccess or your httpd virtual hosts config. Continue reading Set Magento website based on URL
You can add a couple of tags to your page html to instruct Google to not index certain parts of your content or to not use certain bits of your content for the snippets shown in the SERPs.
Continue reading googleon and googleoff tags
I was just debugging a Magento problem and thought I would list out all the available methods for the category objects I was working through. Quite handy to have as a reference I thought, so here they are.
Continue reading Magento Category Object Methods
This was a curious and frustrating problem to fix. After updating the local dev copy of a a magento site, and changing a few local folder permissions the admin area stopped working, giving instead an error message of: ERROR_CONNECTION_RESET.
Continue reading Magento admin on localhost gives ERROR_CONNECTION_RESET message (winamp)
Before performing any major operations on a site it is great to have the reassurance that you have a complete back up. ALWAYS do this when taking over a new project and, even though you may have your files in a .git or svn system it can be a real livesaver to just turn time back a few minutes if your major update goes pear shaped. One of my colleagues refers to this as the “get out of jail free card”. You can also use this to take a copy of the entire site when you want to move it – to a development server for example.
Continue reading Archive An Entire Web Folder Using Tar Via SSH
So, you are building a design with dynamic content and the designer or client says, “but those blocks should be the same height”, and you say “but the content changes, we don’t know how tall it can be and anyway, the height needs to be different depending on what device you are using”, etc., etc.
Here is a little jQuery function you can call to set the height of matching elements
Continue reading Match Element Heights Using JQuery
When showing an HTML 5 video element on a non-black background a black rectangle flashed on the screen when the video element initialised but before the video file loaded. Here is how I avoided the problem.
Continue reading Hide HTML 5 Video Black Flash Box With jQuery
A new security patch has been released for Magento in the last few days. I have had to patch a number of sites running different Magneto versions and ran into a couple of common issues. This might help others having trouble.
Continue reading Problems running SUPEE-6788 Patch