Insights

View the property values in SQL for latest version of a page in Umbraco

I've previously blogged about how to download any Umbraco document as a CSV from SQL but we hit a slightly different issue today and needed to view the values for a property in SQL. By default Umbraco stores each property as it's own row in the

How to: Send order confirmation emails to multiple recipients in Ucommerce

Sometimes it's the simple things that are hardest to find/remember but if you've ever needed to send the same Ucommerce email to multiple recipients you'll be pleased to hear that it's built in. To send an email to multiple people in

How to: Restore nodes from a SQL backup

We had an odd issue the other day where a bunch of nodes disappeared from one of our Umbraco installs. There didn't appear to be any reason behind why they were gone and the customer assured me that they didn't delete them but they were gone

Speed up your uCommerce checkout pipeline

Speed is key when it comes to e-commerce. Regardless of which platform you use to sell online it has to be fast and no-where is this truer than the checkout processes. uCommerce is a great platform and it's Pipeline feature makes uCommerce hugely extensible however with great power

Periodically hit a url with Windows Scheduler

Sometimes you have a task that you want to run every x minutes i.e. updating order statuses or sending abandoned cart emails. There are a few ways you can do this but our preferred method at The Site Doctor is to setup a Powershell Task in Windows Task Scheduler

Export/get all customer email addresses from uCommerce

If you running an online web-shop, you'll undoubtably be marketing to your customers so here’s  a simple script for you to generate a list of customers and their emails to import (excluding some of the test email addresses). As you should be segmenting your customers I’ve

Umbraco stuck at 5% on install

If you’ve ever gone through an install screen and got stuck at the “Connecting to database..” screen, you’ll know it’s one of the most frustrating and often worrying screens. The fix is generally quite simple though. If you use any form of URL rewriting to lowercase the

Export all products and properties from uCommerce

Update: I have just published an updated version of this script which works for more recent versions of Ucommerce and also exports the category hierarchy which may be useful. You can find how to export all products and categories from Ucommerce here. One of the most time consuming parts of

IIS Url Rewrite appends trailing slash after page extension

I’m a big fan of IIS’s built in Url rewriting module, if you’re not using it, you should be to lowercase urls, set canonical urls and all sorts it’s great. One thing that caught me out when we started using it though was the fact that

List all products from child categories on uCommerce

One question I’ve seen batted around a lot is how to list all products from the child categories when viewing a parent category. On the uCommerce demo store Avenue Clothing we simply loop through the category and all child categories to output the products: src\uCommerce.RazorStore\App_Code\