Join our team, we're recruiting Contact us on: +44 (0)121 3145 374

The Site Doctor Blog

Footprints in the snow of a warped mind

  1. Aug

    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

    Posted by: Tim on Tuesday, August 15 2017
    Read On

    Leave your mark

  2. 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

    Posted by: Tim on Friday, August 19 2016
    Read On

    Leave your mark

  3. Add every country to uCommerce

    Something I learnt the other day was that uCommerce uses the culture code you specify for a country to determine the two/three digit ISO code when sending the order to the payment gateway. This is

    Posted by: Tim on Friday, August 16 2013
    Read On

    Leave your mark

  4. Jul

    Export all products and properties from uCommerce

    One of the most time consuming parts of building an e-commerce site is getting the data right and often it requires numerous exports. Although uCommerce is generally awesome, mass updating product

    Posted by: Tim on Tuesday, July 12 2016
    Read On

    Leave your mark

  5. Jun

    Bulk delete products by SKU in uCommerce

    You may already have come across my script to Quickly delete all products and orders from uCommerce but sometimes you need to delete just a set of products by SKU so here's a new one for you BEGIN

    Posted by: Tim on Tuesday, June 03 2014
    Read On

    Leave your mark

  6. May

    Quickly delete Umbraco nodes by document type in SQL

    Ever needed to delete all nodes by a document type or delete all nodes from the recycle bin in Umbraco? This little script should help. Delete Umbraco nodes by Document Type Alias BEGIN TRAN DECLARE

    Posted by: Tim on Thursday, May 08 2014
    Read On

    Leave your mark

  7. Mar

    How to: Delete duplicate products from a category in uCommerce

    I was looking into an issue with one of our sites that couldn't delete a product from a category in uCommerce today and noticed that there were a lot of duplicate product-category relationships in the

    Posted by: Tim on Friday, March 21 2014
    Read On

    Leave your mark

  8. Nov

    Download any Umbraco document type’s values as crosstab/Excel table

    In a follow up to my post yesterday -How to download Umbraco content properties into a crosstab table this is the follow up SQL Script that makes it even easier to download any Umbraco document type

    Posted by: Tim on Tuesday, November 09 2010
    Read On

    Leave your mark