I love the On-page Optimisation in SEOmoz (referral link). This feature allows you to enter your focus keyword against a page for the url you wish to score. Personally I add my focus keywords with a label just to keep it tidy when reporting back. However you can not extract the url from the database [...]
Download the basic order details for analysis from CS Cart using MySQL (& phpMyAdmin). Change the year/month parameters for your required data set.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SELECT `order_id` AS 'Order Number', DATE( FROM_UNIXTIME( `timestamp` ) ) AS 'Order Date', `total` AS Revenue, DATE_FORMAT( DATE( FROM_UNIXTIME( `timestamp` ) ) , '%Y' ) AS Year, DATE_FORMAT( DATE( FROM_UNIXTIME( `timestamp` ) ) , '%m' ) AS Month, DATE_FORMAT( DATE( FROM_UNIXTIME( `timestamp` ) ) , '%e' ) AS Day, CONCAT(`firstname`, ' ', `lastname`) As 'Customer Name', `company` AS Company, `email` AS 'Email Address' FROM `cscart_orders` WHERE `status` = 'P' AND DATE_FORMAT( DATE( FROM_UNIXTIME( `timestamp` ) ) , '%Y' ) = '2012' AND DATE_FORMAT( DATE( FROM_UNIXTIME( `timestamp` ) ) , '%m' ) = '09' ORDER BY `order_id` DESC |
A quick and dirty export (ie you may need to do a bit of data filtering) of the SEO Focus Keywords data used in the Yoast SEO WordPress plugin.. The data could then be imported into SEO tools such as SEOmoz
|
1 2 3 4 5 |
SELECT `meta_value` FROM `wp_postmeta` WHERE `meta_key` = '_yoast_wpseo_focuskw' AND `meta_value` != '' ORDER BY `wp_postmeta`.`meta_key` DESC |
This hook is for the ThemeBlvd WordPress framework and Yoast SEO plugin to enable the meta title tag to be displayed correctly. Add this code snippet to your (preferably in your child theme) functions.php file
|
1 2 3 4 5 6 7 8 9 10 11 |
/*-------------------------------------------------------*/ /* Add hook for Yoast SEO plugin /*-------------------------------------------------------*/ function my_title() { wp_title(''); } function yoast_mods() { remove_action( 'themeblvd_title', 'themeblvd_title_default' ); add_action( 'themeblvd_title', 'my_title' ); } add_action( 'after_setup_theme', 'yoast_mods' ); |
If you move your site from your developmental domain to your clients domain, you will need to do a bit of housework on the database, fix the URLs for the GUID (globally unique identifier) field in wp_posts table. This is important as the GUID is used to translate your post or page slug to the [...]
Want to change some data in a mdb database via a VBscript? Great when you’ve left a client with the lights switched on, or even a boolean set to true when it should be false. All you need is the path to the database, the table name and the field you want to edit. You may [...]
Financial reporting for CS-Cart I have three SQL Queries that make my reporting life a little more comfortable. I’ll jump right in assuming you know how to run SQL via phpMyAdmin. Total orders for a given month and year (just edit ’2012′ & ’07′ for your requied date)
|
1 2 3 4 5 6 |
SELECT `order_id` , DATE( FROM_UNIXTIME( `timestamp` ) ) AS order_date, `total` FROM `cscart_orders` WHERE `status` = 'P' AND DATE_FORMAT( DATE( FROM_UNIXTIME( `timestamp` ) ) , '%Y' ) = '2012' AND DATE_FORMAT( DATE( FROM_UNIXTIME( `timestamp` ) ) , '%m' ) = '07' ORDER BY `order_date` ASC |
Total order value for a given [...]
This is a Visual Basic script that backs up your online Google calendars. All you need to do is copy the code into a text editor such as notepad or my favourite Ultra Edit then save the file as Calendar-BackUp.vbs (not .txt or this is really not going to work for you). Save your newly [...]
Bit of an odd start: Blocking search engines. Well there is method in the madness. When developing sites I use a domain just for development then migrate once built and approved. I could run it all locally using the awesome XAMPP but it’s just the way I like to work. What you don’t want to happen for a [...]
