Sign in Subscribe

Tim Gaunt

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 TRAN DECLARE @ProductIds TABLE (Id int) INSERT INTO @ProductIds (Id)

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 Media player reduced their volume and wouldn't come back up. Turns out

How To: Bulk delete orders in uCommerce

Sometimes things go wrong in testing but you don't want to delete all orders so here's a little script that will help you quickly delete orders based on your own criteria. In this example I'm deleting orders from customers without a billing email address

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 @Nodes TABLE (NodeId int) INSERT INTO @Nodes (NodeId) SELECT top 1000 n.id FROM cmsContent

To 08xx or not 08xx that is the question

At some point, when setting up a new website or business you need to give some thought to your telephone number. In the UK we have numbers that start with 08 which have different charging rates (free, local, national etc) and I've been asked several times in the

No basket exist for the current user when checking out in uCommerce

Stupidly this had me going for a while today so this is partly a post to act as a reminder not to do it again but also hopefully to help someone else from doing the same. A site we are working on was sending the order confirmation email -and processing

Illegal characters in path in MVC view

I initially thought that this was an issue with Umbraco's implementation on MVC but it turns out that if you have an IEnumerable property on your view model then you may get an error similar to the below. I've done a little searching around in the

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 table. Deleting them is fairly simple so I thought I'd share

Error when publishing Umbraco page - Object reference not set to an instance of an object

This is one of those irritating errors that you come across every now and again and can take hours to diagnose. If you've seen something like the error at the end of this post, then check that you don't have any document types which have an

How to price your products

I blogged a few years ago about how to price your time I thought I should blog about how to price a physical product. Recently, I've been involved in setting up a new company selling all sorts of Christmas decorations, artificial trees and more called Festive Sparkle. Part