The Site Doctor Blog

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

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

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

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

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

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

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

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

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

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