For Mozilla Firefox 3.6, if you find you need to copy your passwords to another PC, navigate to DRIVE:\Documents and Settings\PROFILENAME\Application Data\Mozilla\Firefox\Profiles\SOMESTRING.default and copy the following files to the same destination in your other PC:

• key3.db
• signons.sqlite
• signons3.txt (or any signons#.txt)

That’s it!

Computer crashed and OS was unrecoverable and now you want to recover your bookmarks to your new OS?  Reinstall Mozilla Firefox, under Bookmarks, go to organize bookmarks, and click Import and Backup at the top.  This was done on Moz FF 3.6.

Using your old hard drive as an external/internal drive, navigate to DRIVE:\Documents and Settings\USERNAME\Application Data\Mozilla\Firefox\Profiles\SOMESTRING.default\bookmarkbackups and select the latest JSON file to import.

That’s it!

To see who links to your site, ask the search engines. When searching for your own site, replace yourdomain.com with your domain name.

Show all pages with links to this specific page url
link:http://www.yourdomain.com/page.html

Show all pages with links to your domain (from any site)
linkdomain:yourdomain.com

Show all pages with links to your domain (except from your site)
linkdomain:yourdomain.com -site:yourdomain.com

After trying half a dozen methods found on other blogs on how to get the favicon.ico to work on Magento, I decided to go my own route.  And, I found a way that worked for me (on my webhost, 1and1).

1. Created my favicon as a transparent GIF that is 32×32 using Photoshop.
2. Uploaded it to my skin or template directory via FTP or WebspaceExplorer.
3. FTP to yourdirectory/app/design/frontend/default/default/template/page/html
4. Edit head.phtml so that it looks for favicon.gif and the type will be “image/gif” e.g.

   <link rel="icon" href="<?php echo $this->getSkinUrl('favicon.gif') ?>" type="image/gif" />
   <link rel="shortcut icon" href="<?php echo $this->getSkinUrl('favicon.gif') ?>" type="image/gif" />

5. Voila! Clear your browser and Magento cache and reload.  Your webhost may have a delay and you may have to wait several hours to a day.  Mine does.

Here’s a custom automated image reflection Yahoo! RTML template for your store.

Automatic Item Image Reflection

Click here to view this product.

For other similar items, visit our Image Enhancement templates.

*Wine glass not included.

For some odd reason, my blog (or webhost: 1and1.com) couldn’t display the affiliate banner when I linked directly from ShareASale.com. Just copied the image to my site, updated the link, and it worked as it should have.  Here’s the hook and HTML I used to get it to work:

function diytheme_affiliate_banner() {
?>
<div class="thesis_aff_banner"><a target="_blank" href="ADDYOURLINKHERE"><img src="http://www.YOURDOMAIN.com/blog/wp-content/themes/thesis_16/lib/images/thesis-125x125-1.png" alt="How smart is your Theme?  How good is your support? Check out ThesisTheme WordPress." border="0" /></a></div>
<?php
}
add_action('thesis_hook_before_sidebars','diytheme_affiliate_banner');

Note: Don’t forget to update the User ID and Domain and hook to the location of your choice.

Just start a Magento store, make some test sales, and, now you can’t delete them? Magento doesn’t include a way to delete test orders.  A much needed thanks goes out to the fellows at inchoo.net for posting a way to do it.

Log into your MySQL database and run the following SQL commands:

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE `sales_order`;
TRUNCATE `sales_order_datetime`;
TRUNCATE `sales_order_decimal`;
TRUNCATE `sales_order_entity`;
TRUNCATE `sales_order_entity_datetime`;
TRUNCATE `sales_order_entity_decimal`;
TRUNCATE `sales_order_entity_int`;
TRUNCATE `sales_order_entity_text`;
TRUNCATE `sales_order_entity_varchar`;
TRUNCATE `sales_order_int`;
TRUNCATE `sales_order_text`;
TRUNCATE `sales_order_varchar`;
TRUNCATE `sales_flat_quote`;
TRUNCATE `sales_flat_quote_address`;
TRUNCATE `sales_flat_quote_address_item`;
TRUNCATE `sales_flat_quote_item`;
TRUNCATE `sales_flat_quote_item_option`;
TRUNCATE `sales_flat_order_item`;
TRUNCATE `sendfriend_log`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `wishlist`;
TRUNCATE `log_quote`;
TRUNCATE `report_event`;

ALTER TABLE `sales_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_datetime` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_varchar` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;
ALTER TABLE `tag` AUTO_INCREMENT=1;
ALTER TABLE `tag_relation` AUTO_INCREMENT=1;
ALTER TABLE `tag_summary` AUTO_INCREMENT=1;
ALTER TABLE `wishlist` AUTO_INCREMENT=1;
ALTER TABLE `log_quote` AUTO_INCREMENT=1;
ALTER TABLE `report_event` AUTO_INCREMENT=1;

TRUNCATE `customer_address_entity`;
TRUNCATE `customer_address_entity_datetime`;
TRUNCATE `customer_address_entity_decimal`;
TRUNCATE `customer_address_entity_int`;
TRUNCATE `customer_address_entity_text`;
TRUNCATE `customer_address_entity_varchar`;
TRUNCATE `customer_entity`;
TRUNCATE `customer_entity_datetime`;
TRUNCATE `customer_entity_decimal`;
TRUNCATE `customer_entity_int`;
TRUNCATE `customer_entity_text`;
TRUNCATE `customer_entity_varchar`;
TRUNCATE `log_customer`;
TRUNCATE `log_visitor`;
TRUNCATE `log_visitor_info`;

ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `log_customer` AUTO_INCREMENT=1;
ALTER TABLE `log_visitor` AUTO_INCREMENT=1;
ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;

TRUNCATE `eav_entity_store`;
ALTER TABLE  `eav_entity_store` AUTO_INCREMENT=1;

TRUNCATE `sales_order_tax`;
TRUNCATE `sales_flat_quote_shipping_rate`;
TRUNCATE `sales_flat_quote_payment`;
TRUNCATE `log_url_info`;
TRUNCATE `log_url`;

ALTER TABLE `sales_order_tax` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;
ALTER TABLE `log_url_info` AUTO_INCREMENT=1;

TRUNCATE `catalogsearch_query`;
TRUNCATE `catalogsearch_result`;

ALTER TABLE `catalogsearch_query` AUTO_INCREMENT=1;
ALTER TABLE `catalogsearch_result` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

That’s right! We’ve updated the store with a few Yahoo! Store RTML templates. Check them out! More to come…

http://www.islandtechnica.com/index.php/yahoo-rtml.html

FTP into app/design/frontend/default/{your_theme}/template/catalog/product/list.phtml and using the Find tool, search for “Add to Cart” in the code for both List View and Grid View.  Replace with your desired text.

Need to filter by portrait or landscape in Lightroom?

1. Under Library Filter at the top, click Metadata.
2. Right-click on one of the column’s drop-down menus.
3. Select Add Column.
4. Choose Aspect Ratio to filter by Portrait or Landscape images.
5. That’s it!