TheJasonParker


Member since 01/11/2011

Name: Jason Parker

Location: Nottingham, UK

Father & Nerd that Loves - Music, Football, Darts, The Net & Apple but Hates - Early Mornings, Ignorance & Apple (owns a MacBook Pro & iPhone!)

20 snippets

10 profile views

2 Comment(s) Posted

View their favorites

Profile

All time reputation: 58

Achievement

first submission:submitting first snipplet

TheJasonParker's Recent Snippets



« Prev 1 Next »
  1. FAV

    Hide DIV scrollbars with CSS

    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
    CSS 11 views posted 7 years ago TheJasonParker
  2. FAV

    Google Analytics Goal Funnels for Magento One Page Checkout

    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 i...
    JavaScript saved by 1 person 21 views posted 7 years ago TheJasonParker
  3. FAV

    Magento Gallery Image Rollover

    Replace the code below in your templates 'media.phtml' file. This has mouseover and mouseout but can be removed it needed.
    PHP 14 views posted 7 years ago TheJasonParker
  4. FAV

    How to check to see if a table exists in a mySQL database.

    PHP 20 views posted 8 years ago TheJasonParker
  5. FAV

    Restore MySQL database in WampServer

    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 dire...
    MySQL 10 views posted 8 years ago TheJasonParker
  6. FAV

    Decompress gz files in Linux

    Gunzip can currently decompress files created by gzip, zip, compress, compress -H or pack programs.
    Other 4 views posted 9 years ago TheJasonParker
  7. FAV

    Excuting sql files from Linux shell

    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 3 views posted 9 years ago TheJasonParker
  8. FAV

    Restoring a backup in Magento

    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 command...
    MySQL 5 views posted 9 years ago TheJasonParker
  9. FAV

    Log & Cache Maintenance Script

    Save the file to the directory where Magento resides.
    PHP 4 views posted 9 years ago TheJasonParker
  10. FAV

    Magento Log File Contents Report

    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...
    PHP 9 views posted 9 years ago TheJasonParker
  11. FAV

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

    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 h...
    PHP 6 views posted 9 years ago TheJasonParker
  12. FAV

    Delete All Category Products

    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.
    PHP 2 views posted 9 years ago TheJasonParker
  13. FAV

    Remove a specific character from the end of a Excel cell

    Replace 'A1' with the cell and '-' with the character you want to remove.
    Visual Basic 12 views posted 9 years ago TheJasonParker
  14. FAV

    Batch create categories

    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,s...
    PHP 6 views posted 9 years ago TheJasonParker
  15. FAV

    Cleanly delete all categories

    MySQL 5 views posted 9 years ago TheJasonParker
  16. FAV

    Export categories with ID's

    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 4 views posted 9 years ago TheJasonParker
  17. FAV

    Mass enable categories

    Create a CSV with a maximum of 1 column, with just the Magento category ID.
    PHP 3 views posted 9 years ago TheJasonParker
  18. FAV

    Mass delete products for Magento 1.4+

    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...
    PHP 7 views posted 9 years ago TheJasonParker
  19. FAV

    Disable products by category

    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 s...
    MySQL 5 views posted 9 years ago TheJasonParker
  20. FAV

    Disable products by sku

    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...
    MySQL 11 views posted 9 years ago TheJasonParker
« Prev 1 Next »