Snipplr

(CSS) Hide DIV scrollbars with CSS - TheJasonParker

Fri, 06 Jul 2012 19:15:48 UTC

overflow: hidden; will hide both vertical and horizontal scrollbars overflow-y: hidden; will hide the vertical scrollbar overflow-x: hidden; will hide the horizontal scrollbar

(JavaScript) Google Analytics Goal Funnels for Magento One Page Checkout - TheJasonParker

Thu, 31 May 2012 21:19:44 UTC

Fooman GoogleAnalyticsPlus: http://www.magentocommerce.com/magento-connect/fooman-googleanalyticsplus.html The key to seeing the different steps in your checkout is ensuring a page view is triggered each time one of the sections of the checkout is loaded. To do this we need to edit opcheckout.js this file should be in \skin\frontend\default\YOURTHEME\js if not then copy it there from \skin\frontend\base\default\js Within this file search for â€œgotoSection: function(section)â€ to find the function we are interested in amending and add in the lines of code shown below. If you are using the old analytics code then you will need to remove the slashes from the line â€œ//pageTrackerâ€¦.â€ and comment out (add a double slash to the beginning of) the line beginning â€œ_gaq.pushâ€¦â€. Google Analytic Gaol Setup Goal Type: URL Destination Match Type: Head Match Goal URL: /checkout/onepage/success/ Step 1 URL: /checkout/onepage/ Name: Login or Register Step 2 URL: /checkout/onepage/billing/ Name: Billing Address Step 3 URL: /checkout/onepage/shipping/ Name: Shipping Address Step 4 URL: /checkout/onepage/shipping_method/ Name: Shipping Method Step 5 URL: /checkout/onepage/payment/ Name: Payment Details Step 6 URL: /checkout/onepage/review/ Name: Confirmation

(PHP) Magento Gallery Image Rollover - TheJasonParker

Sat, 17 Mar 2012 01:04:25 UTC

Replace the code below in your templates 'media.phtml' file. This has mouseover and mouseout but can be removed it needed.

(MySQL) Delete & Recreate a table quickly with mySQL - TheJasonParker

Thu, 21 Jul 2011 21:41:41 UTC

(MySQL) Drop a table if it exists with mySQL - TheJasonParker

Thu, 21 Jul 2011 20:50:34 UTC

(PHP) How to check to see if a table exists in a mySQL database. - TheJasonParker

Thu, 21 Jul 2011 20:33:45 UTC

(MySQL) Restore MySQL database in WampServer - TheJasonParker

Tue, 19 Apr 2011 21:58:12 UTC

Go to the Windows command line by going to Start -> Run and typing in cmd. You need to change directory to the MySQL bin directory. On my version, the directory is c:\wamp\bin\mysql\mysql4.1.22\bin. Therefore, the command to change to this directory is: cd wamp\bin\mysql\mysql4.1.22\bin Put the MySQL dump (SQL file) into the above directory Create the new database in phpmyAdmin (or on the command line) The actual restore command is slightly different to normal (see below). Note that is says mysql.exe rather than the normal mysql. When it asks you for a password, just hit enter. There is no password associated with the database that you created (unless you prefer to have one. But as it is local, there is no need).

(Other) Decompress gz files in Linux - TheJasonParker

Tue, 25 Jan 2011 23:52:33 UTC

Gunzip can currently decompress files created by gzip, zip, compress, compress -H or pack programs.

(MySQL) Excuting sql files from Linux shell - TheJasonParker

Tue, 25 Jan 2011 23:34:46 UTC

Ftp your *.sql file to the (remote) machine, login via SSH and then go to the directory where your sql file is and run this code.

(MySQL) Restoring a backup in Magento - TheJasonParker

Fri, 21 Jan 2011 02:33:43 UTC

Wrap these two sets of commands around your sql backup if it hasn't come from a backup from the Magento admin interface (Magento adds this). This stops foreign key checks and then restarts them. The /*!40101 ---- */ code around the SET commands asks "If this version of mySQL is 4.1.1 or newer then run the SET command else do nothing." Older versions will not understand the statement. This allows for easier compatibility with other versions of mySQL.

(PHP) Log & Cache Maintenance Script - TheJasonParker

Mon, 17 Jan 2011 22:26:36 UTC

Save the file to the directory where Magento resides.

(PHP) Magento Log File Contents Report - TheJasonParker

Mon, 17 Jan 2011 22:20:58 UTC

And a now, word on the log.php maintenance script that comes with Magento 1.4 which has one major shortcoming. It doesnâ€™t maintain your dataflow_batch_* tables, said tables have been seen hiding in the wild at over a Gigabyte in size. php -f ./shell/log.php help gives you a listing of the various options php -f ./shell/log.php status gives you a listing of the log tables, how many rows and the size of storage space contained in the tables and indexes. php -f ./shell/log.php clean --days 15 will clear all but the last 15 days of log contents (minimum 1 day) php -f ./shell/log.php clean clears everthing per your settings in system setups under log maintenance

(PHP) Magento Memory Leak v1.4.1.1 (The Array of Death) - TheJasonParker

Mon, 17 Jan 2011 21:55:41 UTC

This fixes the way Magento imports data as it just keeps adding â€˜straight joinâ€™ to the array which uses a lot of memory if your importing a lot of products and will kill the import. Replace this function in /lib/Varien/Db/Select.php This has been fixed in the next update and a discussion can be seen here... http://www.magentocommerce.com/boards/viewthread/113901/

(PHP) Delete All Category Products - TheJasonParker

Sat, 15 Jan 2011 02:42:47 UTC

Change the category id and store id at the top of the script before running it. You can also remove the echo statements if you donâ€™t want any output.

(Visual Basic) Remove a specific character from the end of a Excel cell - TheJasonParker

Fri, 14 Jan 2011 22:09:35 UTC

Replace 'A1' with the cell and '-' with the character you want to remove.

(PHP) Batch create categories - TheJasonParker

Thu, 13 Jan 2011 00:03:44 UTC

First off, create your CSV with 2 columns, the parent ID for the category and the category name â€“ you could easily add more columns for extra options, but it wasnâ€™t necessary for us. The CSV file should be something like this: 3,subcat 4,subcat2 6,subcat3 Then it should be saved in ./var/import/importCats.csv Then save the following in ./quickCatCreate.php

(MySQL) Cleanly delete all categories - TheJasonParker

Wed, 12 Jan 2011 23:59:02 UTC

(PHP) Export categories with ID's - TheJasonParker

Wed, 12 Jan 2011 23:05:09 UTC

Simply save the above code in a PHP file in the base Magento directory of your store, and visit the URL in your web browser, simples!

(PHP) Mass enable categories - TheJasonParker

Wed, 12 Jan 2011 22:58:35 UTC

Create a CSV with a maximum of 1 column, with just the Magento category ID.

(PHP) Mass delete products for Magento 1.4+ - TheJasonParker

Wed, 12 Jan 2011 22:03:15 UTC

The easiest way to pull this off is by means of a quick script. The key to this script is that the indexing functionality is disabled entirely for the process, then enabled again at the end â€“ requiring a manual update at the end. In our case, we filtered the type of products by its â€œData Setâ€ â€“ an attribute assigned to that batch of products, but you can change this to suit any means of filtering.

(MySQL) Disable products by category - TheJasonParker

Wed, 12 Jan 2011 21:57:26 UTC

After the MySQL above has run â€“ youâ€™ll need to let Magento take the reigns back a little to update the category indexes, this is quite straightforward, but a little time consuming. Login to your admin and go to System > Cache Management, the select Rebuild Catalog Index

(MySQL) Disable products by sku - TheJasonParker

Wed, 12 Jan 2011 21:52:52 UTC

You'll first need to find the attribute_id value for 'status' for your Magento installation and replace 273 in this example. The easiest way to tell is if you go into: Admin > Catalog > Attributes > Manage Attributes Then in the â€œAttribute Codeâ€ box, enter â€œstatusâ€ then press â€œSearchâ€. Click the attribute result â€œstatusâ€ â€“ then look at the digits at the very end of the URL â€¦ catalog_product_attribute/edit/attribute_id/XXX/ In the code below (to be run via command line MySQL or phpMyAdmin), just replace %SKU% with your SKU identifier and use % as a wildcard or _ as a single character wildcard. This will obviously apply to any other attribute, so just change the code as necessary. enabled = 1 disabled = 2 After the MySQL above has run â€“ youâ€™ll need to let Magento take the reigns back a little to update the category indexes, this is quite straightforward, but a little time consuming. Remove this line to disable all... AND cpe.sku LIKE '%SKU%' Login to your admin and go to System > Cache Management, the select Rebuild Catalog Index