The Site Doctor Blog

Footprints in the snow of a warped mind

  1. Aug

    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

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

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

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

    Posted by: Tim on Friday, July 01 2016
    Read On

    Leave your mark

  5. Apr

    Export Umbraco members as CSV/table

    A while ago I blogged about how to list umbraco document types as an Excel table which has come in handy a few times. Today I thought I’d blog about how to list Umbraco members in a CSV format with

    Posted by: Tim on Thursday, April 28 2016
    Read On

    Leave your mark

  6. May

    Stop windows lowering the music volume when a call starts

    We've started using Sqwiggle to aid remote working which is awesome. The only issue is recently I've noticed that when someone starts a conversation or sends an instant message Spotify and Windows

    Posted by: Tim on Friday, May 30 2014
    Read On

    Leave your mark

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

  8. Quickly delete all products and orders from uCommerce

    Sometimes you need to blitz your uCommerce database e.g. just before launch or to remove the testing products etc. This is a quick database clear script which will clear delete all orders and

    Posted by: Tim on Saturday, May 11 2013
    Read On

    Leave your mark

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

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