The Site Doctor Blog

Footprints in the snow of a warped mind

  1. Aug

    Error running Ucommerce scratch indexer Illegal duplicate key definitions

    We hit an interesting issue indexing the Ucommerce data the other day which had us going for a while.It turns out that when upgrading Ucommerce to 7.0.6, some new payment providers were added to

    Posted by: Tim on Friday, August 02 2019
    Read On

    Leave your mark

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

  3. Jul

    Design with data -how to get the longest/shortest product/category name from Ucommerce

    Make sure your final Ucommerce e-commerce site looks as good as the designs by using real data

    Posted by: Tim on Tuesday, July 16 2019
    Read On

    Leave your mark

  4. Apr

    Delete all products and orders from Ucommerce

    Here's an updated script to delete all the products, orders and any other testy type data from Ucommerce. This is an updated version of my previous script to delete all product and order data from

    Posted by: Tim on Tuesday, April 23 2019
    Read On

    Leave your mark

  5. Drop/Kill all connections to a SQL Database

    Every now and again you need to get exclusivity to a database e.g. to do a database restore but someone is connected. You can manually find who it is using EXEC sp_who but that can result in having to

    Posted by: Tim on Thursday, April 04 2019
    Read On

    Leave your mark

  6. How To: Automatically set Umbraco folder permissions after AppVeyor deploy

    We've been playing more with AppVeyor over the past few weeks to automate the deployment of our sites and one of the things we got caught out with was the Umbraco folder permissions which we do with

    Posted by: Tim on Tuesday, April 03 2018
    Read On

    Leave your mark

  7. Mar

    How To: Quickly Set Umbraco File and Folder Permissions with PowerShell

    In 2010 I blogged about how to set Umbraco folder permissions using PowerShell. This has been a really handy snippet -but it's always been a bit of a pain when dealing with new servers, remembering

    Posted by: Tim on Friday, March 16 2018
    Read On

    Leave your mark

  8. Oct

    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

    Posted by: Tim on Friday, October 27 2017
    Read On

    Leave your mark

  9. Dec

    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

    Posted by: Tim on Thursday, December 08 2016
    Read On

    Leave your mark

  10. Nov

    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

    Posted by: Tim on Monday, November 28 2016
    Read On

    Leave your mark